near singular matrix error
Posted: Thu Oct 24, 2024 12:19 pm
Hi all!
I'm attempting to create a forecast of expected values to compare to actuals from a post-treatment period. However, I'm receiving a near singular matrix error. I'm almost certain this is caused by all the dummy variables I'm using (dom = day of month, moy = month of year, dow = day of week, mft = dummy variable for treatment). Please note: I've dropped an observation from each dummy variable in attempt to avoid perfect collinearity, but I don' think it worked.
I would like to estimate and evaluate the forecast over two time periods:
1. Pre-treatment estimation, pre-treatment evaluation: hoping this will allow me to use my t-stat on the treatment dummy variable to gauge the confidence intervals, and also back-test the forecast
2. Pre-treatment estimation, post-treatment evaluation: comparing the forecasted expected values to the actual values of the treatment period to quantify the impact of the treatment.
Please see the workfile below, containing the equation i'm attempting to estimate.
Thanks!
Bob
I'm attempting to create a forecast of expected values to compare to actuals from a post-treatment period. However, I'm receiving a near singular matrix error. I'm almost certain this is caused by all the dummy variables I'm using (dom = day of month, moy = month of year, dow = day of week, mft = dummy variable for treatment). Please note: I've dropped an observation from each dummy variable in attempt to avoid perfect collinearity, but I don' think it worked.
I would like to estimate and evaluate the forecast over two time periods:
1. Pre-treatment estimation, pre-treatment evaluation: hoping this will allow me to use my t-stat on the treatment dummy variable to gauge the confidence intervals, and also back-test the forecast
2. Pre-treatment estimation, post-treatment evaluation: comparing the forecasted expected values to the actual values of the treatment period to quantify the impact of the treatment.
Please see the workfile below, containing the equation i'm attempting to estimate.
Thanks!
Bob