Using a spreadsheet you have written, perform an annual minima analysis on the data for the Clear Fork Trinity River at Fort Worth, TX, given on page 2-42. Plot the data on Gumbel paper and determine the minimum monthly discharge for the mean annual drought. If the demand is 0.021 m3/s, will storage be required if the regulatory agency will allow a withdrawal of 3%?
Page 2-42
Clear Fork Trinity River at Fort Worth, TX | ||||||||||||
| Year | Jan | Feb | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec |
| 1940 | — | — | — | — | — | — | — | — | — | 0.00 | 5.63 | 15.4 |
| 1941 | 4.59 | 23.8 | 7.5 | 6.91 | 10.2 | 17 | 2.07 | 2.29 | 0.2 | 1.71 | 0.631 | 0.926 |
| 1942 | 0.697 | 0.595 | 0.614 | 58.93 | 24.1 | 9.09 | 0.844 | 0.714 | 1.21 | 10 | 2.38 | 1.87 |
| 1943 | 1.33 | 1 | 3.99 | 3.71 | 8.38 | 3.77 | 0.14 | 0.00 | 1.33 | 0.014 | 0.00 | 0.139 |
| 1944 | 0.311 | 4.93 | 2.83 | 2.25 | 13.3 | 1.68 | 0.21 | 0.609 | 4.11 | 0.985 | 0.515 | 1.47 |
| 1945 | 3.06 | 30.38 | 35.23 | 28.85 | 5.69 | 21.7 | 2.14 | 0.23 | 0.162 | 0.971 | 0.617 | 0.541 |
| 1946 | 1.88 | 5.75 | 3.54 | 1.89 | 6.57 | 5.86 | 0.153 | 1.45 | 4.02 | 0.906 | 12.2 | 10.3 |
| 1947 | 4.64 | 2.62 | 4.87 | 5.13 | 2.27 | 4.25 | 0.292 | 0.054 | 0.535 | 0.371 | 0.331 | 3.51 |
| 1948 | 3.99 | 16.9 | 9.06 | 1.91 | 2.64 | 1.11 | 1.22 | 0.00 | 0.00 | 0.00 | 0.00 | 0.003 |
| 1949 | 0.309 | 4.19 | 9.94 | 4.16 | 55.21 | 11.1 | 1.38 | 0.45 | 0.447 | 4.53 | 0.711 | 0.614 |
| 1950 | 3.28 | 14.7 | 3.26 | 12.7 | 15.1 | 2.5 | 3.6 | 2.44 | 10.6 | 1.12 | 0.711 | 0.801 |
| 1951 | 0.708 | 0.994 | 0.719 | 0.527 | 1.37 | 6.2 | 0.98 | 0.00 | 0.00 | 0.00 | 0.006 | 0.09 |
| 1952 | 0.175 | 0.413 | 0.297 | 1.93 | 3.65 | 0.21 | 0.003 | 0.029 | 0.007 | 0.00 | 0.368 | 0.167 |
| 1953 | 0.099 | 0.08 | 0.134 | 0.671 | 0.934 | 0.008 | 0.286 | 0.249 | 0.041 | 0.546 | 0.182 | 0.066 |
| 1954 | 0.108 | 0.092 | 0.114 | 0.088 | 0.278 | 0.017 | 0.021 | 0.015 | 0.008 | 0.047 | 0.024 | 0.063 |
| 1955 | 0.091 | 0.153 | 0.317 | 0.145 | 0.464 | 0.64 | 0.049 | 0.05 | 0.119 | 0.104 | 0.055 | 0.058 |
| 1956 | 0.069 | 0.218 | 0.026 | 0.306 | 1.35 | 0.3 | 0.026 | 0.019 | 0.029 | 0.266 | 0.03 | 0.17 |
| 1957 | 0.065 | 0.3 | 0.385 | 12.8 | 23.6 | 59.9 | 6.97 | 1.36 | 0.501 | 0.476 | 0.855 | 1.55 |
| 1958 | 1.65 | 1.61 | 4.59 | 5.69 | 28.1 | 0.589 | 0.524 | 0.456 | 0.549 | 0.572 | 0.49 | 0.566 |
| 1959 | 0.759 | 0.776 | 0.12 | 0.261 | 0.097 | 0.685 | 0.379 | 0.668 | 0.473 | 9.03 | 1.64 | 3.65 |
| 1960 | 11.8 | 4.45 | 3.26 | 1.42 | 0.631 | 0.379 | 0.66 | 0.566 | 0.467 | 0.498 | 0.241 | 0.648 |
| 1961 | 2.05 | 1.92 | 3.4 | 1.02 | 0.306 | 2.34 | 0.821 | 0.816 | 1.08 | 0.824 | 0.297 | 0.504 |
| 1962 | 0.311 | 2.03 | 0.467 | 0.759 | 0.459 | 0.236 | 0.745 | 1.41 | 6.94 | 1.31 | 0.405 | 0.767 |
| 1963 | 0.345 | 0.268 | 0.379 | 1.74 | 3.79 | 1.48 | 0.527 | 0.586 | 0.331 | 0.277 | 0.249 | 0.266 |
| 1964 | 0.416 | 0.266 | 1.16 | 0.813 | 1.02 | 0.374 | 0.535 | 0.963 | 3.96 | 0.351 | 1.47 | 0.886 |
| 1965 | 2.13 | 14.6 | 4.16 | 2.28 | 20.5 | 2.45 | 1.22 | 0.821 | 0.776 | 0.394 | 0.476 | 0.213 |
| 1966 | 0.169 | 0.354 | 0.462 | 6.4 | 23.1 | 18.5 | 5.32 | 0.951 | 0.294 | 1.37 | 0.15 | 0.134 |
| 1967 | 0.244 | 0.244 | 0.198 | 0.688 | 1.04 | 3.65 | 0.354 | 0.068 | 0.697 | 0.473 | 0.394 | 0.558 |
| 1968 | 1.64 | 3.85 | 23.2 | 1.89 | 15.7 | 6.12 | 0.583 | 0.144 | 0.22 | 0.419 | 0.396 | 0.206 |
| 1969 | 0.259 | 0.555 | 2.66 | 12.1 | 21.2 | 0.745 | 0.674 | 0.3 | 1.56 | 0.917 | 0.459 | 1.94 |
| 1970 | 5.78 | 6.37 | 27 | 3.31 | 15 | 1.03 | 0.521 | 0.697 | 1.23 | — | — | — |
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.