beautypg.com

Chitest, 240 chitest – Apple iWork '09 User Manual

Page 240

background image

Examples

=CHIINV(0.5, 2) returns 1.38629436111989.
=CHIINV(0.1, 10) returns 15.9871791721053.
=CHIINV(0.5, 1) returns 0.454936423119572.

Related Topics
For related functions and additional information, see:

“CHIDIST” on page 239

“CHITEST” on page 240

“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

CHITEST

The CHITEST function returns the value from the chi-square distribution for the given
data.

CHITEST(actual-values, expected-values)

Â

actual-values: The collection containing the actual values. actual-values is a
collection containing number values.

Â

expected-values: The collection containing the expected values. expected-values is
a collection containing number values.

Usage Notes

The degrees of freedom relating to the value returned is the number of rows in

Â

actual-values minus 1.
Each expected value is computed by multiplying the sum of the row by the sum of

Â

the column and dividing by the grand total.

240

Chapter 10

Statistical Functions