A frequency distribution is a statistical representation of the frequency of occurrence of different values in a dataset. In Excel, you can easily create a frequency distribution to summarize and analyze your data.
To create a frequency distribution in Excel, follow these steps: