# The PROB Function in Excel

A free Office suite fully compatible with Microsoft Office

A free Office suite fully compatible with Microsoft Office

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables and more fulfilling your needs perfectly.

· **Description:**

The PROB function calculates the probability that the values in a range are between two specific limits.

· **Syntax:**

PROB(x_range, prob_range, [lower_limit], [upper_limit])

· **Arguments:**

**X_range**: Required. The range of numeric values associated with probabilities.

**Prob_range**: Required. The array of probabilities associated with values in x_range. The values in Prob-range must add up to 1 or 100%.

**Lower_limit**: Optional. The lower limit of the value for which you want to calculate probability.

**Upper_limit**: Optional. The upper bound of the value for which you want to calculate probability.If this argument is omitted, the formula will return the probability which is equal to the lower_limit.

· **Example:**

Here assume that we have a list of Coffee sales and the probabilities of achieving the sales volume, and the sum of all probabilities is 1. And we want to calculate the probability that the sales of coffee is between 244 and 300. Now let's explore how to perform the calculation.

1. Click on cell B11 and navigate to the **Formulas **tab. Click the **Insert Function** button, enter **PROB **in the dialogue box and select **PROB **function. Alternatively, you can directly click the shortcut **Insert Function** button to pull out the dialogue box. Also, the PROB function can be found in **More Functions** > **Statistical**.

In the pop-up box, enter A2:A7 at **X_range**, B2:B7 at **Prob_range**, 244 at **Lower bound** **of the X range** and 300 at **Upper bound** **of the X range**. As a result, the formula returns the probability value of 0.6 in cell 11, the probability that the coffee sales are between 244 and 300.

Was this helpful?

Yes

No

Trending Tutorials

- 1. How to get month name from a date in Excel (3 easy ways)
- 2. Check if value is in list in Excel (3 easy methods)
- 3. How to Copy File Names in Excel from a Folder?
- 4. How to color cell based on value in Excel?
- 5. How to compare two excel sheets and highlight differences
- 6. How to add text to beginning or end of all cells in Excel