Data Analysis with Microsoft Excel: Updated for Office 2007

(Tuis.) #1
570

One Sample z test


The StatPlus>One Sample Tests>1 Sample z test command performs a one
sample z test and calculates a confi dence interval for data with a known
standard deviation. 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. Users must specify the
value of the standard deviation.
Free download pdf