In this case, you insert the range B2:E9 in the Input Range field (of the dialog box of Figure 2) and select the Columns radio button. Suppose, by way of example, this data consists of a 4 × 8 array representing 4 treatments as in Figure 3. The Input Range consists of the Excel range where the data elements to be analyzed are stored. You will now be presented with the dialog box shown in Figure 2.įigure 2 – Dialog box for Anova: Single Factor option Fields Now suppose by way of example that you choose Anova: Single Factor. t-Test: Two-Sample Assuming Unequal VarianceĮach of these options represents a data analysis tool that will be described on this website.t-Test: Two-Sample Assuming Equal Variance.You can now select any one of the following options useful for statistical analysis: Main Dialog BoxĪfter selecting Data > Analysis|Data Analysis you will be presented with the dialog box in Figure 1. You will then be able to access the data analysis tools.

Next, you select the Analysis ToolPak option on the dialog box that appears and click the OK button. This is done by selecting Office Button > Excel Options > Add-Ins in Excel 2007 or File > Help|Options > Add-Ins in versions of Excel starting with Excel 2010, and clicking the Go button at the bottom of the window. If this option is not visible you may need to first install Excel’s analysis tool pack. Excel provides a number of data analysis tools, which are accessible via Data > Analysis|Data Analysis.

How to get data analysis tool in excel