Hi, I'm trying to use the Linest function to perform linear regression on a set of data. My known ys are in one row, and there are 65 values. I'm trying to fit those values against 27 known xs (ie - an array with 27 rows and 65 columns) however, I'm getting a #ref error. The error seems to go away when I limit my known xs to 16 rows. I'm sure I've used this function with known x arrays of greater than 16 rows before, and there's no mention of a limit to the number of rows in the help docs, so I don't think it's an excel limitation. Does anyone have any ideas what could be causing the error?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Limits of the Linest function in Excel
- Thread starter murad5
- Start date
- Status
Similar threads
- Locked
- Question