managing quality

excel assignment

Chapter 5: Managing Quality DIRECTIONS To generate the key, put the same 4-digit number in the space below that was used in printing out the original assignment. Name: P. KEY 4-digit number 2000 No. of 1 2 3 4 *** KEY Duff Gardens Amusement Park likes to track customer satisfaction levels. Over a course of 15 days, management asked a random sample of guests whether they were happy or unhappy with their overall experience. The sample results are shown below. Sample unhappy Sample Size Fuests 30 2 30 30 30 30 6 30 7 30 8 30 9 30 10 30 11 30 12 30 13 30 14 30 15 30 In the space below, set up the p chart required to track the proportion of dissatisfied guests Round your p value to three decimal points (ex. -0,067 - 6.7%) ALSO, answer the following question in one or two sentences: What should Duff Gardens do if a future sample falls above the UCL? 1 1 1 1 1 1 2 2 2 2 1 1 2 2