The mode can have several numbers if there are ties, when a single number is required, what is the correct function to apply?

208 Views Asked by At

The mode can have several numbers if there are ties, what is that best strategy to take a single number - e.g. take the arithmetic mean or median (of the modes)?

Would the geometric mean, harmonic mean, or any other measure of central tendency be a better option?

Note: Excel has a function Mode.Sngl, although the docs doesn't explain how it works mathematically. Even if it did, I'm not sure it is the best option?

For example, the mode of { 0, 11, 22, 44, 100 } is { 11, 22, 44 }. However, this is not useful for some applications, where a single number must be used. Therefore, 22 could be selected, as the median, or 25.67 as the mean, or a different type of average.