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

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