Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can you calculate trend line formula values for power series
can use LINEST for linear trendlines, LOGEST for Exp. trendlines, but Ican't
see how to get values for Power series trendlines. Anybody help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can you calculate trend line formula values for power series
see the website
http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm for how to use LINEST for linear, polynomial, log, power, and exponential equations. Power: y = ax^b =LINEST(LN(y-values), LN(x-values)) Gives Ln(a) and b On Monday, November 02, 2009 5:23 PM newby wrote: can use LINEST for linear trendlines, LOGEST for Exp. trendlines, but Icannot see how to get values for Power series trendlines. Anybody help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making a trend line for several series of data | Excel Worksheet Functions | |||
What is the formula to calculate time & power consumption | Excel Discussion (Misc queries) | |||
Need formula to calculate trend for the high values in data. | Excel Worksheet Functions | |||
Trend Line constants as Excel Cell Values | Excel Discussion (Misc queries) | |||
Getting values from a trend line | Excel Discussion (Misc queries) |