next up previous contents index
Next: TTEST2EV Up: A. Function Reference Previous: TRUNC   Contents   Index


TTEST

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


next up previous contents index
Next: TTEST2EV Up: A. Function Reference Previous: TRUNC   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003