Statistical test functions

CHIDIST(chisquared,df) One-tailed probability from the Chi-squared distribution

CHIINV(p,df) Returns the reverse of the Chi-squared distribution

FDIST(F,v1,v2) One-tailed probability from the F distribution

FINV(p,v1,v2) The inverse of the F probability distribution

FISHER(a,b,c,d) Calculates Fisher's exact probability

NORMSDIST(z) One-tailed probability from standardized Normal distribution

NORMSINV(p) Returns a Standardized Normal deviate

TDIST(t,df) Two-tailed probability from the Student t distribution

TINV(p,df) Returns the reverse of the Student t distribution

See also