# Click the home tab at the upper left of the excel

• Notes
• Gibber
• 9
• 91% (53) 48 out of 53 people found this document helpful

This preview shows page 2 - 6 out of 9 pages.

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 the 6 most populous counties and their populations. List the most BUS/ST 350-601 HW #4 Fall 2013 ... 3 of 10 12/17/13, 4:44 AM
populous county first and use commas in your population answers. 1. (most populous) Mecklenburg Mecklenburg County; population 969,031 969,031 2. Wake Wake County; population 952,151 952,151 3. Guilford Guilford County; population 500,879 500,879 4. Forsyth Forsyth County; population 358,137 358,137 5. Cumberland Cumberland County; population 324,049 324,049 6. (6th most populous) Durham Durham County; population 279,641 279,641 Question 2 . You would now like to select a random sample of 5 counties from the remaining 94 counties in rows 6 through 99 of the spreadsheet. To select the counties use this random digits table and 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 line 131 and select the random sample of 5 counties 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 commas in your population answers) in the order in which they are selected using the random number table. BUS/ST 350-601 HW #4 Fall 2013 ... 4 of 10 12/17/13, 4:44 AM
1. Lincoln Lincoln County; population 79,313 79,313 2. Chatham Chatham County; population 65,976 65,976 3. Anson Anson County; population 26,351 26,351 4. Brunswick Brunswick County; population 112,257 112,257 5. Mitchell Mitchell County; population 15,368 15,368 BUS/ST 350-601 HW #4 Fall 2013 ... 5 of 10 12/17/13, 4:44 AM
4. 1.5/1.5 points | Previous Answers The list of individuals from which a sample is actually selected is called the sampling frame .