B2 A 1 Value List 2 1 3 5 4 7 9 6 15 7 12 8 13 9 3 10 2 11 3 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 B fx Random Values D E G H K L M N Sheet1 Sheet2 Sheet3 B + 100% Ready Scroll Lock 1. Using Excel - selecting a simple random sample To answer the questions that follow, download an Excel spreadsheet by clicking on the following words in bold: Download Excel File The upper left-hand corner of the Excel spreadsheet in the file you download should look like the sample spreadsheet that follows: A B Value List Random Values 1 2 1 3 5 4 7 5 9 6 15 7 12 8 13 9 3 10 11 2 3 Perform each of the following steps in your Excel spreadsheet in order to take a simple random sample of three values from the given Value List in column A. In cell B2 of the preceding spreadsheet, select the correct Excel formula for generating a random number that is greater than or equal to 0 and less than 1. The next step in taking a random sample is to copy this formula into cells New random numbers are returned each time your spreadsheet recalculates. To lock in your random numbers, make sure the Home tab is selected on the ribbon. Highlight cells B2 through B11, click the Copy button (in the Clipboard group), then click the Paste button, and select Paste Values from the dropdown menu. Next, sort your random numbers from smallest to largest: Click any cell in column and select Sort from Smallest to Largest. click the ' button in the Editing group, The original column A data now appear in random order. Suppose that you use the first three data values in the randomly ordered list of data values as your random sample. Then your simple random sample is located in cells