## boxfigure3-1-1

## Source details

**Canonical URL:** [boxfigure3-1-1](https://www.imf.org/-/media/files/publications/gfsr/2018/april/chapter-3/csv/boxfigure3-1-1.csv)

## Other formats

- [Markdown version](/-/media/files/publications/gfsr/2018/april/chapter-3/csv/boxfigure3-1-1.csv.md)
- [Structured JSON version](/-/media/files/publications/gfsr/2018/april/chapter-3/csv/boxfigure3-1-1.csv.json)

---

### Dataset description
- Title (worksheet "csv"): Figure 3.1.1. Real House Prices in 40 Largest U.S. Cities by Population
- Source note in file: Sources: U.S. Census Bureau; Zillow Group; and IMF staff calculations.
- File structure: 1 worksheet named "csv" with rowCount 265 and columnCount 3.
- Frequency and start: Monthly observations beginning at 1996m1 (first dated row present in sample).

### Variables and units
- Column 1: Observation date in monthly format (e.g., "1996m1", "1996m2", ...).
- Column 2: Median real house price (Log of 2010 US dollars).
- Column 3: Ratio of 90th percentile to 10th percentile (right scale).

### Coverage and scope
- Geographic scope: 40 largest U.S. cities by population (as described by the figure title).
- Statistical scope: Median real house price (log scale) and a measure of cross-city dispersion (90th/10th percentile ratio).
- Row and column counts: 265 rows; 3 columns.

### Sample data points (exact values from the file)
- 1996m4: Median real house price (Log of 2010 US dollars) = 12.14428; Ratio of 90th percentile to 10th percentile = 3.228021
- 1996m5: Median real house price (Log of 2010 US dollars) = 12.138; Ratio of 90th percentile to 10th percentile = 3.228708
- 1996m6: Median real house price (Log of 2010 US dollars) = 12.13605; Ratio of 90th percentile to 10th percentile = 3.236264
- 1996m7: Median real house price (Log of 2010 US dollars) = 12.13857; Ratio of 90th percentile to 10th percentile = 3.233197

### Key statistics and technical notes
- Numeric precision is preserved as provided (e.g., 12.14428; 3.228021).
- Dispersion metric reported is the ratio of the 90th percentile to the 10th percentile (labeled as the right scale in the figure).
- Median house prices are expressed as the natural log (or log) of 2010 US dollars as labeled.

### Usage guidance for analysis
- Use column 2 (log median price) for trend analysis of central tendency; exponentiate if level interpretation in 2010 US dollars is required.
- Use column 3 (90th/10th ratio) to assess cross-city inequality in house prices over time.
- Maintain provided numeric precision when reporting results.

*Source: https://www.imf.org/-/media/files/publications/gfsr/2018/april/chapter-3/csv/boxfigure3-1-1.csv*

---


_Source: https://www.imf.org/-/media/files/publications/gfsr/2018/april/chapter-3/csv/boxfigure3-1-1.csv_