Analyze Google Sheets Data using FREQUENCY

On many occasions, such as grading exam papers, you need to analyze some data based on classes, i.e. ranges of values.

Let’s say, for example, you have the following scores from a class test:

Click image to enlarge

Click image to enlarge

You want to decide where to place your grading boundaries. To do so, let’s analyze the data using some provisional grading boundaries: less than 40, 40-49, 50-59, 60-69, 70 and over:

Click image to enlarge

Click image to enlarge

Now to employ FREQUENCY. The syntax is:

FREQUENCY(data, classes)

Parameter data is the array or range containing the values to be counted, while classes is the array or range containing, unsurprisingly, the set of classes. FREQUENCY will return a vertical range, the size of which will be one greater than classes as the last value in the list is the number of elements in data with a value greater than any of the class boundaries (in our example, 70 or greater):

Click image to enlarge

Click image to enlarge

So we can see that, using these boundaries for our classes, two students scored <40, three scored 40-49, three more scored 50-59, 5 students scored 60-69 and finally three students scored 70 or over.