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

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




Bruce Miller, 2008, 2016

Solution

More Brain Teasers

Index of IT articles

Home