Completion and Submission Instructions: This assignment includes completion of the following tasks in MS Excel. The deliverables include one excel file with multiple worksheets. The deliverables should satisfy the following requirements: - Each one of the problems below will be completed in one worksheet of the excel file that has been provided. - If provision of your rationale or an answer is required, they should be provided in the form of a text box in each worksheet. - The submission should be submitted in xls or xlsx formats. Other formats are not accepted by Canvas. - The name of the file should be lastname_firstname_hw\#. - Keep a back-up of all the files that you are submitting. - This assignment should be completed individually. - Problems have equal points. Problem 5. Stream (Chapra 24.12) Stream cross-sectional areas are required for a number of tasks in water resources engineering, including flood forecasting and reservoir design. Unless electronic sounding devices are available to obtain continuous profiles of the channel bottom, the engineer must rely on discrete depth measurements to compute the area. An example of a typical stream cross-section is shown below. The data points represent locations where a boat was anchored and depth readings taken. Evaluate the cross sectional area 3 ways: CEE 3804 - Homework Assignment No.13 Computer Applications for Civil and Environmental Engineering a) trapezoidal rule with delta x=4m b) trapezoidal rule with delta x=2m c) Simpson's 1/3 rule. \begin{tabular}{|r|r|} \hline Distance & Depth \\ \hline 0 & \\ 4 & \\ 8 & \\ 12 & \\ 16 & \\ 20 \\ \hline \end{tabular} trapezoid w/dx=4 trapezoid w/dx=2 15 Simpson's 1/3