USING THE COMPUTER

EXCEL

• Excel has the capability of performing any of the statistical techniques presented in this chapter with the exception of testing the difference in two population proportions.
• Each of the tests presented here in Excel is accessed through the Data Analysis feature.
• To conduct a z test for the difference in two means, begin by selecting the Data tab on the Excel worksheet. From the Analysis panel at the right top of the Data tab worksheet, click on Data Analysis. If your Excel worksheet does not show the Data Analysis option, then you can load it as an add-in following directions given in Chapter 2. From the Data Analysis pulldown menu, select z-Test: Two Sample for Means from the dialog box. Enter the location of the observations from the first group in Variable 1 Range. Enter the location of the observations from the second group in Variable 2 Range. Enter the hypothesized value for the mean difference in Hypothesized Mean Difference. Enter the known variance of population 1 in Variable 1 Variance (known). Enter the known variance of population 2 in Variable 2 Variance (known). Check Labels if you have labels. Select Alpha.