TTEST2UV(R1, R2)

 

Description

This function returns the significance level 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.  The return value is the probability of error in rejecting the null hypothesis that the mean of R1 equals the mean of R2, assuming that the variances 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.