Gold
Silver
Bronze
Sum
Norway
17
14
11
42
Germany
16
9
6
31
Canada
13
9
11
33
United States
12
10
7
29
Sum
58
42
35
135
Gold
Silver
Bronze
Norway
=58*(42/135)
=42*(42/135)
=35*(42/135)
Germany
=58*(31/135)
=42*(31/135)
=35*(31/135)
Canada
=58*(33/135)
=42*(33/135)
=35*(33/135)
United States
=58*(33/135)
=42*(29/135)
=35*(29/135)
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.8861
0.8861 > 0.05, Do Not Reject Ho. No, it cannot be concluded that medal won is dependent on
country.
Question 14 of 20
1.0/ 1.0 Points
A local gym is looking in to purchasing more exercise equipment and runs a survey to find out
the preference in exercise equipment amongst their members. They categorize the members
based on how frequently they use the gym each month – the results are below. Run an
independence test at the 0.01 level of significance.
Free Weights
Weight
Machines
Endurance
Machines
Aerobics
Equipment
0-10 Uses
12
17
25
13
11-30 Uses
20
18
9
9

31+ Uses
26
12
11
9
Enter the test statistic - round to 4 decimal places.
15.8803
Answer Key: 15.8803
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.
Free Weights
Weight Machines
Endurance
Machines
Aerobics
Equipment
0-10 Uses
12
17
25
13
11-30 Uses
20
18
9
9
31+ Uses
26
12
11
9
Sum
58
47
45
31
Free Weights
Weight Machines
Endurance
Machines
Aerobics
Equipment
0-10 Uses
=58*(67/181)
=47*(67/181)
=45*(67/181)
=31*(67/181)
11-30 Uses
=58*(56/181)
=47*(56/181)
=45*(56/181)
=31*(56/181)
31+ Uses
=58*(58/181)
=47*(58/181)
=45*(58/181)
=31*(58/181)
Now that we calculated the Expected Counts we need to find the Test Statistic.
Test Stat =
You will need to use all 12 Count values but I am only showing you 3 because there isn't room
to write out the entire equation.
Question 15 of 20
1.0/ 1.0 Points
The medal count for the 2018 winter Olympics is recorded below. Run an independence test to
find out if the medal won is dependent on country. Use
α=0.10
.

Norway
17
14
11
Germany
16
9
6
Canada
13
9
11
United States
12
10
7
Enter the test statistic - round to 4 decimal places.
2.3387
Answer Key: 2.3387
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.
Gold
Silver
Bronze
Sum
Norway
17
14
11
42
Germany
16
9
6
31
Canada
13
9
11
33
United States
12
10
7
29
Sum
58
42
35
135
Gold
Silver
Bronze
Norway
=58*(42/135)
=42*(42/135)
=35*(42/135)
Germany
=58*(31/135)
=42*(31/135)
=35*(31/135)
Canada
=58*(33/135)
=42*(33/135)
=35*(33/135)
United States
=58*(33/135)
=42*(29/135)
=35*(29/135)
Now that we calculated the Expected Counts we need to find the Test Statistic.