Formulas and Functions

paired (1): Perform a paired test.
two-sample equal (2): Perform a two-sample equal variance (homoscedastic) test.
two-sample unequal (3): Perform a two-sample unequal variance (heteroscedastic)
test.
Examples
=TTEST({57, 75, 66, 98, 92, 80}, {87, 65, 45, 95, 88, 79}, 1, 1) returns 0.418946725989974, for the one-tailed,
paired test.
=TTEST({57, 75, 66, 98, 92, 80}, {87, 65, 45, 95, 88, 79}, 2, 1) returns 0.837893451979947 for the two-tailed,
paired test.
=TTEST({57, 75, 66, 98, 92, 80}, {87, 65, 45, 95, 88, 79}, 1, 2) returns 0.440983897602811 for the one-tailed,
two sample equal test.
=TTEST({57, 75, 66, 98, 92, 80}, {87, 65, 45, 95, 88, 79}, 2, 2) returns 0.881967795205622 for the two-tailed,
two sample equal test.
=TTEST({57, 75, 66, 98, 92, 80}, {87, 65, 45, 95, 88, 79}, 1, 3) returns 0.441031763311189 for the one-tailed,
two sample unequal test.
Related Topics
For related functions and additional information, see:
“TDIST” on page 296
“TINV” on page 297
“Listing of Statistical Functions” on page 225
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
VAR
The VAR function returns the sample (unbiased) variance, a measure of dispersion, of a
collection of values.
VAR(num-date, num-date…)
 num-date: A value. num-date is a number value or a date/time value.
 num-date…:Optionally include one or more additional values. If more than one
num-date-dur value is specied, they must all be of the same type.
298 Chapter 10 Statistical Functions