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

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

Rate this: (3/5 from 1 vote)

	Thanks 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 mdboxberger on 28 Apr 2011

Replies - Displaying 1 to 8 of 8

Order Replies By: Most Recent | Chronological | Highest Rated

	Analyzing independent variables 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 Excel Helper on 28 Apr 2011

Re:Does the Spreadsheet provide method to input new independent variables... Rate this: (3/5 from 1 vote) Thanks - 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 mdboxberger on 28 Apr 2011

	Using the forecast feature Rate this: (3.5/5 from 2 votes) 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 Excel Helper on 28 Apr 2011

Re:Using the Forecast Feature 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 mdboxberger on 29 Apr 2011

	Forecast options from the Output sheet Rate this: (2.5/5 from 2 votes) 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 Excel Helper on 30 Apr 2011

	Forecast options from the Output sheet Rate this: (3/5 from 2 votes) 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 mdboxberger on 03 May 2011

	This support forum page crashes Internet Explorer 8 (Firefox & Chrome OK) Rate this: (3/5 from 1 vote) The 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 mdboxberger on 03 May 2011

	IE8 issue Rate this: (4/5 from 2 votes) 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 Excel Helper on 04 May 2011

Displaying page 1 of 1