Mike,

=CORREL(Xvalues,YValues)^2

or

=RSQ(YValues,XValues)

See also help on LINEST - there is more available in that help than in the CORREL help.

HTH,
Bernie
MS Excel MVP


"mikelee101" <mikelee101athotmaildotcom wrote in message
...
Hello,
I have a scatter chart with a power trendline. The R-squared value is
displayed. I did find formulae that I can use to calculate the c & b value
(for the equation y=c*x^b) directly from the data. My question is whether
there is a formula that I can use to either:

a-extract the R-squared value from the chart, or
b-calculate the R-sqared value directly from the data and equation values (c
& b).

I hope that makes sense. It's been a looooong time since I've used
Statistics, so I may have used some terms incorrectly. If so, I apologize.
Let me know and I can clarify.

Thanks for the help.
--
Mike Lee
McKinney,TX USA