You are employed by a consultant firm which is commissioned to investigate the f

Question

You are employed by a consultant firm which is commissioned to investigate the flood hydrology at a new bridge crossing over the Red River of the North. The river forms the border of North Dakota and Minnesota. Your first assigned task is to compile a certain streamflow data that can be downloaded from the internet. Obtain the annual peak discharge series (up to 2016) observed at a USGS’s gaging station found along this river, near Grand Forks, ND. The Hydrologic Unit for the Red River is 09.

(a) Arrange the data in columns of “Year” and “Peak Discharge” in a separate worksheet within an EXCEL file. Compute the mean annual peak discharge. Tabulate and submit the results in a single table.

(b) Rank and list the top ten floods recorded. Showing the years and annual peak discharges in a table.

(c) How many times higher was the maximum flood discharge recorded as compared with the mean annual peak discharge of the station (or the worst flood index)? Show your results in another table. (For a table, you must show a caption on the top).

Explanation / Answer

Dear Student,

The data which is need to be download from the internet is not having access in my place. So i m requesting you to please download the data from your resources and send the question again. Dont think in otherway. If you want the solution for this you must download the data first so you might have access to get the data. So im requesting you that please download the data first and send the question again. This is the best thing we can do to get the solution.

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.