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: Fraction Combinations
Stage: 3 and 4
Take four numbers say 2, 5, 7, 15.
Use the four numbers to make two fractions, for example: 2/5 and 7/15.
There are 12 ways you could have done that.
For the numbers a, b, c, and d, the value a could go with the b, c, or d.
That's 3 choices. The un-chosen letters then make the other pair without any further choice.
For each of the two pairs there are 2 possibilities, the numbers could be either way up: a/b or b/a.
So 3 . 2 . 2 = 12 arrangements.
Which of these arrangements gives the greatest (or least) sum (or difference)? That's four questions.
Can you generalise, producing a process or strategy that will always identify the combination required for the fractions to be as far apart as possible?
The Excel file
shows the twelve arrangements.
You can experiment with different values for a, b, c, and d.
The combination producing the greatest and least result colour automatically so as to be conspicuous.
When you open the Fraction Combinations file you will see a text box explaining how to change the Excel formula to investigate the difference rather than the sum of the fractions.
Remember for most of the Excel resources it's best to save the file rather than open it directly from the hyperlink.
To do this: right-click the link, choose Save Target As, then select the directory (folder) in which you wish the file to be saved.
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 - 2014. University of Cambridge. All rights reserved.
NRICH is part of the family of activities in the
Millennium Mathematics Project