Books  Data Analysis & Modelling  Modelling 

Spreadsheet Exercises in Ecology and Evolution

TextbookOut of Print
Key modeling primer for ecology and evolution

By: Therese M Donovan and Charles W Welden

556 pages, Figs, tabs

Sinauer Associates

Paperback | Mar 2002 | #129320 | ISBN: 0878931562
Out of Print Details

About this book

Pitched at undergraduates, the book is an excellent primer in spreadsheet modeling for the construction of biological models. In the process, it provides insight on basic and advanced concepts in ecology, evolution, conservation biology, landscape ecology and statistics.
The book contains basic spreadsheet exercises that explicate the concepts of statistical distributions, hypothesis testing and power, sampling techniques, and Leslie matrices. It contains exercises for modeling such crucial factors as population growth, life histories, reproductive success, demographic stochasticity, Hardy-Weinberg equilibrium, metapopulation dynamics, predator-prey interactions (Lotka-Volterra models), and many others. Building models using these exercises gives students "hands-on" information about what parameters are important in each model, how different parameters relate to each other, and how changing the parameters affects outcomes. The "mystery" of the mathematics dissolves as the spreadsheets produce tangible graphic results.
Each exercise grew from hands-on use in the authors' classrooms. Each begins with a list of objectives, background information that includes standard mathematical formulae, and annotated step-by-step instructions for using this information to create a working model. Students then examine how changing the parameters affects model outcomes and, through a set of guided questions, are challenged to develop their models further. In the process, they become proficient with many of the functions available on spreadsheet programs and learn to write and use complex but useful macros.
Spreadsheet Exercises in Ecology and Evolution can be used independently as the basis of a course in quantitative ecology and its applications or as an invaluable supplement to undergraduate textbooks in ecology, population biology, evolution, and population genetics.


PART I: SPREADSHEETS AND STATISTICS - Mathematical Functions and Graphs - Spreadsheet Functions and Macros - Statistical Distributions - Hypothesis Testing: Alpha, Beta, and Power - PART II: ECOLOGY - Geometric and Exponential Population Models - Logistic Population Growth - Interspecific Competition - Predator-Prey Dynamics (Lotka-Volterra) - Island Biogeography - Life Tables and Survivorship Curves - Reproductive Value: Matrix Approach - Reproductive Value: Life Table Approach - Demographic Stochasticity - Key Factor Analysis - Age-Structured Matrix Models (Leslie) - Stage-Structured Matrix Models - Sensitivity and Elasticity Analysis - Metapopulation Dynamics - Source-Sink Dynamics - Niche Breadth and Resource Partitioning - Population Estimation - Survival Analysis - Habitat Selection - Optimal Foraging Models - Range Expansion - Succession - PART III: EVOLUTION - Hardy-Weinberg - Multi-Locus Hardy-Weinberg - Measures of Genetic Diversity - Natural Selection and Fitness - Adaptation - Gene Flow and Population Structure - Life History Evolution - Heritability - Quantitative Genetics - Sexual Selection - Evolutionarily Stable Strategies - Parental Care and Mating Systems - Inbreeding and Outbreeding - Genetic Drift - Effective Population Size

Write a review

There are currently no reviews for this product. Be the first to review this product!


THERESE M. DONOVAN, University of Vermont. - CHARLES W. WELDEN, Southern Oregon University.

Bestsellers in this subject