Wrong R2 value by Mac

Question

When I show the trendline and R2 values in Mac, they are wrong.
I opened the same file by Win PC, the R2 value is correct.
It's strange. Does anyone have same problem?
How can I modify it in Mac?

Answer 1

@Ayu Miyamoto ,

Based on your screenshots, is one value of R-Squared 0.9907, another one 0.28822697?
As I could not reproduce your issue, could you please right click the trendline > Format Trendline take a screenshot of the Trendline Option both on Mac and Windows? I would check the options.

Please also go to Excel for Mac, click Excel > About Microsoft Excel > check the version number of Excel. Ensuer the Office is updated to the laste one.

Generally, the differences of R-Squared values due to rounding, please make sure they have the same rounding.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Thank you for your reply.

The data itself is made by Win, so I tried it by Mac too. However the result is same.
Off course I selected three options for making R-squared, otherwise the equation and R-squares are not shown.
If "set-intercept" is not selected (means Y=aX+b formula for linear regression) in Mac, the R-squared seems OK. (see attached)
But I need "set-intercept" =0, then result is strange.
Luckily I could notice it, because I use both Win and Mac and the result is quite obvious to find the wrong R-squared.
However if it is the program error of excel for Mac, many people has same problems and possibly they don't notice it.

I will try RSQ function. and I know if I use "Data analysis" -> "Regression", it gives correct R-squared.
But it is not solution for excel for Mac.

Best regards,
Ayu

Answer 3

Dear emilyhua-msft

Thank you for your help.
The version is the latest (Ver.16.42), because I just updated to the office 365.

I have attached the screenshots of exactly same file opened by Mac and Win.

I know the R-squared values is rounding, but values by Mac is far from the correct value.
I checked the R-square values by my Mac are always wrong.
It is strange that Mac and Win show different R-square values with the same file.

Thank you in advance.
Ayu

Answer 4

I have exactly the same issue as Ayu.

I have used a linear fit in a graph on a Mac and it gives an R2 value. Opening exactly the same file on a Windows machine gives a slightly different R2 value (I didn't even do a refit - the value simply changes). This is really poor, as the R2 value should be identical and should not depend on the operating system nor on the excel version.

Given that this is a commonly used and rather basic tool on Excel, I would expect that the developers would want to priortise fixing this?