Stats project
The
Project
The
infamous company, Canton & Associates, is in trouble again. The
Deputy Director has just resigned in the midst of rumors going around the
departments about discrimination, lawsuits, and even the company picnic has
been canceled.
I
would like to seek your help in putting together an Ad hoc Statistics
Report to be submitted to the CEO so that he can make the appropriate
corrective, proactive, and retroactive decisions for the troubled company. Review the issues following this report
description, and then review the data listed in the table starting on page 11
that is to be applied to issues 1-9. I recommend that you use Excel to construct your
histograms and tables and cut and paste them in your final Microsoft Word
document.
Issue
1
Nine employees need to be chosen randomly to serve on the
Grievance Board from the Employee Roster so that no one will say that we chose
employees based on popularity. You may use any method, including with the
aid of a random number table, to accomplish this task. However, you
have to explain your method, whichever you choose to use.
Please list the employees ID# after selecting them.
Issue
2
Please complete the following two conditional probability
tables. There have been complaints that there is skewness in certain
departments as it relates to ethnicity and gender. It seems that certain
supervisors are hiring only females or only Asians. Please complete this
accurately so that the CEO can see if there are hiring trends in his agency.
Table I
White |
Black |
Hispanic |
Asian |
Foreign |
Total |
|
Dept. 1 |
||||||
Dept. 2 |
||||||
Dept. 3 |
||||||
Dept. 4 |
||||||
Dept. 5 |
||||||
Total |
Table II
Female |
Male |
Total |
|
Black |
|||
White |
|||
Hispanic |
|||
Asian |
|||
Foreign |
|||
Total |
Issue
3
Please create a histogram for vacation hours for employees
in Department 1, 3, and 5. Please exclude any vacation hours over 320 as
a person cannot accumulate vacation over that amount.
After you have created this histogram, please indicate the
distribution’s shape.
Issue
4
Find the Mean weight for Departments 4 and 5 combined.
Find
the Mean salary for Department 2.
Find
Mean age for Department 1.
Find the Mean Placement Score (P. Score) for
Department 3.
Issue
5
Find the standard deviation for the evaluation score (E.
Score) of Department 5 and Department 2 separately.
The CEO is thinking about giving one of these department a
$1000 per person bonus. Based on their means and standard deviation,
which department is doing better as it relates to this year’s evaluation?
Who should the bonus go to and why?
Issue
6
The Equal Opportunity Commission has cited Jordan &
Associates with discrimination against Asian females and Hispanic
females. They need to promote either an Asian female or an Hispanic
female within the next month. Based on their evaluation scores (E.
Score), find the corresponding z -score for each Asian and
Hispanic female and make a decision on which person should be promoted.
Please list them by their ID # based on the percentile.
Use s = 6.06 and m = 16.
Issue
7
Please refer to the conditional probability table or
complete it first before attempting this assignment. The CEO has asked
for a committee to be formed to approve and review promotions. Please
list all your answers in percentages?
From Table 1, what is the probability of choosing an African
American employee?
From Table 2, what is the probability of choosing an Asian
female given all females?
From Table 1, what is the probability of choosing a White
employee from Dept. 2 and then an Hispanic employee from Dept. 3?
From Table 2, what is the probability of choosing a Black
male or Foreign male?
From Table 1, what is the probability of choosing a
Foreigner or an Hispanic both from Department 5?
Issue 8
Find the evaluation score (E. Score) confidence intervals
for the following two departments: Department 1 and Department 4 combined.
Find the confidence interval at the 95% level. Use
s = 6.06 and