Complete parts A – D of question 45 from Chapter 7, page 444, using file P08_07.xlsxPreview the documentView in a new windowP08_07.xlsxPreview the documentView in a new windowWithin the spreadsheet, include a brief explanation of what the data is telling you. No Word document is required for this assignment.45. The file P08_07.xlsx contains a random sample of200 service times during the busiest hour of the dayat a particular fast-food restaurant. Find a 95%confidence interval for each of the followingpopulation parameters. Then explain how each resultmight be useful to the manager of the restaurant interms of improving service.a. The mean service timeb. The standard deviation of service timesc. The proportion of service times longer than90 secondsd. The proportion of service times shorter than60 seconds
