LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
indiana_jones81
 
Posts: n/a
Default 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)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
multiple regression September21 New Users to Excel 5 September 25th 05 11:48 PM
Multiple Regression in Excel 2002 SP3 (Office XP)? KA Excel Worksheet Functions 3 September 23rd 05 01:50 AM
formula for linear regression DBane Excel Worksheet Functions 14 September 1st 05 09:54 PM
mutiple regression help happycow Excel Discussion (Misc queries) 1 July 30th 05 04:47 AM
XML / parent with multiple children and with multiple children Richard Excel Discussion (Misc queries) 0 January 5th 05 11:49 AM


All times are GMT +1. The time now is 01:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"