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

Polynomial fit using EXCEL

  1. Mar 18, 2005 #1
    I performed a fit, using EXCEL, to data and the fit gave me a polynomial. How do I get the uncertainty in the resulting parameters. For example the least squares fit gives y = Ax+B and there are equations to give the uncertainties in A and B. IS there a program that does this for non linear fits?

  2. jcsd
  3. Mar 18, 2005 #2


    User Avatar
    Staff Emeritus

    You'll want to output the R^2 correlation coefficient. The closer R^2 is to 1, the more accurate the equation is. I know excel can output it, but i'm not sure exactly how since I haven't used excel in a long time.
  4. Mar 18, 2005 #3


    User Avatar
    Science Advisor

    In the "INSERT TRENDLINE" dialog box, there is a tab for options. At the bottom of the dialog box you will see three check boxes. "SET INTERCEPT TO 0," "DISPLAY EQUATION ON CHART" and "DISPLAY R^2 ON CHART." Select the ones you want.

    Word of warning, if you check the equation output, you may have to increase the number of decimal places shown in the equation to get better correlation between your regression and the data.
  5. Mar 22, 2005 #4
    How about performing a fit to data that should obey [csc(theta/2)]^4. Would this be out of a numerical methods book or something?

Share this great discussion with others via Reddit, Google+, Twitter, or Facebook