PROB function to calculate the probability of events in Excel

Very often, when working in Excel, it is necessary to use calculations of the probability of occurrence of a certain event. For this, the statistical function PROB is used.



Examples of using the PROB function for calculations in Excel

It is worth noting that Excel and other statistical functions are used frequently, for example:

  • VAR;
  • HYPGEOM.DIST;
  • FORECAST and others.

PROB function calculates the probability that the values from the interval are within the specified limits. If the upper limit is not specified, then the probability that the value of the argument Range_x will be equal to the value of the argument called lower_limit will be returned.



Calculate the percent probability of an event in Excel

Example 1. A table of the range of numerical values is given, as well as the probabilities that correspond to them: Example 1.

When using this statistical function, it is necessary to calculate the probability of an event that the value from the specified interval falls within the range [1,4].

To do this, we introduce PROB function with the following arguments:

PROB.

here:

  • X_range is the initial data (0, ..., 4);
  • Prob_range is the set of probabilities for the initial data (0.15; 0.1; 0.15; 0.2; 0.4);
  • Lower_limit is 1;
  • [Upper_limit] is 4.

As a result of the calculations we get:

result of the calculations.

Example 2. In the condition of the previous example, it is necessary to calculate the probability of the event " value of x is 4".

Enter in cell C3, we introduce PROB function with the following arguments:

Example 2.

here:

  • X_range - initial parameters (0,...,4);
  • Prob_range - set of probabilities for parameters (0.1,0.15,0.2,0.15,0.4);
  • Lower_limit is 4;

In this example, the upper limit is not specified, since a specific probability value is needed, namely for the value 4.

We get:

upper limit is not.

PROB function under multiple interval conditions

Example 3. In the condition of example 1, it is necessary to calculate the probability that the values of the range [0,4] will be located within the intervals [0,1] and [3,4].

We introduce the formula:

Description of formulas similar to the previous examples.

As a result of the calculations we get:

probability.

Download examples PROB function to calculate probability in Excel

Thus, making a formula, you can use this function to calculate the percentage of probability under several conditions.


en ru