Data management analysis reporting – Empire Essays
Complete parts A – D of question 45 from Chapter 7, page 444, using file P08_07.xlsxPreview the documentView in a new window
P08_07.xlsxPreview the documentView in a new window
Within 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 of
200 service times during the busiest hour of the day
at a particular fast-food restaurant. Find a 95%
confidence interval for each of the following
population parameters. Then explain how each result
might be useful to the manager of the restaurant in
terms of improving service.
a. The mean service time
b. The standard deviation of service times
c. The proportion of service times longer than
90 seconds
d. The proportion of service times shorter than
60 seconds
