What is the relationship between mean, median, and mode? Under what circumstances are they equal? Over the
Question:
What is the relationship between mean, median, and mode? Under what circumstances are they equal?
Over the next several weeks, we will be observing a company that develops, markets, manufactures, and sells integrated wide-area network access products. See the attached dataset for the salary paid to employees
For all the 130 data points:
-Calculate the simple and weighted arithmetic mean of salary paid (all data points have same weight, but use the SUMPRODUCT function for weighted mean).
-Calculate the Coefficient of Range
-Find the average deviation from mean
Data Sets:
Rank | Monthly Salary | Gender |
Senior Manager | 125,000 | M |
Manager | 100,000 | M |
Manager | 100,000 | M |
Manager | 100,000 | M |
Manager | 100,000 | M |
Manager | 100,000 | F |
Manager | 100,000 | F |
Manager | 100,000 | F |
Manager | 100,000 | F |
Manager | 100,000 | F |
Supervisor | 75,000 | M |
Supervisor | 75,000 | F |
Supervisor | 75,000 | M |
Supervisor | 75,000 | F |
Supervisor | 75,000 | M |
Supervisor | 75,000 | M |
Supervisor | 75,000 | F |
Supervisor | 75,000 | F |
Supervisor | 75,000 | F |
Supervisor | 75,000 | M |
Supervisor | 75,000 | M |
Supervisor | 75,000 | M |
Supervisor | 75,000 | M |
Supervisor | 75,000 | F |
Supervisor | 75,000 | F |
Supervisor | 75,000 | M |
Supervisor | 75,000 | M |
Supervisor | 75,000 | F |
Supervisor | 75,000 | M |
Supervisor | 75,000 | M |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | M |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | M |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | M |
Employees | 45,000 | F |
Employees | 45,000 | M |
Employees | 45,000 | F |