Real Medical Services Expenditures by Disease: Neoplasms, Blended Account Basis (NPSMSMREXBLEND) | FRED | St. Louis Fed
- Rows
- 22
- Columns
- 2
- Data range
- 2000-01-01 to 2021-01-01
Graph and download economic data for Real Medical Services Expenditures by Disease: Neoplasms, Blended Account Basis (NPSMSMREXBLEND) from 2000 to 2021 about neoplasms, disease, healthcare, medical, health, expenditures, services, real, and USA.
AI analysis
Data Analysis: Real Medical Services Expenditures by Disease (Neoplasms)
1. Dataset Overview
This dataset, sourced from the Federal Reserve Bank of St. Louis (FRED) via fredgraph.csv?id=NPSMSMREXBLEND, tracks real (inflation-adjusted) medical services expenditures specifically attributable to neoplasms (cancer and tumor-related conditions) on an annual basis from 2000 to 2021. The "Blended Account Basis" methodology suggests this combines multiple payer/accounting sources (e.g., out-of-pocket, insurance, public programs) into a single expenditure index. As a FRED-hosted series, it benefits from institutional credibility and is likely indexed to a base year (values suggest an index rather than raw dollar figures, given the 95–155 range). This makes it valuable for longitudinal correlation studies examining how cancer-related healthcare spending trends relate to broader economic indicators (GDP, CPI-Medical, insurance coverage rates) or health outcome metrics (cancer incidence/mortality rates) over the same two-decade window.
2. Data Quality Observations
The dataset is exceptionally clean for analytical purposes: zero null cells across both columns, and all 22 rows have complete, distinct values in both observationdate and NPSMSMREXBLEND. The 1:1 ratio of distinct values to row count (22 distinct dates, 22 distinct expenditure values) indicates no duplicate observations at first glance, though the "duplicate rows" check is still pending Phase D Parquet verification. No type mismatches are evident — dates are properly typed as Date, and expenditures as Decimal. The main limitation is not a quality issue but a structural one: with only 22 annual observations, statistical power for correlation analysis will be limited, and any regression-based work should account for low degrees of freedom.
3. Key Column Distributions
The NPSMSMREXBLEND column shows a mean of 113.87 and median of 103.44, with the gap between them signaling right-skewed data — confirmed by a skewness of 1.01, indicating a longer tail toward higher values. This is consistent with the standard deviation (σ=20.58) being large relative to the median, and the interquartile range (Q1=99.06, Q3=134.63) spanning roughly 35 points. The max value (154.89) sits well above Q3, suggesting the most recent years (likely 2020–2021) pulled the distribution upward — plausible given pandemic-era healthcare cost inflation or delayed cancer treatment costs. This pattern (steady baseline ~95-105 followed by a late acceleration) is a common shape in healthcare expenditure series and worth visualizing as a time series rather than relying on summary stats alone.
4. Recommended Join Keys
- observationdate is the clear and only viable join key, given its Date type, zero nulls, and full distinctness (22/22). - For cross-dataset work, this should be truncated/aligned to annual granularity (January 1 of each year) since this series is annual — joining against monthly or quarterly datasets will require aggregation (mean/sum) to the same annual frequency before merging.
5. Suggested Complementary Datasets
Given the health-economics focus, strong correlation candidates include: - Other FRED NPSMSMREXBLEND-family series for different disease categories (circulatory, respiratory, mental health) to compare relative cost growth across conditions - CPI for Medical Care Services (CPIMEDSL) to distinguish price inflation from utilization-driven cost increases - CDC/NCI cancer incidence and mortality rates to test whether expenditure growth correlates with disease burden or survivorship trends - Health insurance coverage rates (Census/CPS) and National Health Expenditure (NHE) data from CMS to contextualize neoplasm spending within total healthcare spend - GDP and personal consumption expenditure (PCE) data to normalize spending trends against overall economic growth, especially around the 2020-2021 anomaly likely visible in this series
Columns
- observation_date (date)
- NPSMSMREXBLEND (decimal)