Skip to end of metadata
Go to start of metadata

Problem

There is no Data Analysis tab in Excel 2011 for Mac. 

Solution

Unlike Excel for Windows and Excel 2016 for Mac, the Data Analysis ToolPak is not included in Excel 2011. The workaround is to add the free StatsPlus Lite Edition to Excel 2011.  Follow the steps below:

  1. Download StatsPlusLE for Mac and save the zip file on the desktop.  

  2. Double-click on the zip file to unzip the contents to a folder on the desktop.  Double-click on the folder.

  3. Double-click on the StatPlusMacLE.dmg file.

     

  4. Double-click on the StatPlus icon to launch the program.

     

  5. In the menu bar, click on the Spreadsheet tab.  Choose Excel 2011, then Enable.

     


    .

    Note:  If you a doing this in a MSU Open-Access Lab, you will be asked for an Administrator login. Ask a lab assistant to do this for you.

  6. Close StatPlus and open Excel 2011. The Statistics tab now functions as your usual Excel Data Analysis tab.

 



 

 


For questions or comments, contact the Computer Services Help Desk
HelpDesk@MissouriState.edu
417-836-5891