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.

The work below uses made-up data. Remember that the values you use in your hypotheses are up to you. You can compare your population parameters to any value; just remember that the sample statistic must agree with your alternate hypothesis. We always try to reject the null hypothesis; that means we must have evidence (via the sample statistic) that the alternate hypothesis is true. Click in the cell to see the formula used. Blank row, Table 1 begins in A8. Blank row, Table 1 begins in A8. Confidence Intervals: Questions 1–4 Question Question Error Lower Limit Upper Limit Conclusion #1 0.56 322 #1 0.055325126 0.504674874 0.61532512598465 We are 95% confident t #2 0.43 322 #2 0.055178986 0.374821014 0.485178986008212 We are 95% confident t #3 0.48 61 #3 0.1279344094 0.3520655906 0.607934409424338 We are 95% confident t #4 0.852 61 #4 0.0909317885 0.7610682115 0.942931788522686 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 Size Question Error Lower Limit Upper Limit Conclusion #5 18.7 1.5 322 #5 0.1671834638 18.532816536 18.8671834637726 We are 95% confident t #6 492.03 136.62 61 #6 34.984797073 457.04520293 527.014797072865 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.5 p < 0.55 z < -1.645 2.15332301339117 #2 p ≤ 0.50 p > 0.50 z > 1.645 -2.51221018228969 #3 p = 0.60 p ≠ 0.60 z < -1.96 or z > 1.96 -0.312409987036266 #4 p ≥ 0.75 p < 0.75 z < -1.645 5.49841577183829 #5 μ = 17 μ ≠ 17 z < -1.96 or z > 1.96 8.37403394096563 #6 μ ≤ 119 μ > 119 z > 1.645 21.3252630405757 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. End of worksheet. Statistical Summary: Question Sample Proportio n Sample Size Sample Mean Sample Std Dev and Ha. IMPORTANT: Be sure you change Test Statistic formul and Ha. Ha. Remember that the values used in the hypotheses are whatever you want; just make sure the sample statistic supports Ha. options. FORMAT HINT: Copy the math notation to another cell using copy , then paste . Right- click in the cell to see these options.