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

Exercise 0.6

Set this up on your own machine.

Solution:

=-2 | =A1+1 | =B1+1 | =C1+1 | =D1+1 | =E1+1 | =F1+1
=A1+1 | 1 | | | | |
=A2+1 | | =C2*C$1+B2 | =D2*D$1+C2 | =E2*E$1+D2 | =F2*F$1+E2 | =G2*G$1+F2
=A3+1 | | =C3*C$1+B3 | =D3*D$1+C3 | =E3*E$1+D3 | =F3*F$1+E3 | =G3*G$1+F3
=A4+1 | | =C4*C$1+B4 | =D4*D$1+C4 | =E4*E$1+D4 | =F4*F$1+E4 | =G4*G$1+F4
=A5+1 | | =C5*C$1+B5 | =D5*D$1+C5 | =E5*E$1+D5 | =F5*F$1+E5 | =G5*G$1+F5
=A6+1 | | =C6*C$1+B6 | =D6*D$1+C6 | =E6*E$1+D6 | =F6*F$1+E6 | =G6*G$1+F6
=A7+1 | | =C7*C$1+B7 | =D7*D$1+C7 | =E7*E$1+D7 | =F7*F$1+E7 | =G7*G$1+F7
=A8+1 | | =C8*C$1+B8 | =D8*D$1+C8 | =E8*E$1+D8 | =F8*F$1+E8 | =G8*G$1+F8
=A9+1 | | =C9*C$1+B9 | =D9*D$1+C9 | =E9*E$1+D9 | =F9*F$1+E9 | =G9*G$1+F9
=A10+1 | | =C10*C$1+B10 | =D10*D$1+C10 | =E10*E$1+D10 | =F10*F$1+E10 | =G10*G$1+F10
=A11+1 | | =C11*C$1+B11 | =D11*D$1+C11 | =E11*E$1+D11 | =F11*F$1+E11 | =G11*G$1+F11
=A12+1 | | =C12*C$1+B12 | =D12*D$1+C12 | =E12*E$1+D12 | =F12*F$1+E12 | =G12*G$1+F12
=A13+1 | | =C13*C$1+B13 | =D13*D$1+C13 | =E13*E$1+D13 | =F13*F$1+E13 | =G13*G$1+F13
=A14+1 | | =C14*C$1+B14 | =D14*D$1+C14 | =E14*E$1+D14 | =F14*F$1+E14 | =G14*G$1+F14
=A15+1 | | =C15*C$1+B15 | =D15*D$1+C15 | =E15*E$1+D15 | =F15*F$1+E15 | =G15*G$1+F15
=A16+1 | | =C16*C$1+B16 | =D16*D$1+C16 | =E16*E$1+D16 | =F16*F$1+E16 | =G16*G$1+F16
=A17+1 | | =C17*C$1+B17 | =D17*D$1+C17 | =E17*E$1+D17 | =F17*F$1+E17 | =G17*G$1+F17
=A18+1 | | =C18*C$1+B18 | =D18*D$1+C18 | =E18*E$1+D18 | =F18*F$1+E18 | =G18*G$1+F18
=A19+1 | | =C19*C$1+B19 | =D19*D$1+C19 | =E19*E$1+D19 | =F19*F$1+E19 | =G19*G$1+F19
=A20+1 | | =C20*C$1+B20 | =D20*D$1+C20 | =E20*E$1+D20 | =F20*F$1+E20 | =G20*G$1+F20
| | =C21*C$1+B21 | =D21*D$1+C21 | =E21*E$1+D21 | =F21*F$1+E21 | =G21*G$1+F21

which becomes

-2 | -1 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7
-1 | 1 | | | | | | | |
0 | | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1 | | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
2 | | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
3 | | 0 | 1 | 3 | 1 | 0 | 0 | 0 | 0
4 | | 0 | 1 | 7 | 6 | 1 | 0 | 0 | 0
5 | | 0 | 1 | 15 | 25 | 10 | 1 | 0 | 0
6 | | 0 | 1 | 31 | 90 | 65 | 15 | 1 | 0
7 | | 0 | 1 | 63 | 301 | 350 | 140 | 21 | 1
8 | | 0 | 1 | 127 | 966 | 1701 | 1050 | 266 | 28
9 | | 0 | 1 | 255 | 3025 | 7770 | 6951 | 2646 | 462
10 | | 0 | 1 | 511 | 9330 | 34105 | 42525 | 22827 | 5880
11 | | 0 | 1 | 1023 | 28501 | 145750 | 246730 | 179487 | 63987
12 | | 0 | 1 | 2047 | 86526 | 611501 | 1379400 | 1323652 | 627396
13 | | 0 | 1 | 4095 | 261625 | 3E+06 | 7508501 | 9321312 | 5715424
14 | | 0 | 1 | 8191 | 788970 | 1E+07 | 40075035 | 63436373 | 49329280
15 | | 0 | 1 | 16383 | 2E+06 | 4E+07 | 2.11E+08 | 4.21E+08 | 408741333
16 | | 0 | 1 | 32767 | 7E+06 | 2E+08 | 1.1E+09 | 2.73E+09 | 3281882604
17 | | 0 | 1 | 65535 | 2E+07 | 7E+08 | 5.65E+09 | 1.75E+10 | 25708104786
18 | | 0 | 1 | 131071 | 6E+07 | 3E+09 | 2.9E+10 | 1.11E+11 | 1.97462E+11
19 | | 0 | 1 | 262143 | 2E+08 | 1E+10 | 1.48E+11 | 6.93E+11 | 1.49292E+12

Up Previous Next