Nonprescription Drugs Expenditures Price Index (NONDRGPIHCSA) | FRED | St. Louis Fed
- Rows
- 22
- Columns
- 2
- Data range
- 2000-01-01 to 2021-01-01
Graph and download economic data for Nonprescription Drugs Expenditures Price Index (NONDRGPIHCSA) from 2000 to 2021 about nonprescription drugs, medicines, healthcare, health, expenditures, price index, indexes, price, and USA.
AI analysis
Dataset Analysis: Nonprescription Drugs Expenditures Price Index (NONDRGPIHCSA)
1. What this dataset represents
This is an annual price index tracking nonprescription (over-the-counter) drug expenditures, sourced directly from the Federal Reserve Bank of St. Louis's FRED database via their public API (fredgraph.csv endpoint). FRED is a highly reputable, actively maintained aggregator of economic data, which lends strong credibility to this series — it's likely sourced originally from BEA's Personal Consumption Expenditures (PCE) price index data. With only 22 annual observations spanning 2000–2021, this is a compact, low-frequency time series best suited as a macro-level covariate rather than a standalone analytical dataset. Its real value emerges when joined against other healthcare, inflation, or consumer spending series to study how OTC drug pricing trends relate to broader economic or health-sector dynamics.
2. Data quality observations
Quality appears excellent on the surface: zero null cells across both columns, and both observationdate and NONDRGPIHCSA show 22 distinct values against 22 total rows — meaning no duplicate dates and no duplicate index values, consistent with a clean one-row-per-year time series. No type mismatches are indicated. The main caveat is structural rather than a "quality" defect per se: with only 22 observations, statistical power for correlation or regression analysis is inherently limited, and the annual granularity means this series cannot be joined against monthly/quarterly data without aggregation or interpolation. The "duplicate rows" and sample-data fields are still pending backend computation (Phase D), so full row-level verification isn't yet available.
3. Key columns and distributions
The index column (NONDRGPIHCSA) ranges from 94.38 to 102.91 (an 8.5-point spread), with a mean of 99.10 and median of 99.46 — very close together, suggesting a fairly symmetric distribution, which is corroborated by the modest skewness of -0.351 (slight left skew, meaning a few lower-index years pull the tail down). The interquartile range (Q1=96.935, Q3=101.015) spans about 4 points, indicating the middle 50% of observations cluster fairly tightly around the mean, with the tails (min/max) contributing most of the spread. A standard deviation of 2.52 relative to a mean near 99 gives a coefficient of variation around 2.5%, indicating relatively low volatility — expected for a price index that's normalized around a base period (likely 100 in a reference year). No explicit outlier counts are provided, but given the tight quartile spread and moderate skew, extreme outliers seem unlikely.
4. Recommended join key
observationdate is the clear and only viable join key — it's a clean, fully-populated, non-duplicated annual date field (2000-01-01 through 2021-01-01). For cross-dataset joins, this should be normalized to year-level granularity (e.g., extracting the year integer) to match against other annual series, or used directly as a date key when joining with other FRED series that share the same annual timestamp convention (typically January 1st of each year).
5. Suggested pairings for correlation discovery
This series pairs naturally with: (a) the overall CPI or PCE Price Index (headline and medical care components) to see how OTC drug pricing tracks general inflation vs. healthcare-specific inflation; (b) Prescription Drug Expenditures Price Index (a likely FRED sibling series) to compare OTC vs. prescription pricing trends; (c) healthcare spending/GDP share or out-of-pocket health expenditure series to explore consumer substitution behavior between OTC and prescription options; (d) unemployment rate or real disposable income to test whether economic downturns correlate with OTC drug price/demand shifts; and (e) pharmaceutical industry producer price indexes (PPI) to examine upstream-to-downstream pricing pass-through. Given the annual frequency, any paired dataset should either be annual natively or be aggregated (mean/year-end) to match this cadence before running correlation or regression analysis.
Columns
- observation_date (date)
- NONDRGPIHCSA (decimal)