Spreadsheet Exercises in Ecology and Evolution Chapters

Each chapter has links to the .pdf document, a completed spreadsheet for instruction(.xlsx), and a spreadsheet shell(.xlsx). Some chapters also include answer documents for in chapter questions(.pdf). Some Chapters require Macros enabled spreadsheets. Click here for instructions on using macros.

Chapter 0: Spreadsheet Hints and Tips
  • Download Chapter
  • Download Completed Spreadsheet
  • Download Spreadsheet Shell
  • Download Answers
Chapter 1: Mathematical Functions and Graphs
  • Download Chapter
  • Download Completed Spreadsheet
  • Download Spreadsheet Shell
  • Download Answers
Chapter 2: Spreadsheet Functions and Macros
Chapter 3: Statistical Distributions
Chapter 4: Central Limit Theorem
Chapter 5: Hypothesis Testing – Alpha, Beta, and Power
Chapter 6: Sampling Species Richness
Chapter 7: Geometric and Exponential Population Models
Chapter 8: Logistic Population Models
Chapter 9: Interspecific Competition and Competitive Exclusion
Chapter 12:  Life Tables, Survivorship Curves, and Population Growth
Chapter 18: Key Factor Analysis
Chapter 23: Population Estimation with Mark-Recapture Techniques
Chapter 33: Adaptation: Persistence in a Changing Environment

Any Questions or Comments? Please contact tdonovan@uvm.edu

Copyright © 2020. All Rights Reserved.

Website last updated August 6, 2020

Skip to toolbar