Creating a polynomial equation without charting a trendline

[rollinn95z]

I have a chart that displays a series of data. From that, I add a polynomial trendline and extract the coefficients to generate a curve fit equation. Is there a way to generate this polynomial equation (pulling the coefficients) of the data without invoking the charting function??

Thanks.

[rylo]

Hi

If your x data is in column A, put your y data in column C. Then in column B, create your x^2 data. You could then use LINEST to extract the relevant data. I'm pretty sure that the chart will always use a starting point of 1 with an increment of 1 when it is working out your coefficients so if you want to match the chart formula, the you may have to change your x variables.


hth

rylo