202301 lab 01 stats worksheet3

.docx

School

Valdosta State University *

*We aren’t endorsed by this school

Course

1108K

Subject

Biology

Date

Feb 20, 2024

Type

docx

Pages

4

Uploaded by mostlikelyalli

Report
Statistics & Writing Worksheet Question 1 (0.25 pts). Recreate the dataset shown below on a new Excel sheet. Replace the image below with a screenshot of your dataset. You can take a screenshot by pressing Win- Shift-S on Windows, or Shift-Cmd-3 on Mac. Question 2 (3 pts). This dataset contains data about the diets and sizes of the main olfactory bulb (mob) and auditory nucleus (aud) in 20 species of bats. These are parts of the brain involved in processing the senses of smell (main olfactory bulb) and hearing (auditory nucleus). The sizes are adjusted for overall body size: negative values have smaller than average mob or aud for their body mass, while positive values have larger than average mob or aud for their body mass. Each row represents 1 species of bat. Species that are “hawkers” are bats that catch insect prey in mid-flight, using echolocation to find their prey. “Herbivores” are bats that land on plants and consume fruits or leaves. BIOL 1108L Lab 1: Statistics in biology worksheet Page 1 of 4
Write a hypothesis about how the relative sizes of parts of the brain might be related to diet in bats (remember a hypothesis is explanatory and broader in scope than the specific study, refers specifically to the biology, and leads to many possible testable predictions). Then, write two predictions—one about mob and one about aud—that could be tested with this dataset. Hypothesis: The size of the parts of the brain responsible for sensory processing are adapted based on their diets – because the different types of sensory demands in how they forage for food Prediction about main olfactory bulb (mob): Herbivore bats will have larger mob sizes relative to their body mass in comparison to the hawker bats Prediction about auditory nucleus (aud): Hawker bats will have larger aud sizes relative to their body mass in comparison to the herbivore bats Question 3 (2.25 point; 0.25 pts per blank, 0.25 for pivot table): Use a pivot table to calculate the mean and SD of mob and aud for each diet type (hawker and herbivore). Round the numerical values to the nearest 0.01. Fill out the table below, then paste a screenshot into this document. Hawkers Herbivores Variable Mean SD Mean SD Main olfactory bulb -1.21 1.08 0.35 0.70 Auditory nucleus 0.75 0.94 -0.18 0.50 Paste screenshot here. BIOL 1108L Lab 1: Statistics in biology worksheet Page 2 of 4
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help