# Manuals/calci/PROB

Jump to navigation
Jump to search

**PROB (Xs,Probabilities,lower_limit,upper_limit)**

- is the array of x range of values in the function.
- is the set of probabilities.
- is the lower limit
- is the upper limit value.
- PROB(),returns the probability that values in a range are between two limits.

## Description

- This function gives the probability that values in a range of given limits.
- Probability is the likelihood that an event will occur.
- Probabilities can be used to describe frequencies of outcomes in random experiments.
- In , is the array of numeric values which there are associated probabilities, is a set of probabilities associated with , is the lower limit of the probability and is the upper limit of the probability.
- Here is optional. When we are omitting the value of , then the function simply returns the probability associated with the value of the given .
- This function will return the result as error when

1.Any one of the value is non-numeric. 2.Any value of or 3.The values in the given do not adding up to 1 4. and is of different number of data points.

## Examples

1.

A | B | C | |
---|---|---|---|

1 | 0 | 1 | 2 |

2 | 0.3 | 0.5 | 0.2 |

=PROB(A1:C1,A2:C2,1) = 0.5 =PROB(A1:C1,A2:C2,1,3) = 0.7

2.

A | B | C | D | |
---|---|---|---|---|

1 | 1 | 2 | 3 | 4 |

2 | 0.2 | 0.2 | 0.1 | 0.5 |

=PROB(A1:D1,A2:D2,2) = 0.2 =PROB(A1:D1,A2:D2,2,4) = 0.8

3.

A | B | C | |
---|---|---|---|

1 | 0 | 1 | 2 |

2 | 0.3 | 0.7 | 0.1 |

=PROB(A1:C1,A2:C2,2) = NAN

## Related Videos

## See Also

## References