Calculating the 95% confidence inteval of a slope

[seeker]

As a low key user, I can calcualte the slope of a line from the x and y
values, but I don't know how to determine how good the estimate is. Can
someone help?

 

[Bernard Liengme]

1) Using Analysis ToolPac Regression tool. See
http://www.jeremymiles.co.uk/regressionbook/extras/appendix2/excel/
http://www.stat.wmich.edu/s216/book/node128.html

2) With LINEST and/or STEYX. See
http://office.microsoft.com/en-us/excel/HA011119631033.aspx
quote:The STEYX function calculates the standard error of a regression, a
measure of the amount of error accrued in predicting a y for each given x.
This function takes the form =STEYX(known_y's, known_x's). If we apply this
function to the worksheet shown in Figure 3, the formula =STEYX(B2:B19,
A2:A19) returns a standard error value of 12.96562.
end quote

3) If you have the stomach for YouTupe

best wishes