Computation of Mean and Median and Standard Deviation using Excel formulas
Calculate and record the mean and the median and the standard deviation of the data set.
Divide the data into 9 to15 categories (classes).
Create both absolute as well as relative frequency tables for the categories.
Take a printout of the frequency tables showing the total of both frequencies.