US LPG Export Figures: Keep Product Mix and Missing Data Visible

Define the basket before describing its growth

An LPG market report can change its conclusion simply by changing the products included in the total. A broader hydrocarbon-gas-liquids figure should not be relabeled as propane exports, and a propane series should not be presented as the entire gas-carrier market. Define the product basket before comparing periods or estimating commercial opportunity.

For a US exporter, owner, or broker, this is more than a statistical detail. Different product requirements can lead to different counterparties, commercial programs, and suitability questions. A growing aggregate does not prove that the specific product relevant to the business is growing at the same pace.

The useful analysis shows the components, their units, and their contribution to the change. It also preserves missing or inapplicable observations instead of converting them into invented zeroes.

Official labels carry meaning

EIA's hydrocarbon-gas-liquids explanation distinguishes multiple products, including ethane, propane, and butanes, within the broader category. EIA product context

EIA's propane/propylene export table explicitly distinguishes not-applicable, not-available, and withheld data codes. EIA table legend

Those two source features address different risks. Product definitions control what the analysis includes. Data-status codes control what the analyst can conclude from an individual observation. Neither should be discarded to make a chart easier to construct.

If a familiar series no longer provides the expected observation, investigate the current reporting structure and relevant methodology. Do not quietly replace it with another series that has a similar name. A replacement may be useful, but any change in scope belongs in the explanation.

A fictional mix shift hidden by the total

Consider an invented export dataset using consistent volume units. In the first period, Product A accounts for 800 units and Product B for 200 units. The combined basket totals 1,000 units. In the second period, Product A rises to 840 units while Product B rises to 360 units. The basket now totals 1,200 units.

Aggregate growth is 20%. Product A grows only 5%, while Product B grows 80%. Product B contributes 160 of the 200 additional units, or 80% of the total increase. A business focused on Product A would misread the opportunity if it applied the basket's 20% growth rate to its own market.

The product mix also changes. Product B moves from 20% of the basket to 30%. That may justify investigating whether the relevant customer requirements or logistics patterns differ. It does not, by itself, identify the cause of the change or establish a new vessel requirement.

Now suppose a report adds Product C only in the second period, contributing another 100 units. The displayed total becomes 1,300 units, apparently 30% above the first period. But the comparable A-and-B basket still grows 20%. The remaining increase is a scope change, not growth in the original basket.

A clear report would show both the comparable change and the expanded total. Hiding the new component inside the headline creates a misleading trend even though every individual number is arithmetically correct.

Preserve the unit through every calculation

Before combining series, check whether each reports mass, liquid volume, energy, or a daily average. Similar-looking numbers can represent fundamentally different quantities. A conversion needs an appropriate basis for the product and measurement conditions; it should not be inferred from a convenient generic factor.

If the business question concerns a particular cargo, use the applicable commercial quantity basis. If it concerns a broad trend, a consistent source series may be sufficient without converting it into another unit. Avoid unnecessary conversions that add assumptions without improving the decision.

A chart should state the unit where the reader sees the result. A footnote far from the headline is not enough when a unit misunderstanding would change the conclusion. The same applies to whether the observation is a period total or a daily rate.

Missing does not mean zero

Imagine the fictional dataset has no available observation for Product B in a third period, while Product A is reported at 850 units. Treating the missing value as zero would produce an apparent combined collapse from 1,200 to 850 units. That conclusion is unsupported because part of the basket is unknown.

The appropriate response depends on the analytical purpose. The team can report Product A separately, state that the combined total cannot yet be compared, or use a clearly labeled estimate with a defensible method. It should not silently fill the gap and present the result as observed data.

The same discipline applies to percentage changes. A missing or inapplicable base period cannot support an ordinary growth calculation. A very small valid base can produce a large percentage change that deserves context. Show the absolute movement as well as the percentage when scale affects the commercial interpretation.

Connect the mix to a real commercial question

Once the product trend is established, investigate the relevant destinations, timing, and procurement responsibility. A product increase may be spread across many small movements or concentrated in a few programs. The aggregate alone does not reveal the parcel structure or the parties seeking transportation.

For a commercial team, use the analysis to decide where further research is worthwhile. Identify which product contributes to the change and whether that product fits the business's capabilities. Then seek actual enquiries and responsible counterparties rather than treating the statistical increase as an available sales pipeline.

A negative trend can also be useful. It may suggest reviewing exposure to a particular customer segment or testing whether a broader market narrative masks weakness in the relevant product. That is a reason to investigate, not an automatic instruction to withdraw from the trade.

Publish a comparison the reader can reproduce

State the included products, source series, unit, period, and treatment of missing observations. Separate comparable growth from changes in the basket. If the data cannot answer the shipping question directly, say what additional evidence is needed.

Bring Zeaclub the specific LPG product question and the source definitions behind the proposed trend. Ask for a commercial discussion tied to the relevant product and customer requirement. A carefully defined smaller market is more useful than a larger headline assembled from incompatible or incomplete figures.

Sources

Related articles