Filter
Top Products
320 Functions and commands
Binomial Binomial probability density function. Computes the
probability of k successes out of n trials, each with a
probability of success of p. Returns Comb(n,k) if there is no
third argument. Note that n and k are integers with .
BINOMIAL(n,k,p)
Example: Suppose you want to know the probability that just
6 heads would appear during 20 tosses of a fair coin.
BINOMIAL(20,6,0.5) returns 0.0369644165039.
Poisson Poisson probability mass function. Computes the probability
of k occurrences of an event during a future interval given ,
the mean of the occurrences of that event during that interval
in the past. For this function, k is a non-negative integer and
is a real number.
POISSON(,k)
Example: Suppose that on average you get 20 emails a day.
What is the probability that tomorrow you will get 15?
POISSON(20,15) returns 0.0516488535318.
Cumulative
Normal Cumulative normal distribution function. Returns the lower-tail
probability of the normal probability density function for the
value x, given the mean, and standard deviation, of a
normal distribution. If only one argument is supplied, it is
taken as x, and the assumption is that =0 and =1.
NORMALD_CDF([,,]x)
Example:
NORMALD_CDF(0,1,2) returns 0.977249868052.
T Cumulative Student's t distribution function. Returns the lower-
tail probability of the Student's t-probability density function
at x, given n degrees of freedom.
STUDENT_CDF(n,x)
Example:
STUDENT_CDF(
3,–3.2) returns 0.0246659214814.
kn