The Department of Water and Sanitation (DWS) has nominated you to carry out an assessment of the sustainability of the water resource system (in the Coastal rivers system, of South Africa). Assuming annual total flow data (in million cubic meters), downloadable on the https://www.dws.gov.za/Hydrology/Default.aspx. The appropriate statistical performance criteria should be used in the assessment.
The data refer to the flow gauge on Tsisikama at Geelhoutboom, located in the sub-drainage K8, namely the Coastal rivers. The flow gauge is numbered by K8H005. Use the verified data from DWS.
Perform the following tasks:
1.1. Clearly write down your unique number for visiting the DWS website
1.2. Show the time series of flow data. (Show all screenshots of all steps to obtain the data. All your screenshots must show the unique number as well (15)
1.3. Determine the third of the maximum value as drought threshold (5)
1.4. Plot in Excel, the times series of flows for the data length in points 1. 2, and include the threshold levels. (No handwritten plot allowed). Comment on the plot obtained. (15)
1.5. Calculate the absolute value of the difference between the cumulative deficit versus the cumulative surplus (10)
1.6. Determine the statistical performance criteria of the water resources system related to the drought threshold. (15)
1.7. Briefly assess the water resources system based on the results of the tasks you have performed. (5)