Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

Standard Error of the X coefficient

Posted by Rob Parry on February 13, 2002 11:53 AM

Is there any way to find the Standard error of the x coefficient without using the LINEST function? I need to perform several t-tests. Please advise.

Check out our Excel Resources

Re: Standard Error of the X coefficient

Posted by Tom on February 13, 2002 12:05 PM

Gives the Slope, or simply use SLOPE

=INDEX(LINEST(array1,array2,,True),1,1)

' Standard Error

=INDEX(LINEST(array1,array2,,True),2,1)

' t-stat

=top / bottom

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.