Wrong R2 value by Mac

Ayu Miyamoto 1 Reputation point
2020-10-26T13:19:29.243+00:00

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?
35083-image.png

34869-image.png

Office Mac
Office Mac
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Mac: A family of Apple personal computers that run the macOS operating system.
482 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Hua-MSFT 27,581 Reputation points
    2020-10-27T04:18:09.25+00:00

    @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.

    1 person found this answer helpful.
    0 comments
  2. Ayu Miyamoto 1 Reputation point
    2020-10-27T09:24:52.917+00:00

    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
    35403-screenshot-mac.png35376-screenshot-win.png

  3. Ayu Miyamoto 1 Reputation point
    2020-10-28T10:31:43.527+00:00

    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
    35695-screenshot-2020-10-28-at-112214.png

    0 comments