Multiply midpoints by frequencies add the subtotals and divide by the total of the frequencies. Step 1 - Select type of frequency distribution Discrete or continuous Step 2 - Enter the Range or classes X seperated by comma Step 3 - Enter the Frequencies f seperated by comma. Here cell F11 contains the formula D11E11 which calculates the mean and cell G14 contains the formula D14-E14F14 E14-1 which calculates the variance.
Mean 2 1 5 2 4 3 2 4 1 5 2 5 4 2 1.
M 267 13 m 267 13 Simplify the right side of m 267 13 m 267 13. Multiply midpoints by frequencies add the subtotals and divide by the total of the frequencies. Step 1 - Select type of frequency distribution Discrete or continuous Step 2 - Enter the Range or classes X seperated by comma Step 3 - Enter the Frequencies f seperated by comma. Find the midpoint of each interval.