Data management analysis reporting

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