Problem

Using a spreadsheet you have written, perform a complete series analysis on the data for...

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
Mean monthly discharge (m3/s)

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

Step-by-Step Solution

Request Professional Solution

Request Solution!

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.

Request! (Login Required)


All students who have requested the solution will be notified once they are available.
Add your Solution
Textbook Solutions and Answers Search
Solutions For Problems in Chapter 2