Hello,
I wanted to do a simple linear regression analysis.
To do so, I selected the two data ranges I was interested in (x and y), and I created a scatter plot.
When I make a scatterplot and check "Show R-squared" in the graph settings, I am shown a different number than when I use the formula =COEFFICIENT.DETERMINATION.
However, I am using the same range of data.
Similarly, when I click on Data > Data Analysis > Linear Regression. I enter the same data range, and the detailed regression report shows me a coefficient of determination (R-squared) similar to =COEFFICIENT.DETERMINATION, but different from the graph.
Could you please explain what the problem is?
Thank you.