I have one column of data and I want to graph how common/frequent each number is in a chart. How do I do this? I have thousands of numbers in the column, so I don’t want to have to count them all, even when sorted out (they range from 1-500, and contain almost every number in between).
One way to do this is to use classes in combination with the
FREQUENCY() function (help page) in array form. Create a row of classes (perhaps integers from 1-500) via a simple click-n-drag or basic addition formula. The function can then be used to determine how many occurrences of each datum fall within each class. There are other methods using VLOOKUP() and MATCH() functions in array form.