IT Logo Top Hermit's Free Library  Brain Teasers

Finding multiple modes in the same data using MS-Excel.

Brain Teaser #15: Analyze Research Data

Task

You're carrying out research to determine the effect of talking on a cell phone on the reaction times of subjects. You have collected your data and now you want to analyze it.

You know how to find which number came up most frequently in your results, i.e. the mode. However, you are interested in knowing the first eight most common results, not just the most common.

Determining this manually would be tedious and require extreme care to avoid errors. How can you get these results quickly and accurately?

As a bonus, how could you get a count for each of the first eight most common results?

Data

Data File