View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Mike Middleton Mike Middleton is offline
external usenet poster
 
Posts: 762
Default Error / Uncertainty in Excel

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



"Jel" wrote in message
...
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?