Filter
Top Products
322 Functions and commands
T Inverse cumulative Student's t distribution function. Returns the
value x such that the Student's-t lower-tail probability of x, with
n degrees of freedom, is p.
STUDENT_ICDF(n,p)
Example:
STUDENT_ICDF(3,0.0246659214814) returns –3.2.
Inverse cumulative distribution function. Returns the value x
such that the lower-tail probability of x, with n degrees of
freedom, is p.
CHISQUARE_ICDF(n,p)
Example:
CHISQUARE_ICDF(2,0.957147873133) returns 6.3.
F Inverse cumulative Fisher distribution function. Returns the
value x such that the Fisher lower-tail probability of x, with
numerator n and denominator d degrees of freedom, is p.
FISHER_ICDF(n,d,p)
Example:
FISHER_ICDF(5,5,0.76748868087) returns 2.
Binomial Inverse cumulative binomial distribution function. Returns the
number of successes, k, out of n trials, each with a probability
of p, such that the probability of k or fewer successes is q.
BINOMIAL_ICDF(n,p,q)
Example:
BINOMIAL_ICDF(20,0.5,0.6) returns 11.
Poisson Inverse cumulative Poisson distribution function. Returns the
value x such that the probability of x or fewer occurrences of
an event, with expected (or mean) occurrences of the event
in the interval, is p.
POISSON_ICDF( ,p)
Example:
POISSON_ICDF(4,0.238103305554) returns 3.
List
These functions work on data in a list. They are explained in
detail in chapter 24, “Lists”, beginning on page 451.
2
2
2