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.