Find Part I II, below
Excel Activity #4 — Chapter 8 Instructions: Find Part I & II, below, utilizing Excel and the Excel skills you ascertained from STAT 1102. Print your results in a well formatted professional manner. All formulas/equations utilized within Excel need be pasted within a Word Document, printed, and submitted with your Excel results (i.e. if you instructed a specific cell within Excel to make a specific calculation, for example Cell C2 is set to “=AVERAGE(range…)”, then on a Word Doc list: Part II – NAPS Data: Lack of sleep costs companies about $18 billion a year in lost productivity, according to the National Sleep Foundation. In recognition of this problem, many companies now make quiet rooms available for employees to take “power naps” during work breaks. A major airline enacted a new policy that encourages employees to take a nap during their breaks. The data lists the number of complaints received from each employee during the 6 months before the nap policy and during the 6 months after the policy change. The airline wants to know if the new napping policy reduced the mean number of customer complaints against their employees. 1. State the null and alternative hypothesis. 2. Run the appropriate test in Excel and give your results appropriately. 3. What is the test statistic and p-value for this test? 4. State your conclusion at ∝=.05. Make sure to express this conclusion in the context of this problem.