Frequency Table Calculator


Instructions: Use this Frequency Table Calculator to construct a frequency table associated with the sample provided in the form below.

Type (or paste from Excel) the sample values you want to analyze

Name of the random variable (Optional)
Compute Relative Frequencies       
Compute Cumulative Frequencies

Frequency Table Calculator

A frequency table corresponds to an organized table that contains the different values that are in the sample along with the frequencies of those values (how many times each value appears in the sample).

In other words, it is a way of tallying up the sample data you have available.

Typically, a frequency table can be represented by a bar chart (a frequency bar chart) to get a clear depiction of the distribution of the variable, although the most common tool to assess the distribution of sample data is the construction of an histogram.

With this calculator all you need to do is to just type or paste the data from Excel and then click on "Calculate" to get all the steps shown.

Frequency Table Calculator

Frequency distribution table

This calculator will create a frequency distribution table by grouping and tallying up the number of times a number appears in the sample data provided.

Once this frequency distribution is constructed, depending on whether or not you checked the option for it, you will also see the construction of the relative and cumulative frequencies, which also provide a perspective on the distributional properties of the sample provided.

Then, once the tables are shown and explained, you will see a bar chart depicting the situation graphically. Of course, you can construct a full-fledged histogram, to get a more clear graphical depiction.

Relative Frequency Table

Often times, it is useful to express the frequencies to normalize them and get what proportion (percentage) of the frequencies are associated to each values. Such relative frequencies can also be graphed and represented with a bar chart ( relative frequency bar chart ).

One thing to be observed is that when looking at the shape of the bars in a regular frequency chart, the same shape will be obtained in the relative frequency bar chart, only the scale on the Y-axis changes.

Frequency Distribution Table Calculator

Cumulative Frequency Table

Also, it is useful to construct the cumulative frequencies to see how much is accumulated (in terms of cumulative frequencies) with respect to the total number of frequencies.

Observe that for working with classes instead, you can use this histogram maker which would a better work instead.

log in to your account

Don't have a membership account?
REGISTER

reset password

Back to
log in

sign up

Back to
log in