Hi,

I'm using the "Power" trendline in an XY scatter chart and want to use
the formula and the rsquared result in a worksheet.

What worksheet function can I use to to show the function (or it's
components) and the rsquared within the worksheet?

(The formula stated on the chart is: y = 644.691x^-0.895)

I've looked at LINEST but that seems to only give a straight line
trend?

LOGEST gives me the exponential result?

Basically I'm worried about using the rsquared value from the chart if
I don't have it through a function as well.

Anyone able to help?

Thanks!


--
acjim
------------------------------------------------------------------------
acjim's Profile: http://www.excelforum.com/member.php...o&userid=24487
View this thread: http://www.excelforum.com/showthread...hreadid=381152