Skip to content
Skip to main content

About this free course

Download this course

Share this free course

Data analysis: visualisations in Excel
Data analysis: visualisations in Excel

Start this free course now. Just create an account and sign in. Enrol and complete the course for a free statement of participation or digital badge if available.

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.
‘Add Ins’ dialogue box
Figure 4 Activating the Data Analysis ToolPak

The Data Analysis icon should now be available on the Data ribbon in the Analysis group.