TTEST2EV(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 under the assumption 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 equal variance.

 

Parameters

 

R1

A range.

 

R2

A range.

 

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.