Measuring Salespeople Performance

Scenario: You are employed as a statistician for a company that makes household products, which are sold by part-time salespeople who work during their spare time. The company has four salespeople employed in a small town. Let us denote these salespeople by A, B, C, and D. The sales records (in dollars) for the past 6 weeks for these four salespeople are shown in the table below.

Week

A

B

C

D

1

1774

2205

1330

1402

2

1808

1507

1295

1665

3

1890

2352

1502

1530

4

1932

1939

1104

1826

5

1855

2052

1189

1703

6

1726

1630

1441

1498

Your supervisor has asked you to prepare a brief report comparing the sales volumes and the consistency of sales of these four salespeople.

  • Use the mean sales for each salesperson to compare the sales volumes.

Choose an appropriate statistical measure to compare the consistency of sales.

Make the calculations on the Microsoft® Excel® file

“Measuring Salespeople Performance Template,” and write a report of 350 words comparing the sales volumes and the consistency of sales of these four salespeople.