Exercise 1 Re-Do
Olivia Martin
2025-01-24
National Level
The dataset grows more complete over time
## # A tibble: 9 × 3
## year non_na_prop_tax non_na_hpi
## <dbl> <int> <int>
## 1 1982 19055 461
## 2 1987 19188 1951
## 3 1992 19249 2816
## 4 1997 19342 3259
## 5 2002 19401 4052
## 6 2007 19464 4523
## 7 2012 17829 4527
## 8 2017 17633 4414
## 9 2022 17364 4319Balanced Panel based on cities in 1987 with non-NA HPI:
## # A tibble: 8 × 2
## year n
## <dbl> <int>
## 1 1987 1820
## 2 1992 1820
## 3 1997 1820
## 4 2002 1820
## 5 2007 1820
## 6 2012 1820
## 7 2017 1820
## 8 2022 1820
##
## ==========================================================
## Dependent variable:
## -------------------------------------------
## mean_ln_prop_tax
## (1) (2)
## ----------------------------------------------------------
## mean_ln_hpi 1.435*** 0.527**
## (0.207) (0.186)
##
## lag_mean_hpi_1 0.968**
## (0.211)
##
## Constant 7.999*** 7.886***
## (1.100) (0.595)
##
## ----------------------------------------------------------
## Observations 8 7
## R2 0.889 0.978
## Adjusted R2 0.870 0.967
## F Statistic 48.011*** (df = 1; 6) 88.244*** (df = 2; 4)
## ==========================================================
## Note: *p<0.1; **p<0.05; ***p<0.01City-Level
##
## ==========================================================================================================
## Dependent variable:
## ---------------------------------------------------------------------------------------
## ln_prop_tax
## (1) (2) (3)
## ----------------------------------------------------------------------------------------------------------
## ln_hpi 1.291*** 0.612*** 0.681***
## (0.009) (0.014) (0.015)
##
## ca_flag:ln_hpi -0.263***
## (0.020)
##
## lag_ln_hpi_1 0.720*** 0.717***
## (0.015) (0.015)
##
## ----------------------------------------------------------------------------------------------------------
## City Fixed Effects Yes Yes Yes
## Observations 14,560 12,740 12,740
## R2 0.604 0.620 0.626
## Adjusted R2 0.547 0.556 0.563
## F Statistic 19,395.910*** (df = 1; 12739) 8,900.528*** (df = 2; 10918) 6,079.525*** (df = 3; 10917)
## ==========================================================================================================
## Note: *p<0.1; **p<0.05; ***p<0.01