ENVS 202 Third Homework Assignment

Date Due: Thursday Feb 25

For this assignment its not practical to use email as there will be graphing involved. So waste some trees and use paper.

All about Dams and the Columbia river

1. What is the time history of dam construction on the Columbia River? What are the power generating capacities of each dam? Based on the number of dams and the time of their construction, do you think its feasible that dams are entirely responsible for the apparent loss of Salmon in the Columbia River System?

Note for question 2. The specific question refers to McNary Dam - however if you go here:

Fish Data

you can select another dam if you like. So you don't have to do the specific McNary Dam on posed below. Possible other candidates are, The Dalles, John Day, or Bonneville. If you select another dam, make sure you answer the same kinds of questions as the ones listed below.

If different groups do different dams then we can pool all the data to search for systematic trends. But, that's up to you guys.

2. You have been assigned by your company, "Progress 'R Us", to study if there has been a decline in recent years of Salmon at McNary dam. You have the following raw data from which to work with. When working with data like this its best to abbreviate it. So if you enter numbers into the the Tool don't be anal and put in a number of 126555 - just abbreviate that to 126 and remember that the units are thousands. It will save a lot of data entry time.

  YEARLY TOTALS OF SALMONIDS COUNTED OVER MCNARY DAM 1954-1994

 YEAR  CHINOOK* STEELHEAD  SOCKEYE    COHO*     TOTALS*

 1954    126,555    75,059   108,181       950    310,745
 1955    108,915    85,575   173,758       643    368,891
 1956    114,342    42,554   102,145       683    259,724
 1957    292,696   105,728    85,460     2,855    486,739
 1958    226,092    87,890   102,397     1,350    417,729
 1959    171,490   110,475    83,977     1,970    367,912
 1960    176,767    96,895    55,372     1,580    330,614
 1961    154,996   103,743    16,388     2,045    277,172
 1962    152,756   163,181    29,372     3,195    348,504
 1963    154,459   113,646    59,744     3,113    330,962
 1964    167,934   100,742    83,931     3,317    355,924
 1965    150,907   118,960    42,052     2,700    314,619
 1966    223,141   145,130   173,028     8,525    549,824
 1967    195,653    77,700   105,635    27,226    406,214
 1968    200,488   112,522   101,007    39,518    453,535
 1969    213,407    76,681    29,787    53,716    373,591
 1970    168,892    69,759    59,636    36,399    334,686
 1971    171,448   109,630    52,867    39,358    373,303
 1972    168,821    93,820    26,422    45,635    334,698
 1973    184,112    64,620    42,731    17,682    309,145
 1974    127,858    26,932    26,505    13,746    195,041
 1975    133,150    23,663    43,143     3,975    203,931
 1976    163,314    54,000    24,632     7,539    249,485
 1977    183,581    87,712    80,781     4,622    356,696
 1978    144,148    34,740    18,511    20,356    217,755
 1979     95,275    50,304    37,792    12,800    196,171
 1980     80,773    66,524    44,301       571    192,169
 1981     80,619    61,985    26,644     3,736    172,984
 1982    102,225    75,099    15,077     3,119    195,520
 1983    121,636   125,254    40,903     2,470    290,263
 1984    159,071   135,515    56,906     2,841    354,333
 1985    288,483   188,204    98,457     6,917    582,061
 1986    342,417   193,481    46,443     1,374    583,715
 1987    286,638   148,811    72,190       615    508,254
 1988    243,608   151,765    50,080     2,010    447,463
 1989    176,407   170,467    41,318     3,383    391,575
 1990    147,439    95,061    46,145     2,059    290,704
 1991    114,841   168,692    69,365     2,272    355,170
 1992    135,707   194,026    68,737     1,801    400,271
 1993    143,412    93,183    66,485       481    303,561
 1994    128,868    94,427    10,603     1,735    235,633
 1995    113,354   114,910     8,320     1,021    237,605
 1996    114,947   124,177    28,585     1,853    269,562 

A. Where is McNary Dam located, when was it built, and how much power does it produce?

B. For the 40 year data set above, what are the means and dispersions for the Chinook and Sockeye data sets?

C. Make a graph of Chinook counts vs sockeye counts. Are they correlated? If they are correlated, explain how this might simplify your data analysis. If they are not correlated, explain how this might complicate your data analysis.

D. Compare the last 5 years of data (1992-1996) to the first 37 years of data for both Chinook and Sockeye and determine if there is a significant deficit of counts, in either species, over the last few years.

E. Now look at the data carefully to see if you can identify any other 5 year period in which the Salmon counts at McNary Dam were low.

F. Based on your study, you have to give a press release to the community around McNary Dam that want to blow it up because no more Salmon pass through it. Write a one paragraph press release that summarizes your findings. Remember, Joe Sixpack will be listening.

Course Page