geology exercise and need the explanation and answer to help me learn.
i started the excel and need some editing it.
attached is the requirments for the assignment. In this activity you will perform an analysis in Excel of a stream you pick. You will have a discussion question based on the activity. here is a youtube totrial. Flood Frequency Analysis tutorialLinks to an external site. (YouTube) [12:38]
Requirements: answer | .doc file
Discussion: Streams The flood frequency analysis you performed for your homework uses historical data to make predictions about the likelihood of future events. In essence, it assumes that the factors that determine river discharge are random variables that don’t change with time. Is this a good assumption? Why do you think this is an important consideration?
In this assignment, you will be constructing and interpreting an annual peak discharge (flood) frequency diagram and rating curve for a river in a specified US state. This activity must be done in Excel! You will analyze the data and create graphs in Excel and upload the Excel file into Canvas. Everyone in the class has been randomly assigned a US state based on your student id FOR THIS CLASS – NOT YOUR U-number! It’s the same number you used for the Rocks Assignment. Someone else may have the same state as you. You are responsible for making sure you do not analyze duplicate rivers. Go to the Streams Activity – State Conflicts post in Discussions in Canvas. I have added a post for each state. You must check this list. If no one else has posted your river, then reply to the State thread with the river name and your student id (FOR THIS CLASS). If someone has selected your river, you must select a different one and then add it as a post to the thread. If you encounter problems, notify me. Here’s how you get your data: 1. Go to https://nwis.waterdata.usgs.gov/usa/nwis/peak 2. Check the following boxes: Site Location = State/Territory; Date Attribute = Number of observations 3. Click “Submit” 4. Pick your state and set minimum number of observations = 60 5. Pick Table of sites grouped by Hydrologic unit; don’t check any other boxes 6. Click “Submit” 7. Once again, you must choose a river. Do not pick a “creek”, “drainage canal”, etc. If you are stuck, contact me. 8. Peruse the sites which have sufficient data and pick one. To view the actual data available, click on the site number then click on Table to see all the data. Make sure there are at least 60 peak discharge measurements and at least 40 stage measurements. 9. You will need to get the data into an Excel spreadsheet. The easiest way to do this is to copy and paste: copy just the data (exclude the headings) and paste into a blank worksheet in Excel. When you paste choose to “match destination formatting” or you’ll have to remove the formatting on the USGS page. 10. VERY IMPORTANT: carefully examine your spreadsheet and make sure all the numbers have transferred properly. In some cases, the USGS uses footnotes in the Table to describe certain conditions of the data, and these footnotes will not copy/paste properly. Failing to ensure that the data have transferred properly is a major source of problems later on. 11. Insert a row at the top and label your columns: “Year”, “Date”, “stage(ft)”, and “Q(cfs)”.
12. At the top of your spreadsheet insert a few rows and enter the following: (a) the name of your river, exactly as it appears on the USGS web page; (b) the link to the USGS web page where you downloaded your data. This is important, you will not receive any credit if I can’t go to this page to see the data you were working with! Your tasks: 1. Perform a flood frequency analysis for your stream by creating: (a) the EI/Q graph and fit line; and (b) the rating curve and fit curve. Using the equations for these lines, determine the 100- and 200-year flood discharge and stage, and report it in your spreadsheet. 2. Write a paragraph discussing your data and any problems you may have had in doing your analysis, or any concerns you may have with the result. You may add your paragraph to the spreadsheet by inserting a text box. I must be able to read the entire paragraph without having to change the size of the text box. Do not skimp on this part of the activity! It is worth 1/3 of your grade! Here are some guidelines for what I’m looking for: • I am not looking for a play-by-play of what you did (you followed instructions; I get it.) • I am not looking for a reflection on what you learned. • I am looking for a discussion of your data; what decisions you had to make and how you justified these decisions. • If your data presented problems, I want to know how you dealt with the problems. • If your data were difficult to interpret—for example, if the rating curve did not define a smooth curve—I want to read a discussion of why this might be. • If there’s a way to figure out a better way to interpret your data, I expect to see some effort at doing this. 3. Save your spreadsheet file with a unique name. Upload your XLSX file to Canvas using the assignment link. There is also a short essay question you will answer when you open the quiz. Christy’s Tips There is an example of a completed assignment – you want to make yours look as close to that as possible. The tutorial is very good, too. You must think about your data! How might you get “better” results for the lines/curves you are drawing? Is there too much of a “hook” at the lower end of the graph? Does the river appear to have
more than one set of data – perhaps something has changed in its history – can you find the most current? What would the graphs look like if this happened? Most of the time you can plot the data using a semi-log graph and power functions. What do you think you should do if that doesn’t give you a “good fit”? How to Lose Points (a few major ways) 1. Do not follow the directions EXACTLY. Especially, make sure the river name is in the spread sheet and the link to its data – if we can’t get to the data, we won’t grade the spreadsheet, and you will receive a zero. 2. Graph a duplicate river (see above). Only the first one recorded in Discussions will be graded. 3. Don’t think about your data and what it shows – or should show. 4. If your trend line isn’t projected forward enough for us to “read” your extrapolated data 5. If your graphs aren’t correct (did you plot the correct data? Did you use the correct formulas?) 6. Not using all the data points – and/or – not explaining why data points were not included. 7. Using a log scale with a weird base (don’t use things like base 2 or base 5). 8. Either no paragraph or a poorly constructed paragraph. Make sure to touch on the bullets above. 9. Turning this in late 10. Making the layout so confusing we can’t figure out how to grade it or what you did.
We are a professional custom writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework.
Yes. We have posted over our previous orders to display our experience. Since we have done this question before, we can also do it for you. To make sure we do it perfectly, please fill our Order Form. Filling the order form correctly will assist our team in referencing, specifications and future communication.
2. Fill in your paper’s requirements in the "PAPER INFORMATION" section and click “PRICE CALCULATION” at the bottom to calculate your order price.
3. Fill in your paper’s academic level, deadline and the required number of pages from the drop-down menus.
4. Click “FINAL STEP” to enter your registration details and get an account with us for record keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
5. From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.
Need help with this assignment?
Discount Code: SAVE25