July 16th, 2008
Calculating Averages Using Excel Statistical Functions
Need to calculate statistical averages? Microsoft Excel supplies several easy-to-use statistical functions for just such a purpose says bestselling computer book author Stephen L. Nelson
Excel provides useful functions for finding the mean, median, and mode of a data set. In general, the functions look at a set of values and then make the expected calculation. For example, the mean functions, which calculate averages, take the sum of the values in the set and divide it by the number of values.
AVERAGE