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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - SLOPE, (error in b if y= a+ bx) (https://www.excelbanter.com/excel-worksheet-functions/179398-slope-error-b-if-y%3D-bx.html)

Miesjz

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

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

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

On Mon, 10 Mar 2008 04:11:01 -0700, Miesjz
wrote:

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

All times are GMT +1. The time now is 04:47 PM.