MAT-FPX2001_TemenMelissa_Assessment4-2

Your assessment must be submitted using this template. Feel free to add additional work at the bottom, but the top must remain. There are five tables in this worksheet: two for statistical summary, two for confidence intervals, and one for hypothesis tests. To find a table quickly, press Ctrl+G. Press the Tab key to move to input areas of the table. Note: See the worksheet named "Example" (in the bottom tab) for examples of how to fill in the yellow boxes. Blank row, Table 1 begins in A8. Blank row, Table 1 begins in A8. Confidence Intervals: Questions 1–4 Question Sample Size Question Error Lower Limit Upper Limit Conclusion #1 0.5232 86 #1 0.1077166308 0.4154833692 0.63091663083359 We are 95% confident t #2 0.6046 86 #2 0.105446744 0.499153256 0.71004674397037 We are 95% confident t #3 0.4418 86 #3 0.1070997709 0.3347002291 0.54889977091587 We are 95% confident t #4 0.53418 86 #4 0.1075805221 0.4265994779 0.64176052205479 We are 95% confident t End of Table 1, blank row. Table 2 begins in F8. End of Table 2, blank row. Table 3 begins in A15. Statistical Summary: Questions 5–6 Confidence Intervals: Questions 5–6 Question Sample Mean Question Error Lower Limit Upper Limit Conclusion #5 8 2.6 86 #5 0.5607304207 7.4392695793 8.56073042065788 We are 95% confident t #6 5 1.4 86 #6 0.301931765 4.698068235 5.30193176496963 We are 95% confident t End of Table 3, blank row. Table 4 begins in F15. End of table, blank row. Table 5 begins in F21. Blank row. Table 4 begins in F15. End of table, blank row. Table 5 begins in F21. Table 5 begins in F21. Hypothesis Tests: Questions 1–6 Question Ho Ha Reject Ho When Test Statistic #1 p =0.8 p≠.8 z < -1.96 or z > 1.96 -6.41734399888303 #2 p=.7 p≠.7 z < -1.96 or z > 1.96 -1.93058066764528 #3 p=.7 p≠.7 z < -1.96 or z > 1.96 -5.2251145533125 #4 p=.4 p≠.7 z < -1.96 or z > 1.96 -3.35564870344802 #5 μ=7 μ≠7 z < -1.96 or z > 1.96 3.56677634442142 #6 μ=4 μ≠4 z < -1.96 or z > 1.96 6.62401321106836 End of table, blank row. Rejection criteria: Left-tailed test, reject Ho when z < -1.645. Right-tailed test, reject Ho when z > 1.645. Two-tailed test, reject Ho when z < -1.96 or z > 1.96. Statistical Summary: Questions 1–4 Sample Proportion Sample Std Dev Sample Size and Ha. IMPORTANT: Be sure you change Test Statistic formul and Ha.

End of worksheet.