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.

Examples