# Gold silver bronze sum 11 42 germany 16 9 6 31 canada

• 34
• 100% (8) 8 out of 8 people found this document helpful

This preview shows page 27 - 30 out of 34 pages.

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.