question

VISCAINOJennifer-0915 avatar image
0 Votes"
VISCAINOJennifer-0915 asked VISCAINOJennifer-0915 edited

Different values of coefficient of determination (R squared) on Excel

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.

not-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

DSPatrick avatar image
0 Votes"
DSPatrick answered

Q&A forums are currently English only. I'd try asking for help over here in dedicated forums.
https://social.msdn.microsoft.com/Forums/fr-fr/home
https://social.technet.microsoft.com/Forums/fr-fr/home
https://answers.microsoft.com/fr-fr

--please don't forget to upvote and Accept as answer if the reply is helpful--


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.