Home > Forum Home > Excel Multiple Regression Analysis and Forecasting Template > Interpreting QA output in Excel > Area variable data Share

Area variable data

Excel Help for Area Variable Data in Excel Multiple Regression Analysis and Forecasting Template


Forum TopicLogin

Area Variable Data

Rate this:
(3/5 from 1 vote)
SurprisedThank you for sending through your data. The problem is with the Area independent variable data. You will notice that the regression analysis does actually complete and the error then appears when setting up the forecasting options. This is because the data for area has only 1 or 0 which is presumably for a Boolean result (either in the area or not). Normally this is not an issue, however the recurrence of only 1s followed by only 0s causes and issue with the algorithm to find linear, polynomial and exponential trends within the data. The solution is to reorder the observations slightly (such as putting the last row of dat as the first one) to create variability within the series. As a quick test, simply change cell G4 (first Area observation) of the Input sheet from 1 to 0 and re run the analysis.
 Excel Business Forums Administrator
 Posted by on
 
View Full Post

Find relevant Excel templates and add-ins for Area variable data in the