7.24 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 following scale: 0â€”did not exceed expectations; 1â€”marginally met expectations; 2â€”met expectations; 3â€”exceeded expectations; 4â€”greatly exceeded expectations. The questions are as follows:
Q1: Did the support representative explain the process for resolving your problem?
Q2: Did the support representative keep you informed about the status of progress in resolving your problem?
Q3: Was the support representative courteous and professional?
Q4: Was your problem resolved?
Q5: Was your problem resolved in an acceptable amount of time?
Q6: Overall, how did you find the service provided by our technical support department?
A final question asks the customer to rate the overall quality of the product using a scale of 0â€”very poor; 1â€”poor; 2â€”good; 3â€”very good; 4â€”excellent. A sample of survey responses and associated resolution and response data are provided in the Excel file Customer Support Survey [Attached].
The company has set a service standard of 1 day for the mean resolution time. Does evidence exist that the response time is more than 1 day? How do the outliers in the data affect your result? What should you do about them?
Test the hypothesis that the average service index is equal to the average engineer index.
7.35For the data in the Excel file Graduate School Survey, perform a chi-square test for independence to determine if plans to attend graduate school are independent of gender.
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount! Use Discount Code “Newclient” for a 15% Discount!NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.
The post excel-questions-file-attached appeared first on Essay Fount.
What Students Are Saying About Us.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐
"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."