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

M

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 ?
 
R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top