Formulas and Functions
ह्या कंट्रोलमध्ये बदल केल्यामुळे हे पेज ऑटोमॅटिकली अपडेट होईल

PROB

The PROB function returns the probability of a collection of values, if you know the probabilities of the individual values.

PROB(num-set, probability-values, lower, upper)

num-set: A collection containing the number values.

probability-values: The collection containing the probability values. probability-values must contain number values and the sum of the number values must add up to 1. Any string values are ignored.

lower: A number value representing the lower limit or bound of the value(s) whose probability you want to know.

upper: An optional number value representing the upper limit or bound of the value(s) whose probability you want to know.

Notes

  • The PROB function sums the probabilities associated with all values in the collection greater than or equal to the specified lower limit value and less than or equal to the specified upper limit value. If upper is omitted, PROB returns the probability of the single number equal to the specified lower limit.

  • The two collections must be of the same size. If a string value is contained in a collection, it is ignored.

Examples

Suppose that a particular research study asked people to select a number between 12 and 16. In the following table, cells A1:A5 contain the possible choices (the numbers 12 to 16). The percentage that each number was chosen by those participating in the research, expressed as a decimal, is contained in B1:B5.

A

B

1

12

0.17

2

13

0.32

3

14

0.15

4

15

0.19

5

16

0.17

=PROB(A1:A5, B1:B5, 15,16) returns 0.36, the probability that the number selected was 15 or 16.

=PROB(A1:A5, B1:B5, 14) returns 0.15, the probability that the number selected was 14.

See alsoBINOMDISTCRITBINOMNEGBINOMDISTPERMUT
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
उपयुक्त आहे का?
कॅरॅक्टर मर्यादा : 250
कमाल कॅरॅक्टर मर्यादा 250 आहे.
तुमच्या प्रतिक्रियेबद्दल धन्यवाद.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.