CurveFit.xlsx

Rating:
4

Description


Purpose
To determine which order polynomial best fits the data and to calculate the coefficients for that polynomial
Method
For a linear LSQM fit we can use:
[Y] = [A] x {X}   
The values for [Y] and {X} is presented in the range Calc!P5:AB16.
Below this range in column P the values of [A] is calculated for every order from 1 to 11.
Columns C to M are then filled with data generated from these coefficients
In Rows 2 and 3 the correlations and errors are calculated for each order.
A conditinal format is used to highlight the applicable result.
Test
The TestData sheet at the end is used to generate data to paste (Values only) into the raw data column.
The results will be immediately highlighted.

Calculation Reference
Curve Fitting
Polynomials
Least Squares Method

Calculation Preview

Uploaded
06 May 2011
Last Modified
06 May 2011
File Size:
65.74 Kb
Downloads:
121
File Version:
1.0
File Author:
dfh
Rating:
4

 
Full download access to any calculation is available to users with a paid or awarded subscription (XLC Pro).
Subscriptions are free to contributors to the site, alternatively they can be purchased.
Click here for information on subscriptions.
Comments: 1
JohnDoyle[Admin] 13 years ago
The file opened with no problems in Excel 2010 but Excel 2003 failed to open it. Now I can open it I see that it is very well executed and laid out. I have happily awarded you a 6 month XLC Pro subscription. Thanks for your contribution to the site and I hope this is only the start of the dfh collection!