Write up #12

The Spreadsheet in Mathrmatics Explorations

by Kaori Tabeta

Fibonnaci sequence

Generate a Fibonnaci sequence in the first colum using f(0)=1, f(1)=1,

f(n)=f(n-1)+f(n-2)

Click here for Excel file. The graph of Fibonnaci sequence is as following;

Limit of the ratio of every n term

Let's try to construct the ratio of adjacent terms in the Fibonnaci sequence using above Excel file! What happen as n increases ? What about the ratio of every second time ?

Click here.

In the case of f(0)=a, f(1)=b

Explore sequences where f(0) and f(1) are same aritray integers other than 1. Click here.

Return