Pharmaceutical Products (Without Prescription Drugs) Expenditures (PHPRDREXPHCSA) | FRED | St. Louis Fed
- Rows
- 22
- Columns
- 2
- Data range
- 2000-01-01 to 2021-01-01
Graph and download economic data for Pharmaceutical Products (Without Prescription Drugs) Expenditures (PHPRDREXPHCSA) from 2000 to 2021 about nonprescription drugs, medicines, pharmaceuticals, healthcare, health, expenditures, and USA.
AI analysis
Dataset Analysis: Pharmaceutical Products (Without Prescription Drugs) Expenditures (PHPRDREXPHCSA)
1. Dataset Overview and Value
This series, sourced from FRED (Federal Reserve Bank of St. Louis) via fredgraph.csv?id=PHPRDREXPHCSA, tracks annual expenditures on non-prescription pharmaceutical products in the U.S. from 2000–2021. As a FRED-hosted series, it benefits from a trusted, well-maintained public data infrastructure, though the 2021 cutoff suggests this specific series may not be actively updated (FRED often deprecates or slows updates on niche health-expenditure subcomponents in favor of aggregated series). Its primary value lies in longitudinal macro-health-economics analysis — examining how consumer spending on OTC drugs trends against inflation, healthcare policy shifts, or broader consumption patterns. Given it's annual data over 22 years, it's better suited to trend/regression analysis than high-frequency correlation work.
2. Data Quality Observations
Data quality here is excellent at face value: zero null cells across both columns, and both observationdate and PHPRDREXPHCSA show 22 distinct values against 22 total rows — indicating no duplicate timestamps and a clean one-to-one mapping typical of well-curated FRED series. The duplicate-row check is marked as pending recomputation ("Phase D"), so this should be verified before finalizing any merge/join operations, but there's no immediate red flag. The absence of sample rows (pending Parquet wire-up) limits our ability to visually spot-check formatting issues (e.g., date parsing, decimal precision), which I'd recommend validating once available.
3. Key Column Distributions
The PHPRDREXPHCSA value column ranges from 23.24 to 99.58 (a ~4.3x spread), with a mean of 52.16 and median of 50.09 — the small mean/median gap suggests a roughly symmetric distribution, confirmed by a modest positive skew of 0.463 (slight right tail, no extreme outliers). The interquartile range (Q1=33.20, Q3=67.62, IQR≈34.4) combined with σ=22.16 indicates substantial spread relative to the range, consistent with a steadily growing or trending series over two decades rather than a stationary metric — worth checking for a strong time trend or unit root before running raw correlations (differencing or YoY % change is advisable).
4. Recommended Join Keys
observationdate is the clear and only viable join key — it's a clean annual date field with zero nulls and full distinctness. For cross-dataset work, this should be normalized to year-only (or January 1 anchor dates, as FRED typically uses) to align with other annual economic series. Watch for frequency mismatches if pairing with quarterly or monthly datasets — aggregation (mean/sum by year) will be needed.
5. Suggested Pairings for Correlation Analysis
Strong candidates include: (a) other FRED health expenditure series (e.g., prescription drug expenditures, total personal healthcare expenditures, or CPI for medical care) to study substitution effects between OTC and prescription spending; (b) macroeconomic indicators like disposable personal income, unemployment rate, or CPI (all-items) to assess whether OTC spending is discretionary/cyclical; (c) demographic data (aging population %, insurance coverage rates) since uninsured or underinsured populations often lean on OTC alternatives; and (d) public health event indicators (flu season severity, COVID-19 case counts post-2020) given the sharp potential relevance of the 2020–2021 endpoint years to pandemic-driven self-medication trends.
Columns
- observation_date (date)
- PHPRDREXPHCSA (decimal)