Danie Brink

SPREADSHEET INVESTIGATIONS - THE GOLDEN RATIO

A spreadsheet has many uses. Some of these uses include ...

1. To graph a table of x and y values.

2. To do probability exercises like roling a die or flipping a coin.

3. To do basic statistical calculations like averages and standard deviations on a set of data.

In this exercise we are going to look at the Fibonacci Numbers and the Golden Ratio.

 In an Excel spreadsheet we enter the Fibonacci Numbers into column A. This is done by placing a 1 in cell A1 and in A2. In A3 we write the formula =A1+A2 and copy this formula downwards.

 In column B, I let Excel calculate the ratio of consecutive numbers in column A. For example, in B1 I write =A2/A1. Then I copy this formula downwards. Conclusion: What we see appearing in column B is the Golden Ratio.

 If we change the sequence to something other than the Fibonacci Numbers, like the Lucas Sequence the result remains the same.

To see another way to get to the Golden Ratio by means of an Excel spreadsheet, click here.

Back to my Main Page