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:
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:
Now to employ FREQUENCY. The syntax is:
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):
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.