Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a set of data that is non-linear and believe it will fit a power trend
equation. I have been unable to locate a program that will curve fit the data. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
the trend line in the Graph Function.
Linest You can see how Bernard Liengme solves for the coefficients of a polynomial curve using LINEST. Perhaps you can adapt a similar approach to working with your 6th order polynomial equation. http://www.stfx.ca/people/bliengme/E...Polynomial.htm -- Regards, Tom Ogilvy "Houston banker" <Houston wrote in message ... I have a set of data that is non-linear and believe it will fit a power trend equation. I have been unable to locate a program that will curve fit the data. |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Supplementing Tom's response:
Create a chart with the data. Then, in the chart select the plotted series then select Chart | Add Trendline... and select the appropriate option. Also, in addition to Bernard's web page that Tom referenced, you may want to check Trendline coefficients http://www.tushar-mehta.com/excel/ti...efficients.htm -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , "=? Utf-8?B?SG91c3RvbiBiYW5rZXI=?=" <Houston says... I have a set of data that is non-linear and believe it will fit a power trend equation. I have been unable to locate a program that will curve fit the data. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how can you calculate trend line formula values for power series | Excel Discussion (Misc queries) | |||
Trend Line | Charts and Charting in Excel | |||
How do I set a Trend Line and Remove the Data Line | Charts and Charting in Excel | |||
Trend line | Charts and Charting in Excel | |||
trend line | Charts and Charting in Excel |