Which insert size should go in the default kit? The most frequent request is a better starting point for this question than the average length.
Enter all the sizes in the same unit
Put 8, 10, 10, 12, 12, 12 and 14 in A2:A8, measured in centimeters. In C2 enter:
=MODE.SNGL(A2:A8)The result is 12 cm.

Illustrated frequency chart. Compare measurements recorded in the same unit.
Confirm how often it wins
Count the reported size with:
=COUNTIF(A2:A8,C2)Expect 3. The next most common size, 10 cm, appears twice. If several sizes tie for the highest count, report the tie from a frequency table. If every size appears once, MODE.SNGL has no repeated value to report.

Illustrated verification. Check whether the frequency table has a tie.
For measured lengths with small differences, agree on useful size categories before tallying them.



