You are hired to upgrade an existing water treatment plant. Using the historical data provided below, forecast the water demand through $2024.$ The population is expected to increase by $1\mathrm{.}8\%$ per year.a$.$ Create a graph of the historical average, minimum$-$day, and maximum$-$day water demand in gdp for each year. Extrapolate trend lines for the projected future water demand through $2024.($In Excel, go to format trendline label then click number to see the full trendline equation$).$ Use your projection to determine the average, minimum$-$day, and maximum$-$day water demand in $2024.$ b$.$ Determine the average water demand per capita.c$.$ Determine a demand factor for the minimum$-$day and maximum$-$day demand, using