Input your data on first column and frequency on the second column. Assume, your frequency table is 10,20,40,60,80 and we have to calculate the relative frequency distribution.
Calculate the sum of all frequencies. In this example, you add 10+20+40+60+80. The sum of frequencies is 210.
Create another column called Relative Frequency Column.
Divide 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 in Step 2. 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.
F RF
10 0.05
20 0.10
40 0.19
60 0.29
80 0.38
210 1