By default, Excel does not install the Analysis Toolpack to the Data menu. This can be fixed easily with the add-in manager, that is found in the File menu.
Category Archives: Data Menu
Filter a database
Turning on the filter for a database allows sorting and filtering that is helpful in investigating the details of a data set.
The Data menu
This tab has commands to connect an Excel spreadsheet to external data sources for reporting and graphing that data. There are also commands for sorting, filtering, outlining and data cleaning. Some of the more powerful and useful features for analysis are also located in this menu tab.
Descriptive statistics
The Analysis Toolpack has a command to create the descriptive statistics for a data set.
Histogram Tool
In the analysis toolpack, there is a command that will create a histogram.