To perform data analysis on the remainder of the worksheets, recalculate the analysis tool for each worksheet. The Analysis ToolPak includes the tools described in the following sections. To access these tools, click Data Analysis in the Analysis group on the Data tab.
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 freeto Excel 2011. Follow the steps below:. and save the zip file on the desktop.
Double-click on the zip file to unzip the contents to a folder on the desktop. Double-click on the folder. Double-click on the StatPlusMacLE.dmg file.
Double-click on the StatPlus icon to launch the program. In the menu bar, click on the Spreadsheet tab. Choose Excel 2011, then Enable.