Filter
Top Products
Functions and commands 321
Cumulative distribution function. Returns the lower-tail
probability of the probability density function for the value
x, given n degrees of freedom.
CHISQUARE_CDF(n,k)
Example:
CHISQUARE_CDF(2,6.1) returns 0.952641075609.
F Cumulative Fisher distribution function. Returns the lower-tail
probability of the Fisher probability density function for the
value x, given numerator n and denominator d degrees of
freedom.
FISHER_CDF(n,d,x)
Example:
FISHER_CDF(5,5,2) returns 0.76748868087.
Binomial Cumulative binomial distribution function. Returns the
probability of k or fewer successes out of n trials, with a
probability of success, p for each trial. Note that n and k are
integers with .
BINOMIAL_CDF(n,p,k)
Example: Suppose you want to know the probability that
during 20 tosses of a fair coin you will get either 0, 1, 2, 3,
4, 5, or 6 heads.
BINOMIAL_CDF(20,0.5,6) returns 0.05765914917.
Poisson Cumulative Poisson distribution function. Returns the
probability x or fewer occurrences of an event in a given time
interval, given expected occurrences.
POISSON_CDF( ,x)
Example:
POISSON_CDF(4,2) returns 0.238103305554.
Inverse
Normal Inverse cumulative normal distribution function. Returns the
cumulative normal distribution value associated with the lower-tail
probability, p, given the mean, and standard deviation, of a
normal distribution. If only one argument is supplied, it is taken as
p, and the assumption is that =0 and =1.
NORMALD_ICDF([,,]p)
Example:
NORMALD_ICDF(0,1,0.841344746069) returns 1.
2
2
2
kn