
Chapter 6
PB
Discrete Probability Distributions
227
in Gujarat. This can be done by inserting formula “= Sum (B2: B6)” and pressing Enter. The
required probability which is 0.98136646 will be calculated in the concerned cell.
The second method is to click f
x
to open the Insert Function dialog box. From select a
category, select Statistical and from Statistical, select HYPGEOM·DIST, and then click OK
(Figure 6.26). The Function Arguments dialog box will appear on the screen (Figure 6.27).
Now place the desired values as shown in Figure 6.27 and click OK. The probability value for
x = 1 will appear in the selected cell. Repeat this procedure for ...