Spreadsheet
in Mathematics
(Assignment 12)
by
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!