1. Excel commands to select a simple random sample for the B&B example are as follows:

a. Select DATA, Data Analysis, Sampling, and click OK.

b. For Input Range insert B1:B31. Check the Labels box. Select Random, and enter the sample size for the Number of Samples, in this case 5. Click the Output Range, and indicate the place in the spreadsheet you want the sample information. Note that your sample results will differ from those in the text. Also, recall that Excel samples with replacement, so it is possible for a population value to appear more than once in the sample.