Data Analysis with Microsoft Excel: Updated for Office 2007

Excel Reference 543

Variable 1 Range

Enter an input range of the fi rst sample; it must be a single row or column.

Variable 2 Range

Enter an input range of the second sample; it must be a single row or

column.

Hypothesized Mean Difference

Enter a mean difference with which to calculate the z test. If no value is en-

tered, a mean difference of zero is assumed.

Variable 1 Variance (known)

Enter the known variance s^21 of the fi rst sample.

Variable 2 Variance (known)

Enter the known variance s^22 of the second sample.

Labels

Indicate whether the fi rst row of the Y range and that of the X range include

header information.

Alpha

Enter an alpha value used to calculate the critical values of the z shown in

the output.

See “Output Options” at the beginning of this section for information on

the output storage options.