For example, if you want to show a frequency distribution for every 10 units you would need to define that for Excel. The Frequency function refers to this limit as the "Bin Array." ...

In the example, you might enter "20," "40," "60," "80" and "100" in cells B1 through B5 to find the frequency distribution of scores in ranges of 20 points each.

Establishing a frequency distribution of each sample Mapping out the distribution on a graph Once the information is gathered, plotted, and analyzed, researchers can make inferences and conclusions.