Skip over navigation
Guide and features
Guide and features
Science, Technology, Engineering and Mathematics
Featured Early Years Foundation Stage; US Kindergarten
Featured UK Key Stage 1&2; US Grades 1-4
Featured UK Key Stage 3-5; US Grades 5-12
Featured UK Key Stage 1, US Grade 1 & 2
Featured UK Key Stage 2; US Grade 3 & 4
Featured UK Key Stages 3 & 4; US Grade 5-10
Featured UK Key Stage 4 & 5; US Grade 11 & 12
Excel Investigation: Difference Tuples
Stage: 3 and 4
This is based on the activity
Here's the Excel file I created:
. I usually right-click, "Save Target As", and select where I want the file to be saved.
You can see the given start numbers 100, 2, 37, 59 in the first row.
Here are the formulae I used (you can see these in the formula bar when you click on each cell).
ABS calculates the positive difference.
Under 100, =ABS(A2-B2) this compares 100 with 2
Under 2, =ABS(B2-C2) this compares 2 with 37
Under 37, =ABS(C2-D2) this compares 37 with 59
Under 59, =ABS(D2-A2) this compares 59 with 100, right back at the beginning.
Once I had all four formulae in and working correctly I highlighted these four cells (A3 to D3). I then caught hold of the extreme, bottom, right-hand corner of the highlighted area (the normal white cross changes to a small thin black one), and I dragged down as far as I wanted those formulae to be replicated. Excel created new formulae which do the same job as the formulae in the top line, but automatically adjusted the cell references so that they would be correct for the new position.
Isn't it nice when you get answers that quickly? It leaves time to ask more interesting questions.
Which set of start numbers gives the longest run before becoming 0 0 0 0?
How is the 4-number problem like a pair of 2-number problems running side by side? How is it different? How is the 8-number problem like a pair of 4-number problems running side by side? How is it different?
Have I missed anything? Oh yes, the increment buttons:
So that I could change the start numbers quickly, and without typing, I put in some scroll bars to control the values in the first row. Look back at
to find out about increment buttons. They're very easy and let you keep your eye on the numbers instead of the keyboard.
Meet the team
The NRICH Project aims to enrich the mathematical experiences of all learners. To support this aim, members of the NRICH team work in a wide range of capacities, including providing professional development for teachers wishing to embed rich mathematical tasks into everyday classroom practice. More information on many of our other activities can be found here.
Register for our mailing list
Copyright © 1997 - 2012. University of Cambridge. All rights reserved.
NRICH is part of the family of activities in the
Millennium Mathematics Project