Normalized house-price indexes
First aligned observation = 100
Business analytics project · Spring 2026
Housing Price Index Dashboard
Business question: How have Tennessee house prices performed relative to the United States, including growth, return consistency, and downside movement? The analysis uses aligned quarterly data and a common starting point for a transparent comparison—not investment advice.
Summary Metrics
Returns are based on consecutive aligned quarters. Volatility is the sample standard deviation of quarterly returns; maximum drawdown is the largest decline from a prior peak.
- TN latest quarter
- Loading… Quarterly return
- U.S. latest quarter
- Loading… Quarterly return
- TN trailing 4 quarters
- Loading… Four-quarter return
- U.S. trailing 4 quarters
- Loading… Four-quarter return
- TN CAGR
- Loading… Full comparison period
- U.S. CAGR
- Loading… Full comparison period
- TN volatility
- Loading… Quarterly returns
- U.S. volatility
- Loading… Quarterly returns
- TN max drawdown
- Loading… Peak-to-trough
- U.S. max drawdown
- Loading… Peak-to-trough
Trend Comparison
Normalization sets each series to 100 at the first shared observation, making relative movement comparable even when original index levels differ.
Quarterly returns
Percentage change from the prior aligned quarter
Key Observations
These statements update from the displayed dataset and describe the selected comparison period only.
| Quarter | TN index | U.S. index | TN normalized | U.S. normalized | TN return | U.S. return |
|---|
Methodology
Wilfred’s role was to build the comparison, organize the data, calculate the measures, and present the results in a usable dashboard. The original project used Excel, Power Query, and the FRED API; this web demonstration uses HTML, CSS, and JavaScript.
1. Integrate and align
Retrieve quarterly FHFA Tennessee and U.S. series through FRED, validate numeric values, and retain only identical dates.
2. Normalize and calculate
Rebase both series to 100, calculate consecutive-quarter and four-quarter returns, CAGR, sample volatility, and maximum drawdown.
3. Compare and communicate
Place growth and downside measures alongside charts and recent observations to support a balanced market comparison.
What This Demonstrates
A transparent workflow from data preparation through analysis and communication.
Data preparation
Data integration, validation, quarterly date alignment, and normalization.
Quantitative analysis
Return calculations, compound growth, volatility analysis, and drawdown.
Business communication
Visualization, documented methodology, clear limitations, and decision support.
Data source: U.S. Federal Housing Finance Agency, All-Transactions House Price Index for Tennessee (TNSTHPI) and the United States (USSTHPI), retrieved through FRED, Federal Reserve Bank of St. Louis. Both are quarterly, not seasonally adjusted, and indexed to 1980 Q1 = 100. FRED data can be revised. The displayed cache is identified above and is never presented as live data.