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

Missing data for regression

Excel Help for Missing Data For Regression in Excel Multiple Regression Analysis and Forecasting Template


Forum TopicLogin

Missing Data For Regression

Rate this:
(3.3/5 from 3 votes)
ConfusedThe 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
 
View Full Post

Find relevant Excel templates and add-ins for Missing data for regression in the