How to Create a Frequency Distribution with Categorical Data in Excel Using Formulas

This tutorial demonstrates how to create a frequency, relative frequency, and percentage distribution in Excel using Formulas. You can also do this using the Pivot Table tool, that approach is demonstrated in another video tutorial at • Using Pivot Tables For... . This tutorial using the formula approach. When you use formulas the tables will be updated automatically when the source data changes, this is not true for pivot tables. You would have to manually "refresh" the pivot table to update it if the source data is changed.