Statistics Homework Fall 2019

C?) This document I Excel Homework 4 Fall 2019 Use the Excel Homework 4 Tutorial in Canvas or any other sources to answer all of the following questions. This portion of the homework must be attached after the non-Excel portion of Homework 4. All pages of Homework 4 and Excel Homework 4 must be stapled together. A retail store has a goal that the mean wait time of customers in line is not more than 3 minutes. A random sample of wait times collected for 16 customers resulted in a sample mean of 3. l 5 minutes and a sample standard deviation of 0.5 minutes. The level of signicance for this problem is 0.10. 1. Write the null and alternative for this problem. (.1) 2. What assumption must be true about your population since your sample size is small? (.1) (Questions 1-2 can be completed after Lecture 20.) 3. Decide what distribution is appropriate and solve for your test statistic in Excel. Following the pattern in the Excel tutorial, write your own equation for your test statistic in an empty cell in Excel and then solve in Excel. You must handwrite or type the entire equation (including the equals sign) following the pattern in the tutorial. No credit will be given without the equation following the pattern in the tutorial and the test statistic value. (.1) 4. Using the appropriate T.DIST function, nd the pvalue. (You will have to decide if you need area to the right, left, or both tails.) Do not round, make sure you write down all of the decimal places. If you use tables to get the pvalue, you will not get credit. You must handwrite or type the entire function equation (including the equals sign, the function name, and the argument) and the p-value. No credit will be given without the entire equation and the p-value. (.1) 5. Compare your pvalue to alpha and state your decision about rejecting/accepting the null. (.1) 6. Clearly state your conclusion now in terms of the context of the problem. What does this mean about the retail store's goal? (.1) (Questions 3-6 can be completed after Lecture 21.)