Excel Activity #4 — Chapter 8Instructions: Find Part I & II, below, utilizing Excel and the Excel skills you ascertained fromSTAT 1102. Print your results in a well formatted professional manner. All formulas/equationsutilized within Excel need be pasted within a Word Document, printed, and submitted with yourExcel results (i.e. if you instructed a specific cell within Excel to make a specific calculation, forexample 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 tothe National Sleep Foundation. In recognition of this problem, many companies nowmake quiet rooms available for employees to take “power naps” during work breaks. Amajor airline enacted a new policy that encourages employees to take a nap during theirbreaks. The data lists the number of complaints received from each employee during the6 months before the nap policy and during the 6 months after the policy change. Theairline wants to know if the new napping policy reduced the mean number of customercomplaints 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 contextof this problem.