Scribd
Upload
34 views6 pages

Polynomial Fitting for Data Sets

The document describes determining polynomials from a data set to model the relationship between variables X and Y. It shows data with X values from 1 to 9.2 and corresponding Y values. Polynomials of order 4 and 5 are calculated to model the data and their coefficients are determined using LINEST in Excel. Graphs compare the original data with the polynomials to assess fit. The process is demonstrated for both 4th and 5th order polynomials.

Uploaded by

Yann Van Osselaer
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
34 views6 pages

Polynomial Fitting for Data Sets

The document describes determining polynomials from a data set to model the relationship between variables X and Y. It shows data with X values from 1 to 9.2 and corresponding Y values. Polynomials of order 4 and 5 are calculated to model the data and their coefficients are determined using LINEST in Excel. Graphs compare the original data with the polynomials to assess fit. The process is demonstrated for both 4th and 5th order polynomials.

Uploaded by

Yann Van Osselaer
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd

determination of polynomials fro data sets

Data

X
1
2.6
3.1
3.9
5.6
6.1
7.3
8
9.2

Y
280
203.1
193
165
183
240.2
410.3
705.2
1152.9

Calculated from
Polynomial 4th
order
Err:504
Err:504
Err:504
Err:504
Err:504
Err:504
Err:504
Err:504
Err:504

Calculated from
Polynomial 5th
order
Err:504
Err:504
Err:504
Err:504
Err:504
Err:504
Err:504
Err:504
Err:504

1400

1200

f(x) = - 1.9860E-01x
1000

800

600

400

200

0
0

Polynomial

Y=A4*x^4+A3*x^3+A2*x^2+A1*x^+A0

4th order

Polynomial

Y=A5*x^5+A4*x^4+A3*x^3+A2*x^2+A1*x^+A0

5th order

Example:

Polynomial 4th Order

=INDEX(LINEST(b,a^{1,2,3,4}),5)

=INDEX(LINEST(b,a^{1,2,3,4}),4)

Coefficient A0

1,2,3,4 for Poly 4th order

a is the name of the range of data x-value (here cell C6 to C14)


(highlight cells, click on insert, click on name,
click on define, type the name for this range of cells)
b is the name of the range of data y-value (here cell D6 to D14)

Example:

Polynomial 5th Order

=INDEX(LINEST(b,a^{1,2,3,4,5}),6)

=INDEX(LINEST(b,a^{1,2,3,4,5}),5)

Coefficient A0

1,2,3,4,5 for Poly 5th order

a is the name of the range of data x-value (here cell C6 to C14)

b is the name of the range of data y-value (here cell D6 to D14)

Data with Polynomial 4th Order

Data with P

1400

1400

1200

1200
f(x) = - 1.9860E-01x^4 + 8.1851E+00x^3 - 5.7282E+01x^2 + 8.9217E+01x + 2.3746E+02

f(x) = - 3.1396E-01x^5 + 8.0146E+00x^4 - 7.0

1000

1000

800

800

600

600

400

400

200

200

0
0

10

A0
Err:502

A1
Err:502

A2
Err:502

A3
Err:502

A4
Err:502

A0
Err:502

A1
Err:502

A2
Err:502

A3
Err:502

A4
Err:502

T(b,a^{1,2,3,4}),4)

Coefficient A1

=INDEX(LINEST(b,a^{1,2,3,4}),3)

Coefficient A2
=INDEX(LINEST(b,a^{1,2,3,4}),2)

Coefficient A3

value (here cell C6 to C14)


=INDEX(LINEST(b,a^{1,2,3,4}),1)

range of cells)
value (here cell D6 to D14)

T(b,a^{1,2,3,4,5}),5)

Coefficient A4

=INDEX(LINEST(b,a^{1,2,3,4,5}),4)

A5
Err:502

Coefficient A1

Coefficient A2
=INDEX(LINEST(b,a^{1,2,3,4,5}),3)

Coefficient A3

value (here cell C6 to C14)


=INDEX(LINEST(b,a^{1,2,3,4,5}),2)

value (here cell D6 to D14)


Coefficient A4
=INDEX(LINEST(b,a^{1,2,3,4,5}),1)

Coefficient A5

Data with Polynomial 5th Order

.1396E-01x^5 + 8.0146E+00x^4 - 7.0982E+01x^3 + 2.8461E+02x^2 - 5.4192E+02x + 6.0138E+02

compare excel Polynomial


and calculated polynomial

10

You might also like