MrExcel Publishing
Your One Stop for Excel Tips & Solutions

LINEST CSE Function


Posted by Rob Parry on February 06, 2002 11:27 AM

Is there a seperate function for finding the standard error values of the x coefficients (m) without using the Linest fuhction?

Thanks,

RP


Posted by Mark W. on February 06, 2002 12:13 PM

Why do you desire a separate function?...

..if you just want these values, you can use...

=INDEX(LINEST(known_y's,known_x's,,1),2,0)