Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Linear Regression Error on Excel

  1. Apr 28, 2014 #1
    This is for an experimental physics homework,I am using the latest version of MS Excel. I have a set of data, I perform linear regression on them and it gives me a line y=ax + b.

    Given that both a and b have physical significance I would like to know how could I know the uncertainty associated with both a and b, so I could get meaningful results.

    How do I do this? The statistics pack seems to give everything but these values.

    Any help would be appreciated.
  2. jcsd
  3. Apr 28, 2014 #2


    User Avatar

    Staff: Mentor

  4. Apr 28, 2014 #3
    Uncertainty with regards to coefficients of a model fit to data can be inferred from so called "Goodness of Fit" measures. There are many different ways to approach this however, since you are using Excel, the easiest for way for you is to have Excel display the R2 value. You can do this by either right clicking on your line, selecting Format Trendline and checking off the box next to "Display R-squared value on chart." If you are fitting the line then the same dialog box will have that option on the bottom. Interpretation of the value is fairly straight-forward, a quick Google search will gives lots of discussions.
  5. May 10, 2014 #4
    useful textbook

    There is a useful textbook explaining things in an introductory manner. Have a look at: "Data Fitting and Uncertainty (A practical introduction to weighted least squares and beyond)", ISBN 978-3-8348-1022-9.
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook