Data Analytics (3) Soobin yoon 10/13/20 5:51 A S Homework: Chapter 4 Assignment 2 core: 0 of 1 pt 15 of 15 (7 complete) HW Score: 37.54%, 5.63 of 15 7.11.71 Question Help A producer of computer-aided design software for the aerospace industry receives numerous calls for technical support Tracking software is used to monitor response and resolution times. In addition, the company surveys customers who request support using the scale: 0 Did not meet expectations 1-Marginally met expectations, 2. Met expectations, 3 Exceeded expectations, 4. Greatly exceeded expectations. The questions are 01: Did the support representative explain the process for resolving your problem? 02: Did the support representative keep you informed about the stafus of progress in resolving your problem? 03. Was the support representative courteous and professional? 04 Was your problem resolved? 05. Was your problem resolved in an acceptable amount of time? 06. Overall, how did you find the service provided by our technical support department? A final question asks the customer to rate the overall quality pf the product using a scale: O very poor, 1-poor, 2-good, 3 very good. 4. excelent. A sample of survey responses and associated resolution and response data are provided in the accompanying Customer Support Survey data. Use whatever Excel tools you deem appropriate to analyze these sample data and write a report to the manager explaining your findings and conclusions Click the icon to view the insurance survey data The means for the ratio variable, 01, 02, 03, 04, 05, 06, and Software are between and I (Use ascending order. Round to two decimal places as needed) NC Enter your answer in the ed elds and then click Check Answer 1 per remaining Clear A Check Answer . 3 A B D Q3 E F H Q1 1 1 Q4 25 90 M N 2 3 0 0.36 2 Q2 3 2 2 4 4 3 4 2 2 2 4 4 2 2 2 2 4 4 5 4 6 7 2 2 3 4 4 3 4 4 4 4 4 3 4 3 2 EEEE 8 4 4 6 E 10 4 3 4 4 3 3 3 4 3 + 3 11 3 1 4 12 1 1 1 E 13 E 1 3 4 4 4 1 EEEE 4 4 14 15 16 4 4 3 3 4 3 E G Software Service In Engineer Resolutior Response Time (min) 2 3 1.667 2 20 2 2 2 2 7.99 12 2 2 2 2.333 0.01 12 4 1 4 4 0.05 19 4 3 4 4 71.68 118 3 4 2.667 0.65 22 4 3 4 4 0.96 2 3 3 3.333 0.91 13 3 3 3.667 3.333 2.43 28 4 4 3.333 3.667 0.01 11 1 1 1 48.92 2 2 3 2.333 24.31 11 4 4 4 4 0.03 13 2 3.667 3 0.05 21 3 3 3 0.02 13 4 4 4 4 1.16 12 4 3 4 4 0.1 61 2 3 2 2 0.03 13 3. 3 3.333 0.03 25 4 4 4 4 0.15 47 4 4 4 4 0.02 2 4 3 2667 3.667 0.06 19 4 4 4 5.96 33 3 3 2.96 11 3 2333 3 0.05 33 4 4 3.667 4 5.35 17 4 4 4 4 6.16 29 1 2 1.667 0.03 31 3 3 3 7.08 25 4 4 4 0.01 5 E E 17 4 1B 4 4 3 3 4 4 2. 2 4 4 3 4 19 4 4 2 3 4 4 3 4 4 2 2 4 4 2. 4 3 4 4 2 4 4 2 20 E EEEZ 4 22 4 4 3 E 24 4 E 3 3 E 4 3 3 E E 25 26 27 28 2 3 2 4 E 4 4 3 3 4 4 3 3 4 4 3 4 4 4 4 2 29 1 EEEZ 30 2 3 3 E 3 4 31 3 2 4 E EEEE 3 32 EE 80 010 011 012 013 014 015 . 2 0 C Data Analytics (3) Soobin yoon 10/13/20 5:51 A S Homework: Chapter 4 Assignment 2 core: 0 of 1 pt 15 of 15 (7 complete) HW Score: 37.54%, 5.63 of 15 7.11.71 Question Help A producer of computer-aided design software for the aerospace industry receives numerous calls for technical support Tracking software is used to monitor response and resolution times. In addition, the company surveys customers who request support using the scale: 0 Did not meet expectations 1-Marginally met expectations, 2. Met expectations, 3 Exceeded expectations, 4. Greatly exceeded expectations. The questions are 01: Did the support representative explain the process for resolving your problem? 02: Did the support representative keep you informed about the stafus of progress in resolving your problem? 03. Was the support representative courteous and professional? 04 Was your problem resolved? 05. Was your problem resolved in an acceptable amount of time? 06. Overall, how did you find the service provided by our technical support department? A final question asks the customer to rate the overall quality pf the product using a scale: O very poor, 1-poor, 2-good, 3 very good. 4. excelent. A sample of survey responses and associated resolution and response data are provided in the accompanying Customer Support Survey data. Use whatever Excel tools you deem appropriate to analyze these sample data and write a report to the manager explaining your findings and conclusions Click the icon to view the insurance survey data The means for the ratio variable, 01, 02, 03, 04, 05, 06, and Software are between and I (Use ascending order. Round to two decimal places as needed) NC Enter your answer in the ed elds and then click Check Answer 1 per remaining Clear A Check Answer . 3 A B D Q3 E F H Q1 1 1 Q4 25 90 M N 2 3 0 0.36 2 Q2 3 2 2 4 4 3 4 2 2 2 4 4 2 2 2 2 4 4 5 4 6 7 2 2 3 4 4 3 4 4 4 4 4 3 4 3 2 EEEE 8 4 4 6 E 10 4 3 4 4 3 3 3 4 3 + 3 11 3 1 4 12 1 1 1 E 13 E 1 3 4 4 4 1 EEEE 4 4 14 15 16 4 4 3 3 4 3 E G Software Service In Engineer Resolutior Response Time (min) 2 3 1.667 2 20 2 2 2 2 7.99 12 2 2 2 2.333 0.01 12 4 1 4 4 0.05 19 4 3 4 4 71.68 118 3 4 2.667 0.65 22 4 3 4 4 0.96 2 3 3 3.333 0.91 13 3 3 3.667 3.333 2.43 28 4 4 3.333 3.667 0.01 11 1 1 1 48.92 2 2 3 2.333 24.31 11 4 4 4 4 0.03 13 2 3.667 3 0.05 21 3 3 3 0.02 13 4 4 4 4 1.16 12 4 3 4 4 0.1 61 2 3 2 2 0.03 13 3. 3 3.333 0.03 25 4 4 4 4 0.15 47 4 4 4 4 0.02 2 4 3 2667 3.667 0.06 19 4 4 4 5.96 33 3 3 2.96 11 3 2333 3 0.05 33 4 4 3.667 4 5.35 17 4 4 4 4 6.16 29 1 2 1.667 0.03 31 3 3 3 7.08 25 4 4 4 0.01 5 E E 17 4 1B 4 4 3 3 4 4 2. 2 4 4 3 4 19 4 4 2 3 4 4 3 4 4 2 2 4 4 2. 4 3 4 4 2 4 4 2 20 E EEEZ 4 22 4 4 3 E 24 4 E 3 3 E 4 3 3 E E 25 26 27 28 2 3 2 4 E 4 4 3 3 4 4 3 3 4 4 3 4 4 4 4 2 29 1 EEEZ 30 2 3 3 E 3 4 31 3 2 4 E EEEE 3 32 EE 80 010 011 012 013 014 015 . 2 0 C