Install Analysis ToolPak Add-In

Analysis ToolPak
The Analysis Toolpak add-in for Excel includes a collection of 19 data-analysis tools designed to save steps when users develop complex statistical or engineering analyses. Users provide the data and parameters for each analysis; the tool applies the appropriate statistical or engineering macro functions, and then displays the results in a same or separate worksheet or workbook. It is mainly used for these analysis : Descriptive Statistics, Hypothesis Testing, Regression and Correlation, Time Series Forecasting.

How to Install Analysis ToolPak

Step 1:

Click on the Excel Options located at the bottom of the windows menu



Step 2: 

Select Add–Ins option and then Click on the Go button


Step 3:

In the dialog box appeared on the screen Select Analysis ToolPak and then press OK button.



After completing the above steps , you will see Data Analysis in Data menu.



Related Posts
Spread the Word!
Share
About Author:
Deepanshu Bhalla

Deepanshu founded ListenData with a simple objective - Make analytics easy to understand and follow. He has over 10 years of experience in data science. During his tenure, he worked with global clients in various domains like Banking, Insurance, Private Equity, Telecom and HR.

1 Response to "Install Analysis ToolPak Add-In"
  1. At step 2, I get "eviews add-in for excel 2007" under active application add ins. Thats why I cannot install the analysis toolpack, and thats why i failed to get data analysis- how do I solve it?
    Regards
    meher afroze

    ReplyDelete

Next → ← Prev
Ad-Blocker Detected