# Linest

#### mrroland

##### Active Member
Hi,

From the below thread (very usefull) i was able to simulate the equation made by the graph when i applied a polynomial graph

http://www.mrexcel.com/board2/viewtopic.php?t=93761&highlight=linest

However, i am having difficulty to understand the outcome of this. The graph produces a formula but, how do i apply that formula in excel?

My objective is to reproduce the graph by calculating the numbers in column C but so far to no avail.
Book4.xls
ABCDEF
1Jan1,0971,135.741.2321-14.4611119.8
2Feb1,126
3Mar1,068
4Apr1,076
5May1,066
6Jun1,090
7Jul1,097
8Aug1,067
9Sep1,091
polynomial 2 (2)

Any feedback on this is greatly appreciated.

edit: sorry the equation on hte graph shows ==> y = 1.2321x2 - 14.461x + 1119.8

Cheers,
Roland

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

bump

#### Andrew Poulsom

##### MrExcel MVP
Here's how to get the trend for that 2nd order polynomial:
Book12
ABCDEF
1Jan1,0971,1071.247835-14.62841120.071
2Feb1,1261,096
3Mar1,0681,087
4Apr1,0761,082
5May1,0661,078
6Jun1,0901,077
7Jul1,0971,079
8Aug1,0671,083
9Sep1,0911,089
10Oct1,099
Sheet1

The formula in C1 is:

=(D\$1*(ROW(A1)^2))+(E\$1*ROW(A1))+F\$1

copied down.

If you create an XY(scatter) chart from your data and add a polynomial trend line you will see those values.

#### mrroland

##### Active Member
Andrew, Thank you very much. Your solution works perferct!

All the best,
Roland

Replies
11
Views
468
Replies
0
Views
1K
Replies
2
Views
3K
Replies
1
Views
409
Replies
1
Views
864

1,191,416
Messages
5,986,430
Members
440,029
Latest member
GabSSSH

### 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