CORREL formula work on multiple dependents

F

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=
 
F

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?
 
M

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
 
F

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.
 
J

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
 
F

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top