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.
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
