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.



About Author:

Deepanshu founded ListenData with a simple objective - Make analytics easy to understand and follow. He has close to 7 years of experience in data science and predictive modeling. During his tenure, he has worked with global clients in various domains like retail and commercial banking, Telecom, HR and Automotive.


While I love having friends who agree, I only learn from those who don't.

Let's Get Connected: Email | LinkedIn

Get Free Email Updates :
*Please confirm your email address by clicking on the link sent to your Email*

Related Posts:

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