How to Install Analysis ToolPak Add-In

Deepanshu Bhalla 1 Comment
Analysis ToolPak

The Excel Analysis Toolpak add-in offers 19 data analysis tools to simplify complex statistical or engineering tasks. Users input data and parameters and then the tool applies relevant functions and displays results in the same or separate worksheet. It is mainly used for these analysis : Descriptive Statistics, Hypothesis Testing, Regression and Correlation, Time Series Forecasting.

How to Install Analysis ToolPak

Step 1 : Go to the "File" menu and select "Options".

File menu in MS Excel Option in MS Excel

Step 2 : Select Add–Ins option and then Click on the Go button.

AddIn option in MS Excel

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

Analysis ToolPak in Excel

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

Data Analysis Tab in MS Excel
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.

Post Comment 1 Response to "How 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