Question

# 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.

Subject: Calculus, Math
Problem #2.xls) with mean annual river discharge (ft3/s) and annual precipitation (in/yr, liquid water equivalent) data for the Georges Creek... 372,107 students got unstuck by Course
Hero in the last week 