multiple regression

[indiana_jones81]

hi,
i need to find the slope for a multiple regression equation. I 3 columns Y,X1,X2 with values. Now normally i can use slope(known y,known x) to get the slope. But in this case for the 100 variables i have i need to get the slope in batches of 30 variable at a time.

example: y is in A1:A100
x1 is in B1:B100
x2 is in C1:C100

i need to be able to do:
slope(A1:A30,B1:C30)
slope(A2:A31,B2:B31)
.
.
slope(A71:A100,B71:C100)

but slope does not support 2 X variables i can only use slope(A1:A30,B1:b30)
so i have to use data analysis for each 30 variables at a time and this is taking too long. any ideas???

Thanks

[duane]

use LINEST for multivariable regression

[indiana_jones81]

thanks so much!

[indiana_jones81]

ist actuallly use in the following format


=index(LINEST(known y's,known x's),1) x-intercept
=index(LINEST(known y's,known x's),2) y-intercept