Teaching the Logistic Growth Difference Equation Using Spreadsheets

The logistic growth difference equation is often used in biology to model population growth. The terms that satisfy the difference equation have many remarkable mathematical properties such as exhibiting chaotic behavior. Using spreadsheet modeling tools, the properties of logistic growth can be inv...

Full description

Bibliographic Details
Main Authors: Fred J Rispoli, Jeffrey Feuer, Richard Wilkens
Format: Article
Language:English
Published: McMaster University
Series:Spreadsheets in Education
Online Access:http://sie.scholasticahq.com/article/4558-teaching-the-logistic-growth-difference-equation-using-spreadsheets.pdf
_version_ 1797970203000176640
author Fred J Rispoli
Jeffrey Feuer
Richard Wilkens
author_facet Fred J Rispoli
Jeffrey Feuer
Richard Wilkens
author_sort Fred J Rispoli
collection DOAJ
description The logistic growth difference equation is often used in biology to model population growth. The terms that satisfy the difference equation have many remarkable mathematical properties such as exhibiting chaotic behavior. Using spreadsheet modeling tools, the properties of logistic growth can be investigated by students in a user friendly environment. Students will learn about useful computational and modeling tools, while also learning about a new area of mathematics that has fascinated many (e.g. James Gleick’s Chaos: Making a New Science is a national best seller). Moreover, the model has many real world applications in biology. Unfortunately, many mathematics and computer science students do not see the logistic growth model because it does not appear in the standard set of required courses. In this paper we describe a how to implement the logistic growth model, and describe related applications and student exercises.
first_indexed 2024-04-11T03:14:13Z
format Article
id doaj.art-c3c5fbda560042648d2aec9d95591c8e
institution Directory Open Access Journal
issn 1448-6156
language English
last_indexed 2024-04-11T03:14:13Z
publisher McMaster University
record_format Article
series Spreadsheets in Education
spelling doaj.art-c3c5fbda560042648d2aec9d95591c8e2023-01-02T10:55:12ZengMcMaster UniversitySpreadsheets in Education1448-6156Teaching the Logistic Growth Difference Equation Using SpreadsheetsFred J RispoliJeffrey FeuerRichard WilkensThe logistic growth difference equation is often used in biology to model population growth. The terms that satisfy the difference equation have many remarkable mathematical properties such as exhibiting chaotic behavior. Using spreadsheet modeling tools, the properties of logistic growth can be investigated by students in a user friendly environment. Students will learn about useful computational and modeling tools, while also learning about a new area of mathematics that has fascinated many (e.g. James Gleick’s Chaos: Making a New Science is a national best seller). Moreover, the model has many real world applications in biology. Unfortunately, many mathematics and computer science students do not see the logistic growth model because it does not appear in the standard set of required courses. In this paper we describe a how to implement the logistic growth model, and describe related applications and student exercises.http://sie.scholasticahq.com/article/4558-teaching-the-logistic-growth-difference-equation-using-spreadsheets.pdf
spellingShingle Fred J Rispoli
Jeffrey Feuer
Richard Wilkens
Teaching the Logistic Growth Difference Equation Using Spreadsheets
Spreadsheets in Education
title Teaching the Logistic Growth Difference Equation Using Spreadsheets
title_full Teaching the Logistic Growth Difference Equation Using Spreadsheets
title_fullStr Teaching the Logistic Growth Difference Equation Using Spreadsheets
title_full_unstemmed Teaching the Logistic Growth Difference Equation Using Spreadsheets
title_short Teaching the Logistic Growth Difference Equation Using Spreadsheets
title_sort teaching the logistic growth difference equation using spreadsheets
url http://sie.scholasticahq.com/article/4558-teaching-the-logistic-growth-difference-equation-using-spreadsheets.pdf
work_keys_str_mv AT fredjrispoli teachingthelogisticgrowthdifferenceequationusingspreadsheets
AT jeffreyfeuer teachingthelogisticgrowthdifferenceequationusingspreadsheets
AT richardwilkens teachingthelogisticgrowthdifferenceequationusingspreadsheets