Instructions for Making Graphs of MacKinnon Data
Open the workbook bird data.xls Based on the survey data contained nthe worksheets Gallon lug MacKinnon,
Coxcomb Basin- Mackinnon, Punto Gorda MocKinnon,and Belmopan MacKinnon enter the CUMULATIVE number
of species encountered bysurvey, the yellow-shaded portion < of the worksheet Graph (If prompted by Exceltogive a
password order to add these values, enter SNHU).
Although there ways you calculation these values, one possibility would bethe following
the drop -down arrow at the top of
column (labeled survey). you will see a window
like that showninthis screenshot toggling
buttons, you can see whid particular species
were observed neach survey.
The following shows the species
02 recordlines those cell with
Survey 02 had
in Survey 01,
seeifa was shown: having
Survey Survey Survey 04).
Here, Oropendola Northern
but Ochre-bellied Flycatcher
that this visual inspection "works' isthat
for each already been sorted for
name and then survey number.
cumulative add 9tothe previoustotal, meaning inthis example, that after twosurveys Belmopan
Next. highlight (survey), change the fillcolor to No Fill, select all. and then repeat the process from above for
Afte completing the analysis for particular location, you are ready incorporate that information intoagraph Goto
the worksheet called Graph and enter the numbers youjust calculated into the appropriate column. You can do this
manually through copy paste ofthe value: described above in the MacKinnon worksheets.
There are actually twoimportant lessons learn in this process that may not be immedi ately obvious you Data
manipulation and analysis almost never the favorite activity of any field biologist those activities
importar doing the funstuffof walking around outside, in this example, looking birds Yournayno finda job
where your sole responsibilityistodo field work so use this exercise t help remind you self that workine with
spreadsheets important Secondly, the relative commitment between analysis and field work susually about 5:1
Thati: for every hour spent doing field work, you probably spend five hours working with data manipulation and
After having entered the MacKinnon data for each fthe four sites your graphs should look something like this
(althoughthe values shownhere are not the ones you will discover from your data analysis):
These solutions may offer step-by-step problem-solving explanations or good writing examples that include modern styles of formatting and construction
of bibliographies out of text citations and references. Students may use these solutions for personal skill-building and practice.
Unethical use is strictly forbidden.