You are planning a sample survey that involves selecting11of the 100 counties in North Carolina. Your sample will be a stratified sample consisting of the6most populous counties in the state and5counties randomly selected from the remaining 94 counties.

Obtain your stratified sample from the US Census Bureau North Carolina county populations inthis Excel file.

The Excel worksheet has an alphabetical listing of all 100 North Carolina counties in column A and population estimates for July 1, 2011 and July 1, 2012 in columns D and E, respectively.

We will use the population values for July 1, 2012 in column E. To simplify the selection of the11counties, we will order the counties according to their July 1, 2012 populations.

• Order the counties by July 1, 2012 population as follows:
  • Excel 2003
  • highlight the cell range A5:E105
  • in the Excel menu bar click on "Data"; in the drop-down menu click "Sort"
  • near the bottom of the Sort dialogue box click the radio button next to "Header row"
  • in the first "Sort by" window choose "2012" and make sure that the "Ascending" radio button is selected
  • click OKExcel 2010 and Excel 2007
  • highlight the cell range A5:E105
  • Click the "Home" tab at the upper left of the Excel window
  • at the far right of the menu ribbon click on the "Sort and Filter" icon
  • In the drop-down menu click on "Custom Sort..."
  • In the upper right-hand corner of the Sort window make sure the box next to "My data has headers" has a check mark; if it does not have a check mark, click in the box to make a check mark appear.
  • In the Sort window, under Column, sort by "2012"
  • In the Sort window, under Sort On, choose "values"
  • In the Sort window, under Order, choose "A to Z"
  • Click OK

The counties should now be listed in increasing order according to their July 1, 2012 populations. Tyrell County should be listed first (in row 6) with July 1, 2012 population 4,338.

Question 1. Scroll down to the bottom of the worksheet to see the most populous counties. List below the6most populous counties and their populations. List the most populous county first anduse commasin your population answers.

1.(most populous)

County; population

2.

County; population

3.

County; population

4.

County; population

5.

County; population

6.(6th most populous)

County; population

Question 2. You would now like to select a random sample of5counties from the remaining94counties in rows 6 through 99 of the spreadsheet. To select the counties usethis random digits tableand use the row numbers 06 through 99 in the Excel spreadsheet as the number assigned to each county. Enter the table of random digits at line131and select the random sample of5counties using the consecutive pairs of digits 05 00 71, and so on, as you proceed from left to right in line 131. List the counties and their populations (use commasin your population answers) in the order in which they are selected using the random number table.

1.

County; population

2.

County; population

3.

County; population

4.

County; population

5.

County; population