Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Flood frequency analysis excel

25/03/2021 Client: saad24vbs Deadline: 3 days

In this assignment, you will be creating a flood frequency curve for a California river, the Merced River. A flood frequency curve is used in hydrological studies, to get an idea of the statistical likelihood of floods of a given size on a river. Obviously, there are a modest number of small floods, a moderate number of large floods, and a very small number of gigantic floods. But what streamflow would translate as “small”, large”, or “gigantic” on a particular river? And if you could attach streamflow measurements to various floods, how frequently do those streamflows occur? That is the purpose of the flood frequency curve. In this lab you will process raw Excel data from the USGS to construct a flood frequency curve.

You are expected to revisit your Picture Yourself Learning Microsoft Excel 2010 textbook chapters (as assigned in the syllabus) to find the techniques necessary to do the manipulations outlined in this assignment. I will guide you through the hydrological work, and tell you what to do accomplish in your Excel workbook, but not provide every step of how to accomplish the required spreadsheet tasks; those are for you to have learned from your readings, and apply here.

Hydrological background

A flood frequency curve is a graph which summarizes the statistical behavior of peak river runoff. A sample flood frequency curve is shown below.

The annual probability is the chance for a flood of that size (or smaller) occurring in any particular year. The formula for the annual probability p is given as:

1

The letter m is the rank of the annual peak discharge (or streamflow, in cubic feet per second), and n is data points represented in the analysis. In a flood frequency analysis, all years are treated independently, so there will only be one peak runoff per year. Thus, if there are 70 years of data, there should be n=70 data values being analyzed. The smaller the size of m, the greater the flood. The largest flood is ranked number 1.

The quantity represented by p-1 is the return period. This is the duration of time, on average, between flood events of a certain discharge. The return period is an alternate way to express the statistical likelihood, as a whole number. For example, if the annual probability p is 0.0625 (6¼ %), the return period would be p-1 , or 16 years. Thus the water quantity representing the 6.25% annual probability would alternatively be known as the 16-year flood. The smaller the annual probability—or longer the return period—the greater the flood discharge. But it is not a linear proportionality between probability and discharge, which is why the need for the flood frequency curve arises.

Necessary steps

1. Import the data file into Excel, by opening it from within Excel. Choose the tab-delimited option.

2. Copy the geographic and data information notes into a new worksheet. Rename this worksheet with the name metadata. Rename the original worksheet data with the station number given in the metadata, and color its tab light blue.

3. Insert the column headings of Date and Discharge (cfs). 4. Delete the entries from 10/1/1916 through 12/31/1916, and 1/1/2002 through 9/30/2002. 5. Insert a new column, Year, between Date and Discharge. 6. Use the year function to have Excel compute the year for each row. 7. Perform (auto)filtering to have Excel display only one year. Then click the discharge

column to display the individual choices available for that year. The data will be sorted in ascending order. Note the maximum discharge and type it into a new worksheet tab, named Annual Peaks.

8. Next to the discharge, type the associated year. Click in the cell entry, then use the Fill (Series) button to automatically fill in every year of record.

9. Repeat step 7 for every year. 10. In the Annual Peaks worksheet, add a new column for the annual probability. Program it

using an Excel formula, and compute the annual probability for every discharge. 11. In a separate worksheet, generate a hydrograph for the annual discharges. Remember the

important convention for independent and dependent variables. Make sure you label all axes, and title the figure.

12. On a separate worksheet, generate a flood frequency curve for the data. You should use markers for your data points. The flood frequency data should be expressed using return periods. Again, use the proper convention for independent and dependent variables, and label and title your work. One of the axes should be plotted on a semilogarithmic scale (traditional for this type of graph, for compact viewing).

13. Use your graph to estimate the return period for a discharge of 14,800 cfs. State this value, and label it on your flood frequency graph, using a textbox callout.

14. Save your Excel file with your name and FF (for flood frequency), and submit it to the instructor. For example, Ashley Smith would submit ASmithFF.xls.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Financial Solutions Provider
Study Master
24/7 Assignment Help
Phd Writer
Write My Coursework
Coursework Assignment Help
Writer Writer Name Offer Chat
Financial Solutions Provider

ONLINE

Financial Solutions Provider

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$62 Chat With Writer
Study Master

ONLINE

Study Master

Give me a chance, i will do this with my best efforts

$29 Chat With Writer
24/7 Assignment Help

ONLINE

24/7 Assignment Help

Give me a chance, i will do this with my best efforts

$34 Chat With Writer
Phd Writer

ONLINE

Phd Writer

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$25 Chat With Writer
Write My Coursework

ONLINE

Write My Coursework

Give me a chance, i will do this with my best efforts

$15 Chat With Writer
Coursework Assignment Help

ONLINE

Coursework Assignment Help

I will cover all the points which you have mentioned in your project details.

$63 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Essay assignment- how Blockchain technology can be implemented to reduce ad fraud and cost while meeting consumers’ increasing expectation for excellent customer service? - G1 - Hozelock mixer tap connector screwfix - Shaver manufacturing inc offers dental insurance to its employees - Research Paper - Oa frontier ip - vanguard growth index - The direct labor budget of yuvwell - Purple heart drop off locations maryland - Naf strong or weak - Excel 2016 in practice ch 9 guided project 9 3 - Bofa merch svcs des interchng - Network diagram with ip addresses - 8 week hypertrophy program - Casa analysis - Kobe bryant basketball poem - In what pursuit is solmization useful or important - Education - Efficiency of dc shunt motor - Wimberley head wh 101 - What is a rental ledger - Want a case study asap - Petbarn narre warren grooming - 101.9 the mix double your paycheck - Tim hortons case study analysis - A written memorandum evidencing an oral contract - Blue gate fields infant school - Unit 3 physics cheat sheet - Principles of managerial finance 14th edition chapter 2 solutions - W1 - Natural gas condensate msds - Jinx episode 3 escape from area 52 - 3 types of levers - Have you seen luis valdez book - Week 4 - Sample training needs analysis questionnaire for employees - Holmbyre boarding cattery and dog groomers - Independent events venn diagram - Readiness for enhanced family coping - Risk management - 4 pages from the attached article - Which of the following statements describes french service - Prysmian lv cable catalogue - What physical property most distinguishes biotite mica from muscovite mica - Boiling point of ammonia gas - Motor program theory - European humanities - PICO Question - Hot bolting safety precautions - Indiana edu plagiarism test answers 2019 - Similes to describe trees - Bridge to terabithia book chapter 2 - A farewell to arms thesis statement - Schemas openxmlformats org package 2006 content types - A pair of silk stockings study questions and answers - Miller forensic assessment of symptoms test m fast pdf - Butler machine tool v ex cell o corp - Parameterization of an ellipse - Biology chapter 6 assessment answers page 175 - The following events occurred for johnson company - Chain of custody flow chart - Chapter 4 checking accounts lesson 4.4 bank statements answers - Molar mass oxalic acid dihydrate - Gator wilderness camp school - Paper chromatography of ink dyes lab report - NUR506- ASSIGMENT 6- Policy Analysis Paper - Biomes in north america - Adrian cooper sydney grammar - Coca cola company strategy implementation - Community DQ6 - What spartan values are suggested by this document - Society and culture pip syllabus - Fishy in the water fishy in the sea lyrics - Composition of functions worksheet - What does attica mean in dog day afternoon - Chemistry study design vce - Hlp1081c - Lakes in victoria for boating - Health insurance tax penalty australia - Ipip neo short form - Response to waiting for superman - 1200 word paper on diversity and inclusion - Coca cola vision mission values - Media relations cover letter - Intake manifold runner control circuit - Davies v swan motor co - Discuss as a command word - Practicum – Week 8 Journal Entry - Allroad parts competitive strategy - Lacy construction has a noncontributory - Salvage the bones character analysis - Stihl bg 86 ignition module - Breakfast club personality types - 64mm top hat price - Stretford grammar school admissions - Must give very detailed answers non-plagiarized - Sketch up free trial - Pros and cons of continuing nursing education - California executive branch - Health Assessment - If 360 is invested at an interest rate of 4 - See if i care readworks