Home > Forum Home > Excel Multiple Regression Analysis and Forecasting Template > Does the Spreadsheet provide method to input new independent variables... Share

Does the Spreadsheet provide method to input new independent variables...

Excel Help for Does The Spreadsheet Provide Method To Input New Independent Variables... in Excel Multiple Regression Analysis and Forecasting Template


Forum TopicPost Reply Login

Does The Spreadsheet Provide Method To Input New Independent Variables...

Rate this:
(3/5 from 1 vote)
ConfusedThanks for the nice program -

Does the Spreadsheet provide method to input new independent variables into the regression equation - i.e. input given independent variables, get the predicted dependent variable?

Or, do you have to construct it manually to input a new set of independent variables and get a predicted dependent variable?

Thanks,
MDBoxberger 
 Posted by on
 
Replies - Displaying 1 to 8 of 8Order Replies By: Most Recent | Chronological | Highest Rated
Happy
Rate this:
(2.5/5 from 2 votes)
The model is set up to test independent variables manually against the dependent variable in order to obtain the best predictive equation.

By evaluating the detailed analysis of each independent variable's impact on the dependent, variables can be included and excluded accordingly to determine the most appropriate regression equation for forecasting.
 Excel Business Forums Administrator
 Posted by on
ConfusedThanks - understood.

But, my questions was specific to this scenario:  I used the spreadsheet to anaylze real estate sales for a market area - size, date of sale, bathrooms, etc.

Then, for my one specific 'study' property, I want to use the equation to plug in the specific details for that property, and see the predicted value from the regression model's equation.

I know I can manually do it with the formula provided as output from your tool, but hoped there might be a 'hidden' feature that would construct the equation for me, and I just plug in the values for the property I'm studying?

Thanks for your excellent support!

MattB
 Posted by on
Surprised
Rate this:
(3/5 from 1 vote)
OK - now I understand too.

In this case, you want to use the Forecasting feature in the bottom right of the results.  Choose at least one period (to allow the input of the independent variables) and the option to 'Leave Blank' for each independent variable.  This will then output a forecast for the dependent variable using the regression equation with cells available to input the values of the independent variables to return the predicted value.
 Excel Business Forums Administrator
 Posted by on
Confused
Rate this:
(3/5 from 1 vote)
Great to hear the feature is there.  I did not see a way to select the option to 'Leave Blank' the independent variable.

I tried clearing out the values on the Forecast Tab and running again, and also clearing out the values on the Forecast Tab and inputting the independent variables, but neither option worked.

Could you explain how to use the 'Leave Blank' feature?

Thanks,
MattB 
 Posted by on
Oops
Rate this:
(3/5 from 1 vote)
At the bottom right of the Output sheet there is an area to specify the forecasting method for each of the independent variables used for the overall regression forecast.  If values are available for the independent variables, then the option to 'Leave Blank' should be selected in the blue cells to the right under Forecast Method. This will then allows values to be entered for each independent variable where this option has been specified to be used in the predication equation.
 Excel Business Forums Administrator
 Posted by on
Confused
Rate this:
(3/5 from 1 vote)
OK, I think I've got it working:

Input the values I want to use in the model on the 'Input' tab, on the row after my measured data.

Then, when run the forecast, the result is on the bottom line of the 'Forecast' tab.

thanks,
Matt
 Posted by on
ConfusedThe main business-spreadsheet page works fine, but going to this forum page to log in crashes IE8 on my system - is this a known issue?

Matt
(using Firefox)
 Posted by on
Oops
Rate this:
(3/5 from 1 vote)
Glad that the regression issue is resolved.  Thanks for the heads up for IE8. We have tested on many versions of IE including 8 but will definitely look into it.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Does the Spreadsheet provide method to input new independent variables... in the