Create a single new Excel file; all Excel problems of this assignment should be contained in this single

file. Complete each problem on its own sheet in this one file. Label each sheet as Problem 1, etc.

Complete all of your work near the top left region of the sheet, so it is easy to find. Please enter your

first and last name uid, assignment name, and discussion section id in cells A1:A3 on each sheet.

Be sure to format all plots and tables nicely, so that they are easy to read. Label your plot axes and table

columns, use titles and legends where necessary, and minimize clutter and wasted white space on plots.

1. (5 pts.) We wish to calculate the golden ratio using Fibonaccis Sequence. See:

https://en.wikipedia.org/wiki/Golden_ratio

https://en.wikipedia.org/wiki/Fibonacci_number

To do this:

a) In Cell A5 put a zero

b) Then fill cells A6:A25 with the integers 1 to 20 using an equation that can be copied to create

all the numbers in sequence (do not simply type out each number, 1, 2, 3, 4, and so on).

c) Next to the integers in Column A, generate the first 21 terms of the Fibonacci Sequence in

Column B, starting with the values 1, 1.

d) In Cell D1, calculate the true Golden Ratio. To ensure its accuracy, this calculation should be

implemented as an equation within the cell, and not as a decimal approximation. See the wiki

article for the correct equation. Highlight this value with a yellow background.

e) The ratio of consecutive numbers in the Fibonacci Sequence should approach the Golden

Ratio. In Column C, calculate the ratio of each consecutive pair in Column B.

f) In Column E calculate the difference between the approximate values in Column C and the

true Golden Ratio, using an absolute reference to Cell D1.

g) Plot this difference versus the data point number (1 to 20) just to the right of the data.

h) On a separate plot below the first, plot the log of the absolute value of this same difference.

i) Add a linear trend line to this plot.

j) If we wanted to obtain

the Golden Ratio out to

20 digits of accuracy,

how many terms of the

Fibonacci sequence

would be needed?

Estimate this value

using your trendline

and show your answer

in the cell E1,

highlighted in magenta.