Question

1) (13 pts) A survey of firefighters and other responders (police, EMT, etc.) in New York is shown in the table below. Participated in 9/11 rescue Did not participate Total No alcohol problems 705 455 1160 Moderate to Severe alcohol problems 385 110 495 Total 1090 565 1655 Does the data provide evidence, at 5%, to show alcohol problems are dependent on 9/11 participation? a) Which hypothesis test would you use here? Explain. b) Calculate the Expected values. You can use your calculator or formulas in sheets. Create a new table for expected values and copy to your report. c) Based on the expected values, does it seem alcohol problems are dependent on 9/11 participation? Explain. d) Are the requirements met for a hypothesis test? Explain. e) Now we’ll compute a hypothesis test. State the null and alternative hypotheses to be tested and significance level. Label as steps 1 and 2. f) Steps 3 and 4. Calculate the test statistic and P-value by doing the following. Use this Chi Square Independence Calculator. Do not copy totals into the calculator. Copy and paste to your report with a screenshot. g) Write out the conclusions (steps 5 & 6) h) Create two pie charts of the data. Copy the data (without the totals) into sheets. Highlight all of the data. Choose Insert > Chart > Pie Chart. In the chart menu, choose the following options: 🔲 Switch rows / columns ✅ Use row 1 as headers ✅ Use column 1 as labels Scroll down to Value in the menus. Create a Pie Chart for "Participated in 9/11 Rescue." Add an appropriate title and include your name. Copy the graph to your report. i) Change Value to "Did not Participate" to create a second pie chart. Add an appropriate title and include your name. Copy the graph to your report. j) What do these results tell you about alcohol problems and firefighters participating in 9/11?

1) (13 pts) A survey of firefighters and other responders (police, EMT, etc.) in New York is shown in the table below.

Participated in 9/11 rescue

Did not participate

Total

No alcohol problems

705

455

1160

Moderate to Severe alcohol problems

385

110

495

Total

1090

565

1655

Does the data provide evidence, at 5%, to show alcohol problems are dependent on 9/11 participation?

a) Which hypothesis test would you use here? Explain.

b) Calculate the Expected values. You can use your calculator or formulas in sheets. Create a new table for expected values and copy to your report.

c) Based on the expected values, does it seem alcohol problems are dependent on 9/11 participation? Explain.

d) Are the requirements met for a hypothesis test? Explain.

e) Now we’ll compute a hypothesis test. State the null and alternative hypotheses to be tested and significance level. Label as steps 1 and 2.

f) Steps 3 and 4. Calculate the test statistic and P-value by doing the following. Use this Chi Square Independence Calculator. Do not copy totals into the calculator. Copy and paste to your report with a screenshot.

g) Write out the conclusions (steps 5 & 6)

h) Create two pie charts of the data. Copy the data (without the totals) into sheets. Highlight all of the data. Choose Insert > Chart > Pie Chart.

In the chart menu, choose the following options:

🔲 Switch rows / columns

✅ Use row 1 as headers

✅ Use column 1 as labels

Scroll down to Value in the menus. Create a Pie Chart for "Participated in 9/11 Rescue." Add an appropriate title and include your name. Copy the graph to your report.

i) Change Value to "Did not Participate" to create a second pie chart. Add an appropriate title and include your name. Copy the graph to your report.

j) What do these results tell you about alcohol problems and firefighters participating in 9/11?

Added by Suki C.