Answered step by step

Verified Expert Solution

## Question

1 Approved Answer

# 2. Estimate the populations of Fargo, ND and Bismarck, ND in years of 2040 and 2050. Select a single value of population that you

## 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

## 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