Forum Discussion
same XY Scatter with different R square
I have a set of X and Y, as below.
| X | Y |
| 0.05 | 0.28344174663489400 |
| 0.5 | 1.26762275157997000 |
| 1 | 3.43248288736777000 |
| 2 | 9.69228927203065000 |
| 3.5 | 19.16153253754330000 |
| 5 | 26.01969057665260000 |
In my computer trying Office 2013, 2016, and 2019, all the R square of the linear trend is 0.9886, while in my friends' computers, it's 0.9945. We used SAS and SPSS to calculate, which also showed R2=0.9945.I used them to produce a linear trend with intercept = 0.
Is anything wrong with my computer?
How can I fix it?
2 Replies
Hello! You've posted your question in the Tech Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Office 365 space - please post Office 365 questions here in the future.
- Ok thanks
