FREQUENCY counts how often values occur in a set of data. You can use Excel's FREQUENCY function to create a frequency distribution - a summary table that. Guide to Excel Frequency Distribution. Here we discuss its Formula and how to create Frequency Distribution with examples and downloadable excel template. How to do frequency distribution in Excel. the numbers in the Bins column and the numbers in the Frequency column and created two sets of bars in the chart. Frequdncy learn more, see Excel Training, Coaching, and Consulting. Kyd, all rights reserved. In a corporate company yearly review was done and everyone got a rating out of Let us learn this concept with the help of an example. When you click that link, Excel launches the help topic about the function. Verifiable Certificates.