Using a spreadsheet you have written, perform a complete series analysis on the data for the Squannacook River near West Groton, MA, given on page 2-41 Plot a yield curve. What is the safe yield of the river if the regulatory agency will allow a withdrawal of 6%?
Page 2-41
Squannacook River near West Groton, MA | ||||||||||||
Year | Jan | Feb | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec |
1951 | 3.48 | 8.18 | 6.63 | 6.63 | 3.2 | 2.38 | 2.4 | 1.49 | 1.06 | 1.82 | 6.6 | 4.47 |
1952 | 6.68 | 5.07 | 6.51 | 9.94 | 5.44 | 3.71 | 0.87 | 1.01 | 0.69 | 0.45 | 1.05 | 3.37 |
1953 | 4.79 | 6.77 | 11.44 | 9.8 | 6.34 | 1.21 | 0.52 | 0.42 | 0.29 | 0.51 | 1.34 | 3.65 |
1954 | 2.06 | 3.2 | 4.67 | 4.53 | 9.71 | 2.75 | 1.21 | 1.05 | 6.94 | 2.27 | 6.26 | 7.16 |
1955 | 2.92 | 3.06 | 5.41 | 6.17 | 2.77 | 1.44 | 0.46 | 1.63 | 0.61 | 8.38 | 8.61 | 2.17 |
1956 | 9.15 | 3.29 | 3.82 | 14.56 | 5.21 | 2.5 | 0.77 | 0.4 | 0.5 | 0.54 | 1.14 | 2.33 |
1957 | 2.92 | 2.63 | 4.22 | 3.99 | 2.65 | 0.87 | 0.37 | 0.22 | 0.22 | 0.29 | 0.97 | 3.91 |
1958 | 5.89 | 3.48 | 6.6 | 12.4 | 5.35 | 1.29 | 0.81 | 0.49 | 0.45 | 0.62 | 1.13 | 1.49 |
1959 | 2.07 | 2.05 | 5.41 | 8.67 | 2.37 | 1.22 | 1.17 | 0.59 | 0.82 | 2.55 | 4.08 | 5.55 |
1960 | 3.51 | 3.96 | 3.03 | 14.73 | 5.52 | 2.41 | 1.09 | 1.21 | 2.71 | 2.18 | 3.34 | 2.49 |
1961 | 1.57 | 3.09 | 7.28 | 11.1 | 4.67 | 2.31 | 1.03 | 0.8 | 1.23 | 0.99 | 2.06 | 1.73 |
1962 | 3.14 | 1.8 | 5.47 | 10.93 | 3.71 | 1.25 | 0.56 | 0.69 | 0.5 | 2.95 | 4.73 | 4.30 |
1963 | 2.19 | 1.76 | 6.83 | 7.53 | 2.66 | 0.77 | 0.38 | 0.24 | 0.25 | 0.35 | 1.52 | 1.98 |
1964 | 3.77 | 2.57 | 7.33 | 6.57 | 1.85 | 0.59 | 0.38 | 0.25 | 0.21 | 0.27 | 0.36 | 0.79 |
1965 | 0.65 | 1.33 | 2.38 | 3.79 | 1.47 | 0.59 | 0.23 | 0.2 | 0.19 | 0.27 | 0.45 | 0.64 |
1966 | 0.61 | 1.96 | 5.55 | 2.92 | 2.46 | 0.8 | 0.26 | 0.18 | 0.27 | 0.52 | 1.75 | 1.35 |
1967 | 1.68 | 1.53 | 2.64 | 10.62 | 6.29 | 3.17 | 2.22 | 0.72 | 0.47 | 0.6 | 1.07 | 3.03 |
1968 | 2.02 | 2.14 | 9.6 | 3.79 | 3.82 | 4.79 | 1.92 | 0.61 | 0.48 | 0.46 | 1.88 | 4.33 |
1969 | 2.21 | 2.17 | 5.81 | 10.7 | 2.8 | 1.01 | 0.58 | 1.03 | 0.93 | 0.52 | 5.24 | 5.83 |
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.