Average Price: Gasoline, All Types (Cost per Gallon/3.785 Liters) in Chicago-Naperville-Elgin, IL-IN-WI (CBSA) (APUS23A7471A) | FRED | St. Louis Fed
- Rows
- 586
- Columns
- 2
- Data range
- 1978-01-01 to 2026-10-01
- Auto-refresh
- Re-checks its source every 14 days
- Last refreshed with new data
- 2026-11-12
Graph and download economic data for Average Price: Gasoline, All Types (Cost per Gallon/3.785 Liters) in Chicago-Naperville-Elgin, IL-IN-WI (CBSA) (APUS23A7471A) from Jan 1978 to May 2026 about Chicago, energy, WI, IN, IL, gas, urban, retail, price, and USA.
AI analysis
Data Analysis: Chicago-Area Gasoline Prices (APUS23A7471A)
1. Dataset Overview & Source Context
This dataset, sourced from the Federal Reserve Bank of St. Louis's FRED API (fredgraph.csv?id=APUS23A7471A), tracks average gasoline prices (all types, per gallon) for the Chicago-Naperville-Elgin CBSA (spanning Illinois, Indiana, and Wisconsin). FRED is a highly authoritative and actively maintained economic data repository, and the fact that this series extends through May 2026 suggests it includes forward-looking or very recently updated observations — a strong signal of data freshness and reliability. As a regional energy price series with monthly granularity since 1978, this dataset is valuable for correlation studies involving inflation dynamics, regional cost-of-living analysis, transportation costs, and consumer spending behavior in the Midwest.
2. Data Quality Observations
Overall data quality is strong. Out of 581 total rows and 2 columns (1,162 cells), only 2 null values were found — both confined to the price column (APUS23A7471A), representing just 0.3% of that column's values. This is a negligible gap, likely reflecting a reporting lag near the most recent (2026) observations rather than systemic collection issues. The join-key column (observationdate) has zero nulls and 581 distinct values, confirming one-to-one date coverage with no duplicate timestamps — a good sign for time-series integrity. Duplicate-row recomputation is pending (Phase D), so that check should be revisited before finalizing quality conclusions, but based on the null and distinct-value profile, this dataset appears clean and analysis-ready.
3. Key Column Distributions
The price column (APUS23A7471A) spans a wide range from $0.681 to $5.814 per gallon, reflecting nearly five decades of energy market history — including 1970s-80s baseline prices and modern volatility (e.g., 2022 spikes). The mean ($2.13) sits notably above the median ($1.617), and the distribution shows positive skewness (0.75), indicating a right-tailed distribution where higher-price periods (recent years) pull the average upward relative to the bulk of historically lower prices. The interquartile range (Q1=$1.26, Q3=$2.96) shows that the middle 50% of observations span a $1.70 range, again consistent with long-term inflationary drift. Only 1 statistical outlier was flagged despite the wide range, suggesting the extreme values are part of a gradual trend rather than isolated anomalies — typical of energy price series affected by sustained economic and geopolitical trends rather than one-off shocks.
4. Recommended Join Keys
The observationdate column is the clear and only sensible join key. Since it's a clean, fully-populated, monthly time series with no duplicates, it can be joined directly against other FRED series or external datasets using exact date matching, or resampled (e.g., to quarterly/annual) if pairing with lower-frequency datasets like GDP or CPI.
5. Suggested Pairings for Correlation Analysis
This dataset would pair well with: (a) national or regional CPI/inflation indices to assess gasoline's contribution to cost-of-living trends; (b) crude oil price benchmarks (WTI, Brent) to study pass-through effects; (c) Chicago-area unemployment or wage data to explore consumer purchasing power; (d) vehicle miles traveled (VMT) or public transit ridership data to study price elasticity of demand; (e) other CBSA-level gasoline price series (e.g., NY, LA) for cross-regional comparison; and (f) macro indicators like the Federal Funds Rate or consumer sentiment index, given gasoline's role as a leading indicator in discretionary spending models.
Columns
- observation_date (date)
- APUS23A7471A (decimal)