November 27, 2007

Activating the Anova Data Analysis Function in Excel 2007

To add the Anova Data Analysis function to Excel 2007, start by opening Excel and clicking on the Office button at the top left of the screen. At the bottom of the drop down menu, click on the’ Excel Options’ button.

The Excel Options window will open. In the column on the left, click on the Add-Ins heading. On the right side of the window, scroll down to Inactive Application Add-Ins and click on ‘Analysis ToolPak’ to select it. Then click the Go Button.

An ‘Add-Ins’ window will open. Click in the checkbox next to ‘Analysis ToolPak’ and click the OK button. Another window may open that says Excel can’t run the add-in until you install the feature. Click Yes.

The Microsoft Office Configuration window will launch. This can take a minute or two to configure. When it is finished, click on the Data tab and the Anova Data Anaylsis function will appear in the Anaylsis group on the right side of the ribbon.