3. Use the same data in Problem 1. Tip: Prob 3 can be done easily in Excel (1) Plot the peak flow (cfs) in the y-axis vs. water year in the x-axis. (2) Add a linear trend line (linear regression line) including the regression equation with a R? valve (3) Label all axes with proper unit. (4) Fill out the following table. Note that your data is not population but “sample". Assume a regional skewness Cm =-0.20 in computing Cw.[: (a) Compute the probability that a peak flow is less than 22500 cfs (answer up to 4 decimals). (b) What will be the return period for the peak flow 22500 cfs? (c) Compute the probability that a peak flow exceeds 17500 cfs (answer up to 4 decimals).

Fig: 1

Fig: 2

Fig: 3

Fig: 4

Fig: 5

Fig: 6

Fig: 7

Fig: 8

Fig: 9