Trendline - coefficient of a polynomial

[slam888]

Hello,
I have a set of experimental data. I'm using the option trendline to fit a polynomial regression curve. I can retrieve the equation by selecting "Display Equation on chart" then copy/paste to insert the equation in the worksheet and manipulate to extract the coefficients:
example:

y = 0.0004x3 - 0.0033x2 + 0.0122x + 0.0185
R² = 0.991​

It works but it's getting tideous.


I'm wondering if there is a formula that would return directly the coefficients of the polynomial equation, I found only linear regression.

Thank you for your help.

Seb

 

[pgc01]

Hi Seb
Welcome to the board

John Walkenbach posts here the formulas for the coefficients of the trendlines you can add to a chart:

http://spreadsheetpage.com/index.php/tip/chart_trendline_formulas/