You can use Excel's FREQUENCY function to create a frequency distribution - a summary table that shows the frequency (count) of each value in a range. FREQUENCY counts how often values occur in a set of data. It returns a vertical array of numbers that represent frequencies.
Notes:
To create a frequency distribution using FREQUENCY: