Determine the population for the town of Stonewall based on the following record available from Statistics Canada. Year Pop 1961 1420 1966 1577 1971 1583 1976 1814 1981 2217 1986 2349 1991 2997 1996 3689 2001 4012 2006 4376 A) Generate a curve of population vs. year in Excel. B) Calculate projected population at the end of a 10-year time frame, using the basic formulae of geometric increase, arithmetic mean and decreasing rate of increase. Assume a saturation population double the latest available population listed above. C) Which method is the most appropriate one to be used in this case?

Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)
5th Edition
ISBN:9781305084766
Author:Saeed Moaveni
Publisher:Saeed Moaveni
Chapter19: Probability And Statistics In Engineering
Section: Chapter Questions
Problem 18P
icon
Related questions
Question
Determine the population for the town of Stonewall based on the following record available from Statistics
Canada.
Year
Pop
1961
1420
1966
1577
1971
1583
1976
1814
1981
2217
1986
2349
1991
2997
1996
3689
2001
4012
2006
4376
A) Generate a curve of population vs. year in Excel.
B) Calculate projected population at the end of a 10-year time frame, using the basic formulae of
geometric increase, arithmetic mean and decreasing rate of increase. Assume a saturation
population double the latest available population listed above.
C) Which method is the most appropriate one to be used in this case?
Transcribed Image Text:Determine the population for the town of Stonewall based on the following record available from Statistics Canada. Year Pop 1961 1420 1966 1577 1971 1583 1976 1814 1981 2217 1986 2349 1991 2997 1996 3689 2001 4012 2006 4376 A) Generate a curve of population vs. year in Excel. B) Calculate projected population at the end of a 10-year time frame, using the basic formulae of geometric increase, arithmetic mean and decreasing rate of increase. Assume a saturation population double the latest available population listed above. C) Which method is the most appropriate one to be used in this case?
Expert Solution
steps

Step by step

Solved in 1 steps with 3 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Engineering Fundamentals: An Introduction to Engi…
Engineering Fundamentals: An Introduction to Engi…
Civil Engineering
ISBN:
9781305084766
Author:
Saeed Moaveni
Publisher:
Cengage Learning