Build a frequency distribution
IntermediateA frequency distribution tells you how often values fall into each range, which is much more useful than a raw list when you want to understand how a group performed. In this exercise, you will use the FREQUENCY function to bin test scores into standard grade ranges.
FREQUENCY takes two arguments: the data_array (the values you want to count) and the bins_array (the upper boundaries for each group). For each boundary, FREQUENCY counts values that are less than or equal to that boundary and greater than the previous one. It also returns one extra count for values above the last boundary, so N boundaries produce N+1 bins. In modern Excel, FREQUENCY automatically spills its results into adjacent cells.
=FREQUENCY(data_array, bins_array)
Your sheet contains a list of 15 student test scores in A2:A16. The grade range labels are already filled in C2:C6 ("0-59", "60-69", "70-79", "80-89", "90-100").
Your task
Enter one formula in D2 that uses FREQUENCY to count how many scores fall into each grade range. The counts should spill automatically from D2 through D6.
You need to supply a bins_array that contains the upper boundary of each grade range except the last one. Look at the range labels to determine what those boundary values should be. Because FREQUENCY returns one extra count for anything above the highest boundary, the 90-100 range is covered automatically.
Need some help?
Hint 1
The bins_array needs the upper boundary for each grade range, not the range labels themselves. Each label like "0-59" has a boundary value you can extract. You can type your boundaries as a constant array using curly braces, like {val1,val2,...}.
Hint 2
FREQUENCY returns one more count than the number of boundaries you supply. The extra count covers everything above your last boundary, which maps to the highest grade range.
Build a frequency distribution
IntermediateA frequency distribution tells you how often values fall into each range, which is much more useful than a raw list when you want to understand how a group performed. In this exercise, you will use the FREQUENCY function to bin test scores into standard grade ranges.
FREQUENCY takes two arguments: the data_array (the values you want to count) and the bins_array (the upper boundaries for each group). For each boundary, FREQUENCY counts values that are less than or equal to that boundary and greater than the previous one. It also returns one extra count for values above the last boundary, so N boundaries produce N+1 bins. In modern Excel, FREQUENCY automatically spills its results into adjacent cells.
=FREQUENCY(data_array, bins_array)
Your sheet contains a list of 15 student test scores in A2:A16. The grade range labels are already filled in C2:C6 ("0-59", "60-69", "70-79", "80-89", "90-100").
Your task
Enter one formula in D2 that uses FREQUENCY to count how many scores fall into each grade range. The counts should spill automatically from D2 through D6.
You need to supply a bins_array that contains the upper boundary of each grade range except the last one. Look at the range labels to determine what those boundary values should be. Because FREQUENCY returns one extra count for anything above the highest boundary, the 90-100 range is covered automatically.
Need some help?
Hint 1
The bins_array needs the upper boundary for each grade range, not the range labels themselves. Each label like "0-59" has a boundary value you can extract. You can type your boundaries as a constant array using curly braces, like {val1,val2,...}.
Hint 2
FREQUENCY returns one more count than the number of boundaries you supply. The extra count covers everything above your last boundary, which maps to the highest grade range.