Using a spreadsheet you have written and the data in Table 2-7 , continue the analysis o...

Average monthly discharge of Troublesome Creek at Nosleep, (m³/S)

Year

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

1987

2.92

5.1

1.95

4.42

3.31

2.24

1.05

0.74

1.02

1.08

3.09

7.62

1988

24.3

16.7

11.5

17.2

12.6

7.28

7.53

3.03

10.2

10.9

17.6

16.7

1989

15.3

13.3

14.2

36.3

13.5

3.62

1.93

1.83

1.93

3.29

5.98

12.7

1990

11.5

4.81

8.61

27

4.19

2.07

1.15

2.04

2.04

2.1

3.12

2.97

1991

11.1

7.9

41.1

6.77

8.27

4.76

2.78

1.7

1.46

1.44

4.02

4.45

1992

2.92

5.1

28.7

12.2

7.22

1.98

0.91

0.67

1.33

2.38

2.69

3.03

1993

7.14

10.7

9.63

21.1

10.2

5.13

3.03

10.9

3.12

2.61

3.00

3.82

1994

7.36

47.4

29.4

14

14.2

4.96

2.29

1.7

1.56

1.56

2.04

2.35

1995

2.89

9.57

17.7

16.4

6.83

3.74

1.6

1.13

1.13

1.42

1.98

2.12

1996

1.78

1.95

7.25

24.7

6.26

8.92

3.57

1.98

1.95

3.09

3.94

12.7

1997

13.8

6.91

12.9

11.3

3.74

1.98

1.33

1.16

0.85

2.63

6.49

5.52

1998

4.56

8.47

59.8

9.8

6.06

5.32

2.14

1.98

2.17

3.40

8.44

11.5

1999

13.8

29.6

38.8

13.5

37.2

22.8

6.94

3.94

2.92

2.89

6.74

3.09

2000

2.51

13.1

27.9

22.9

16.1

9.77

2.44

1.42

1.56

1.83

2.58

2.27

2001

1.61

4.08

14

12.8

33.2

22.8

5.49

4.25

5.98

19.6

8.5

6.09

2002

21.8

8.21

45.1

6.43

6.15

10.5

3.91

1.64

1.64

1.90

3.14

3.65

2003

8.92

5.24

19.1

69.1

26.8

31.9

7.05

3.82

8.86

5.89

5.55

12.6

2004

6.20

19.1

56.6

19.5

20.8

7.73

5.75

2.95

1.49

1.69

4.45

4.22

2005

15.7

38.4

14.2

19.4

6.26

3.43

3.99

2.79

1.79

2.35

2.86

10.9

2006

21.7

19.9

40

40.8

11.7

13.2

4.28

3.31

9.46

7.28

14.9

26.5

2007

31.4

37.5

29.6

30.8

11.9

5.98

2.71

2.15

2.38

6.03

14.2

11.5

2008

29.2

20.5

34.9

35.3

13.5

5.47

3.29

3.14

3.20

2.11

5.98

7.62