Data Analysis with Microsoft Excel: Updated for Office 2007

(Tuis.) #1
540

Alpha


Enter an alpha value used to calculate the critical values of the t shown in
the output.
See “Output Options” at the beginning of this section for information on
the output storage options.

t-Test: Two-Sample Assuming Equal Variances

The t-Test: Two-Sample Assuming Equal Variances command calculates the
unpaired two-sample Student’s t-test. The test assumes that the variances
in the two groups are equal. The output includes both the one-tail and the
two-tail critical values.

Variable 1 Range


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

Variable 2 Range


Enter an input range for the second sample; it must be a single row or column.

Hypothesized Mean Difference


Enter a mean difference with which to calculate the t-test. If no value is en-
tered, a mean difference of zero is assumed.
Free download pdf