A lot of Mac users knock for not being as pretty as Numbers on the Mac, but at the end of the day the hardcore Excel users care about one thing and that is functionality. If you’re looking for strong analytics tool that can easily calculate regressions, ANOVA, and other used by statisticians, then Excel with the StatPlus add-in is the solution for you. However if you’re coming from a Windows environment you will find that there is no add-in dialog that allows you to install the StatPlus normally found in Excel for Windows.
That’s because Excel 2011 doesn’t ship with StatPlus, it requires a separate download and install from the makers of StatPlus. Check out the guide below to get you started with StatPlus for Excel 2011 on your Mac.
I've been unable to do this in (mac) excel 2011 but I just took a file created in 2011, turned on this option in 2016 (option does exist in mac office 2016) and then re-opened file in 2011. The setting stuck thru data refreshes and minor table changes such as adding additional fields in the 'Values' section.
Software/Hardware used: Excel 2011 and StatPlus:Mac LE running on Mac OS X. Download and Setup StatPlus 1. Head on over to AnslystSoft.com to a free copy of StatsPlus:Mac LE. Open the Zip file and extract the DMG file. When you run the DMG file drag the application icon to the Applications folder. To begin using StatPlus with Excel 2011, open the spreadsheet you wish to run the analysis on. Then open the StatPlus application and click Spreadsheet Microsoft Excel.
Run Your First Analysis To make sure everything is working as it should let’s give StatPlus a try. Using the spreadsheet you opened in the previous section click Statistics Basic Statistics then Descriptive Statistics. Select the cell range you wish to use and click OK. In a couple of seconds you will see a separate spreadsheet with the details of the analysis, that’s it.
Play with the other tools to become familiar with the StatPlus application on your Mac. Check back in the next couple of weeks because we will be covering some of the analytical tools in detail. If you have any comments or questions please use the comments form below. Gilbert is a Microsoft MVP, a full-time blogger, and technology aficionado. When Gilbert is away from his bike and his iPad, he's busy writing technology how-to's from his home-office in Miami, Florida on the latest programs and gadgets he can get his hands on.
![Download Download](/uploads/1/2/5/4/125407330/522890638.jpg)
He's locally known as 'the computer guy' and has spent the last 12 years helping family, friends, and GilsMethod.com visitors with their computer questions and problems. He was awarded the 2009 MVP award from Microsoft for his contributions in forums and blogs and is enjoying the new addition to his family.
Excel for Mac 2011 now includes the Solver add-in built-in. You do not need to install and run the 3rd Party Solver add-in. Before You Begin Before you are able to install the Solver add-in for Excel for Mac 2011, you are required to install Microsoft Office for Mac 2011 Service Pack 1 (14.1.0). Open an Office for Mac 2011 application, go to Help - Check for Updates and install the 14.1.0 update. Install Solver Add-in for Excel for Mac 2011. Open Excel for Mac 2011. Go to the Tools menu, select 'Add-ins'.
Check 'Solver.Xlam' then click OK. After restarting Excel for Mac 2011 (fully Quit Excel 2011), select the 'Data' tab, then select 'Solver'. The Solver add-in window will open.