W05 Group Problem Solving Summer Sales Assignment PDF

Preview

Summary

Summarizing DataCompanyMean Median Mode Max MinPlease refer toAriel is a college student thinking ofworking for the summer sellingproducts door-to-door. He needs helpdeciding which company to work for.To the right are the commission recordsfor the employees of the companiesAriel is thinking of worki...

Description

Summarizing Data C Ariel is a college student thinking of working for the summer selling products door-to-door. He needs help deciding which company to work for.

To the right are the commission records for the employees of the companies Ariel is thinking of working for. You need to analyze the data by calculating the mean, median, mode, minimum, and maximum for each company. Then explain which company you think Ariel should work for, and why.

Mean Median Mode Max Min

Please refer t

Company A

Company B

Company C

$ $ $ $ $ $ $ $

25,000 28,300 5,000 2,200 19,000 2,600 1,300 8,600

$ $ $ $ $ $ $ $

5,600 7,600 5,800 6,100 6,000 7,200 8,900 3,800

$ $ $ $ $ $ $ $

13,000 14,100 1,200 1,600 2,100 13,300 12,100 11,900

$ $ $ $ $ $ $ $ $

31,230 3,400 4,900 17,000 3,700 1,800 115,000 300 1,800

$ $ $ $ $ $ $ $ $

5,000 6,700 5,200 6,100 6,300 8,800 3,600 3,800 4,100

$ $ $ $ $ $ $ $ $

5,600 1,800 2,100 4,500 5,200 16,800 3,600 4,300 6,700

Mean $ 5,917.65

Mean $

7,052.94

Median $

5,200.00

$

2,100.00

$ 15,948.82 $

4,900.00

Median $ 6,000.00

$

1,800.00

Mode $ 6,100.00

Mode

$ 115,000.00

Max $ 8,900.00

Max

$

Min $ 3,600.00

Min $

300.00

Which co Ariel sho

Compan Consiste than the The min commiss

The pay keeps hi

$ 16,800.00 1,200.00

to your textbook if you have any questions about how to use Excel to make these calculations.

ompany do you think ould work for? Why?

ny B ently pay better e others. imum sions are good.

is good and that im motivated....