Return

 

Write-up 7:

Use a spreadsheet, such as EXCEL, WINGS, or Claris Works, to explore the following:

Generate a Fibonnaci sequence in the first column usign f(0)=1 and f(1)=1, f(n)=f(n-1) + f(n-2).

A. Construct the ratio of each pair of adjacent terms in the Fibonnaci sequence. What happens as n increases? What about the ratio of every second term? etc.

B. Explore sequences where f(0) and f(1) are some arbitrary integers other than 1. If f(0)=1 and f(1)=3, then your sequence is a Lucas Sequence. All such sequences, however, have the same limit of the ratio of successive terms.

Explorations in EXCEL