Excel question

7) In surface-water hydrology problems hydrograph refers to the time record of stream flow rate measured at a watershed outlet. A hydrograph is a representation of how a watershed responds to a rainfall. The area under a hydrograph gives the total volume of water produced by the storm. The flow observed at the outlet of a watershed at different times is given in the following table. Calculate the total volume of water produced by the storm in cubic feet. (set up an excel spreadsheet to solve this problem using the trap rule). Be careful with your units, covert flow in cubic feet per second (cfs) to cubic feet perhour! 01 2 3 45 67 8 9 10 11 12 13 14 Q (cfs) | 0 | 12 | 32 | 62 | 108 | 180 | 208 | 182 | 126 | 80 | 53 | 32 | 18 | 6 | 0