Given a set of values and corresponding probabilities, calculates the probability that a value chosen at random falls between two limits.
Sample Usage
PROB({1,2,3,4},{0.25,0.25,0.25,0.25},3)
PROB(A2:A100,B2:B100,C2,C3)
Syntax
PROB(data, probabilities, low_limit, [high_limit])
-
data
- Array or range containing the dataset to consider. -
probabilities
- Array or range containing probabilities corresponding todata
.- Each value in
probabilities
must be greater than0
and less than or equal to1
.
- Each value in
-
low_limit
- The lower bound on the value range for which to calculate the probability. -
high_limit
- [ OPTIONAL -low_limit
by default ] - The upper bound on the value range for which to calculate the probability.- If
high_limit
is omitted,PROB
calculates the probability that a value chosen at random is exactly equal tolow_limit
.
- If
Notes
- The number of values in
data
andprobabilities
must be the same.
See Also
CRITBINOM
: Calculates the smallest value for which the cumulative binomial distribution is greater than or equal to a specified criteria.
BINOMDIST
: Calculates the probability of drawing a certain number of successes (or a maximum number of successes) in a certain number of tries given a population of a certain size containing a certain number of successes, with replacement of draws.