PROB : General Usage
1
data
probability
2
1
0.12
3
2
0.15
4
3
0.20
5
4
0.27
6
5
0.10
7
6
0.16
8
9
10
Result
Formula
11
0.12
=PROB(A2:A7,B2:B7, 1)
12
0.1
=PROB(A2:A7,B2:B7,5)
13
0.26
=PROB(A2:A7,B2:B7,5, 6)
14
1
=PROB(A2:A7,B2:B7,1, 6)
15