Week 6 Reflection (Ch 9) Name: Answer each of the following questions in complete sentences and relate your answers to the context of the problem. : You need to show your work. Use Excel for your...

Answer the questions on the attached word document. Use an excel document to show your work.


Week 6 Reflection (Ch 9) Name: Answer each of the following questions in complete sentences and relate your answers to the context of the problem. : You need to show your work. Use Excel for your calculations, be sure to upload your well-documented Excel and to make note in this file how you arrived at your answers. Chapter 9 Reflection: Annual expenditures for prescription drugs was $838 per person in the Northeast of the country. A sample of 60 individuals in the Midwest showed a per person annual expenditure for prescription drugs of $745. Suppose the population standard deviation is $300. Follow the steps below to develop a hypothesis test to determine whether the sample data support the conclusion that the population annual expenditure for prescription drugs per person is lower in the Midwest than in the Northeast. 1. Formulate the null and alternative hypotheses. State whether this is a one-tailed test (and if so, upper or lower tail) or a two-tailed test. 2. Suppose the significance level is . Explain what this means. 3. Calculate the test statistic. (Hint: Is known or unknown?) 4. Calculate the p-value and make a decision to either reject or to fail to reject . 5. Calculate the critical value(s). Use the test statistic then to make a decision to either reject or to fail to reject . 6. State what your decision means in the context of the problem (prescription expenditure in the Midwest vs. the Northeast).