Your assessment must tted using this template. Feel tional w 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 Ctri+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. Statistical Summary: Questions 1-4 Confidence Intervals: Questions 1-4 Question Sample Proportion Sample Size Question Error |Lower Lim Upper Limit Conclusion #1 0.64 37 #1 0.157823028 0.482176972 0.797823028 We are 95% confident the true population proportion is between 0.482 and 0.798 #2 0.38 36 #2 0.161795481 0.218204519 0.541795481 We are 95% confident the true population proportion is between 0.218 and 0.542. #3 0.48 37 #3 0.164267415 0.315732585 .64426741 We are 95% confident the true population proportion is between 0.316 and 0.644. HA 0.51 37 HA 0.164366104 0.345633896 0.674366104 We are 95% confident the true population proportion is between 0.346 and 0.674. Statistical Summary: Questions 5-6 Confidence Intervals: Questions 5- Sample Question Sample Mean Sample Std Dev Size Question Error Lower Lim Upper Limit Conclusion #5 11.56 2.499 0.821666139 10.73833386 12.38166614 We are 95% confident the true population proportion is between 10.738 and 12.382. #6 1.405 1.344 37 #6 0.441904478 0.963095522 1.846904478 We are 95% confident the true population proportion is between 0.963 and 1.847. Hypothesis Tests: Questions 1-6 Question Ho Ha Reject Ho When Test Statistic Decision Summary #1 20.32 P 0.12 z1.96 -1.44 Do not Reject Ho There is not sufficient statistical evidence to show the population proportion is less than 034. #3 =0.23 p #0.23 Z1.645 -3.371409201 Reject Ho There is not sufficient statistical evidence to show the population proportion is greater than 0.52. #5 H =9.2 H #9.2 z>1.645 13.24138782 Reject There is not sufficient statistical evidence to show the population proportion is greater than 0.52. U S1.2 H >1.2 z1.96 -532.2190921 Do not Reject Ho There is not sufficient statistical evidence to show the population proportion is less than 034. Rejection criteria: IMPORTANT: Left-tailed test, reject Ho when z 1.645. Statistic formula to reflect what you put in Ho and Ha. Two-tailed test, reject Ho when z 1.96