5. Excel steps to create the Poisson probability distribution for the lost luggage 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 through A7, enter the integers 0 to 5 (for 0 to 5 lost bags). 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 POISSON.DIST.

d. Enter 0 for X, 0.3 for Mean, and 0 for Cumulative. Click OK. The result, 0.7408 is stored in cell B2.

e. To copy, double-click cell B2. The Poisson 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: =POISSON.DIST(A2,0.3,0).

f. Copy cell B2 to cells B3:B7.