Owner manual

Chapter 10 Statistical Functions 255

“FINV” on page 255

“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

FINV

The FINV function returns the inverse of the F probability distribution.

FINV(prob, d-f-numerator, d-f-denominator)

Â prob: A probability associated with the distribution. prob is a number value and

must be greater than 0 and less than or equal to 1.

Â d-f-numerator: The degrees of freedom to include as the numerator. d-f-numerator

is a number value and must be greater than or equal to 1. If there is a decimal

portion, it is ignored.

Â d-f-denominator: The degrees of freedom to include as the denominator. d-f-

denominator is a number value and must be greater than or equal to 1. If there is a

decimal portion, it is ignored.

Examples

=FINV(0.77, 1, 2) returns 0.111709428782599.

=FINV(0.77, 1, 1) returns 0.142784612191674.

=FINV(0.77, 2, 1) returns 0.34331253162422.