Back to Blog
![]() For the purpose of this tutorial, suppose you have a small employee data set that contains 20 observations (rows) and three variables (columns): department, gender and age.Ģ. ![]() To create an interactive frequency table in Excel, take the following steps:ġ. If you prefer written instructions, then continue reading. Watch the video below to see how to create an interactive frequency table in Excel. In other Excel versions, there may be some slight differences in the described steps. You can create an interactive frequency table in Excel with the PivotTable tool where you can interactively change the variable by which the data is summarized. Frequency table usually consists of the following three columns: 1) Class – one of the categories into which data can be classified 2) Class frequency – the number of observations in the data set falling into a particular class 3) Relative frequency – the class frequency divided by the total number of observations in the data set, usually expressed as a percentage. It provides frequencies and relative frequencies for data by class. Frequency table is one of the commonly used methods to summarize both qualitative and quantitative data.
0 Comments
Read More
Leave a Reply. |