Multiple Linear Regression with Excel

This a brief about using Microsoft Excel in order to apply Multiple Linear Regression
to get the regressor coefficients , ANOVA ( Analysis of Variance Table ) , R^2 ( Determent Coefficient ) and the Residual ..
we also apply it to get the graphs of the residual and normal probability plot
by this way we can get the Linear Regression model : y=B0+B1Xn+......+BnXn

Done By : Aref Esam Asaad

Category:

Education

Tags:

• Aref
• Asaad

[arefasaad]

@ sergeantRC , what do you mean by doing them individually ?

first of all , you can`t calculate them individually since we have more than one independent value , and we also have only one dependent value

as a result that dependent value will depend on all independent value

so we have the coefficient

B^=(X`X)-1 X`y >> where X^X and X`y are matrices

[arefasaad]

just move the video to the 6th minute , you will find that I already talked about the coefficients which are B0, B1, B2

but what you meant by B0 and B1 is single regression

however, this is multiple linear regression

does not matter if you mean B0 = intercept

you will find it in the table

where B1, B2 are the other coefficients of the independent variables x1 and x2

so the equation become :

y=B0+B1X1+B2X2

[arefasaad]

You are welcome all ,,, I appreciate your comments

and I will work hard to do such statistic subjects .

[arefasaad]

to be useful and watch it clearly

just change the mode to HD next to the audio control in the screen

[Noveleffect]

@ratupel I like that he shows us EVERY STEP. If it's so annoying, fast forward to the part that interests you most.

[Noveleffect]

beautiful! Thank you!



[beergaucho2]

This was helpful. Thank you!

[TheAmeriswede]

Thank you very much arefasaad!

[RASTEE112]

thnx

[foliolizer]

Foliolizer helps you to draw a dot on the Return-risk chart with no efficient frontier curve on the chart and help you manipulate your new allocations to study its impact on expected portfolio return and portfolio risk.

[ratupel]

arefasaad, for the next video skip us the pain of watching how you introduce data in the sheet

[mava96]

disgustingly BASIC !

looks to me like he just wanted to show his VMware running on his mac ...

[atanuswati]

Great, thanks

[diuneya]

it really helps! i m also doing the regression project =(

THANK YOU SO MUCH, GREATLY APPRECIATED!!