CORREL formula work on multiple dependents

[Fin Fang Foom]

I'm trying to do a multiple regression but using formulas but it seems
I can't get these formulas to work on multiple dependents.

=CORREL(Y,X1,X2,X3,X4)

=RSQ(Y,X1,X2,X3,X4)

=INTERCEPT(Y,X1,X2,X3,X4)

=SLOPE(Y,X1,X2,X3,X4)

Are there other formulas could do this? I know I could use the Data
Analysis in excel for this but managment would like a formula version.

I also post this qustion to the link below.
http://www.mrexcel.com/board2/viewtopic.php?t=295968&highlight=

 

[Mike Middleton]

Fin Fang Foom -

Use the array-entered LINEST worksheet function.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

 

[Fin Fang Foom]

Fin Fang Foom -

Use the array-entered LINEST worksheet function.

- Mike Middletonhttp://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel








- Show quoted text -

Hi Mike,

I have but I'm trying to get indiviual formulas for Regression
Statistics.


Multiple R
R Square
Adjusted R Square
Standard Error
Observations

Does anyone has a sample file for this?

 

[Mike Middleton]

Fin Fang Foom -

You asked about "formulas" but your examples are "functions." Which do you
want?

If worksheet functions are acceptable, you can use the INDEX and LINEST
functions to get most of the results. John Walkenbach shows how at
http://www.j-walk.com/ss/excel/tips/tip101.htm

Instead, if you want formulas (add-subtract-multiply-divide), the answer for
multiple regression usually involves matrix operations (linear algebra), and
it's not much fun to do the calculations any other way.

- Mike

 

[Fin Fang Foom]

Fin Fang Foom -

You asked about "formulas" but your examples are "functions." Which do you
want?

If worksheet functions are acceptable, you can use the INDEX and LINEST
functions to get most of the results. John Walkenbach shows how athttp://www.j-walk.com/ss/excel/tips/tip101.htm

Instead, if you want formulas (add-subtract-multiply-divide), the answer for
multiple regression usually involves matrix operations (linear algebra), and
it's not much fun to do the calculations any other way.

- Mike

Click on the link below I post a an example. It will give you a better
idea what I'm looking for.

 

[Jerry W. Lewis]

All of the output from the ATP multiple regression tool comes either directly
or indirectly from the LINEST function (as Mike already told you). Help is
misleading, but you can pass a multiple column range to LINEST and get
multiple regression output.

Jerry

 

[Fin Fang Foom]

All of the output from the ATP multiple regression tool comes either directly
or indirectly from the LINEST function (as Mike already told you). Help is
misleading, but you can pass a multiple column range to LINEST and get
multiple regression output.

Jerry






- Show quoted text -

Hi Jerry


Thank you so much for replying. Honestly I very little experience in
stats. Can you post example file.