Skip to main content
 

Making It Fit

Using Excel to Analyze Biological Systems

By Robert Leaf, Brian R. Murphy

Making It Fit


 

Abstract

In this case, students read about a biologist who needs to determine how to analyze age-at-length data, a common situation in fisheries biology. The fictional Dr. Latimer is tasked with fitting non-linear models to the data, and the case develops as he draws parallels between linear and non-linear models. After learning the terminology and concepts through a series of exercises, students use Excel's built-in Solver algorithm to fit models to the data. Intended for use in a fisheries biology, ecology, or management class, the case is targeted to junior and senior level undergraduate students who have some experience using spreadsheets on microcomputers and some knowledge of ichthyology.

   

Date Posted

09/11/2009

Overview

Objectives

  • Understand the similarities of non-linear and simple linear regression.
  • Appreciate the importance of non-linear regression to describe natural phenomena.
  • Learn how to use the "Solver" algorithm in Microsoft Excel.
  • Become familiar with basic computer programming in Microsoft Excel.
  • Understand fish growth and gain exposure to the most commonly used model to describe it<./li>

Keywords

Fisheries management; ichthyology; yellow tang; Zebrasoma flavescens; fish; fish growth; age determination; von Bertalanffy growth function; non-linear regression; Microsoft Excel; Hawaii

  

Subject Headings

Biology (General)
Ecology
Natural Resource Management
Wildlife Management

EDUCATIONAL LEVEL

Undergraduate upper division

  

FORMAT

PDF

   

TOPICAL AREAS

Scientific method

   

LANGUAGE

English

   

TYPE/METHODS

Discussion, Interrupted

 

 

Asset 2