Average Price: Electricity per Kilowatt-Hour in St. Louis, MO-IL (CBSA) (APUS24B72610) | FRED | St. Louis Fed
- Rows
- 553
- Columns
- 2
- Data range
- 1978-11-01 to 2024-11-01
Graph and download economic data for Average Price: Electricity per Kilowatt-Hour in St. Louis, MO-IL (CBSA) (APUS24B72610) from Nov 1978 to Nov 2024 about St. Louis, electricity, energy, MO, IL, urban, retail, price, and USA.
AI analysis
Data Analyst Review: Average Electricity Price per kWh — St. Louis, MO-IL (APUS24B72610)
1. Dataset Overview and Value for Correlation Studies
This dataset, sourced directly from the Federal Reserve Bank of St. Louis (FRED) via fred.stlouisfed.org/graph/fredgraph.csv?id=APUS24B72610, tracks the average retail price of electricity (per kilowatt-hour) in the St. Louis, MO-IL Core-Based Statistical Area (CBSA) from November 1978 through November 2024 — a 46-year time series. As a FRED-hosted series, it inherits BLS-grade methodology (this is a BLS Average Price series) and benefits from a highly reputable, actively maintained publisher, meaning the data is refreshed on a known cadence and unlikely to disappear or be silently altered. This long horizon makes it valuable for macroeconomic and regional cost-of-living correlation studies — particularly for examining energy inflation, utility cost pass-through, and regional CPI components over multiple economic cycles (oil shocks, 2008 recession, COVID-era inflation, etc.).
2. Data Quality Observations
The dataset is structurally clean at the row level: 553 rows, 0 nulls in the observationdate join key, and all 553 dates are distinct — indicating no duplicate timestamps and a reliable temporal index. However, the actual value column, APUS24B72610, has 242 null cells out of 553 rows (43.8%) — a significant and disproportionate gap given it's the only measure column in the dataset. This strongly suggests the underlying survey (likely a subset of BLS's Average Price program) was collected at a lower frequency than monthly for much of its history (e.g., bi-monthly or quarterly sampling before a later shift to monthly reporting), rather than indicating faulty collection. Analysts should verify the exact reporting cadence before assuming missing = data quality defect, and should apply forward-fill, interpolation, or resampling strategies rather than treating nulls as errors.
3. Key Column Distributions
The price column shows a mean of 0.0851/kWh vs. a median of 0.071/kWh, with the mean sitting well above the median — consistent with the reported positive skew of 0.82, indicating a right-tailed distribution where more recent (higher) prices pull the average upward relative to the bulk of historical (lower) observations. The interquartile range (Q1=0.068, Q3=0.1035) shows the middle 50% of observations cluster in a relatively tight 3.5-cent band, while the full range (min=0.042, max=0.177) spans over 4x from lowest to highest — reflecting decades of inflation and energy market volatility. With only 61 distinct values across 553 rows, the series changes infrequently between observations (typical of slow-moving administered/regulated utility pricing), and the 11 flagged outliers likely represent the most recent high-price observations (2022–2024 energy inflation) rather than data errors.
4. Recommended Join Keys
observationdate is the clear and only viable join key — it's complete (0 nulls), fully distinct (553/553), and monthly-aligned, making it straightforward to merge with other FRED series or macroeconomic datasets on a calendar-date or year-month basis. When joining with lower-frequency datasets, resample this series to quarterly/annual averages; when joining with daily data, forward-fill from the join date.
5. Suggested Pairings for Correlation Analysis
Strong candidates include: CPI for Energy/Electricity (national and Midwest region), Henry Hub natural gas spot prices (fuel-cost pass-through), regional CPI-U for St. Louis, BLS Average Price series for other utilities (natural gas, water/sewer) in the same CBSA, household income or CPI-adjusted real wages for St. Louis, and weather/heating-degree-day data to explain seasonal demand-driven price spikes. Cross-referencing with national average electricity prices would also help distinguish whether St. Louis-specific regulatory/utility factors or broader national energy trends are driving the observed skew and outliers in recent years.
Columns
- observation_date (date)
- APUS24B72610 (decimal)