Homework Help is Here – Start Your Trial Now!
Math
Statistics
- Please complete all work in excel. Use excel to make any necessary calculations and be sure to identify your answer, including units (if necessary). 1) A manager of a call center has noticed customer survey ratings on a scale of 1 being extremely dissatisfied to 10 being extremely satisfied have been getting worse lately and wants to understand the factors that could be impacting the ratings. The first thing the manager looks at is the data on customer wait time on the phone prior to being assisted by a customer service representative. Customer Satisfaction Wait time in minutes 1. 15 4 3 16 4 6. 9. 17 6. 11 8. a. What is the regression equation? b. Use the model to forecast customer satıstaction if someone waited 8 minutes. c. Is the model statistically significant at the .05 level? d. How much of the variability in customer satisfaction is determined by wait time in minutes?

- Please complete all work in excel. Use excel to make any necessary calculations and be sure to identify your answer, including units (if necessary). 1) A manager of a call center has noticed customer survey ratings on a scale of 1 being extremely dissatisfied to 10 being extremely satisfied have been getting worse lately and wants to understand the factors that could be impacting the ratings. The first thing the manager looks at is the data on customer wait time on the phone prior to being assisted by a customer service representative. Customer Satisfaction Wait time in minutes 1. 15 4 3 16 4 6. 9. 17 6. 11 8. a. What is the regression equation? b. Use the model to forecast customer satıstaction if someone waited 8 minutes. c. Is the model statistically significant at the .05 level? d. How much of the variability in customer satisfaction is determined by wait time in minutes?

MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
See similar textbooks
icon
Related questions
Question
:- Please complete all work in excel. Use excel to make any necessary calculations and be sure to identify your answer, including units (if necessary). 1) A manager of a call center has noticed customer survey ratings on a scale of 1 being extremely dissatisfied to 10 being extremely satisfied have been getting worse lately and wants to understand the factors that could be impacting the ratings. The first thing the manager looks at is the data on customer wait time on the phone prior to being assisted by a customer service representative. Customer Satisfaction Wait time in minutes 15 4 3 16 7 4 б 3 17 11 8. 4 a. What is the regression equation?. b. Use the model to forecast customer satıstaction if someone waited 8 minutes. Is the model statistically significant at the .05 level? С. d. How much of the variability in customer satisfaction is determined by wait time in minutes? 2) The manager wonders if there are any other variables that could better predict customer service ratings. The following data is collected is added to the original data set. # of employees customer spoke to in the call Problem solved (Y or N) Customer Wait time in Satisfaction minutes 1 15 Y 9. 4 1 Y 16 4 Y 7 1 4 9. 17 4 N. 6 11 3 8 2 Y 9. 4 1 Y a. What variables should be kept in the model and why? b. What is the regression equation (only include variables that should be in the model)? c. What is the customer satisfaction rating forecast for an 8 minute wait time when 2 employees speak to the customer and the problem is solved?
Transcribed Image Text::- Please complete all work in excel. Use excel to make any necessary calculations and be sure to identify your answer, including units (if necessary). 1) A manager of a call center has noticed customer survey ratings on a scale of 1 being extremely dissatisfied to 10 being extremely satisfied have been getting worse lately and wants to understand the factors that could be impacting the ratings. The first thing the manager looks at is the data on customer wait time on the phone prior to being assisted by a customer service representative. Customer Satisfaction Wait time in minutes 15 4 3 16 7 4 б 3 17 11 8. 4 a. What is the regression equation?. b. Use the model to forecast customer satıstaction if someone waited 8 minutes. Is the model statistically significant at the .05 level? С. d. How much of the variability in customer satisfaction is determined by wait time in minutes? 2) The manager wonders if there are any other variables that could better predict customer service ratings. The following data is collected is added to the original data set. # of employees customer spoke to in the call Problem solved (Y or N) Customer Wait time in Satisfaction minutes 1 15 Y 9. 4 1 Y 16 4 Y 7 1 4 9. 17 4 N. 6 11 3 8 2 Y 9. 4 1 Y a. What variables should be kept in the model and why? b. What is the regression equation (only include variables that should be in the model)? c. What is the customer satisfaction rating forecast for an 8 minute wait time when 2 employees speak to the customer and the problem is solved?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman
SEE MORE TEXTBOOKS