next up previous contents index
Next: TTEST2UV Up: A. Function Reference Previous: TTEST   Contents   Index


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


next up previous contents index
Next: TTEST2UV Up: A. Function Reference Previous: TTEST   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003