Resolving Polynomial Trendline Formula for Chart
Thanks, MartinW, that was very helpful!
One thing I don't understand, though, is the formula that is displayed on
the chart for a trend line. Why are the coefficients in the displayed formula
not the same as the ones obtained with LINEST()? I thought maybe the
displayed formula used arbitrarily assigned X values starting with 0, but
that doesn't seem to be the case.
David Reynolds
|