

Anova is used to see if there is any difference between groups of some variable. The Anova analysis tools (single factor, two-factor with replication, two-factor without replication) provide different types of variance analysis.

We won’t get into every one, as a few of them are subsets of more general functions. There are 19 different functions found within this feature. The next section will describe the various tools that the Data Analysis ToolPak has to offer. After it is done loading, the user can access the Data Analysis ToolPak by clicking the “Tools” tab again at the top of the screen and then clicking “Data Analysis”, which now appears at the bottom of this pull-down menu.Īfter accessing Data Analysis, a box pops up with the various analysis tools. The program will then take a few seconds to add this feature to Excel.

This particular Excel add-in is easy to install and use and saves the user time in performing complex analyses. The add-in we are discussing today is the Analysis ToolPak which performs complex statistical and engineering analyses. In addition to these default features, the user may choose to incorporate various add-ins offered by Microsoft at no cost. Microsoft’s spreadsheet application known as Excel, found in Microsoft Office, features graphing tools, calculation capabilities, pivot tables and many other helpful tools for its users.
