On Oct 11, 5:22 am, Jerry W. Lewis wrote:
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" wrote:
On Oct 10, 3:48 pm, "Mike Middleton" wrote:
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

"Fin Fang Foom" wrote in oglegroups.com...

On Oct 10, 12:04 pm, "Mike Middleton" wrote:
Fin Fang Foom -

Use the array-entered LINEST worksheet function.

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

"Fin Fang Foom" wrote in
ooglegroups.com...

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/viewto...ighlight=-Hide
quoted text -

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

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

- Show quoted text -

Hi Jerry


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