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



"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?

Have a look here
http://people.stfx.ca/bliengme/ExcelTips.htm
where I have notes on confidence limits
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"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?