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!
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!
=LINEST(ydata,LN(xdata),,TRUE)
Jerry
"lcoddens" wrote:
>
> 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: http://www.excelforum.com/member.php...o&userid=32252
> View this thread: http://www.excelforum.com/showthread...hreadid=520036
>
>
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
"lcoddens" wrote:
>
> 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: http://www.excelforum.com/member.php...o&userid=32252
> View this thread: http://www.excelforum.com/showthread...hreadid=520036
>
>
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks