Be sure to use Excel Megastat to solve the following problem . Copy and paste re

Question

Be sure to use Excel Megastat to solve the following problem. Copy and paste relevant excel output on this assignment. Be sure to write in all required information below the corresponding question. Your answers must be full and complete.

Show ALL the steps (both critical value and p-value approaches).

Promotion discrimination case

The following table shows the rank attained by male and female officers in the CPD (Cleveland Police department). The CPD HR consultant wants to find if data indicate that men and women are equitably represented at all levels of the department.

Male

Female

Officer

29,900

4281

Detective

4058

806

Sergeant

3898

415

Lieutenant

1333

89

Captain

359

12

Higher ranks

218

10

(0.5pts.) What is the probability that a person selected at random from the CPD is a female?

(0.5pts.) What is the probability that a person selected at random from the CPD is a detective?

(0.5pts.) Assuming no bias in promotions, how many female detectives would you expect the CPD to have?

(3.5pts.) Using Excel Megastat and the p-value approach, test to see if gender and rank are independent (which, if true, will indicate no discrimination). Use = 0.01 and the 7-steps of the hypothesis test discussed in class. Be sure to write your conclusion explicitly in the context of the problem.

Male

Female

Officer

29,900

4281

Detective

4058

806

Sergeant

3898

415

Lieutenant

1333

89

Captain

359

12

Higher ranks

218

10

Explanation / Answer

probability that a person selected at random from the CPD is a female=5613/45379 =0.1237

probability that a person selected at random from the CPD is a detective =4864/45379 =0.1072

for no bias number of  female detectives would you expect the CPD to have =5613*4313/45379=601.636

applying chi square test on above::

null hypothesis: men and women are equitably represented at all levels of the department

alternate hypothesis:

men and women are not equitably represented at all levels of the department

l;evel of significance =0.01

for above chi square test stat =200.954

and degree of freedom =5

for above 5 degree of freedom and above test stat p value =0.0000

as p vlaue is less then 0.05 level we reject null hypothesis

and conclude that men and women are not equitably represented at all levels of the department

O male Female Total Officer 29900 4281 34181 Detective 4058 806 4864 Sergeant 3898 415 4313 Lieutenant 1333 89 1422 Captain 359 12 371 Higher ranks 218 10 228 Total 39766 5613 45379

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.