Breaking down the polynomial

duration17

New Member
Joined
Sep 26, 2006
Messages
9
Hello!

I am using INDEX() &LINEST() to get the coefficients for a quadratic polynomial regression (using =INDEX(LINEST(y:y,x:x^{1,2}),1,3) kind of formulas). I would like to understand every step of the calculation. Does anyone know how to break down the calculation, using SLOPE() and INTERCEPT() ?

Many thanks,
 

duration17

New Member
Joined
Sep 26, 2006
Messages
9
PGC01,
Thank you very much!
Everything is clearer now and am able to understand everything better.
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

duration17

New Member
Joined
Sep 26, 2006
Messages
9
Hello again.

Thanks to your help I managed to understand better all steps of the polynomial. I have it plotted and it matches the trendline provided with excel.

Now I am trying to forward it (forecast), by dragging down the calculations (y = (c2 * x^2) + (c1 * x ^1) + b), but it does not match the forward polynomial of excel :(

do you have any idea why? i can send you the file if it helps.
 

Forum statistics

Threads
1,141,302
Messages
5,705,587
Members
421,400
Latest member
chakam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top