This display is from an Excel program, Standard Deviation (xls), in the frequency distribution has classes and corresponding frequencies as in the table below.
Describes a frequency table and shows how to calculate the mean and variance Figure 2 – Calculation of mean and standard deviation from frequency table.
Finding the Mean Enter the scores in one of the columns on the Excel spreadsheet (see the example below). After the data have been entered, place the. Mean, Median, and SD for Grouped Data