1.3 Adding the Data Analysis ToolPak in Excel
In this section, you are going to learn how to add the Data Analysis ToolPak in Excel and what its purpose is. If you are using another spreadsheet software, you may skip this section. Alternatively, similar functionality is usually available within the software, and all tasks within the Excel ToolPak can be carried out using other functions in Excel as well.
The Data Analysis ToolPak is a Microsoft Excel add-in function that provides you with a set of statistical tools for analysing data efficiently and effectively. This add-in comes with Excel during installation; however, if it has not already been loaded or activated on the machine you are using, you need to load or activate it before you can use it.
To load the Data Analysis ToolPak:
- Open the Excel worksheet.
- Click on the File tab, then click on Options, and select Add-Ins.
- In the Manage box, select Excel Add-ins as shown in the screenshot below and click Go.
- In the Add-Ins dialog box, select the Analysis Tool Pak check box, and then click OK.
The Data Analysis icon should now be available on the Data ribbon in the Analysis group.