PROB

Definition of PROB

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 to data.

  • Each value in probabilities must be greater than 0 and less than or equal to 1.

• 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 to low_limit.

Notes

• The number of values in data and probabilities 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.

In order to use the PROB formula, start with your edited Excellentable

Then type in the PROB Formula in area you would like to display the outcome:

Type in the complete PROB formula for a cell as shown below:

Excellentable will generate the outcome when hitting enter.