3. Excel steps to create the hypergeometric probability distribution for the PlayTime Toys example are as follows:

a. On a blank Excel worksheet enter the word Success in cell A1 and the word Probability in B1. In cells A2:A7, enter the integers 0 to 5. Click B2 as the active cell.

b. Select Insert Function. From the Or select a category list, select Statistical.

c. In the Select a function list, double-click HYPGEOM. DIST.

d. Enter 0 for Sample_s, 5 for Number_sample, 40 for Population_s, and 50 for Number_pop box, and 0 for Cumulative. Click OK. The result, 0.0001189 is stored in cell B2.

e. To copy, double-click on cell B2. The hypergeometric function will. Replace the 0 to the right of the open parentheses with the cell reference A2. The contents of cell B2 should now be: =HYPGEOM. DIST(A2,5,40,50,0).

f. Copy cell B2 to cells B3:B7.