Suppose you have a plot of y=2x^3 with the x-values in A1:A12 and y-values
in B1:B12
Select two cells and enter =LINEST(LN(A1:A12),LN(B1:B12)) and use
CTRL+SHIFT+ENTER to complete it
You will get 3 and 0.693147
Suppose the 0.69 value is in E1 then =EXP(E1) gives you the 2
Now you know the parameters of the power curve
This is shown on my website
http://www.people.stfx/bliengme/Exce...Polynomial.htm but it seems the
university server is dead (again!) today
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"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.