Question: Use county level data from 2 0 1 0 ( Age 2 0 1 0 sheet ) and 2 0 1 5 ( Age 2

Use county level data from 2010(Age2010 sheet) and 2015(Age2015 sheet) to
complete the highlighted cells in the Question 1 worksheet. Describe how the
proportion of the population under 20 and above 65 has changed from 2010 to from
2015. Below is some guidance on how to proceed.
Step 1: Calculate the total population under 20 and above 65 for year 2010 and
2015.
Step 2: Calculate percent change in population for the two age groups. Percent
change =(2015 data-2010 data)/2010 data.
Step 3: Calculate average, median, min, max, and standard deviation of percent
change for the two age groups.
Step 4: Draw histograms for percent changes in the two groups and determine
whether mean or median is a better measure of central tendency

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!