beautypg.com

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

Page 297

background image

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:

TDIST” on page 296

TTEST” 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

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.