Lab Assignment

Part B - Recurrence Intervals

Data from the chart below was collected at the USGS site and includes the 20 largest discharge events for Sweetwater Creek at station 02337000 from January 1, 2008 through May 1, 2015, excluding the dramatic 2009 flood (we will learn more about that later). In order to create a flood-frequency graph, you must first calculate the recurrence interval (one is calculated below as an example). A recurrence interval refers to the average time period within which a given flood event will be equaled or exceeded once. To calculate it, first evaluate the rank of the flood, with a “1” going to the highest discharge event and a “20” going to the lowest discharge event. Calculate the recurrence interval using the following equation:

RI = (n+1) ÷ m

where, RI = Recurrence Interval (years)

n = number of years of records (in this case, 8)

I am having a hard time writing these SQL queries. Please specify the following queries in SQL on the database schema shown in the figure below.

1) Retrieve the course names of all courses with the number of credit hours as 4

2) Retrieve the names of all courses and their respective departments taught by professor Chang in 2010 and 2011

3) For each section taught by Professor King, retrieve the course number, semester, year, and the number of students who took the section

4) Retrieve the name and transcript of each freshman student (Class=1) majoring in EE. Transcript includes course name, course number, credit hours, semester, year, and grade for each course completed by the student

We can make a simple model of the human vocal tract as an open-closed tube extending from the opening of the mouth to the diaphragm

Q: What is the length of this tube if its fundamental frequency equals a typical speech frequency of 240 Hz ? The speed of sound in the warm air is 350 m/s.

The Australian share market has risen considerably since the S&P/ASX200 index closed at 4546 on March 23. Using the content covered in the subject, do you believe that now is a good time to invest in a diversified portfolio of Australian shares, such as the S&P/ASX200 index? Why or why not?

K_c = 4.15 x 10^-2 at 533°C for PCl_5(g) ↔ PCl_3(g) + Cl_2(g). A closed 2.00 L vessel initially contians 0.100 mol PCl₅. Calculate the total pressure in the vessel (in atm to 2 decimal places) at 533°C when equilibrium is achieved.

12 . NH₂CO₂NH₄(s) when heated to 450 K undergoes the following reaction to produce a system which reaches equilibrium: NH₂CO₂NH₄(s) <--> 2 NH₃(g) + CO₂(g)

        The total pressure in the closed container under these conditions is found to be 0.843 atm. Cal­culate a value for the equilibrium constant, K_p.

Describe the structure of the Universe, and how we know that it is expanding. Describe the Open and Closed Big Bang theories of the Universe, and the Inflationary model, and the differences between them. Discuss the current version of the Big Bang theory, and its implications for the future of the Universe. Discuss the theory of "dark" matter as it relates to the structure of the Universe.

17. Use the IS/LM model to predict the effects of each of the following shocks on income, the interest rate, consumption, and investment. Explain and illustrate your answers. Assume price level is constant and the economy is closed.

a. The Fed reducing the money supply

b. The government raising government expenditures and taxes by the same amount.

Let G = Z x Z and H = {(a, b) in Z x Z | 8 divides a+b}

a. Prove directly that H is a normal subgroup in G (use the fact that closed under composition and inverses)

b. Prove that G/H is isomorphic to Z8.

c. What is the index of [G : H]?