TTEST2EV

**Syntax:** **TTEST2EV( R1, R2)**

*R1* = a range

*R2* = a range

**TTEST2EV** returns the significance level (alpha) of the
two-sided dual population T-test for the population
samples contained in the ranges *R1* and *R2* under the
assumption that the population variances are the same.
Alpha is the probability of error in rejecting the null
hypothesis that mean[*R1*] = mean[*R2*] assuming var[*R1*] =
var[*R2*].

**Examples:**

**TTEST2EV**(A1..A4, B1..B4) = 0.71153758, where A1..A4 = .5,
.98, .22, .1, and B1..B4 = .87, .6, .21, .49.

**TTEST2EV**(H5..H9, K5..K9) = 0.0061236, where H5..H9 = 14,
35, 37, 0, 33, and K5..K9 = 67, 77, 94, 34, 99.

**Excel function:** *N/A*

Grey Trout Software

02 March 2003