|
Some spreadsheet ideas
What is the largest number your spreadsheet can display?
(See here for a partial answer.)
Magic grid. Try this trick. Copy out the grid
below. Now put a circle round any number and cross out all the others in the
same row and column. Choose another number that has not been crossed out,
circle it and once again cross out all the others in the same row and column.
Continue until all the numbers are used up. Add up the four numbers you
circled. Do you get 30? How does this work? Use a spreadsheet to create more,
and bigger, magic grids.
| 6 |
5 |
8 |
3 |
| 9 |
8 |
11 |
6 |
| 7 |
6 |
9 |
4 |
| 10 |
9 |
12 |
7 |
Chaos. If you choose a value for the constant c and
an initial value for the variable x, then the following formula will tell you
how to work out the next value of x:
next value = cx(1-x)
This formula can be used over and
over again, to obtain a sequence of numbers. Start with 5 for c and about 0.1
for x and see what you get.
|