Question: 2. Using Excel, perform the following tasks on the Clear Fork Trinity River data: Mar Apr May Jun Jul Aug Sep Now 561 0.631 Dec
2. Using Excel, perform the following tasks on the Clear Fork Trinity River data: Mar Apr May Jun Jul Aug Sep Now 561 0.631 Dec 154 0926 1.87 0.139 235 Mean monthly decharge, m's Year Month Jan Feb 1940 1941 23.8 1942 0.697 0.595 1943 1.33 1 1944 0311 4.93 1945 3.06 30.38 1946 1.88 5.75 1947 2.62 1948 16.9 1949 0.309 4.19 1950 3.28 14.7 1951 0.708 0944 1952 0.175 0.413 1953 0.099 0.08 1954 0.108 0.092 1955 0.091 0.153 1956 0069 0218 1957 0.065 0.3 1958 1.65 1.61 1959 0.759 0.776 1960 11.8 4.45 1961 2.05 1.92 1962 0311 2.03 1963 0.345 0.268 1964 0.416 0.266 1965 2.13 146 1966 0.169 0.354 1967 0.244 0.244 1968 1.64 3.85 1969 0.259 0.555 1970 5.78 6.37 7.5 0.614 3.99 283 35 23 3.54 4.87 9.06 9,94 3.26 0.719 0.297 0.134 0.144 0.317 0.026 0.385 4.59 0.12 3.26 6.91 58.93 3.71 225 28.85 1.89 5.13 1.91 4.16 12.7 0.527 1.93 0.691 0.08 0.145 0.3% 12.8 5.69 0.261 1.42 1.02 0.759 1.74 0.813 2.28 10.2 24.1 8.38 13.3 5.69 6.57 2.27 2.64 55.21 15.1 1.37 3.65 0934 0.278 0.464 1.35 23.6 28.1 0.097 0.631 0.306 0.469 17 9.09 3.77 1.6% 21.7 5.86 4.25 1.11 11.1 2.5 6.2 0.21 0.00 0.017 0.64 0.305 59.9 0.589 0.685 0.379 2.34 0.236 1.48 0.374 2.45 18.5 3.65 6.12 0.745 1.03 2.07 0.844 0.14 0.21 2.14 0.153 0,292 1.22 1.38 3.6 0.9 0.003 0.286 0,021 0.019 0.026 6.97 0.524 0.379 0.66 0.821 0.745 0.527 0.535 1.22 5.32 0.354 0.583 0.674 0.521 2.29 0.714 0.001 0.00 0.23 1.45 0.054 003 0.45 2.44 0.002 0.029 0.249 0.015 0,05 0.019 1.36 0.456 0.668 0.566 0.816 1.41 0.586 0.963 0.821 0.951 0.068 0.144 0.3 0.697 02 1.21 1.11 4.11 0.162 4.02 0.535 0.025 0.447 10.6 0.035 0.007 0.041 0.008 0.119 0.029 0.501 0.549 0.473 0.467 1.08 6.94 0.331 3.96 0.776 0.294 0.697 0.22 1.56 1.23 Oct 0.01 171 10 0014 0.985 0.971 0906 0.371 0.031 4.53 1.12 0.0021 0.04 0.546 0097 0.104 0.266 0.476 0.572 9.03 0.498 0.824 1.31 0.277 0.351 0.394 1.37 0.473 0.419 0.917 0 0.515 0.617 122 0.131 02 0.701 0.711 0.00 0.36 0.182 0.004 0.055 0.0302 0.855 0.49 1.64 0.241 0.297 0.405 0.249 1.47 0.476 0.15 0.394 0.396 0.459 0541 103 3.51 0003 0.614 O 01 0.09 0.167 0.066 0.03 0.058 0.17 1.55 0.566 165 0.648 0.504 0.767 0.266 0.886 0.213 0.134 0.558 0.206 1.94 0.467 0.379 1.16 4,16 0.462 0.198 23.2 2.66 1.62 20.5 23.1 1.04 0.688 1.89 12.1 15.7 21.2 15 a) Complete series analysis. Plot the flow-duration curve for the river. What is the safe yield (flow equaled or exceeded 80% of the time) of the river if the regulatory agency will allow a withdrawal of 5%? 2. Using Excel, perform the following tasks on the Clear Fork Trinity River data: Mar Apr May Jun Jul Aug Sep Now 561 0.631 Dec 154 0926 1.87 0.139 235 Mean monthly decharge, m's Year Month Jan Feb 1940 1941 23.8 1942 0.697 0.595 1943 1.33 1 1944 0311 4.93 1945 3.06 30.38 1946 1.88 5.75 1947 2.62 1948 16.9 1949 0.309 4.19 1950 3.28 14.7 1951 0.708 0944 1952 0.175 0.413 1953 0.099 0.08 1954 0.108 0.092 1955 0.091 0.153 1956 0069 0218 1957 0.065 0.3 1958 1.65 1.61 1959 0.759 0.776 1960 11.8 4.45 1961 2.05 1.92 1962 0311 2.03 1963 0.345 0.268 1964 0.416 0.266 1965 2.13 146 1966 0.169 0.354 1967 0.244 0.244 1968 1.64 3.85 1969 0.259 0.555 1970 5.78 6.37 7.5 0.614 3.99 283 35 23 3.54 4.87 9.06 9,94 3.26 0.719 0.297 0.134 0.144 0.317 0.026 0.385 4.59 0.12 3.26 6.91 58.93 3.71 225 28.85 1.89 5.13 1.91 4.16 12.7 0.527 1.93 0.691 0.08 0.145 0.3% 12.8 5.69 0.261 1.42 1.02 0.759 1.74 0.813 2.28 10.2 24.1 8.38 13.3 5.69 6.57 2.27 2.64 55.21 15.1 1.37 3.65 0934 0.278 0.464 1.35 23.6 28.1 0.097 0.631 0.306 0.469 17 9.09 3.77 1.6% 21.7 5.86 4.25 1.11 11.1 2.5 6.2 0.21 0.00 0.017 0.64 0.305 59.9 0.589 0.685 0.379 2.34 0.236 1.48 0.374 2.45 18.5 3.65 6.12 0.745 1.03 2.07 0.844 0.14 0.21 2.14 0.153 0,292 1.22 1.38 3.6 0.9 0.003 0.286 0,021 0.019 0.026 6.97 0.524 0.379 0.66 0.821 0.745 0.527 0.535 1.22 5.32 0.354 0.583 0.674 0.521 2.29 0.714 0.001 0.00 0.23 1.45 0.054 003 0.45 2.44 0.002 0.029 0.249 0.015 0,05 0.019 1.36 0.456 0.668 0.566 0.816 1.41 0.586 0.963 0.821 0.951 0.068 0.144 0.3 0.697 02 1.21 1.11 4.11 0.162 4.02 0.535 0.025 0.447 10.6 0.035 0.007 0.041 0.008 0.119 0.029 0.501 0.549 0.473 0.467 1.08 6.94 0.331 3.96 0.776 0.294 0.697 0.22 1.56 1.23 Oct 0.01 171 10 0014 0.985 0.971 0906 0.371 0.031 4.53 1.12 0.0021 0.04 0.546 0097 0.104 0.266 0.476 0.572 9.03 0.498 0.824 1.31 0.277 0.351 0.394 1.37 0.473 0.419 0.917 0 0.515 0.617 122 0.131 02 0.701 0.711 0.00 0.36 0.182 0.004 0.055 0.0302 0.855 0.49 1.64 0.241 0.297 0.405 0.249 1.47 0.476 0.15 0.394 0.396 0.459 0541 103 3.51 0003 0.614 O 01 0.09 0.167 0.066 0.03 0.058 0.17 1.55 0.566 165 0.648 0.504 0.767 0.266 0.886 0.213 0.134 0.558 0.206 1.94 0.467 0.379 1.16 4,16 0.462 0.198 23.2 2.66 1.62 20.5 23.1 1.04 0.688 1.89 12.1 15.7 21.2 15 a) Complete series analysis. Plot the flow-duration curve for the river. What is the safe yield (flow equaled or exceeded 80% of the time) of the river if the regulatory agency will allow a withdrawal of 5%
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help