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