Need help with your Discussion

Get a timely done, PLAGIARISM-FREE paper
from our highly-qualified writers!

glass
pen
clip
papers
heaphones

Umass Boston Science Graphing the Human Population Using Excel Exercise

Umass Boston Science Graphing the Human Population Using Excel Exercise

Umass Boston Science Graphing the Human Population Using Excel Exercise

Question Description

Part 1: Graph the human population using Excel

Year A.D.

Number of People (in billions)

1650

.50

1750

.70

1850

1.0

1925

2.0

1956

2.5

1966

3.3

1970

3.6

1974

3.9

1976

4.0

1980

4.4

1991

5.5

2000

6.0

2004

6.4

2008

6.7

2011

6.9

2015

7.3

2019

7.7

1. Copy and paste the data above into an Excel worksheet (include the column titles).

2. Select all of the data (including the titles) and click on the Insert toolbar

3. Select the icon next to recommended charts that says Insert XY Scatter Plot – this should create the graph for you.

4. Double click on one of the horizontal axis numbers – this will open up a sidebar that allows you to change the axis. Minimum can be 1500, Maximum 2100.

5. Copy the resulting graph and paste here (15):

Analysis

1. It took 1649 years for the world’s population to double, going from .25 billion people to .50 billion people. How long did it take for the population to double once again? (5)

2. How long did it take for the population to double a second time? (5)

3. A third time? (5)

4. According to this information, the human population has increased / decreased (highlight one) at a decelerated / accelerated rate (highlight one) (10)

5. Based on your graph, in what year will the population reach 8 billion? (5)

6. Based on your graph, how many years will it take for the population of 2004 to double? (5)

The Earth’s Carrying Capacity

Prior to 1950, the death rate was high, which kept the numbers of humans from increasing rapidly. In the 19th Century, the agricultural revolution increased food production. The industrial revolution improved methods of transporting food and other good. In the 20th Century, advances in medicine, sanitation and nutrition have decreased the death rates further. These factors combined to produce the rapid growth of the human population in the 20th century.

As with any population, humans are also limited by factors such as space, amount of food and disease. The carrying capacity is the number of individuals that a stable environment can support. Authorities disagree on the maximum number of people that the earth can support, though the numbers generally range for 8 to 10 billion. As the population approaches its limit, starvation will increase. Some countries have a much higher growth rate than others. Growth rate is the number of people born minus the number of people that die. Compare the growth rates of the following countries

Most countries are trying to reduce their growth rate. Zero population growth means that as many people are being born as there are dying – to achieve zero population growth, each couple would need to have no more than two children (to replace the parents). Even if this number is achieved, the population will continue to grow because the parents will still live on for decades, as their children have children and their children have children and so forth. The United States reached zero population growth in the 1980’s, and yet the overall population of the US still increases.

Analysis

1. What factors contributed to the world’s overall population growth in the last 150 years. (10)

2. Why does a population not level off during the same year it reaches zero population growth? (10)

3. If the carrying capacity of the earth was 9 billion people, when would this number is reached (according to your graph)? (10)

4. What will happen when the human population exceeds the earth’s carrying capacity? (10)

5. Based on what you have learned about human population and carrying capacity, what prediction(s) would you make about the future of the human population? (10)

Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."

Order Solution Now

Our Service Charter


1. Professional & Expert Writers: Eminence Papers only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Eminence Papers are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Eminence Papers are known for the timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Eminence Papers, we have put in place a team of experts who answer all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.

We Can Write It for You! Enjoy 20% OFF on This Order. Use Code SAVE20

Stuck with your Assignment?

Enjoy 20% OFF Today
Use code SAVE20