stat analysis homework and excel lab

DS 123 – Lab Assignment # 3

Chaffe-Stengel, Fall 2016

Hypothesis tests: z-tests of one population mean and proportion

1. Read Problem 9.14 on page 355. Assuming the population standard deviation, , is equal to 2.47,

a. Use the Data Analysis Toolkit to find the descriptive statistics for the sample data.

b. Conduct 5-part formal hypothesis tests side-by-side, on the left in the z-statistic and on the right in the p-value, to test whether the new system has reduced the mean waiting time to less than six minutes. Use a 98% level of confidence.

2. Read Problem 9.42 on pages 365 – 6. In light of the manufacturer’s claim that at least 95% of its television sets last at least five years without repair, conduct 5-part formal hypothesis tests side-by-side, on the left in the z-statistic and on the right in the p-value, to test whether there is sufficient evidence to conclude with 99% confidence that the manufacturer’s claim is not true.

This assignment is due September 21.