Microsoft's Mac Business Unit has announced that it has a solution for Excel 2008 users who suddenly found themselves without the Analysis ToolPack, the Visual Basic-based data analysis add-on from previous versions of Excel. The Mac Excel team collaborated with third-party software developer AnalystSoft, and the two came up with StatPlus:mac LE.
StatPlus:mac LE is a wholly independent application, like Solver for Excel 2008. It uses AppleScript to communicate with Excel--both applications need to be running with the worksheet containing the data you want to analyze open. In StatPlus:mac LE, select the analysis function you need. From there, you can select a data range, set variables, and perform the analysis similarly to ATP. The Mac Excel team worked closely with AnalystSoft to make sure that StatPlus:mac LE covered all the same functions that ATP did. So, if linear regression, z-tests, and one-way ANOVA get you hot under the collar, StatPlus:mac LE will definitely fit the bill.
Click Tools - Select Add-Ins. Click to select the check box for Solver.Xlam. The Data Analysis Toolpak was removed in Mac:Office for Mac 2008. However, you can download a free third-party tool that offers similar functionality: StatPlus:mac LE. Analysis Toolpak in Mac – Excelchat The Analysis Toolpak offers data analysis tools for statistical and engineering analysis. It provides advanced tools such as Anova, Correlation, Covariance, Fourier Analysis, Histogram, Regression, t-test and z-test.
The good news for those who need the features of ATP is that StatPlus:mac LE is a free download. The bad news is that it is essentially a nagware version of StatPlus:mac Pro, the $250 version that has 'many extra features to help you analyze data better and more professionally.' Littered throughout the menus are numerous grayed out options with a little 'pro' icon next to them, ? la QuickTime Player. The LE version does seem to cover the most common analysis functions, though, and for the rest of this week AnalystSoft is offering a 20 percent discount on the Pro version. You could grab it for just $200 if you need any of its advanced analysis functions. Academic discounts are also available.
The nagware annoyance aside, StatPlus:mac LE should suffice for many users, especially those that have been stuck with Excel 2004 and haven't been too thrilled with its performance under Rosetta. And, for those that have more advanced analysis needs, StatPlus:mac Pro may prove to be a useful solution.
The Analysis Toolpak offers data analysis tools for statistical and engineering analysis. It provides advanced tools such as Anova, Correlation, Covariance, Fourier Analysis, Histogram, Regression, t-test and z-test.
Figure 1. Data Analysis tools
This articles assists all levels of Excel users on how to load the Data Analysis Toolpak in Excel Mac.
Where is Data Analysis in Mac
The Data Analysis tools can be accessed in the Data tab.
Figure 2. Data Analysis in menu options
When we can’t find the Data Analysis button in the toolbar, we must first load the Analysis Toolpak in Mac.
How to load the Analysis Toolpak?
When we’re using Excel for Mac, we load the Analysis Toolpak through these steps:
- In the Tools tab, select Excel Add-Ins
Figure 3. Excel Add-Ins option in menu
- In the Add-ins window, select Analysis Toolpakand click OK.
Figure 4. Add-ins window
Download Analysis Toolpak Excel Mac
We have successfully loaded the Analysis Toolpak. Click the Data tab > Data Analysis command to see that the Data Analysis tools are now activated.
Figure 5. Output: Load the Analysis Toolpak in Mac
Note:
If the Analysis Toolpakis not available in the list of Add-Ins, click Browse to find it. If it needs to be installed on the computer, click Yes to download and install.
Instant Connection to an Excel Expert
Analysis Toolpak For Excel Mac
Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our liveExcelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.
Comments are closed.