Polynomial fit using EXCEL

  • Thread starter JamesJames
  • Start date
  • #1
205
0
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?

James
 

Answers and Replies

  • #2
dduardo
Staff Emeritus
1,890
3
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.
 
  • #3
FredGarvin
Science Advisor
5,066
9
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.
 
  • #4
205
0
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?

James
 

Related Threads on Polynomial fit using EXCEL

  • Last Post
Replies
4
Views
213K
  • Last Post
Replies
9
Views
4K
  • Last Post
Replies
3
Views
92K
Replies
2
Views
918
  • Last Post
Replies
4
Views
885
Replies
5
Views
675
  • Last Post
Replies
3
Views
2K
  • Last Post
Replies
3
Views
2K
Top