For the same set of data, e.g.
x1=1, y1=3
x1=2, y1=2
x1=3, y1=1
''' from sklearn.metrics import r2_score
r2_score([1,2,3], [3,2,1])'''
the result is -3
2. plot graph in excel -- add a trendline -- right-click on your trendline -- Format Trendline --
(1) if select the checkbox next to "Set Intercept = 0.0", the r2=-2.429
(2) if deselect the checkbox next to "Set Intercept = 0.0", the r2=1
3. linear regression in spss:
the r2 and adjusted r2 is 1
Why do the same set of data get different R2 calculated by three methods?
Hi,
My guess is that you want to compute Rsquare, the coefficient of determination. For your example, Rsquare equals (+1).
In general, Rsquare takes value in the interval [0,1], and there is certainly a mistake in your finding, "the result is -3".
See: https://stats.stackexchange.com/questions/606743/why-do-the-same-set-of-data-get-different-r2-calculated-by-three-methods-r2-sco
The short answer is because the three things you are doing are for three different questions. See the link suggested above. David Booth
Statistical software has various degrees of accuracy and error allowance. You can adjust some under general setting. But those software with coding space, console and command window have lesser errors.
The r-square value with -3 is a serious mistake or error from you end. Kindly check may be the value was -0.3 because r-square can't go beyond 0 and 1. Thank you
- Badges
- Science topic