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
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 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
The mean median and mode are all measures of central tendency used to describe the distribution of a dataset Mean The mean is calculated by summing up ...
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Statistics
Authors: James T. McClave, Terry T Sincich
12th Edition
9780321831088, 321755936, 032183108X, 978-0321755933
