subject
Mathematics, 22.02.2021 19:10 katekayrodriguez10

You are planning a sample survey that involves selecting 11 of the 100 counties in North Carolina. Your sample will be a stratified sample consisting of the 6 most populous counties in the state and 5 counties randomly selected from the remaining 94 counties. Obtain your stratified sample from the US Census Bureau North Carolina county populations in this Excel file, following the directions below. The Excel worksheet has an alphabetical listing of all 100 North Carolina counties in column A, the population values from the most recent census (2010) and Census Bureau population estimates for July 1, 2018 in column D. We will use the population values for July 1, 2018 in column d. To simplify the selection of the 11 counties, we will order the counties according to their July 1, 2018 populations. Order the counties by July 1, 2018 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 OK
Excel 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 the 6 most populous counties and their populations. List the most populous county first and use commas in your population answers.
1. (most populous)

ansver
Answers: 1

Another question on Mathematics

question
Mathematics, 21.06.2019 16:40
How do i get my dad to stop making me gargle his pickle i want my mom to gargle my pickle not my dads
Answers: 3
question
Mathematics, 21.06.2019 17:00
Issof claims that the scale factor is 1/2. which statement about his claim is correct
Answers: 3
question
Mathematics, 21.06.2019 18:00
Janie has $3. she earns $1.20 for each chore she does and can do fractions of chores. she wants to earn enough money to buy a cd for $13.50. write an inequality to determine the number of chores, c, janie could do to have enough money to buy the cd.
Answers: 1
question
Mathematics, 22.06.2019 00:30
Two corresponding sides of two similar triangles are 3cm and 5cm. the area of the first triangle is 12cm2. what is the area of the second triangle?
Answers: 2
You know the right answer?
You are planning a sample survey that involves selecting 11 of the 100 counties in North Carolina. Y...
Questions
question
Mathematics, 28.01.2020 02:31