Brain Teaser #15

This article is one in a series presenting labor and time-saving techniques to accomplish real-world computing tasks. The goal is to stimulate the reader's imagination and to demonstrate creative and highly practical ways of applying computer application program features.

Analyze Research Data


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 File

Bruce Miller, 2008, 2016


More Brain Teasers

Index of IT articles