Project 6-1: Create and Interpret a Pareto Chart Project Description: A Pareto chart is a specialized version of a histogram that ranks the categories mom most frequent to least frequent. A Pareto chart provides an improvement team with information that helps them focus improvement efforts on the vital few problems rather than the trivial many. In this project you'll create a Pareto chart from measurement data and interpret the results. Instructions 1. The data in the tabular report below were obtained from satisfaction surveys distributed to patients who had undergone a procedure in an ambulatory surgery center. The complaints are sorted into seven different categories (listed in the first column). In the second column is the number of times a patient complained about this particular aspect of their healthcare experience at the surgery center. Data were gathered over a 12-month time period. Patient Complaints about Their Ambulatory Surgery Experience Complaint Category Frequency of Response Too Noisy in Unit 257 Inconvenient Parking 190 Discharge Instructions Unclear Admitting Process too Slow 38 Unable to Schedule Preop Tests in Evenings 296 Discharged too Soon 86 All Others Grand Total 955 48 40 2. Construct a Pareto chart from the data in the report. To create the chart you'll need to calculate the percent of total and cumulative percent for each complaint category. Use the form below to record the numeric results of your calculations. Cumulative Percent Complaint Category Too Noisy in Unit Inconvenient Parking Discharge Instructions Unclear Admitting Process too Slow Unable to Schedule Preop Tests in Evenings Discharged too Soon All Others Grand Total Percent Frequency of Total 257 26.01 190 114,90 48 5.03 3,98 296 130.99 86 9.00 404 .19 955 100 38 100 3. After creating the Pareto chart analyze the results and write a short narrative report identifying the complaints that need to be addressed first by the surgery center. Specifically, which complaints, if resolved, are likely to eliminate almost 78 percent of patient complaints about the surgery center