software

Having 2 columns of data x and y, i can fit a *logarithmic *trend to
them after creating a scatterplot. Adding the trendline gives an
R-Squared value. How do I calculate -this- RS myself, without going
through the chart-thing?
Thx!--
lcoddens
------------------------------------------------------------------------
lcoddens's Profile: www.excelforum.com/member.php...oamp;userid=32252
View this thread: www.excelforum.com/showthread...hreadid=520036=LINEST(ydata,LN(xdata),,TRUE)

Jerry

quot;lcoddensquot; wrote:

gt;
gt; Having 2 columns of data x and y, i can fit a *logarithmic *trend to
gt; them after creating a scatterplot. Adding the trendline gives an
gt; R-Squared value. How do I calculate -this- RS myself, without going
gt; through the chart-thing?
gt; Thx!
gt;
gt;
gt; --
gt; lcoddens
gt; ------------------------------------------------------------------------
gt; lcoddens's Profile: www.excelforum.com/member.php...oamp;userid=32252
gt; View this thread: www.excelforum.com/showthread...hreadid=520036
gt;
gt;

Hi,

If you want a formula that returns just the R-squared value, the formula is
=RSQ(y-range,LN(x-range))

If you want the trendline coefficients and the regression statistics
(including the R-squared value) calculated, use the LINEST function (see the
response of Jerry W. Lewis for your post)

Regards,
B. R. Ramachandran

quot;lcoddensquot; wrote:

gt;
gt; Having 2 columns of data x and y, i can fit a *logarithmic *trend to
gt; them after creating a scatterplot. Adding the trendline gives an
gt; R-Squared value. How do I calculate -this- RS myself, without going
gt; through the chart-thing?
gt; Thx!
gt;
gt;
gt; --
gt; lcoddens
gt; ------------------------------------------------------------------------
gt; lcoddens's Profile: www.excelforum.com/member.php...oamp;userid=32252
gt; View this thread: www.excelforum.com/showthread...hreadid=520036
gt;
gt;


Thank you!--
lcoddens
------------------------------------------------------------------------
lcoddens's Profile: www.excelforum.com/member.php...oamp;userid=32252
View this thread: www.excelforum.com/showthread...hreadid=520036