Spreadsheet Exercises in Ecology and Evolution
Published on 1. December 2001
Book
Paperback/Softback
320 pages
978-0-87893-156-9 (ISBN)
Description
Each spreadsheet exercise provides a list of objectives, background material, and annotated step by step instructions (Windows and Macintosh) for creating a model on a given topic. Students then examine how various parameters affect model outcomes and, through a set of guided questions, are challenged to develop their model further. In the process, they become proficient with many of the functions available on most spreadsheet programs and learn to write and develop their own macros. This title can be used independently as the basis of a laboratory course, or can supplement a variety of texts. System requirements are Microsoft Excel or other spreadsheet program.
More details
Edition
Annotated edition
Language
English
Place of publication
Sunderland
United States
Target group
College/higher education
Professional and scholarly
Edition type
Annotated edition
Illustrations
graphs, illustrations
Dimensions
Height: 278 mm
Width: 215 mm
Weight
1294 gr
ISBN-13
978-0-87893-156-9 (9780878931569)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Persons
THERESE M. DONOVAN, University of Vermont. - CHARLES W. WELDEN, Southern Oregon University.
Content
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