Question 6 A human resources director wants to determine if there is a dependenc

Question

Question 6

A human resources director wants to determine if there is a dependence between day of the week ad he number of times employees took sick on that day.

A) .82

B) .83

C) .81

D) .80

Question 7

Continuing ,Determine the critical value at the significance level of .05 using one of:

=CHISQ.INV.RT

=CHISQ.INV

=CHINV() to find the critical value

The critical value is

A) 11.070

B) 12.592

C) 1.145

D) 1.635

Question 8

continuing , find the p value using the chi square statistic in a) and one of the Excel function CHISQ.DIST.RT, =CHISQ.DIST, or =CHIDIST ()

The pvalue is

A) 0.023

B) 0.977

C) 0.936

D) 0.992

Days sick Monday 12 Tuesday 9 Wednesday 11 Thursday 10 Friday 9 Saturday 9

Explanation / Answer

Observed frequency

(O)

probability

Expected frequency

(E=n*p)

O-E

(O-E)2 /E

12

1/6 = 0.66667

1/6*60 =10

2

0.40

9

1/6 = 0.66667

1/6*60 =10

-1

0.10

11

1/6 = 0.66667

1/6*60 =10

1

0.10

10

1/6 = 0.66667

1/6*60 =10

0

0.00

9

1/6 = 0.66667

1/6*60 =10

-1

0.10

9

1/6 = 0.66667

1/6*60 =10

-1

0.10

N =60

0.80

Test statistic X2 =0.80

Option D is correct

Question7

Using excel formula ‘=CHIINV(0.05,5)

Critical value =11.07049775

Option A is correct

Question 8

Using excel formula ‘=CHIDIST(0.8,5)

p-value = 0.977033344

Option B is correct

Observed frequency

(O)

probability

Expected frequency

(E=n*p)

O-E

(O-E)2 /E

12

1/6 = 0.66667

1/6*60 =10

2

0.40

9

1/6 = 0.66667

1/6*60 =10

-1

0.10

11

1/6 = 0.66667

1/6*60 =10

1

0.10

10

1/6 = 0.66667

1/6*60 =10

0

0.00

9

1/6 = 0.66667

1/6*60 =10

-1

0.10

9

1/6 = 0.66667

1/6*60 =10

-1

0.10

N =60

0.80

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

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