View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Power Fit - Trendline

The power law fit gives Y = k X^n. You can transform this into a simple
linear regression model:

log Y = log K + n log X

Put the log of X and Y into two more columns, and use LINEST or simply SLOPE
and INTERCEPT to determine log K and n.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"gsamoil" wrote in message
...
Is it possible to link the Power Fit result back to the spreadsheet for
further data analysis?

My chart accurately displays all values however, I need to use these
values
for further data analysis.

Thank you.