Excel performs many of the hypothesis tests that we’ve discussed in this chapter. So let me explain how to perform the previous battery example using this nifty tool. Follow these steps:
Data entry for the battery example.
1. Open a blank Excel sheet and enter the data from the battery example in Columns A and B as shown in Figure 17.5.
2. From the Tools menu, choose Data Analysis and select t-Test: Two-Sample Assuming Unequal Variances. (Refer to the section “Installing the Data Analysis Add-in” from Chapter 2 if you don’t see the Data Analysis command on the Tools menu.)
3. Click OK.