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.
You can trust us
We are confident, the best writing service, and we will deliver a high-quality homework to you. If your homework is not of the standard you ordered, your next task comes discounted. One-time only for each purchased work)
Submityourhomework.com is a company that’s driven more to academic excellence than monetary gains. This is why our rates are always low and affordable to all. Our aim is to reach out to as many college students as possible.
Submit a written request and our customer service team will reply back to you as quickly as possible (usually within 10 minutes).
Phone: +1(805) 568 7317