Trendline - coefficient of a polynomial

slam888

New Member
Joined
Dec 10, 2011
Messages
1
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
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Watch MrExcel Video

Forum statistics

Threads
1,099,519
Messages
5,469,111
Members
406,637
Latest member
Mbsmbs

This Week's Hot Topics

Top