Use excel

3-16 Using the flowrate data presented below (city to be selected by instructor). estimate the size of an offline equalization tank needed to reduce the flowrate variation. The maximum hourly flowrate to the treatment process should not exceed 1.25. 1.5, and 1.75 times the average daily flowrate (ratio to be selected by instructor). Time period M-1 - 1-2 2-3 Time period N-1 1-2 2-3 4-5 5-6 6-7 7-8 8-9 9-10 10-11 11-N Average flowrate during time period, m/s City 1 City 2 0.300 0.250 0.220 0.190 0.180 0.165 0.160 0.160 0.160 0.165 0.185 0.175 0.240 0.210 0.300 0.270 0.385 0.340 0440 0370 0.480 0.375 0.480 0.355 Average flowrate during time period, m/s City 1 City 2 0.460 0.330 0.420 0.310 0.390 0.305 0.355 0.310 0.331 0.330 0.315 0.370 0.320 0.400 0.346 0.420 0.362 0.440 0392 0420 0.360 0.390 0.300 0.300 4-5 5-6 6-7 7-8 8-9 9-10 10-11 12-M