Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 5 Probability Distributions 191

In this worksheet, you can click the Shoot button to generate a ran-

dom sample of shots at the target. You can select the underlying prob-

ability distribution and the number of shots the shooter takes. Try this

now with the accuracy of the shooter set to moderate to create a sample of

50 random shots.

To generate a random sample of shots:

1 Click the Shoot button.

2 Click the Moderate button and click the spin arrow to reduce the

number of shots to 50.

See Figure 5-6.

Figure 5-6
Accuracy
dialog box

3 Click the OK button twice.

Excel generates 50 random shots as shown in Figure 5-7 (your random

sample will be different).