Error / Uncertainty in Excel

  • Thread starter Thread starter Jel
  • Start date Start date
J

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?
 
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
 
Back
Top