supply chain: ch10

Part 2) Complete question 26 (page 346 of 6 th edition) - 5 pts Problem 26.xlsx - create a p-chart based on the data in the file "Problem 26.xlsx" - answer the question, "what comments can you make about this data?" You are the newly appointed assistant adminstrator at a local hospital, and your first project is to investigate the quality of the patient meals put out by the food-service department. You conducted a 10-day survey by submitting a simple questionnaire to the 400 patients with each meal, asking that they simply check off that the meal was either satisfactory or unsatisfactory. For simplicity in this problem, assume that the response was 1,000 returned questionnaires from the 1,200 meals each day. The results were as follows: Construct a p-chart based on the questionnaire results, using a confidence interval of 95.5%, which is 2 standard deviations. What comments can you make about the process