same XY Scatter with different R square

%3CLINGO-SUB%20id%3D%22lingo-sub-2456743%22%20slang%3D%22en-US%22%3Esame%20XY%20Scatter%20with%20different%20R%20square%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2456743%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20set%20of%20X%20and%20Y%2C%20as%20below.%3C%2FP%3E%3CTABLE%20width%3D%22288%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2272%22%3EX%3C%2FTD%3E%3CTD%20width%3D%22216%22%3EY%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E0.05%3C%2FTD%3E%3CTD%3E0.28344174663489400%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E0.5%3C%2FTD%3E%3CTD%3E1.26762275157997000%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E3.43248288736777000%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E9.69228927203065000%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E3.5%3C%2FTD%3E%3CTD%3E19.16153253754330000%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E5%3C%2FTD%3E%3CTD%3E26.01969057665260000%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%3CSPAN%3E%3CBR%20%2F%3EIn%20my%20computer%20trying%20Office%202013%2C%202016%2C%20and%202019%2C%20all%20the%20R%20square%20of%20the%20linear%20trend%20is%200.9886%2C%20while%20in%20my%20friends'%20computers%2C%20it's%200.9945.%20We%20used%20SAS%20and%20SPSS%20to%20calculate%2C%20which%20also%20showed%20R2%3D0.9945.%3C%2FSPAN%3EI%20used%20them%20to%20produce%20a%20linear%20trend%20with%20intercept%20%3D%200.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20anything%20wrong%20with%20my%20computer%3F%3C%2FP%3E%3CP%3EHow%20can%20I%20fix%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2459523%22%20slang%3D%22en-US%22%3ERe%3A%20same%20XY%20Scatter%20with%20different%20R%20square%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2459523%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1081094%22%20target%3D%22_blank%22%3E%40linnan5945%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHello!%20You've%20posted%20your%20question%20in%20the%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FCommunity-Discussion%2Fbd-p%2FCommunityQuestions%22%20target%3D%22_blank%22%3ETech%20Community%20Discussion%20space%2C%3C%2FA%3E%20which%20is%20intended%20for%20discussion%20around%20the%20Tech%20Community%20website%20itself%2C%20not%20product%20questions.%20I'm%20moving%20your%20question%20to%20the%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Foffice-365%2Fbd-p%2FOffice365General%22%20target%3D%22_self%22%3EOffice%20365%20space%26nbsp%3B%3C%2FA%3E-%20please%20post%20Office%20365%20questions%20here%20in%20the%20future.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I have a set of X and Y, as below.

XY
0.050.28344174663489400
0.51.26762275157997000
13.43248288736777000
29.69228927203065000
3.519.16153253754330000
526.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

@linnan5945 

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