How Do You Find Statistics from Frequency Data?

freq_std_dev_excel_16Working with frequency distributions to find the mean, variance, and standard deviation can be a little tough. In the example below, we’ll incorporate Sheets (or Excel) to make it easier to calculate these statistics. An example is worked out in Example 3 of Question 2 in Section 6.2 for the mean and  in the video below for standard deviation.

Let’s look at how we can implement this process in a spreadsheet.

Goto the MathFAQ >>