Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please show the step by step instructions using an excel file. The country of Palladia has 3,750,000 people. The birth rate is 1.3%. That is,
Please show the step by step instructions using an excel file.
The country of Palladia has 3,750,000 people. The birth rate is 1.3%. That is, each year the number of babies born is equal to 1.3% of the people in the country at the beginning of the year. The death rate is 0.7% of the people in the country at the beginning of the year. Palladia is a wealthy paradise so lots of people are trying to enter from outside. The Minister of Immigration is proposing that 150,000 people be allowed to immigrate into the country each year. (a) Create a worksheet for the Minister that predicts the population of Palladia for each of the next 10 years. There should be an input area at the top of your worksheet with cells for: starting population, annual birth rate, annual death rate, and annual immigration. Use the numbers above. There should be one row for each year. There should be columns for Population at Beginning of Year, Births, Deaths, Immigration, Population at End of Year. Assume the 3,750,000 people is as of the beginning of the first year. (b) Suppose the birth rate is 1.1%, the death rate is 0.9%, and the annual immigration is 100,000. (c) Suppose the birth rate is 1.0% and the death rate is 0.7%. The Prime Minister would like to see close to 5,000,000 people in the country at the end of 10 years. At what number should the annual immigration quota be set? Use Goal Seek to find a quota that results in a population that is 5,000,000 in 10 years. (d) Add a one-dimensional data table that shows the size of the population in 10 years using the entered birth rate and death rate and annual immigration of 0, 10,000, 20,000 all the way through 300,000. Try the worksheet with a birth rate of 1.3% and a death rate of 0.7% (e) Add a two-dimensional data table that shows the population at the end of 10 years for birth rates of 0%, 0.1%, 0.2%, through 2.0% for the top row and annual immigration of 0, 10,000, 20,000, through 300,000 for the leftmost column. Try your worksheet with a death rate of 0.9%Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started