Excel 2016 Mac Residual Plot Output Glitch

Anonymous
2016-11-16T20:05:28+00:00

Hey, wondering if anyone else has encountered an error when running a Regression through the Analysis ToolPak in Excel 2016 for Mac.

In several cases while running a multivariate regression, I've found that the residual plots Excel produces sometimes use x-axis data from the regression output sheet instead of the original data sheet, which produces flawed residual plots.

Any suggestions for how to make sure the residual plots made by the ToolPak use data from the proper sheet?

Microsoft 365 Insider | Excel | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-03-22T23:51:51+00:00

    The error is still there in version 15.31.  The first residual plot generated is correct, the second is not. If you ask for line fit plots , again, some are correct and some not.  The PC version does not seem to have this problem.  The problem only occurs if you ask it to put the plot on a new worksheet ply.  If you put the output on the same page as the original data, the charts will be correct.  So, a simple work around is to put the output on the same page, with the drawback that it makes the original data page messy.

    Was this answer helpful?

    7 people found this answer helpful.
    0 comments
  2. Anonymous
    2016-11-18T17:08:52+00:00

    Hi! Actually, after trying to report the bug over the phone, I was prompted to update all the way through 15.29. The problem persists. Other suggestions?

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  3. Jim G 134K Reputation points MVP
    2016-11-18T17:02:36+00:00

    Bugs in the analysis toolpak were fixed in version 15.28. Go to your Excel menu and choose About Excel. If you have a previous version, then install the update and try again.

    Make sure your Mac has a working internet connection before checking for updates. Install Mac OS X updates followed by Office updates.

    Mac OS X updates:

    To get Mac OS updates, go to the App store on your dock, and then click the Updates button to reveal available updates.

    Office Updates

    To get the update:

    1. Open any Office application:
    2. Make sure your Mac has a working internet connection
    3. Go to the Help menu and choose Check for Updates
    4. Let AutoUpdate check for and install updates
    5. Restart your Mac

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Jim G 134K Reputation points MVP
    2017-03-24T15:49:21+00:00

    Please report the problem to Microsoft using the Smile button. Again. Thanks.

    Was this answer helpful?

    0 comments
  5. Jim G 134K Reputation points MVP
    2016-11-20T20:30:49+00:00

    In 15.29, use the Smile button to send a screen shot and report of the problem to Microsoft.

    Was this answer helpful?

    0 comments