PROBLEM 1: Transportation engineers analyze population growt…
PROBLEM 1: Transportation engineers analyze population growth trends separately for a city and its adjacent suburb to plan future infrastructure projects, such as roads and public transit. You have been given population data for the city and suburbs from 2000 to 2025 at five-year intervals. Year City Population (thousands) Suburb Population (thousands) 2000 450 150 2005 490 180 2010 520 220 2015 540 280 2020 560 340 2025 590 420 Create a chart in Excel comparing the population trends of the city and suburb from 2000 to 2025. Include axis labels, a title, and a legend identifying the two data sets. Add a trendline to each set of data, select the equation that in your opinion is the best fit for each set. Use the equations to predict future populations, as an example forecast the population in 2030. If current trends continue, in what year will the suburb’s population surpass the city’s population? SAVE YOUR EXCEL FILE AND CONTINUE TO THE NEXT PROBLEM