The managers for a sample of stores maintain that their businesses are doing better this year despite relatively flat sares. They argue that they've been able to reduce costs through more efficient staffing and inventory management. Using the data provided in the file, determine if the average weekly profits for one quarter increased for these stures over the past year (from year 1 to year 2). Do your results support the clair of the store managers at the 957: level?! The managers for a sample of stores maintain that their businesses are doing better this year despite relatively flat sales. They argue that they've been ableto reduce costs through more efficient staffing and inventory management. Using the data provided in the file, determine if the average weekly profits for pine quarter increased for these stores over the past year (from year 1 to year-2): Do your results support the daim of the store managers at the 93%% level? Upload your work (calculations) for this question (subpart: b,c) on a separate sheet In the Excel file according to the instructions provided in the exam instructions, la) State the null and the alternative hypothesis. [h) What is the value of the test statisticf Show all your work in the Excel file to receive a grace! Trul Statistics: [Report only numerical values in two decimal places) (r) Using the Corel, answer the following questions: L Report the p-valur= (Report only numerical values in three decimal places) it Using the 95% confidence level. decide whether you have evidence to reject or failto reject the null hypothesis Decision: at a Report only numerical values in two decimal places, because p-value in, Write a onclusion about ily based on the evidence of the test. Answer: At a significance level of Report only numerical values in two decimal places), we mare sufficient evidence to condude that the average wee dy sales have this past year for stores in this chain