Did you know that a school results sheet can correctly show two pupils in first place followed by somebody in third place—with nobody in second? A learner may think the spreadsheet has skipped a pupil. Often it has not. The rank labels reflect how the organiser counts positions after a tie.
A tied ranking occurs when two or more people or results have the same score under the chosen comparison rule. In competition ranking, tied participants share a place and later rank numbers skip positions already occupied; for scores 96, 96, 89 the ranks are 1, 1, 3. In dense ranking, equal scores still share a rank but the next distinct score takes the next number, giving 1, 1, 2. Both conventions can describe the same results. The rule, not a guess about the rank numbers, determines the answer.
Start by asking what the ranking measures
A rank places results in an order. But rank is not the underlying score, and an ordinal position is not always a unique person. Before interpreting a school table, identify the comparison value—marks, time, distance, number of tasks completed, or another defined measure—and which direction counts as better. High Mathematics marks might be better; low race completion times might be better. A tie depends on equality in that comparison measure.
Do not assume a league table always follows one convention. An event organiser may use competition ranks for medals, a classroom learning app may use dense ranks for distinct score bands, and another report may need a separate rule for breaking ties. Unless the convention is specified, the ranks and how many people qualify for an award can be ambiguous.
A complete fictional worked example
Imagine six pupils participating in a made-up quiz, not a real school examination or an official ranking. Arrange their marks in descending order: Asha 96, Ben 96, Clara 89, Dev 84, Erin 84 and Faye 79 marks. The full dataset is 96, 96, 89, 84, 84, 79 out of a hypothetical 100.
Two pupils share the highest score, so they tie. One pupil has 89, followed by two pupils tied at 84 and then one with 79. None of these scores is missing or estimated. We will calculate rankings from this one set of data using two different rules to show exactly which part of the interpretation changes.
Method A: competition ranking
- Asha, 96 marks: rank 1; nobody has a higher mark.
- Ben, 96 marks: rank 1; nobody has a higher mark.
- Clara, 89 marks: rank 3; two pupils have higher marks.
- Dev and Erin, 84 marks: rank 4 each; three pupils have higher marks.
- Faye, 79 marks: rank 6; five pupils have higher marks.
- The complete rank sequence is 1, 1, 3, 4, 4, 6.
The exact rule is beautifully simple: competition rank = 1 + the number of participants with a strictly better score. Clara’s rank is 1 + 2 = 3. Faye’s rank is 1 + 5 = 6. The two rank-1 pupils occupy the first two ordered positions, so the next best pupil starts at position three. There is no unique participant at second place under this convention.
Method B: dense ranking
- The highest distinct score, 96, is dense rank 1 for Asha and Ben.
- The next distinct score, 89, is dense rank 2 for Clara.
- The next distinct score, 84, is dense rank 3 for Dev and Erin.
- The last distinct score, 79, is dense rank 4 for Faye.
- The complete dense-rank sequence is 1, 1, 2, 3, 3, 4.
Here the rule is: dense rank = 1 + the number of distinct strictly better scores. There is one distinct higher score than 89, namely 96, so Clara is dense rank 2. There are three distinct scores above 79—96, 89 and 84—so Faye is dense rank 4. This does not award Clara a silver medal or assert that only two pupils scored better. It is a different numbering of distinct score levels.
Why the two rules produce different answers
In competition ranking, ties take up several positions in an ordered list of people. In dense ranking, ties share one of the distinct score levels, and score levels are numbered consecutively. The difference is not an argument about whether Asha or Ben worked harder. Both have the same recorded score. The difference is what is being counted to reach the next rank number.
A useful analogy is a line of six labelled boxes sorted by marks. Two names fill boxes one and two with the same value. The next person goes in box three. That visualises competition ranking. Now instead make one box for each distinct mark: 96, 89, 84 and 79. There are four boxes, and everyone with the same value points to the same box. That visualises dense ranking.
Don’t insert a second-place pupil just because you expected one
Suppose a poster prints “1st: Asha and Ben; 3rd: Clara”. A pupil might revise it to “1st: Asha; 2nd: Ben; 3rd: Clara” simply to eliminate the numerical gap. That silently breaks the tie and invents an ordering the scores do not justify. Unless the organisers have a legitimate published tie-breaker, Asha and Ben are equal on the recorded comparison variable.
The inverse error is to look at the dense sequence 1, 1, 2, 3, 3, 4 and infer that only one child scored above Clara because Clara is numbered second. In this particular case two pupils scored higher than she did. Dense rank describes the level among distinct score values, not the count of individuals ahead.
How computer spreadsheets and databases define ranking
The official PostgreSQL documentation on window functions distinguishes rank, which leaves gaps after peer groups, from dense_rank, which does not. This is a useful independently documented example of the two mathematical conventions. It does not mean that a school event must adopt PostgreSQL or that every sports rule uses the same system.
The same documentation identifies row_number as a count of successive rows. A row number such as 1, 2, 3, 4, 5, 6 is not automatically a fair attainment rank for tied marks. If two students have 96, assigning the first a superior place solely because the table happens to list that name earlier confuses display order with evaluated performance.
In a spreadsheet, an ordinary rank function may behave like competition ranking, but software versions and functions differ. Check the actual formula, selected range, sort direction and treatment of equal values. If the file uses a custom tie-breaker, document it. The correct interpretation follows the file’s defined rule and the evaluation context.
What does a tie mean when awards are limited?
Suppose the notice says “recognise the top three individual pupils”. With our illustrative marks, there are two pupils tied for first and one pupil with the next score, 89. All three are among the top three individuals in a list sorted by score. Under competition ranking their displayed rank labels are 1, 1 and 3.
Now consider a different instruction: “recognise pupils in the top three distinct score bands.” Under dense ranking, those bands are 96, 89 and 84, so five pupils belong to them: Asha, Ben, Clara, Dev and Erin. The two instructions select different groups because “top three people” is not the same as “top three distinct scores”. Neither selection should be guessed from the raw labels without the award rule.
A real event may use published tie-breakers or fixed numbers of prizes. If the notice does not explain how ties affect awards, ask the organiser rather than promise an award to an extra child. An unexplained rank number is not enough to infer a particular school’s medal policy.
A diagnostic that reveals what the student has confused
Show only these four hypothetical marks in descending order: 90, 90, 85, 80. Ask for the rank of the 85 scorer under competition ranking and under dense ranking. A student who answers 2 to both may be counting distinct score levels without knowing that competition ranks skip an occupied position. The correct answers are competition rank 3 and dense rank 2.
Next ask how many pupils actually performed better than the 85 scorer. The answer is two people, whichever ranking convention is used. This extra question distinguishes understanding the data from memorising a rank sequence. If the learner struggles, draw one dot per pupil and group equal-valued dots.
Guided practice: from ordered scores to trustworthy rank labels
- First, name the comparator. High marks are better here. For a timed race, check whether lower time is better instead.
- Second, sort but preserve ties. Put equal scores together instead of arbitrarily ordering one pupil above another.
- Third, count people ahead. Add one to get a competition rank.
- Fourth, count distinct higher values. Add one to get a dense rank.
- Fifth, explain in words. Say “rank 3 because two people scored higher” or “dense rank 2 because one different score level is higher”.
- Finally, transfer. Remove the model, change the scores, and ask the learner to justify an unfamiliar rank list.
The learner should be able to spot a rank mismatch when a table shows 1, 1, 2 but claims to use competition ranking. Conversely, 1, 1, 3 is not an error merely because the integer 2 is absent. A useful progress indicator is the ability to identify the declared convention before deciding whether the labels are accurate.
Independent practice with complete answers
Task 1. Five fictional students score 18, 18, 15, 15 and 12 out of 20. Find the competition ranks. Answer: 1, 1, 3, 3, 5. The two pupils scoring 15 have two people above them, and the pupil scoring 12 has four.
Task 2. Use the same five marks but calculate dense ranks. Answer: 1, 1, 2, 2, 3, because there are three distinct score values: 18, 15 and 12.
Task 3. Five timed runners finish in 11.0, 11.0, 11.4, 12.2 and 12.2 seconds. Lower time is better. Under competition ranking, what is the rank of a runner finishing in 12.2 seconds? Answer: rank 4, because three runners finish faster. The two 12.2-second runners tie at rank 4.
Task 4. A poster gives two tied first-place pupils separate numerical ranks solely by alphabetical surname. Does this reflect a difference in marks? Answer: no. Alphabetical order may organise a printed list but does not alter equal scores. If the competition uses alphabetical order as an explicit prize tie-breaker, that separate rule must be identified rather than mistaken for a scoring difference.
The role of rounding and measurement precision
A tie can be genuine in the reported measurement and still require interpretation. A school might display integer marks or a race might display times rounded to tenths of a second. Two displayed results can be equal even if underlying unrounded observations differ. Do not invent extra precision or unreported values to force a winner.
Conversely, if the rules specify a recorded precision and regard equal official values as ties, an observer should not apply their own spreadsheet’s hidden decimals to create an unofficial result. The rule and the valid source record are part of the evidence. Schoolwork becomes more trustworthy when students distinguish reported values from assumptions about what the equipment or marking process might have measured.
What parents and teachers should watch for
Ask children to explain a gap in a rank list without saying only “because someone tied”. Can they count how many people scored better? Can they count the different higher scores? Can they switch correctly between competition and dense rules? Try a fresh example days later with a tie in the middle rather than at the top. That transfer reveals whether they understand the mechanism.
A parent can help without intensifying comparison between classmates: give imaginary sports times or puzzle scores, ask the pupil to sort, name the convention and justify every rank. The practical lesson is about evidence, transparent rules and fairness—not attaching a permanent label to a child’s ability or worth.
Limitations and cautions
No single ranking convention governs all competitions, school assessments or statistical reports. Some use average ranks, fixed tie-breakers, score thresholds, percentiles or other calculations. A rank alone also hides score differences: the pupil ranked first may be one mark or twenty marks above the next distinct score. A fair interpretation should inspect the underlying measures and avoid assuming the entire story is contained in one integer.
Rank also depends on which group is included. First among six pupils does not have the same denominator as first among sixty. If absent pupils, invalid entries or disqualifications change the comparison set, the ranking may change without any individual score changing. Record scope, rule and date when making a consequential decision.
Frequently asked questions
Why is there sometimes no second place after two first places?
Under competition ranking, two people share position one, occupying the first two ordered slots. The next person therefore receives position three. In dense ranking the next distinct score instead receives rank two.
Is dense rank less fair than competition rank?
Neither method is inherently the only fair method. They answer different numbering questions. Fairness depends on a transparent rule chosen for the actual purpose and applied consistently.
Can three children all be ranked first?
Yes, if their results tie for the best under the applicable measure and the event recognises ties. Under competition ranking, the next person would be fourth, not second.
Does rank 3 guarantee that exactly two people have better scores?
Under ordinary competition ranking with no other conditions, yes: rank is one plus the number of strictly better participants. Under dense ranking, rank 3 means two distinct score levels are better, possibly shared by many people.
Where to continue the learning
The distinction between a result and its summary connects with classes with the same mean but different spreads and choosing the right denominator in a two-way table. The Secondary Mathematics data-comparison specialist reference and eduKate Education Hub offer wider reading.
Our Secondary 1 Mathematics tutorial reference starts with diagnosis and careful explanations, then builds practice towards independent checks. The same sequence works with tied ranks: find the mistaken assumption, work through people and score levels separately, and test whether the learner can recognise both systems later.
A good ranking reader does more than locate a name beside a number. They can explain exactly what the number counts, which rule produced it, and what further evidence would be needed before making a fair decision.