Data Analysis with Microsoft Excel: Updated for Office 2007

Excel Reference 571

One Sample Sign test

The StatPlus>One Sample Tests>1 Sample Sign test command performs a

one-sample Sign test and calculates a confi dence interval. The data values

can be arranged either as a single column or as two columns (in which case

the command will analyze the paired difference between the columns). If

two columns are used, the columns must have the same number of rows.

Users can specify the null and alternative hypotheses as well as the size

of the confi dence interval. For confi dence intervals, the user specifi es that

the calculated interval be approximately, at least, or at most the size of the

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

variable.

One Sample Wilcoxon Signed Rank test

The StatPlus>One Sample Tests>1 Sample Wilcoxon Signed Rank test com-

mand performs a one-sample Wilcoxon Signed Rank test and calculates a

confi dence interval. The data values can be arranged either as a single col-

umn or as two columns (in which case the command will analyze the paired

difference between the columns). If two columns are used, the columns

must have the same number of rows. Users can specify the null and alterna-

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

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