Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel TREND results
I've been using the TREND function in Excel to do curve fitting to some
data. The problem I'm having is that I can not find the actual coefficients that make up the 6th. Order Polynomial that fitted the data. I'm looking for something like..... Ax^6 + Bx^5 + Cx^4 + Dx^3 + Ex^2 + Fx + G Where I can used the A, B, C, D, E, F and G coefficients in other formulas. Chris. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel TREND results
Hi,
Have a look at these pages on the subject of trendlines and formula. http://www.stfx.ca/people/bliengme/E...Polynomial.htm http://www.tushar-mehta.com/excel/ti...efficients.htm Cheers Andy wrote: I've been using the TREND function in Excel to do curve fitting to some data. The problem I'm having is that I can not find the actual coefficients that make up the 6th. Order Polynomial that fitted the data. I'm looking for something like..... Ax^6 + Bx^5 + Cx^4 + Dx^3 + Ex^2 + Fx + G Where I can used the A, B, C, D, E, F and G coefficients in other formulas. Chris. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get the concatenate function in Excel to display results? | Excel Worksheet Functions | |||
My DCOUNTA formula results do not display in Excel. | Excel Worksheet Functions | |||
how do i set results to appear in status bar of excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |