Home |
Search |
Today's Posts |
#1
|
|||
|
|||
multiple regression
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) |
#2
|
|||
|
|||
multiple regression
use LINEST for multivariable regression -- duane ------------------------------------------------------------------------ duane's Profile: http://www.excelforum.com/member.php...o&userid=11624 View this thread: http://www.excelforum.com/showthread...hreadid=477014 |
#3
|
|||
|
|||
multiple regression
thanks so much! -- indiana_jones81 ------------------------------------------------------------------------ indiana_jones81's Profile: http://www.excelforum.com/member.php...o&userid=28172 View this thread: http://www.excelforum.com/showthread...hreadid=477014 |
#4
|
|||
|
|||
multiple regression
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 -- indiana_jones81 ------------------------------------------------------------------------ indiana_jones81's Profile: http://www.excelforum.com/member.php...o&userid=28172 View this thread: http://www.excelforum.com/showthread...hreadid=477014 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple regression | New Users to Excel | |||
Multiple Regression in Excel 2002 SP3 (Office XP)? | Excel Worksheet Functions | |||
formula for linear regression | Excel Worksheet Functions | |||
mutiple regression help | Excel Discussion (Misc queries) | |||
XML / parent with multiple children and with multiple children | Excel Discussion (Misc queries) |