Fish and Wildlife Population Ecology - Dr. Edward O. Garton
|
|
Snorkel counts are used widely in the Northwest to get an index to trout population sizes. In an attempt to evaluate this technique a complete survey of all the pools on Deer Creek was completed in 1989 by snorkeling and then the survey was repeated by electro-fishing in June. Use the data presented in Table 1 to carry out the analyses described below:
The goal here is to learn the use of spreadsheets to perform common calculations for finite population studies. Feel free to use Excel or QuatroPro or whichever spreadsheet program you use regularly. Try using the built-in formulas to calculate any of the statistics that are available within the program such as mean (called AVERAGE) and variance but note that some provide the population variance rather than the sample variance (using n rather than n-1 in the divisor). You can then use these preliminary steps to calculate the appropriate final results including the finite population correction, etc. There are Excel and Quatropro spreadsheets with the raw data already entered on the S: drive under Wlf543/SAMPLE. Look for the files called RANDSAMP.
|