Prior to Excel 365 Excel did not have a dedicated function to count unique values. Thus the relative frequency of the class 1 10 is 20 66 0303. A fairly simple but important relationship.
Thus we found the relative frequency of each class by taking the frequency of each class and dividing by the total items sold.
Using the same formula midpoints must be determined for each age group up to and including the age group 55 to 64 years see column 3 of Table 310. In total there were 66 items sold. Of absentees Frequency Relative Frequency. The frequency distribution of weekly pocket money received by a group of students is given below.