Solving for Coefficients of a polynomial

[Dan Mertens]

Is there a function in Excel that can return the
coefficients of a polynomial from a set of X values and a
set of Y values? I know you can get a trendline from a
chart but I need the coefficients by themselves, not in
equation form. Any help will be greatly appreciated.

 

[Bernard V Liengme]

Hi Dan,
See my website for how to use LINEST to get coeff of polynomial fit.
Use =LINEST(y-values, x-values^{1,2,3,4}........
Bernard
www.stfx.ca/people/bliengme/ExcelTips