### Frequency Tables | Real Statistics Using Excel

When data is provided in the form of a frequency table, the calculation of the mean and standard deviation cannot be performed directly using the usual AVERAGE and STDEV Excel functions. ... Frequency function corresponding to frequency table. Often frequency tables are used with a range of data values, with intervals for the x values.