TTEST(R, X)

 

Description

This function returns the significance level of the two-sided single population T-test for the population samples contained in the range R.  The return value is the probability of error in rejecting the null hypothesis that the mean of R is equal to X.

 

Parameters

 

R

A range.

 

X

A numeric value.

 

Examples

 

TTEST(A1:A4, B1) = 0.12093936

Where A1:A4 = .5, .98, .22, .1, and B1 = .87.

 

TTEST(H5:H9, K5) = 0.0039514106

Where H5:H9 = 14, 35, 37, 0, 33, and K5 = 67.

 

TTEST(V1:V10, W1:W10) = #Error

Improper argument type.