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=