The grouped frequency table is a statistic method to organize and simplify a large set of data in to smaller "groups." When a data consists of hundreds of values, it is preferable to group them in a smaller chunks to make it more understandable. When grouped frequency table is created, scientists and statistician can observe interesting trends in the data.
The main purpose of the grouped frequency table is to find out how often each value occurred within each group of the entire data. The group frequency distribution is essentially a table with two columns. The first column titled "Groups" represents all possible "grouping" of the data and the second column titled "Frequency" represents how frequent each value occurred within each group.
Collect the data by writing it on a piece of paper. For example, let's say we have data that consists of following 12 values: 16, 17, 18, 19, 10, 11, 13, 14, 17, 11, 12 and 15.
Rearrange the data so that it starts with the smallest number and ends with the highest number. In this example, this data will be rearranged as follows: 10,11,11,12,13,14,15,16,17,17,18 and 19.
Find the highest and lowest value and deduct lowest value from the highest value. In this example, we will deduct lowest value of "10" from the highest value of "19". Result is 19-10 = 9.
Determine the number of groups. Most of the data has between five to 10 groups. It is your decision to choose the number of groups for your data. In this example, since we have only 12 values, we will choose a total of five groups.
Determine the width of group interval. Width simply means number of values per group. The width of group is obtained by dividing Step 3 by Step 4. In this example, divided "9" by "5." The result is 1.8 or 9/5 = 1.8. Round up 1.8 to 2. With this step we determined that there will be only two values per group.
Create two columns. Title first column as "Groups." The first column represents all five groups of your data. Title second column as "Frequency." The second column represents "how frequent" each value occurred per group.
Create all five groups for the first column of groups. Since the width of each group is "2," in our example, the first group will be 10-11. This first group has two values; first value is 10 and second value is 11. Continue to create all five groups. All five groups will be as follows:
Determine the frequencies for all five groups by tallying the data. In our example, first group is 10-11, tally and see how many values fall under this group. You can see that under the first group of 10-11, three values (10,11,11) fall in. You will write three under the "Frequency Column." Continue to tally for the remaining four groups. After you complete all five groups and tally its frequencies, your frequency table is complete.
Final Table will look like this:
Tips & Warnings
- Rearranging the data in Step 2 will make it easy to create a distribution table. Always rearrange the data. You can use an Excel spreadsheet to rearrange the data by first entering the random data and then clicking on the "Sort Ascending" button.
- Statistics Alive; Wendy J. Steinberg; 2008
- Statistics; Robert S. Witte; 1980
- Statistics for People Who Think They Hate Statistics, Excel 2007 Edition; Neil J. Salkind; 2010
How to Make Frequency Tables
Many types of companies use frequency tables. They are a mathematical calculation that shows the distribution of responses to a question in...
How to Display Frequency Tables in SPSS
Displaying a frequency table in SPSS is easy if you know how. SPSS stands for Statistical Package for the Social Sciences, and...
How to Make a Frequency Table on Microsoft Excel
Creating frequency tables, which show the distribution of certain values, is required not only in many college classes, such as Statistics, but...
How to Calculate Mean With Frequency
When analyzing data, it is important to understand how to calculate the mean of a set of numbers. In situations in which...
How to Create a Distribution Chart
A frequency distribution helps data analysts understand the frequency with which values in a set of data occur. Often displayed in a...
How to Create a Frequency Table in Excel Using Pivot Tables
Pivot tables are data summarization tools that look like tables except that they allow a quick rearranging of the constituent fields to...
How to Calculate Relative Frequency Distribution
Relative frequency distribution is a basic statistical technique. To calculate relative cumulative frequency, you need to create a chart. This chart lists...
How to Create a Frequency Graph
A frequency table, or frequency chart, is a type of table that shows how often an item occurs. It's a tool for...
How to Calculate Class Interval
Any data set accumulated for statistical purposes, such as the U.S. census, contains information that needs to be summarized and aggregated. It’d...
How to Calculate Cumulative Relative Frequency
In statistics, frequency means how many times a particular event occurred. If you roll two dice 20 times and the number four...
How to Make a Frequency Table
A frequency table is created to give a certain piece of data, such as how many siblings each member of a classroom...
How to Make Frequency Tables
In order to create a frequency list in Microsoft Excel, it helps to open up a table. Add items on a list...