Question

The table below contains data on sport preferences (Basketball, Football, and Soccer) for Men and Women. By creating a cross-tabulation (contingency table) for the variables "Gender" as a row variable and "Sport Preference" as a column variable in Excel, we can determine if sport preference and gender are independent variables using Î±=0.05. Defend your conclusion by including the statistical analysis that supports your report. (Include DF, Test stat value, P-value, decision, and conclusion). Hint: To create a cross-tabulation (contingency table), use a Pivot Table. Gender Amount Sport Preference Men 20 Basketball Men 25 Football Men 30 Soccer Women 18 Basketball Women 14 Football Women 13 Soccer

          The table below contains data on sport preferences (Basketball, Football, and Soccer) for Men and Women. By creating a cross-tabulation (contingency table) for the variables "Gender" as a row variable and "Sport Preference" as a column variable in Excel, we can determine if sport preference and gender are independent variables using Î±=0.05. Defend your conclusion by including the statistical analysis that supports your report. (Include DF, Test stat value, P-value, decision, and conclusion).

Hint: To create a cross-tabulation (contingency table), use a Pivot Table.

Gender   Amount   Sport Preference
Men      20       Basketball
Men      25       Football
Men      30       Soccer
Women    18       Basketball
Women    14       Football
Women    13       Soccer

Added by Pablo G.

Question

Please give Ace some feedback