AI Analysis: Monthly retail commodity sales

Executive Summary

Canada's monthly retail commodity sales grew 33.3% over the January 2023 to December 2025 period, rising from approximately $53.7 billion to a peak of $76.3 billion (in thousands of dollars) in May 2025, based on Statistics Canada Table 20100080. The dataset spans 249 NAPCS commodity categories across 8,964 records and reveals a highly right-skewed distribution, where a small number of large aggregate categories dominate overall sales volumes. Most top categories move in strong positive correlation with one another, suggesting shared sensitivity to seasonal cycles and broader consumer spending trends.

Key Findings

• Total retail commodity sales increased by 33.3% over the 36-month period, peaking at approximately $76.3 billion (in thousands of CAD) in May 2025.
• The dataset covers 249 unique NAPCS commodity categories across 8,964 records, with monthly sales values ranging from as low as $4,000 to as high as ~$76.3 billion (in thousands).
• The distribution is strongly right-skewed: the mean monthly sales value ($1.64 billion) is more than 6 times the median ($254 million), driven by a small number of very high-value commodity aggregates.
• The middle 50% of sales records fall between $82,305K (Q25) and $832,317K (Q75), while the standard deviation of $6.85 billion reflects extreme variability across categories.
• A correlation heatmap of the top 15 categories revealed strong positive co-movement across most commodity groups, indicating that retail sales broadly rise and fall together with seasonal and macroeconomic trends.
• Outlier detection using the IQR method identified 20 anomalous data points across the top 10 categories from 7,278 valid records (~0.3%), likely reflecting seasonal spikes, demand shocks, or data revisions.
• Multiple data quality status codes (A through F, x, and '..') are present in the dataset, indicating that some values may be suppressed or estimated, which should be considered when interpreting results.