Multiple regression need formulas

[Fin Fang Foom]

Hi everyone me again.

Does anyone have any examples how to a multiple regression with formulas?

I'm very new to this stuff and I'm learning. Right now I'm using a Data Analysis tool for regression. This what I did to get the multiple regression.

1. Click on "Tools" then "Data analysis" then choose regression

2. Click on Y range icon - input (highlight) the Y range (dependent variable) - hit "Enter"

3. Click on X range icon - input (highlight) the X range (4 independent variables) - hit "Enter"

4. Check the Labels box (make sure you have included the top labels row in the input ranges)

5. Under "output options" check "New Workshhet Ply"

6. check the "Residuals" box


Hopefully I did that right. But my boss would like me to make template with formulas. Take a look at the example below in cells D4:D8 I did some research and I came up with those formulas but its not comming out the same as the Summary Ouput results. Or are they? I just dont know.

Does anyone knows if they are? Also does anyone knows how to do this with formulas?

Alfredo2.xls
	A	B	C	D	E	F	G	H	I
1	SUMMARY OUTPUT
2
3	Regression Statistics
4	Multiple R	0.970477245		0.917106137
5	R Square	0.941826083		0.841083666
6	Adjusted R Square	0.929578943		0.826636727
7	Standard Error	0.088765731		0.140515269
8	Observations	24		24
9
10	ANOVA
11		df	SS	MS	F	Significance F
12	Regression	4	2.423744	0.605935897	76.90171	1.83E-11
13	Residual	19	0.149708	0.007879355
14	Total	23	2.573451
15
16		Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
17	Intercept	0.53730577	0.03273	16.41641689	1.11E-12	0.468802	0.60581	0.468802	0.60581
18	0	0.056358131	0.018668	3.018922886	0.007059	0.017285	0.095431	0.017285	0.095431
19	0	0.036454347	0.011576	3.149047596	0.005284	0.012225	0.060684	0.012225	0.060684
20	0	0.022872332	0.00343	6.668276197	2.24E-06	0.015693	0.030051	0.015693	0.030051
21	0	0.005432485	0.003014	1.802495018	0.087354	-0.00088	0.011741	-0.00088	0.011741
Sheet1

 

[Oaktree]

Have a look at the LINEST worksheet function in Excel help (and, specifically example 3 for "Multiple Linear Regression").

 

[Fin Fang Foom]

Have a look at the LINEST worksheet function in Excel help (and, specifically example 3 for "Multiple Linear Regression").

Hi Oaktree,


Thank you for repyling. I have looked at that example but it does not give much. Is there any other link how to this with formulas only?

 

[Oaktree]

Maybe Tushar's writeup here will help:

http://www.tushar-mehta.com/publish_train/data_analysis/16.htm

The whole article is worth reading, but the sections on "Understanding the result" (roughly 1/5 of the way down) and "Linear regression with multiple variables" (roughly 1/2 way down) are particularly relevant to your example.

 

[Fin Fang Foom]

Maybe Tushar's writeup here will help:

http://www.tushar-mehta.com/publish_train/data_analysis/16.htm

The whole article is worth reading, but the sections on "Understanding the result" (roughly 1/5 of the way down) and "Linear regression with multiple variables" (roughly 1/2 way down) are particularly relevant to your example.

Thanks Oaktree I'll read up on it.