Using Pivot Tables For Categorical Data in Excel

This tutorial demonstrates how to create a frequency, relative frequency, and percentage distribution in Excel using Pivot Tables. You can also do this using formulas, that approach is demonstrated in another video tutorial at • How to Create a Freque... . This tutorial using the Pivot Table approach. When you use Pivot Tables the frequency distribution will NOT be updated automatically if the source data changes, this is not true for frequencies created using the formula approach. With Pivot Tables you have to manually "refresh" the pivot table to update it if the source data is changed. This video also shows how to create charts from the pivot table.