O'Reilly logo

The Complete Idiot's Guide to Statistics, 2nd Edition by Robert Donnelly

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Letting Excel Do the Grunt Work

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:
553
Figure 17.5
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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required