Tinv, Ttest, 297 tinv 297 ttest – Apple iWork '09 User Manual
Page 297

Chapter 10
Statistical Functions
297
TINV
The TINV function returns the t value (a function of the probability and degrees of
freedom) from the student’s t-distribution.
TINV(probability, degrees-freedom)
Â
probability: A probability associated with the distribution. probability is a number
value and must be greater than 0 and less than 1.
Â
degrees-freedom: Degrees of freedom. degrees-freedom is a number value and
must be greater than or equal to 1.
Example
=TINV(0.88, 2) returns 0.170940864689457.
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
TTEST
The TTEST function returns the probability associated with a student’s t-test, based on
the t-distribution function.
TTEST(sample-1-values, sample-2-values, tails, test-type)
Â
sample-1-values: The collection containing the first collection of sample values.
sample-1-values is a collection containing numbers.
Â
sample-2-values: The collection containing the second collection of sample values.
sample-2-values is a collection containing number values.
Â
tails: The number of tails to return.
one tail (1): Returns the value for a one-tailed distribution.
two tails (2): Returns the value for a two-tailed distribution.
Â
test-type: The type of t-test to perform.