Excel: How automatically read coefficients from polynomial fit?
I need the coefficients from a polynomial trendline in a chart for further
calculations in excel. Is there a function in excel to get it automatically or do I need to manually type the values displayed in the chart into my worksheet? |
Excel: How automatically read coefficients from polynomial fit?
Use LINEST as demonstrated in
http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "M.R." wrote in message ... I need the coefficients from a polynomial trendline in a chart for further calculations in excel. Is there a function in excel to get it automatically or do I need to manually type the values displayed in the chart into my worksheet? |
All times are GMT +1. The time now is 01:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com