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

License

Icon for the Creative Commons Attribution-NonCommercial 4.0 International License

An Introduction to Business Statistics for Analytics (1st Edition) Copyright © 2024 by Amy Goldlist; Charles Chan; Leslie Major; Michael Johnson is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License, except where otherwise noted.

Share This Book