Data Analysis with Microsoft Excel: Updated for Office 2007

Excel Reference 573

Two Sample z test

The StatPlus>Two Sample Tests>2 Sample z-test command performs a two

sample z test for data values, arranged either in two separate columns or

within a single column alongside a column of category levels. Users can

specify the null and alternative hypotheses as well as the size of the con-

fi dence interval. Users must enter the standard deviation for each sample.

The output can be broken down by the levels of a By variable.

Two Sample Mann-Whitney test

The StatPlus>Two Sample Tests>2 Sample Mann-Whitney Rank test com-

mand performs a two sample Mann-Whitney Rank test for data values,

arranged either in two separate columns or within a single column along-

side a column of category levels. Users can specify the null and alternative

hypotheses as well as the size of the confi dence interval. The output can

be broken down by the levels of a By variable.