MY MEGASTAT WILL NOT WORK!! This one is due tonight, please help!!! You must use

Question

MY MEGASTAT WILL NOT WORK!! This one is due tonight, please help!!!

You must use Excel Megastat to solve the problem. Your calculated values must come from the excel output. Copy and paste relevant excel output. Be sure to write in all required information below each question, you will not receive credit if you only turn it the output. Your answers must be full and complete in order to receive credit.

Show ALL the steps.

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

1. What is the probability that a person selected at random from the CPD is a female?

2. What is the probability that a person selected at random from the CPD is a detective?

3. Assuming no bias in promotions, how many female detectives would you expect the CPD to have?

4. 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

From the given data

1) The probability that a person selected at random from the CPD is a female is 5613 / 45379 = 0.01241

2) The probability that a person selected at random from the CPD is a detective is 4864 / 45379 = 0.10719

3) 806

4)

Step 1: H0:The rank and gender are independent

Step 2: H1: The rank and gender are not independent

Step 3: Let the los be alpha = 1%

Step 4: Chisquare critical value = 15.08626 at 1% level and (6-1)(2-1) = 5df

H0 is rejected if chisquare value > chisquare critical value

Step 5: The expected frequencies are

Chisquare contribution values are

Test Statistic, X^2: 200.9541

Step 6: Critical X^2: 15.08626

Here Chisquare value > Chisquare criticla value, So we reject H0

P-Value: 0.0000

Here P-Value < alpha 0.01, so we reject H0

Step 7: Thus we conclude that  the rank and gender are not independent

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 M
• Subjects

---

---

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