 Formula Engine Reference Guide |
|
Back to Class Index
TTEST2UV(R1, R2)
Returns the significance level (alpha) of the two-sided dual population T-test for the population samples contained in the ranges R1 and R2 without assuming 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] and var[R2] are unrelated.
Parameters
R1
A range
R2
A range
Examples
TTEST2UV(A1..A4, B1..B4) = 0.71306706
where A1..A4 = .5, .98, .22, .1, and B1..B4 = .87, .6, .21, .49
TTEST2UV(H5..H9, K5..K9) = 0.0083561
where H5..H9 = 14, 35, 37, 0, 33, and K5..K9 = 67, 77, 94, 34, 99