Multiple Regression

Excel Help for Multiple Regression in Excel Multiple Regression Analysis and Forecasting Template

Multiple Regression

Rate this: (3/5 from 1 vote)

	Hello I'm not that good in math and i have searched through the internet but came out way confused than before. i would like to know in multiple regression, how does one know when to add another independent variable? do you have to test it in a simple liner regression first then transfer it to a multiple regression? Is it possible to test whether a variable that i added have any relationshipwith the rest of the variable by using some equations? in plotting multiple regression is it usually in a 3d space? how about if you have more than 3 variables how will my graph look? please help me thanks in advance
	Posted by anthony001 on 29 Feb 2008

Replies - Displaying 1 to 3 of 3

Order Replies By: Most Recent | Chronological | Highest Rated

	Independent analysis Rate this: (3/5 from 1 vote) The best way to see whether an independent variable has influence over the dependent variable is to view the Indepenent analysis to see if the r-squared is significantly large. The chart is two dimensional showing the actual versus predicted dependent variable based on the resulting regression equation.
	Excel Business Forums Administrator
	Posted by Excel Helper on 03 Mar 2008

so is this correct? Rate this: (3/5 from 1 vote) so for example: i want to do a multiple regression on let's say voter's behavior then i arrive at a formula voter's behavior = B0 + B1X1+ B2X2 + B3X3 my question is this. should all regression start off as linear regression? meaning that i should add variable one at a time? if so and i have 3 independent variable i wanted to add and i want to test the residuals and coefficient of each one, should i convert them to linear regression? like this  voter's behavior = B0 + B1X1 voter's behavior = B0 + B2X2 voter's behavior = B0 + B3X3 or does multiple regression have a different approach?

Posted by anthony001 on 04 Mar 2008

	Add all 3 Rate this: (3/5 from 1 vote) You can add all 3 independent variables and then evaluate which ones to keep from the independent analysis.
	Excel Business Forums Administrator
	Posted by Excel Helper on 04 Mar 2008

Displaying page 1 of 1