 Formula Engine Reference Guide |
|
Back to Class Index
TTEST(R, X)
Returns the significance level (alpha) of the two-sided single population T-test for the population samples contained in the range R. Alpha is the probability of error in rejecting the null hypothesis that mean [R]=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