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*

Grey Trout Software

02 March 2003