14 Sep What is the relationship between mean, median, and mode? Under what circumstances are they equal?? ?Part 2. Over the next ?several weeks, we will be observing a company that develop
Part 1. What is the relationship between mean, median, and mode? Under what circumstances are they equal?
Part 2. 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
Calculate the simple and weighted arithmetic mean of salary paid
Calculate to Coefficient of Range
Find the average deviation from mean
Sheet1
| 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 |
