multiple regression

I

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)
 
I

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CORREL formula work on multiple dependents 6
Regression gives slope of zero when x values smaller than 10^-7 2
Calulating a point on a line 2
calculate a point 3
Regression intercept to 0 2
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula 2
multivariate regression 1
Inernal function for finding y 1

Top