Hello, I am new to your template, but have so far found it very useful. I am wondering, though, there are some datapoints I have been unable to collect and want to know how to reflect this in the "Input" without having it automatically change to "0" after I ask it to run the regression (which understandbly impacts the output). Does entering a "NA", "?" or "-" into a cell in the "Input" do the trick?
The template will automatically replace non-numeric data with zeros so that the regression analysis will run. Regression cannot be run where values are missing for independent variables and there are two possible solutions:
Fill missing values with the last known value from before under the assumptions that the series has not changed since the last observation.
Truncate the data to include only observations where data is available for all variables. This can be accomplished with a filter and Go to special > Visible cells only in Excel.