# How to calculate Polynomial Trendline Values 5th and 6th degree

#### D_Spark

##### Board Regular
The trendline that produces a best fit for my data is a six factor polynomial. Excel displays the full equation on the chart. I wanted to work out a way to obtain my trendline values? I needed these trendline values to know exactly where my actual datapoints fall relative to my trendline.

I have based my calculations on the following formula

=(INDEX(LINEST(\$J\$3:\$J\$62,\$A\$3:\$A\$62^{1,2,3}),1)*A3^3)+(INDEX(LINEST(\$J\$3:\$J\$62,\$A\$3:\$A\$62^{1,2,3}),1,2)*A3^2)+(INDEX(LINEST(\$J\$3:\$J\$62,\$A\$3:\$A\$62^{1,2,3}),1,3)*A3^1)+INDEX(LINEST(\$J\$3:\$J\$62,\$A\$3:\$A\$62^{1,2,3}),1,4)

Can some please advise of the correct formula syntax for my requirements for six factor polynomial and also what would the formula look like for a five factor polynomial:

Thanks

### Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Replies
4
Views
357
Replies
7
Views
152
Replies
10
Views
831
Replies
12
Views
331
Replies
11
Views
553

1,129,586
Messages
5,637,225
Members
416,963
Latest member
samfuge

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back