How to Make a Frequency Table on Microsoft Excel. A frequency table tabulates the number of times values from a data set appear within a configured range. As an example, you might have a list of ...

In a data table, the first column shows the categories, or options, to choose from. The second column shows how many of that option were counted. This data table shows children's favourite colours.