Question details

QNT 275 Week 2 Assignment Mini Project 3 2
$ 20.00

Purpose of Assignment 

The purpose of this assignment is to provide students an opportunity to gain an understanding on how to compute and interpret descriptive statistics and compare results. 

Assignment Steps 

Resources: Microsoft® Excel® and Student Resources Guide 

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. 

Format your paper consistent with APA guidelines. 

Available solutions