Converting frequency distribution to relative frequency distribution is an easy task. Relative frequency distribution can be calculated by either proportion or by percentage. This article will explore the proportion method.
You will need to Input your data on first column and frequency on the second column in Excel. Assume frequency table is 10,20,40,60,80 and we have to calculate the relative frequency distribution.
First, calculate the sum of all frequencies. In this example, you add 10+20+40+60+80. The sum of frequencies is 210. Second, create another column called Relative Frequency Column.
Now devide EACH frequency by the total frequency of entire distribution. Add that number under Relative Frequency Column. For example first frequency is 10. We need to divide 10 by the total frequencies which we calculated to be 210. If you divided 10 by 210, you will get .05 after rounding. This will be your relative frequency for 10.
Similarly, divide 20,40,60 and 80 by 210 individually. The resulting calculation will give you the relative frequencies. The relative frequencies of 10,20,40,60 and 80 are .05, .10, .19, .29 and .38 after rounding. The Sum of your Relative Frequency must be One. Otherwise your calculations will be wrong.
Your table should look like this:
In this table, F means Frequency and RF means Relative Frequency. As described above, for each frequency, relative frequency is calculated. For example, in this table, Relative Frequency for 10 is .05. The RF was calculated by dividing 10 by the total which is 210. The total of all Relative Frequency must be 1.