| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I determine which order to use in a polynomial trendline? | Charts and Charting in Excel | |||
| Is there a way to obtain a polynomial trendline of order higher th | Charts and Charting in Excel | |||
| Increaseing Precision in polynomial trendline equations | Charts and Charting in Excel | |||
| Polynomial regression - how does Excel do it? (under "Trendline") | Charts and Charting in Excel | |||
| Polynomial trendline | Excel Worksheet Functions | |||
Hybrid Mode
