Home | 18.013A | Chapter 0 | Section 0.2 | | Tools Glossary Index Up Previous Next

Exercise 0.1

Set this all up on your own machine.

Solution:

-3 | =A1+1 | =B1+1 | =C1+1 | =D1+1 | =E1+1
=A1+1 | 0 | | | |
=A2+1 | 1 | | | |
=A3+1 | =B3+B2 | =B5/B4 | | |
=A4+1 | =B4+B3 | =B6/B5 | | |
=A5+1 | =B5+B4 | =B7/B6 | | |
=A6+1 | =B6+B5 | =B8/B7 | | |
=A7+1 | =B7+B6 | =B9/B8 | | |
=A8+1 | =B8+B7 | =B10/B9 | | |
=A9+1 | =B9+B8 | =B11/B10 | | |
=A10+1 | =B10+B9 | =B12/B11 | | |
=A11+1 | =B11+B10 | =B13/B12 | | |
=A12+1 | =B12+B11 | =B14/B13 | | |
=A13+1 | =B13+B12 | =B15/B14 | | |
=A14+1 | =B14+B13 | =B16/B15 | | |
=A15+1 | =B15+B14 | =B17/B16 | | |
=A16+1 | =B16+B15 | =B18/B17 | | |
=A17+1 | =B17+B16 | =B19/B18 | | |
=A18+1 | =B18+B17 | =B20/B19 | | |
=A19+1 | =B19+B18 | =B21/B20 | | |
=A20+1 | =B20+B19 | =B22/B21 | | |
=A21+1 | =B21+B20 | =B23/B22 | | |
=A22+1 | =B22+B21 | =B24/B23 | | |

which becomes

-3 | -2 | -1 | 0 | 1 | 2 | 3 | 4 | 5
-2 | 0 | | | | | | |
-1 | 1 | | | | | | |
0 | 1 | 2 | | | | | |
1 | 2 | 1.5 | | | | | |
2 | 3 | 1.66666667 | | | | | |
3 | 5 | 1.6 | | | | | |
4 | 8 | 1.625 | | | | | |
5 | 13 | 1.61538462 | | | | | |
6 | 21 | 1.61904762 | | | | | |
7 | 34 | 1.61764706 | | | | | |
8 | 55 | 1.61818182 | | | | | |
9 | 89 | 1.61797753 | | | | | |
10 | 144 | 1.61805556 | | | | | |
11 | 233 | 1.61802575 | | | | | |
12 | 377 | 1.61803714 | | | | | |
13 | 610 | 1.61803279 | | | | | |
14 | 987 | 1.61803445 | | | | | |
15 | 1597 | 1.61803381 | | | | | |
16 | 2584 | 1.61803406 | | | | | |
17 | 4181 | 1.61803396 | | | | | |
18 | 6765 | 1.618034 | | | | | |
19 | 10946 | 1.61803399 | | | | | |
20 | 17711 | 1.61803399 | | | | | |

Up Previous Next