PROB

Try it

When to use it

When should I use PROB?

Use PROB when you have a discrete probability distribution defined by a set of values and their associated probabilities and need to find the probability that a variable falls within a specified range.

Used in

science · operations

Syntax

PROB(x_range,prob_range,lo,[hi])

Examples

=PROB({1,2,3,4},{0.25,0.25,0.25,0.25},3) // => 0.25
=PROB({1,2,3,4},{0.25,0.25,0.25,0.25},2,3) // => 0.5
=PROB({1,2,3},{0.5,0.3,0.2},1) // => 0.5