Problem #2. See attached excel file (GeorgesCreek.xls) with mean annual
river discharge (ft3/s) and annual precipitation (in/yr, liquid water equivalent) data for the Georges Creek watershed (area = 72.4 mi2) in western Maryland for water years 1974‐2018.
-First, making the appropriate conversions (please state), draw graphs illustrating the inter‐annual variations in runoff (Rs) and precipitation (P) in Georges Creek for the period of record. Hint: use Excel to convert both time series to units of cm. Are you treating these time series as sample data or pulse data?
-Using the continuity equation discussed in class (and making appropriate assumptions), compute and graph (i) annual evapotranspiration (ET) and (ii) Rs/P time series.
-Compute long‐term mean values for all three water balance components, as well as for the runoff ratio (Rs/P) for this watershed; compare long‐term mean values for Georges Creek with average values for the entire North American continent (see Table 1.2 from Hornberger et al., 1998-presented in class). How would you characterize the hydroclimatology of this watershed?
-Using your results from Problem #2, use Excel to perform an appropriate statistical test for monotonic trend on each of the four time series.
-Are any of the trends statistically significant? Explain.
-Compute a variance for each of the four random variables and express each variance as a percentage of the mean computed in Problem #2 c).
-Which random variable exhibits the greatest (stochastic) variability? Least variability?
-Briefly discuss the results in the context of providing evidence of the effects of climate change in Georges Creek watershed.
372,107 students got unstuck by Course
Hero in the last week
Our Expert Tutors provide step by step solutions to help you excel in your courses