excel to solve calculus problems

- Problem 2 - Volumetric Flow Rate of a River Our goal here is to measure the discharge, or volumetric flow rate, of a river. For this we need i) the cross sectional area of the river and ii) a representative velocity for the river. The cross-sectional area is where numerical integration can be used. Details on the procedure can be found at the USGS website. In Sheet 'Problem2' of MAC2312_Project1_ExcelSheet.xs1x, you'll find depth measurements, in ft, of a river on a particular day. At this particular cross-section, the depth is measured at regular intervals 5ft wide, The river is 120ft wide at the chosen cross section. a.) Use Trapezoid Rule to approximate the cross-sectional area of the river with the data in Sheet 'Problem2'. Report this quantity with units and rounded to 3 decimal places of accuracy for problem 2a in your report. b.) Suppose the representative velocity of the river is 3.4ft/sec. Find the discharge, or volumetric flow rate, of the river. Report this quantity with units and rounded to 3 decimal places of accuracy for problem 2b in your report. c.) Find the value of the volumetric flow rate in gallons per day. Report this quantity with units and rounded to 2 decimal places for accuracy for problem 2c in your report with work/justification. Problem2 Problem3 \begin{tabular}{|r|} \hline \multicolumn{1}{|c|}{ Depth (ft) } \\ \hline 0 \\ \hline 2 \\ \hline 7 \\ \hline 4 \\ \hline 9 \\ \hline 11 \\ \hline 15 \\ \hline 22 \\ \hline 19 \\ \hline 23 \\ \hline 34 \\ \hline 41 \\ \hline 45 \\ \hline 38 \\ \hline 29 \\ \hline 31 \\ \hline 25 \\ \hline 17 \\ \hline 15 \\ \hline 11 \\ \hline 8 \\ \hline 9 \\ \hline 4 \\ \hline 6 \\ \hline 0 \\ \hline \end{tabular}