PROB
ThePROB
function calculates the probability that a value lies between two limits based on a range of data and its corresponding probabilities. This function is commonly used in statistics to calculate the probability distribution of a set of data.
 How to use
PROB
formula?  Examples of using
PROB
formula PROB
formula not working? Similar formulas to
PROB
Usage
Use the PROB
formula with the syntax shown below, it has 3 required parameters and 1 optional parameter:
 data (required):
The range of data values for which you want to calculate the probability.  probabilities (required):
The range of probabilities corresponding to each data value in the data range.  low_limit (required):
The lower limit for which you want to calculate the probability.  high_limit (optional):
An optional upper limit for which you want to calculate the probability. If omitted, the probability is calculated for all values above the lower limit.
Examples
Here are a few example use cases that explain how to use thePROB
formula in Google Sheets.
Calculating the probability of a value in a range
You can use the PROB
function to calculate the probability that a value in a given range falls between two limits. For example, you can use this function to calculate the probability of a student's test score falling within a certain range of grades.
Calculating the probability distribution of a data set
The PROB
function can be used to calculate the probability distribution of a set of data. By providing the function with a range of data values and their corresponding probabilities, you can calculate the probability of each value occurring in the data set.
Calculating the probability of success or failure
You can use the PROB
function to calculate the probability of success or failure based on a set of data and its corresponding probabilities. For example, you can use this function to calculate the probability of a student passing or failing a test based on their test scores.
Common Mistakes
PROB
not working? Here are some common mistakes people make when using the PROB
Google Sheets Formula:
Incorrect parameter order
If the parameters are entered in the wrong order, the formula will produce incorrect results. Double check that the parameters are in the correct order.
Missing or incorrect input data
If the data or probabilities ranges are omitted or contain incorrect data, the formula may produce errors or incorrect results. Double check that the input data is correct.
Related Formulas
The following functions are similar to PROB
or are often used with it in a formula:

NORMDIST
The
NORMDIST
function in Google Sheets calculates the normal distribution for a specified value, mean, and standard deviation. It returns the probability of a value occurring within a specified range of a normal distribution. It is commonly used in statistics, finance, and science to analyze data and make predictions. 
BINOMDIST
The
BINOMDIST
function calculates the probability of a certain number of successes in a fixed number of trials given a constant probability of success for each trial. This function is commonly used in statistical analysis and hypothesis testing. 
POISSON
The
POISSON
function returns the Poisson distribution probability density function, which is used to show the probability of a certain number of events occurring in a fixed interval of time or space. It takes in the values for the number of events (x), the mean (mean), and a boolean for whether or not to return the cumulative distribution (cumulative). 
STDEV
The
STDEV
function calculates the standard deviation of a set of numbers. It measures the amount of variation or dispersion of a set of values from the average (mean) value. It is commonly used in statistics to determine the spread of a data set. The values can be supplied as individual cells, ranges, or constants. 
AVERAGE
The AVERAGE function calculates the average (arithmetic mean) of the values passed to it. It is commonly used to find the average of a range of cells containing numerical data.
Learn More
You can learn more about the PROB
Google Sheets function on Google Support.