2. Excel steps to create the binomial probability distribution for the number of dropped calls example are as follows:

a. In a blank Excel worksheet, enter the word Number of Dropped Calls in cell A1 and the word Probability in B1. In cells A2 through A8, enter the integers 0 to 6. 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 BINOM.DIST.

d. Enter 0 for Number_s, 6 for Trials, 0.05 for Probability_s of a success, and 0 for Cumulative. Click OK. Excel will compute the probability of 0 successes in 6 trials, with a 0.05 probability of success. The result, 0.735 is stored in cell B2.

e. To complete the probability distribution for successes of 1 through 6, double-click the cell B2. The binomial function should appear. Replace the 0 to the right of the open parentheses with the cell reference A2. The contents of cell B2 should now be: =BINOM.DIST(A2,6,0.05,0).

f. Copy cell B2 to cells B3:B8. The probability of a success for the various values of the random variable will be in cells B2:B8.