SLOPE, (error in b if y= a+ bx)

[Miesjz]

So I did my regression analysis using the SLOPE function, the number I'm
interested in however is the error in the result of SLOPE (b if y = a + bx).
What Excel function to use here ?

 

[Ron Rosenfeld]

So I did my regression analysis using the SLOPE function, the number I'm
interested in however is the error in the result of SLOPE (b if y = a + bx).
What Excel function to use here ?

Look at HELP for the LINEST function.

The standard error for the slope, assuming a single range of x-values, would be
returned by

=INDEX(LINEST(known_y's,known_x's,,TRUE),2)

--ron