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...968&highlight=

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" wrote in message
oups.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...968&highlight=

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...68&highlight=- 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?

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" wrote in message
ups.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...68&highlight=- 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?

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.

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.