[go: up one dir, main page]
Scribd
Upload
65 views4 pages

Excel DataAnalysis Toolpak

The document provides instructions on how to activate the Data Analysis ToolPak add-in in Microsoft Excel. It details the steps to access Excel Options, manage add-ins, and verify the installation. Additionally, it mentions that users will find various statistical analysis tools available once the add-in is activated.

Uploaded by

haneefok740
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
65 views4 pages

Excel DataAnalysis Toolpak

The document provides instructions on how to activate the Data Analysis ToolPak add-in in Microsoft Excel. It details the steps to access Excel Options, manage add-ins, and verify the installation. Additionally, it mentions that users will find various statistical analysis tools available once the add-in is activated.

Uploaded by

haneefok740
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 4

Excel Data Analysis

ToolPak

Prof. Raja Sankaran 1


To activate DataAnalysis add-in in Excel
• The Data Analysis Add-in is a Microsoft Office Excel add-in program that is available
when you install Microsoft Office or Excel.
• To use the Solver Add-in, however, you first need to load it in Excel.

1. In Excel, go to File > Options


• Note: For Excel 2007, click the Microsoft Office Button Office button image, then click Excel Options
2. Click Add-Ins, and then in the Manage box, select Excel Add-ins.
3. Click Go.
4. In the Add-Ins available box, select the Analysis ToolPak check box, and then click
OK.
Notes:
• If the Analysis ToolPak is not listed in the Add-Ins available box, click Browse to locate the add-in.
•If you get prompted that the Analysis ToolPak is not currently installed on your computer, click Yes to install it.

Prof. Raja Sankaran 2


To Verify,
• Click on Data tab page
• You will find Data Analysis installed

• When you click on Data Analysis, you will find various statistical analysis
tool in the following window

Prof. Raja Sankaran 3


Thank You

Prof. Raja Sankaran 4

You might also like