Question 9 of 20
0.0/ 1.0 Points
A high school runs a survey asking students if they participate in sports. The results are found
below. Run an independence test for the data at
α=0.01
Freshmen
Sophomores
Juniors
Seniors
Yes
75
88
55
42
No
30
28
38
40
Can it be concluded that participation in sports is dependent on grade level?
.

A.
No, it cannot be concluded that participation in sports is dependent on grade level
because the p-value = 0.0020.
B.
No, it cannot be concluded that participation in sports is dependent on grade level
because the p-value = 0.0010.
C.
Yes, it can be concluded that participation in sports is dependent on grade level because
the p-value = 0.0010.
D.
Yes, it can be concluded that participation in sports is dependent on grade level because
the p-value = 0.0020.
Answer Key:C
Feedback:
We are running a Chi-Square Test for Independence. Copy and Paste the table into Excel. You
are given the Observed Counts in the table. Next you need to sum the rows and columns. Once
you have those you need to calculate the Expected Counts. You need to find the probability of
the row and then multiple it by the column total.
Freshmen
Sophomores
Juniors
Seniors
Yes
75
88
55
42
No
30
28
38
40
Sum
105
116
93
82
Freshmen
Sophomores
Juniors
Seniors
Yes
=105*(260/396)
=116*(260/396)
=93*(260/396)
=82*(260/396)
No
=105*(136/396)
=116*(136/396)
=93*(136/396)
=82*(136/396)
Now that we calculated the Expected Count we can use Excel to find the p-value.
Use =CHISQ.TEST(highlight actual counts, highlight expected counts) = 0.0010
0.0010 < .01,Reject Ho. Yes, it can be concluded that participation in sports is dependent on
grade level.
Question 10 of 20
0.0/ 1.0 Points

An electronics store has 4 branches in a large city. They are curious if sales in any particular
department are different depending on location. They take a random sample of 4 purchases
throughout the 4 branches – the results are recorded below. Run an independence test for the
data below at the 0.05 level of significance.
Appliances
TV
Computers
Cell Phones
Branch 1
56
28
63
24
Branch 2
44
22
55
27
Branch 3
53
17
49
33
Branch 4
51
31
66
29
Can it be concluded that sales in the various departments are dependent on branch?