FISHER(5,5,2) returns 0.158080231095.
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 k≤n.
BINOMIAL(n, p, k)
Example: Suppose you want to know the probability that just 6 heads would appear during 20 tosses of a fair
coin.
BINOMIAL(20, 0.5, 6) returns 0.0369644165039.
Geometric
Geometric probability density function. Computes the probability density of the geometric distribution at x,
given probability p.
GEOMETRIC(p, x)
Example:
GEOMETRIC(0.3, 4) returns 0.1029.
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.
Probability – 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:
360 Chapter 22 Functions and commands
Komentarze do niniejszej Instrukcji