How to Make a Relative Frequency Table

Frequency tables are used to create histograms.
••• Thinkstock/Comstock/Getty Images

Frequency tables are created from the results of a poll. Frequency tables tab the results of a poll and are used to construct histograms, which are graphical representations of the choices. Relative frequency tables are very important, as they express the choices on a poll as percentages instead of number of choices on a poll ( for example, 20% chose "A" instead of 44 people chose "A"). Constructing a relative frequency table is useful to construct histograms and to calculate the statistics related to a poll.

    Write down the results from the poll, broken down by options. For example: 44 people chose Option A, 56 chose B, 65 chose C, 45 chose D, 10 chose E.

    Create a table with three columns. Label the first column "Data Value," the second column "Frequency" and the third column "Relative Frequency."

    Write down the poll options on the "Data Value" column; for example:

    Data Value Option A Option B Option C Option D Option E

    Write down the result from the poll in the "Frequency" column. Add the frequencies and write the total at the bottom of the second column. Continuing the example:

    Data Value || Frequency Option A || 44 Option B || 56 Option C || 65 Option D || 45 Option E || 10 TOTAL: || 220

    Go to the "Relative Frequency Column" column. Divide each frequency value by the total to calculate each relative frequency value. Express the percentage as a decimal between zero and 1. Write down the total at the bottom of the column. Option A had 44 frequency, and a relative frequency of 44/200 = 0.2

    Data Value || Frequency || Relative Frequency Option A || 44 || 0.2 Option B || 56 || 0.25 Option C || 65 || 0.30 Option D || 45 || 0.2 Option E || 10 || 0.05 TOTAL: || 220 || 1

    Tips

    • Make sure that the TOTALS for the Relative Frequency add to 1. Since numbers there represent percentages, they must add to 1, which is 100%.

Related Articles

How to Compute Percentiles on a Histogram
How to Calculate the Mean in a Probability Distribution
How do I Calculate 0.1%?
How to Calculate Percent Relative Range
How to Construct a Percentile Graph
How to Compute a Population Mean
How to Calculate Mode in Minitab
How to Figure Survey Percentages
How to Calculate a Sigma Value
How to Calculate Statistical Difference
How to Calculate a P-Value
How to Convert Seconds Into Miles Per Hour
How to Calculate Cumulative Relative Frequency
How to Calculate the Item Total & Correlation Coefficients
How to Find the X Intercept of a Function
How to Work Out the Percentages for a Pie Chart
How to Create Bar Charts From Likert Scale Results
How to Calculate CV Values
How to Calculate Cost Increase by a Percent
How to Calculate Logit