Median Consumer Price Index (MEDCPIM157SFRBCLE) | FRED | St. Louis Fed
- Rows
- 525
- Columns
- 2
- Data range
- 1983-01-01 to 2026-09-01
- Auto-refresh
- Re-checks its source every 14 days
- Last refreshed with new data
- 2026-10-25
Graph and download economic data for Median Consumer Price Index (MEDCPIM157SFRBCLE) from Jan 1983 to May 2026 about CPI, median, rate, price index, indexes, price, and USA.
AI analysis
Data Analysis: Median Consumer Price Index (MEDCPIM157SFRBCLE)
1. Dataset Overview and Value
This dataset, sourced from the Federal Reserve Bank of Cleveland via FRED (fred.stlouisfed.org), tracks the Median Consumer Price Index — a measure of inflation that uses the median price change across CPI components rather than a weighted average, making it more robust to outlier categories (e.g., volatile energy or food prices) that can distort the headline CPI. The series spans January 1983 to May 2026 (521 monthly observations), giving it over four decades of history — long enough to cover multiple business cycles, recessions, and monetary policy regimes. Because it's sourced directly from the St. Louis Fed's API and updated on a rolling basis, it's a highly credible, research-grade series well-suited as a macroeconomic anchor variable in correlation studies involving inflation, monetary policy, wages, or interest rates. Note that data extending to 2026 suggests this includes forecast/projected values alongside actuals, which should be flagged before using in retrospective analysis.
2. Data Quality Observations
The dataset is clean from a completeness standpoint: zero null cells across both columns and zero nulls reported in either the date join key or the value column. The date column has 521 distinct values matching 521 rows, indicating no duplicate timestamps at the surface level (though the "duplicate rows" recomputation is still pending Phase D/Parquet verification, so this should be confirmed before final use). One mild data-quality flag: the value column shows 516 distinct values across 521 rows, meaning a handful of repeated values — expected behavior for a rounded percentage-change series, not a concern. No type mismatches are indicated.
3. Key Columns and Distributions
The core metric, MEDCPIM157SFRBCLE (presumably a monthly percent-change rate), has a mean of 0.252 and median of 0.237, showing a modest right skew (skewness = 0.746) — consistent with inflation data, which occasionally spikes upward (e.g., during 2021-2022 inflation surge) but rarely drops sharply negative. The interquartile range (Q1=0.187, Q3=0.304) shows most monthly changes cluster in a tight 0.12-point band, while the minimum of -0.024 and maximum of 0.631 reveal the extremes are far more pronounced on the high side. There are 17 flagged outliers (~3.3% of observations) — likely corresponding to known inflationary shocks (e.g., 2021-2023) or the 2008 financial crisis/COVID deflationary dip. The standard deviation (0.103) relative to the mean suggests moderate volatility for a "core" inflation-style metric.
4. Recommended Join Keys
The observationdate column is the clear and only viable join key — it's a clean, fully-populated monthly date field with no duplicates or nulls. For cross-dataset correlation, this should be joined against other FRED or macroeconomic series at matching monthly granularity (first-of-month convention). Analysts should verify date alignment conventions (start-of-month vs. end-of-month timestamps) when joining against series from other publishers.
5. Suggested Pairings for Correlation Analysis
Strong candidates include: (a) headline CPI (CPIAUCSL) and Core CPI (CPILFESL) to compare median vs. trimmed-mean vs. traditional inflation measures; (b) Federal Funds Rate (FEDFUNDS) or 10-Year Treasury Yield (DGS10) to study monetary policy responsiveness to inflation; (c) Unemployment Rate (UNRATE) to explore Phillips Curve dynamics; (d) Wage growth series (e.g., Average Hourly Earnings, CES0500000003) to assess wage-price spiral effects; and (e) PCE Price Index (PCEPI), the Fed's preferred inflation gauge, for a direct methodology comparison. Given the long time horizon, this dataset also pairs well with recession-indicator datasets (e.g., USREC) for regime-based conditional correlation analysis.
Columns
- observation_date (date)
- MEDCPIM157SFRBCLE (decimal)