Guest User

Untitled

a guest
Apr 16th, 2025
33
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
R 1.38 KB | None | 0 0
  1. combined_df <- data.frame(
  2.      Date = as.Date(as.yearmon(index(combined_m))),
  3.      coredata(combined_m)
  4.   ) %>%
  5.   dplyr::rename(
  6.     pop_m = POP,
  7.     pce_m = PCEC96,
  8.     dsp_m = DSPIC96,
  9.     umcsent_m = UMCSENT,
  10.     csu_m = CSUSHPISA,
  11.     totalsl_m = TOTALSL
  12.   ) %>%
  13.   dplyr::mutate(
  14.     # transform to base units
  15.     pop_m = pop_m * 1e3,          # Thousands → persons
  16.     pce_m = pce_m * 1e9,          # Billions → dollars
  17.     dsp_m = dsp_m * 1e9,          # Billions → dollars
  18.     totalsl_m = totalsl_m * 1e6,  # Millions → dollars
  19.    
  20.     # per-capita transformation
  21.     pce_pc = pce_m / pop_m,
  22.     dsp_pc = dsp_m / pop_m,
  23.     totalsl_pc = totalsl_m / pop_m,
  24.    
  25.     # log transformation
  26.     log_pce_pc = log(pce_pc),
  27.     log_dsp_pc = log(dsp_pc),
  28.     log_totalsl_pc = log(totalsl_pc),
  29.    
  30.     # diff-log transformation
  31.     dlog_pce_pc = c(NA, diff(log_pce_pc)),
  32.     dlog_dsp_pc = c(NA, diff(log_dsp_pc)),
  33.     dlog_totalsl_pc = c(NA, diff(log_totalsl_pc)),
  34.    
  35.     # moving average transformation
  36.     dlog_dsp_pc_lag1 = lag(dlog_dsp_pc, 1),
  37.     ma3_dlog_dsp_pc = rollmean(dlog_dsp_pc_lag1, k = 3, align = "right", fill = NA),
  38.    
  39.     # covid dummy
  40.     covid_dummy = ifelse(Date >= as.Date("2020-03-01") & Date <= as.Date("2021-06-30"), 1, 0)
  41.   ) %>%
  42.   na.omit()
  43.  
  44. model <- lm(dlog_pce_pc ~ ma3_dlog_dsp_pc * covid_dummy, data = combined_df)
  45. summary(model)
Advertisement
Add Comment
Please, Sign In to add comment