Linest

[mrroland]

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
	A	B	C	D	E	F
1	Jan	1,097	1,135.74	1.2321	-14.461	1119.8
2	Feb	1,126
3	Mar	1,068
4	Apr	1,076
5	May	1,066
6	Jun	1,090
7	Jul	1,097
8	Aug	1,067
9	Sep	1,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

 

[mrroland]

bump

 

[Andrew Poulsom]

Here's how to get the trend for that 2nd order polynomial:

Book12
	A	B	C	D	E	F
1	Jan	1,097	1,107	1.247835	-14.6284	1120.071
2	Feb	1,126	1,096
3	Mar	1,068	1,087
4	Apr	1,076	1,082
5	May	1,066	1,078
6	Jun	1,090	1,077
7	Jul	1,097	1,079
8	Aug	1,067	1,083
9	Sep	1,091	1,089
10	Oct		1,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]

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

All the best,
Roland