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.

Examples

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
8633438611764570550
true
Search Help Center
true
true
true
true
true
35
false
false