A demographic study of the metropolitan area around Dogpatch divided it into thr
ID: 3679915 • Letter: A
Question
A demographic study of the metropolitan area around Dogpatch divided it into three regions - urban, suburban, rural - and published the following table showing the annual migration from one region to another (the numbers represent percentages). For example 0.3 percent of the urbanites (0.003 times the current population) move to the suburbs each year. The diagonal entries represent internal growth rates. Assume that the 2013 populations are: Urban 2.1 million, Suburban 1.4 million, Rural 0.9 million. Use Planner's Lab to model this growth showing the population of each area for each of the next nine years. From your results, export the Data Table to Excel and then copy the table into a document:Explanation / Answer
first table show the population of each year of next nine years
urban:
r=p+(p*1.1)/100-(p*0.3)/100-(p*0.7)/100;
r=r/1000000;
suburabn: r=p+(p*0.1)/100-(p*1.2)/100-(p*0.3)/100;
r=r/1000000;
rural:
r=p+(p*0.2)/100-(p*0.6)/100-(p*1.3)/100;
r=r/1000000;
2013
2014
2015
2016
2017
2018
2019
2020
2021
urban
2.1
2.1021
2.1042
2.1063
2.10841
2.11052
2.11263
2.11474
2.11685
suburban
1.4
1.3804
1.36107
1.34202
1.32323
1.3047
1.28643
1.26842
1.25066
rural
0.9
0.8847
0.86966
0.854876
0.840343
0.826057
0.812015
0.798211
0.784641
change the urban growth rate to 1.05 in 2016, 1.03 in 2017 and 1.02 beyond that
2013
2014
2015
2016
2017
2018
2019
2020
2021
urban
2.1
2.1021
2.1042
2.10525
2.10588
2.1063
2.10672
2.10714
2.10756
suburban
1.4
1.3804
1.36107
1.34202
1.32323
1.3047
1.28643
1.26842
1.25066
rural
0.9
0.8847
0.86966
0.854876
0.840343
0.826057
0.812015
0.798211
0.784641
2013
2014
2015
2016
2017
2018
2019
2020
2021
urban
2.1
2.1021
2.1042
2.1063
2.10841
2.11052
2.11263
2.11474
2.11685
suburban
1.4
1.3804
1.36107
1.34202
1.32323
1.3047
1.28643
1.26842
1.25066
rural
0.9
0.8847
0.86966
0.854876
0.840343
0.826057
0.812015
0.798211
0.784641
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.