logarithmic regression

L

lcoddens

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!
 
B

B. R.Ramachandran

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

extracting R-squared value from a chart 3
Chart distorts secondary axis when the x-axis is logarithmic 5
Getting the values from a logarithmic trendline 4
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula 2
Logarithmic Trendline 2
How do you display the equation and R-squaredvalue onto an Excel scatter plot chart? 1
Problem creating a logarithmic trend line 2
Regression P-Value Function 2

Top