Average Price: Gasoline, Unleaded Regular (Cost per Gallon/3.785 Liters) in Phoenix-Mesa-Scottsdale, AZ (CBSA) (APUS48A74714) | FRED | St. Louis Fed
- Rows
- 101
- Columns
- 2
- Data range
- 2018-01-01 to 2026-05-01
Graph and download economic data for Average Price: Gasoline, Unleaded Regular (Cost per Gallon/3.785 Liters) in Phoenix-Mesa-Scottsdale, AZ (CBSA) (APUS48A74714) from Jan 2018 to May 2026 about Phoenix, AZ, energy, gas, urban, retail, price, and USA.
AI analysis
Data Analysis: Phoenix-Mesa-Scottsdale Gasoline Prices (APUS48A74714)
1. Dataset Overview and Value
This dataset tracks the average retail price of unleaded regular gasoline (per gallon) in the Phoenix-Mesa-Scottsdale, AZ metro area, sourced from FRED (Federal Reserve Bank of St. Louis) via its public API. The source URL (fred.stlouisfed.org/graph/fredgraph.csv) confirms this is a well-maintained, authoritative macroeconomic series — FRED aggregates BLS/EIA survey data and updates monthly, making it a reliable and citable benchmark for regional energy costs. With a stated coverage window through May 2026, the series appears to include forecast or scheduled-release placeholder dates beyond the actual data collection date, so users should verify the "as-of" date against real-time series length. Its monthly frequency and long horizon (2018–present) make it well-suited for time-series correlation work against inflation, transportation costs, consumer spending, and regional economic indicators.
2. Data Quality Observations
Quality is strong on the surface: zero null cells across both columns, no missing observation dates, and full distinct-value counts (101 distinct dates matching 101 rows, and 101 distinct prices), indicating no duplicate timestamps or repeated price entries. The duplicate-row recomputation is still pending ("Phase D"), so a final duplicate check hasn't been confirmed — this should be validated before heavy analytical reliance. One caveat: the sample data rows are empty (0 rows shown), so structural/type validation from actual row-level inspection isn't yet possible; only aggregate statistics are available at this stage.
3. Key Column Distributions
The price column (APUS48A74714) ranges from $2.053 to $5.559/gallon, with a mean of $3.357 and median of $3.247 — the mean sitting above the median signals a right-skewed distribution, confirmed by the skewness value of 0.569 (moderate positive skew). This aligns with real-world gas price behavior: prices spiked well above baseline during 2022 supply shocks, pulling the mean upward. The IQR (Q1=$2.834, Q3=$3.746) shows the bulk of observations cluster in the $2.83–$3.75 range, with only 1 flagged outlier (likely the 2022 peak near/above $5). Standard deviation of 0.786 relative to the mean indicates meaningful volatility (~23% CV), typical of energy commodities.
4. Recommended Join Keys
The observationdate column is the clear and only sensible join key — it's a clean monthly date field with zero nulls and full distinct values. For cross-dataset correlation, align on month-start dates; if pairing with weekly or daily series (e.g., EIA weekly gas prices, crude oil futures), resample to monthly averages first to preserve alignment integrity.
5. Suggested Pairings for Correlation Analysis
Strong candidates include: (a) WTI/Brent crude oil spot prices (direct input cost driver), (b) CPI for Phoenix or U.S. urban areas, especially transportation/energy subindices, (c) national average gasoline price series (e.g., FRED's GASREGW) to measure regional premium/discount, (d) Arizona unemployment or personal income data to study consumer spending sensitivity, and (e) vehicle miles traveled (VMT) or transportation sector indices to explore demand elasticity. Given the 2018–2026 window, this dataset also pairs well with COVID-era mobility indices and Federal Reserve interest rate series to study broader inflationary dynamics.
Columns
- observation_date (date)
- APUS48A74714 (decimal)