CurveFit.xlsx
![](/components/com_remository_files/file_image_709/img_709_01.png)
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
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.
![avatar johndoyle[admin]](/media/com_osmembership/avatars/62_56e81868b9b33.png)