Contingency Tables with Probabilities

Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or type values, unless otherwise directed, as you will not rece

$1-2.$ Click on cell A$1$ on the Data sheet. Go to the Insert tab and click Recommended PivotTables. Keep the default first pivot table and click OK$.$ Copy the output table from Sheet$1$ and

$\backslash$table$[[$Count of Customer,Column Labels,grad,,$],[$Row Labels,grad Fitness and Strength,Lose Weight,,$],[$Female$,,46,38,84],[$Male$,,47,29,76],[$Grand Total,,$93,67,160]]$

Both names are correct.

$3.$ What do we call the table in cells B$4$:E$8?$ Choose your answer from the dropdown menu in cell F$9.$

$4.$ In cell F$10,$ determine the number of females that go to the gym to lose weight.

$5.$ In cell F$11,$ determine the number of males that go to the gym for fitness and strength.

$6.$ In cell F$12,$ determine the total number of males that were sampled.

$7.$ Go to Sheet$1$ and right$-$click on cell A$3$ in the pivot table. Go to Show Values As and click on $"\%$ of Grand Total". Copy and paste the output table in cells B$14$:E$18.$

$\backslash$table$[[\backslash$table$[[$Count of Customer$],[$Row Labels$]],\backslash$table$[[$Column Labels$],[$Fitness and Strength$]],$Lose Weight,,$],[$Female$,,28\mathrm{.}75\%,23\mathrm{.}75\%,52\mathrm{.}50\%$