The role of spreadsheets in an investigation of Fibonacci Numbers

We introduce a function Z(k) which measures the number of distinct ways in which a number can be expressed as the sum of Fibonacci numbers. Using a binary table and other devices, we explore the values that Z(k) can take and reveal a surprising relationship between the values of Z(k) and the Fibonac...

Full description

Bibliographic Details
Main Authors: John E Baker, Steve Sugden
Format: Article
Language:English
Published: McMaster University
Series:Spreadsheets in Education
Online Access:http://sie.scholasticahq.com/article/4618-the-role-of-spreadsheets-in-an-investigation-of-fibonacci-numbers.pdf
_version_ 1797967793443831808
author John E Baker
Steve Sugden
author_facet John E Baker
Steve Sugden
author_sort John E Baker
collection DOAJ
description We introduce a function Z(k) which measures the number of distinct ways in which a number can be expressed as the sum of Fibonacci numbers. Using a binary table and other devices, we explore the values that Z(k) can take and reveal a surprising relationship between the values of Z(k) and the Fibonacci numbers from which they were derived. The article shows the way in which standard spreadsheet functionalities makes it possible to reveal quite striking patterns in data.
first_indexed 2024-04-11T02:36:46Z
format Article
id doaj.art-72da1acf51744b4d872af26181db7355
institution Directory Open Access Journal
issn 1448-6156
language English
last_indexed 2024-04-11T02:36:46Z
publisher McMaster University
record_format Article
series Spreadsheets in Education
spelling doaj.art-72da1acf51744b4d872af26181db73552023-01-02T19:51:57ZengMcMaster UniversitySpreadsheets in Education1448-6156The role of spreadsheets in an investigation of Fibonacci NumbersJohn E BakerSteve SugdenWe introduce a function Z(k) which measures the number of distinct ways in which a number can be expressed as the sum of Fibonacci numbers. Using a binary table and other devices, we explore the values that Z(k) can take and reveal a surprising relationship between the values of Z(k) and the Fibonacci numbers from which they were derived. The article shows the way in which standard spreadsheet functionalities makes it possible to reveal quite striking patterns in data.http://sie.scholasticahq.com/article/4618-the-role-of-spreadsheets-in-an-investigation-of-fibonacci-numbers.pdf
spellingShingle John E Baker
Steve Sugden
The role of spreadsheets in an investigation of Fibonacci Numbers
Spreadsheets in Education
title The role of spreadsheets in an investigation of Fibonacci Numbers
title_full The role of spreadsheets in an investigation of Fibonacci Numbers
title_fullStr The role of spreadsheets in an investigation of Fibonacci Numbers
title_full_unstemmed The role of spreadsheets in an investigation of Fibonacci Numbers
title_short The role of spreadsheets in an investigation of Fibonacci Numbers
title_sort role of spreadsheets in an investigation of fibonacci numbers
url http://sie.scholasticahq.com/article/4618-the-role-of-spreadsheets-in-an-investigation-of-fibonacci-numbers.pdf
work_keys_str_mv AT johnebaker theroleofspreadsheetsinaninvestigationoffibonaccinumbers
AT stevesugden theroleofspreadsheetsinaninvestigationoffibonaccinumbers
AT johnebaker roleofspreadsheetsinaninvestigationoffibonaccinumbers
AT stevesugden roleofspreadsheetsinaninvestigationoffibonaccinumbers