Re: CORREL formula work on multiple dependents

Tech-Archive recommends: Fix windows errors by optimizing your registry

Fin Fang Foom -

Use the array-entered LINEST work*** function.

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


"Fin Fang Foom" <vj.contreras@xxxxxxxxx> wrote in message
news:1192025175.241180.280600@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

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=



.

Quantcast