Excel
Instruction
Excel
. Now you have found the mean!
Example 1
A group of skaters are distributed into different weight classes. Here’s a table showing the classes and the frequency of each class.
Weight | Frequency |
7 | |
8 | |
12 | |
9 | |
6 | |
Find the mean weight of this group.
Excel
.
Write the following formula in cell B2
:
=(115+125)/2
Enter the formula for calculating the mean in the remaining weight classes in the column representing the midpoints.
In the “”-column, write the following formula in cell D2
:
=B2*C2
Mark cell D2
and copy the formula all the way down to cell D6
.
C7
: =SUM(C2:C6)
And write the following in cell D7
:
=SUM(D2:D6)
Finally, you’ll find the mean by dividing the number in cell D7
by cell C7
.
In cell B9
, write:
=D7/C7
Here are the formulas for each cell:
You can now see that the mean weight for this group is lb.