How to Make a Frequency Table on a Computer

A frequency table is a collection of data that displays how many times a certain condition happens. These tables are useful for seeing how many students scored a certain number on specific a test. Frequency tables are especially useful when dealing with statistics and determining many other functions within math. Making a frequency table on a computer is a rather easy affair.

Instructions

1

Open your spreadsheet program and begin inserting your raw data. This will form a list of options that should be listed inside one column.

2

Construct a table a couple of columns over that contains at least three columns. Name the first column after the type of data inserted and the next column as tally. Name the last column as frequency.

3

Create a row underneath the first column for each singular occurrence of a data type in the raw data column. So, if two students had a score of 40 points then all you need is one row that can account for all the students who scored 40 points.

4

Count the number of occurrences in the raw data for each item under the first column. Record your findings in the tally section. For example, if three students scored 30 points and two students scored 40 points then under the 30 row you would tally three points in the tally column and in the 40 points row you would tally two points in the tally column.

5

Continue tallying all the occurrences until you've finished the entire raw data set. Double check the raw data with the tally to make sure there data sets fits.

6

Write down the numerical value of the tally marks under the frequency column in your frequency table. To complete your frequency table create a text entry called "sum" at the bottom of your tally column and then write the sum of the frequency column at the last row on the frequency column.