SheetFX
≡
<< Go back to all functions

PROB

The PROB function in Google Sheets calculates the probability that a value chosen at random falls between two limits. It takes a set of values and corresponding probabilities as input. With this function, you can perform various statistical analyses and make informed decisions.

Function Syntax and Parameters

Syntax: PROB(data, probabilities, low_limit, [high_limit])

Parameters:

  • data: The range of values.
  • probabilities: The corresponding range of probabilities for each value in the data range.
  • low_limit: The lower limit of the range.
  • high_limit: [Optional] The upper limit of the range. If not provided, the function calculates the probability that a value falls below the low_limit.

Step-by-Step Tutorial

  1. Using PROB with data and probabilities:

    • Example: If A1:A4 has the data values 1, 2, 3, 4 and B1:B4 has the corresponding probabilities 0.1, 0.2, 0.3, 0.4, then =PROB(A1:A4, B1:B4, 2, 4) will calculate the probability that a value chosen at random falls between 2 and 4.

  2. Using PROB with data only:

    • Example: If A1:A4 has the data values 1, 2, 3, 4, then =PROB(A1:A4, , 2, 4) will calculate the probability that a value chosen at random falls below 2.

Use Cases and Scenarios

  1. Risk Assessment: Evaluate the probability of an event falling within a certain range.
  2. Market Analysis: Determine the likelihood of stock prices falling within specific price ranges.
  3. Quality Control: Calculate the probability of measurements falling within acceptable limits.

Related Functions

  • NORMDIST: Calculate the normal distribution for a specified value, mean, and standard deviation.
  • PERCENTILE: Find the k-th percentile of a data set.

Related Articles