Question

Customer Service. A customer service department asks its customers to rate their over-the-phone service on a scale of 1-20 immediately after their service has been completed. The department then matches each customer’s rating with the number of minutes the person waited on hold. The file “Hold” on d2l contains data for the ratings and number of minutes on hold for 20 customers. As demonstrated in the lecture, please create a subset data of size 16 and perform your statistical analysis for the subset data. Please note that the subset data should be a random sample of the given data.

(f) Provide an interpretation for the coefficient of slope.

(g) Construct and interpret a 96% confidence interval for the coefficient of slope.

(h) Compute the residual for the first observation from your sample dataset.

(i) Test to see if there is a significant relationship between the time the customer is on hold and the customer rating. Use α = .04 level of significance.

show work

Minutes	Rating
4	15
8	13
0	18
5	10
6	14
2	16
10	12
3	20
8	17
4	13
2	17
1	19
3	13
4	16
9	12
8	14
5	9
7	15
6	15
7	15

Answer 1

Con = Book1 - Microsoft Excel Page Layout Formulas Data Review View - A AutoSum 4 General 1 Calibri B I - 11 - - A -A Wrap Text Merge & Center - U - E E E EE $ - % , . Cell Styles Insert Delete Format Fill clear Conditional Format Formatting as Table Styles 2 Clear Z Sort & Finc Filter Sele Editing Font Alignment Number Cells Home Insert Cut La Copy Format Painter Clipboard L9 A B 1 Minutes Rating 2 4 8 0 C 15 6 2 10 E F G H SUMMARY OUTPUT Regression Statistics Statistics Multiple R 0.50 R Square 0.25 Adjusted R Square 0.21 Standard Error 2.47 Observations 20 ANOVA | SS MS F Sign F Regression 1 3 7.66 37.66 6.16 Residual 18 110.14 6.12 Total 19 147.8 Coefficients SE t Stat P-value Lower 96.0% Upper 96.0% Intercept 12.43 3.00 4.14 0.00 5.78 19.08 -0.50 0.20 -2.48 0.02 -0.95 -0.05 If the number of person waited time increases by 1 minute, we predict the Rating will Decrease by approximately -0.50 . 3 13.5..6.16 SOE 0.02 8 4 3 5 The 96% Confidance Interval is (-0.95,-0.05) 1 6 Observation h) Residuals -0.925 7 YES, there is a significant relationship between the time the customer is on hold and the customer rating. Use a = .04 level of significance. Because P value is less than 0.04