
Note: If you a doing this in a MSU Open-Access Lab, you will be asked for an Administrator login. In the menu bar, click on the Spreadsheet tab. Just open the application and you are off to the races. This will open Microsoft excel and will allow you to use your new add in! After it has loaded up you Toolpak will be ready to use in Microsoft Excel on your Mac.

If the Analysis Toolpak is not available in the list of Add-Ins, click Browse to find it. Output: Load the Analysis Toolpak in Mac Note: Click the Data tab > Data Analysis command to see that the Data Analysis tools are now activated.įigure 5.

We have successfully loaded the Analysis Toolpak.

The Data Analysis tools can be accessed in the Data tab. This articles assists all levels of Excel users on how to load the Data Analysis Toolpak in Excel Mac. It provides advanced tools such as Anova, Correlation, Covariance, Fourier Analysis, Histogram, Regression, t-test and z-test. The Analysis Toolpak offers data analysis tools for statistical and engineering analysis.
