How to Make a Frequency Table on Microsoft Excel. A frequency table tabulates the number of times values from a data set appear within a configured range. As an example, you might have a list of ...

How to Do Averages With Percentages in Excel. Averages are typically computed as the sum of values divided by the number of data points. However, averages are also calculable from percentages.