In column C, set up the 'Relative Frequency.' Relative Frequency is calculated simply by dividing the individual frequencies by the total number of data values. This result will give you the total number of data points. Select the empty cell below the list of frequencies in Column B and use the sum function to add up the values. In column A, set up the different classes and label the column as 'Class.' Column B will be for the 'Frequency.' Count up the number of data points that fall in each class interval, and state the frequency in column B. Start setting up the table on Microsoft Excel.
