2. Estimate the populations of Fargo, ND and Bismarck, ND in years of 2040 and 2050....

Transcribed Image Text:

2. Estimate the populations of Fargo, ND and Bismarck, ND in years of 2040 and 2050. Select a single value of population that you would use for design purposes in each year. You need to specify and justify the method that you selected for each case and report growth rate constant with proper units. To get full credit you need 1) use Excel; 2) include all your tables showing calculation results; 3) use graphs to show linear regression results; and 4) make decisions based on comparisons of arithmetical and geometric growth methods. (15 pts) < + Population year Fargo, ND Bismarck, ND 1940 32,580 15,496 1950 38,256 18,541 1960 46,6624 27,670 1970 53,365 34,703 1980 61,383 44,485 1990 74,111 49,256 2000 90,599 55,532 2010 105,549 61,272 2019 127,833 73,529 2. Estimate the populations of Fargo, ND and Bismarck, ND in years of 2040 and 2050. Select a single value of population that you would use for design purposes in each year. You need to specify and justify the method that you selected for each case and report growth rate constant with proper units. To get full credit you need 1) use Excel; 2) include all your tables showing calculation results; 3) use graphs to show linear regression results; and 4) make decisions based on comparisons of arithmetical and geometric growth methods. (15 pts) < + Population year Fargo, ND Bismarck, ND 1940 32,580 15,496 1950 38,256 18,541 1960 46,6624 27,670 1970 53,365 34,703 1980 61,383 44,485 1990 74,111 49,256 2000 90,599 55,532 2010 105,549 61,272 2019 127,833 73,529