ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   polynomial trendline (https://www.excelbanter.com/excel-worksheet-functions/140797-polynomial-trendline.html)

Nathoucan

polynomial trendline
 
How can I calculate from two series of values (x and y) entered in an Excel
table the polynomial trendline equation.This without putting it into a graph.
I want to use the equation to calculate specific points after.

Jerry W. Lewis

polynomial trendline
 
You can calculate the polynomial coefficients with LINEST
http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm
Similarly, you can predict unknown values without the intermediate step of
obtaining the coefficients with TREND function.

Jerry

"Nathoucan" wrote:

How can I calculate from two series of values (x and y) entered in an Excel
table the polynomial trendline equation.This without putting it into a graph.
I want to use the equation to calculate specific points after.



All times are GMT +1. The time now is 03:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com