We are running a Chi Square Test for Independence Copy and Paste the table into

# We are running a chi square test for independence

• 20
• 100% (51) 51 out of 51 people found this document helpful

This preview shows page 11 - 14 out of 20 pages.

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