Syntax: TTEST(R, X)
R = a range
X = a numeric value
TTEST 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.
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
Excel function: N/A