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...
Main Authors: | , , |
---|---|
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 |