Monday, September 11, 2017

How do you get Data Analysis menu item in MS Excel?

If you want to do data analysis (regression, trend line, sampling, etc) using Excel, you should be able to locate the Data Analysis menu item on your ribbon in Excel.

For example, right now I do not have this in my ribbon (Microsoft Office Business, Build 8326.2096).


You need Analysis ToolPak add-in in your Excel application.

Follow these steps to add the Analysis ToolPak add-in:
Step 1: In MS Excel click File | Options

Step 2: In Excel Options window click Add-ins


NoDataAnalysis_1.png

Step 3: In Add-ins page, click Analysis ToolPak and Go shown here.


NoDataAnalysis_3.png

The following windows opens.


NoDataAnalysis_4.png


Choose the Analysis ToolPak add-in and click OK.

Immediately Data Analysis appears in the ribbon as shown.




Click on Data Analysis and the following window opens.


These are the various tasks you can carry out.












No comments: