Measures of Central Location
Excel Formulas
Excel Commands
|
A |
B |
C |
D |
|
E |
1 |
X |
W |
Name |
Command |
Answer |
Answer (with Notes) |
2 |
$55,000 |
9 |
Mean |
=AVERAGE(A2:A7) |
$63,500 |
Finds the mean |
3 |
$67,000 |
5 |
Median |
=MEDIAN(A2:A7) |
$64,000 |
Finds the median |
4 |
$71,000 |
12 |
Mode |
=MODE(B2:B7) |
5 |
Returns only one mode |
5 |
$62,000 |
7 |
Mode |
=MODE.MULT(B2:B7) |
5, 12 |
Returns multiple modes |
6 |
$60,000 |
12 |
Sum |
=SUM(B2:B7) |
50 |
Adds (sums) values |
7 |
$66,000 |
5 |
Sum Product |
=SUMPRODUCT(A2:A7, B2:B7) |
3,166,000 |
Multiplies pairs, then adds them |
8 |
|
|
Count |
=COUNT(A2:A7) |
6 |
Count the number of values (non empty cells). |
Computing Weighted Average
- Excel formula=SUMPRODUCT(A2:A7, B2:B7)/SUM(B2:B7) or =D7/D6
- Answer → 63, 320