298 var – Apple iWork '09 User Manual
Page 298
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:
“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 specified, they must all be of the same type.
298
Chapter 10
Statistical Functions