PROB

Formulas / PROB
Calculate the probability of a range of values between two limits.
=PROB(x_range, prob_range, [lower_limit], [upper_limit])
  • x_range - required, range of values for x
  • prob_range - required, specifies the set of probabilities for values in x_range
  • lower_limit - [OPTIONAL] lower limit of the value for which we want a probability
  • upper_limit - [OPTIONAL] upper limit for which we want a probability

Examples

  • PROB(A3:A6,B3:B6,2)

    The PROB function can be used to calculate the probability of an event occurring. For example, if you have a range of cells containing input values (A3:A6) and a range of cells containing output values (B3:B6), you can use the formula above to determine the probability that x is 2.

  • PROB(A3:A6,B3:B6,1,3)

    The PROB function can also be used to determine the probability that x is within a certain range. For example, this returns the probability that x is between 1 and 3.


Summary

The PROB function returns the probability of a range of values being between two limits. If the sum of the values is not equal to 1, it will return an error. If the upper_limit is omitted, it will also return an error. It will also return the probability of being less than or equal to the lower_limit.

  • The PROB function returns the #NUM! error if any value in the prob_range range is less than 0 or if the sum of the values in the prob_range range is not equal to 1.

Frequently Asked Questions

What is the PROB function?
The PROB function is used to return the probability that a range of values is between two limits.
What will the PROB function return if the upper limit is not supplied?
If the upper limit is not supplied, the PROB function will return the probability that a range of values is between two limits.
What can I use the PROB function for?
The PROB function can be used for various statistical applications, such as calculating the probability of certain outcomes or events, estimating the probability of a certain value occurring, or determining the probability of two values meeting certain criteria.
What type of data can I use the PROB function with?
The PROB function can be used with numerical, categorical, and binary data.
How do I use the PROB function?
To use the PROB function, you need to provide two parameters, the lower_limit and upper_limit. You can also optionally supply an additional parameter, which is the probability_distribution. This parameter can be either a normal or uniform distribution. Then, the PROB function will return the probability that the number falls between the two limits.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV