Spreadsheet in Mathematics

(Assignment 12)

by

 Cara Haskins, Matt Tumlin, and Robin Kirkham

 

The spreadsheet is a utility that is useful for data analysis for a variety of mathematics. There are many different explorations that would show useful when working with a spreadsheet such as EXCEL.

 

The spreadsheet is merely a tool that provides a fast and easy exploration of large amounts of data and in constructing the data through the use of an equation.

 

This tool proves to be useful in the classroom when showing quick demonstrations without all the labor required to build the tables by hand.

 

Let us examine a simple sequence of numbers chosen at random and entered into a spreadsheet such that each successive row is replaced by a new entry that is figure as follows:

 

absolute value of A- B column 1

absolute value of B- C column 2

absolute value of C- D column 3

absolute value of D- A column 4

 

Will the process lead to all zeros in all 4 columns?

 

Example 1:

 

 

Example 2:

 

 

In the above 2 examples, it appears that given a sequence of numbers in A, B, C, & D the series turns to zeros prior to row 10.

 

What is the largest number of rows that you found before hitting zero?  After much playing around, the most we found was 13.  

 

 

To examine yourself, CLICK HERE!

 

When the number of columns is increased the sequence continues on, how many iterations can be run before the sequence zeros out?

 

To examine yourself, CLICK HERE!

 

 

Return to Cara’s Homepage