# PROB

The `PROB` 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.

## Usage

Use the `PROB` formula with the syntax shown below, it has 3 required parameters and 1 optional parameter:

Parameters:
1. data (required):
The range of data values for which you want to calculate the probability.
2. probabilities (required):
The range of probabilities corresponding to each data value in the data range.
3. low_limit (required):
The lower limit for which you want to calculate the probability.
4. 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 the `PROB` 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.

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.

You can learn more about the `PROB` Google Sheets function on Google Support.