null

Online Lecture - Introduction to the Data Analysis Toolpak in Microsoft Excel

In this lesson, you will be introduced to the use of the Data Analysis Toolpak in Microsoft Excel for various statistical analysis of concepts.

To download and install Microsoft Excel view video below:

To download and install Data Analysis Toolpak in Microsoft Excel using Windows read instructions below:

Open Microsoft Excel.
Click on the ‘File’ tab located in the upper-left corner.
Select ‘Options’ from the menu on the left.
In the Excel Options dialog box, click on ‘Add-Ins.’
In the Manage box at the bottom, ensure that ‘Excel Add-ins’ is selected, then click ‘Go…’
In the Add-Ins dialog box, check the box next to ‘Analysis ToolPak.’
Click ‘OK.’
The Data Analysis Toolpak will now be available in the ‘Data’ tab on the Ribbon.

To download and install Data Analysis Toolpak in Microsoft Excel using Mac read instructions below:

Open Microsoft Excel.
Click on the ‘Tools’ menu at the top of the screen.
Select ‘Excel Add-ins.’
In the Add-Ins dialog box, check the box next to ‘Analysis ToolPak.’
Click ‘OK.’
The Data Analysis Toolpak will now be available in the ‘Data’ tab on the Ribbon.

Click the video below to watch the online lecture.

null

Required Readings and Videos