1.0/ 1.0 Points
We are running a Chi-Square Test for Independence. Copy and Paste the table into Excel. You are given theObserved Counts in the table. We need to calculate the Expected Counts Then sum up the rows and column.Youneed to find the probability of the row and then multiple it by the column total.
Machine
Shift
A
B
C
Sum
1
46
11
13
70
2
37
10
11
58
3
20
15
16
51
Sum
103
36
40
179
Shift
A
B
C
1
=103*(70/179) =36*(70/179)
=40*(70/179)
2
=103*(58/179) =36*(58/179)
=40*(58/179)
3
=103*(51/179) =36*(51/179)
=40*(51/179)
=40*(51/179) = 11.397
Part 3 of 4 - Chi-Square Test for Independence
5.0/ 5.0 Points
Question 12 of 20A local gym is looking in to purchasing more exercise equipment and runs a survey to find outthe preference in exercise equipment amongst their members. They categorize the members based on howfrequently they use the gym each month – the results are below. Run an independence test at the 0.01 levelof significance.Free WeightsWeightMachinesEnduranceMachinesAerobicsEquipment0-10 Uses1217251311-30 Uses20189931+ Uses2612119Can it be concluded that preference in exercise equipment is dependent on gym usage?
A. Yes, it can be concluded that preference in exercise equipment is dependent on gym usage because the p-value= 0.0144.

1.0/ 1.0 PointsQuestion 13 of 20Click to see additional instructions
B. No, it cannot be concluded that preference in exercise equipment is dependent on gym usage because the p-value = 0.9856.C. No, it cannot be concluded that preference in exercise equipment is dependent on gym usage because the p-value = 0.0144.D. Yes, it can be concluded that preference in exercise equipment is dependent on gym usage because the p-value= 0.9856.Answer Key: 0.0144 > 0.01, Do Not Reject Ho. No, it cannot be concluded that preference in exercise equipment is dependenton gym usage.
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.
Free Weights
Weight Machines
Endurance
Machines
Aerobics Equipment
Sum
0-10 Uses
12
17
25
13
67
11-30 Uses
20
18
9
9
56
31+ Uses
26
12
11
9
58
Sum
58
47
45
31
181
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 Count we can use Excel to find the p-value.
Use =CHISQ.TEST(highlight actual counts, highlight expected counts) = 0.0144