Error / Uncertainty in Excel

[Jel]

I'm a physics student trying to use excel for my experimental data.
After inputting my values and their uncertainties (the error of the values),
I plot the values to find the slope and intercept but I can't find a way to
include their errors. It's possible to include error bars, but they're just
for show and don't actually do anything.

Is there a way for excel to calculate the error / uncertainty of a slope and
intercept?

 

[Mike Middleton]

Jel -

The array-entered LINEST worksheet function provides standard errors of the
regression coefficients.

Or, for formatted output, use the Regression tool of the Analysis ToolPak
(an add-in provided with Excel).

- Mike

http://www.MikeMiddleton.com

 

[Bernard Liengme]

Have a look here
http://people.stfx.ca/bliengme/ExcelTips.htm
where I have notes on confidence limits
best wishes