Home > Forum Home > Excel Multiple Regression Analysis and Forecasting Template > What to enter when no value for datapoint Share

What to enter when no value for datapoint

Excel Help for What To Enter When No Value For Datapoint in Excel Multiple Regression Analysis and Forecasting Template


Forum TopicPost Reply Login

What To Enter When No Value For Datapoint

Rate this:
(3/5 from 1 vote)
ConfusedHello,  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?

Thank you very much! 
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
Confused
Rate this:
(3/5 from 1 vote)
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:
  1. Fill missing values with the last known value from before under the assumptions that the series has not changed since the last observation.
  2. 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. 
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for What to enter when no value for datapoint in the