AutoSave OFF A A . CGP ... w Assignment12 - Read-Only - Saved to my Mac Home Insert Draw Design Layout References Mailings Review N ? Tell me Share Comments A A Aa Ap AaBbCcDdE AaBbCcDdE AaBbCcDc AaBbCcDdEE AaBb( AaBbCCDdEE Paste BI U vab X X|A D V A v Norma No Spacing Heading 1 Heading 2 Title Subtitle Styles Dictate Editor Pane * Read Only To save a copy of this document, click Duplicate. Duplicate Chapter 14 Multiple Regression Starbucks Coffee Co. uses a data-based approach to improving the quality and customer satisfaction of its products. When survey data indicated that Starbucks need to improve its package sealing process, an experiment was conducted to determine the factors in the bag-sealing equipment that might be affecting the ease of opening the bag without tearing the inner liner of the bag. (Data extracted from L. Johnson and S. Burrows, "For Starbucks, It's in the Bag," Quality Progress, March 201 1, pp. 17-23.) Among the factors that could affect the rating of the ability of the bag to resist tears were the viscosity, pressure, and plate gap on the bag-sealing equipment. Data were collected on 19 bags in which the plate gap was varied and stored in Starbucks. xIsx. Develop a multiple regression model that uses the viscosity, pressure, and plate gap on the bag-sealing equipment to predict the tear rating of the bag. Be sure to perform a thorough residual analysis. multiple r b. Interpret the meaning of the slopes in this equation. c. Predict the tear rating of the bag with viscosity of 330, pressure of 180 and plate gap of 0. d. Perform a residual analysis on your results and determine whether the regression assumptions are valid. e. Determine whether there is a significant relationship between tear rating and viscosity at the 0.05 level of significance. f. Determine whether there is a significant relationship between tear rating and all the independent variables at the 0.05 level of significance. g. Interpret the meaning of the coefficient of multiple determination in this problem h. Do you think that you need to use all three independent variables in the prediction model? Explain Page 1 of 1 287 words English (United States) Focus E + 100%AutoSave O OFF W A P ... Starbucks.xlsx - Read-Only Q Home Insert Draw Page Layout Formulas Data Review View Shape Format ? Tell me Share Comments Calibri (Body) v 11 AA = E ab Wrap Text General ZY AP - O. IN Paste BIUV E Merge & Center $ ~ % 9 408 28 Conditional Format Cell Insert Delete Format Sort & Analyze Formatting as Table Styles DV Find & Filter Select Data TextBox 2 fx E H J K L M N 0 P Q R S T U V W X Tear Viscosity Pressure Plate Gap SUMMARY OUTPUT 0.00 350.00 180.00 0.00 0.00 350.00 170.00 0.00 Regression Statistics 0.45 319.00 186.0 1.80 Multiple R 0.75196 0.85 380.00 174.0 1.80 Square 0.5654555 0.35 350.00 180.00 0.00 Adjusted R Square 0.47854661 0.30 300.00 180.0 .00 Standard Error 0.91357272 1C 19.20133 0.70 400.00 180.00 0.00 Observations 19 1.90 350.00 190.00 0.00 10 0.25 350.00 180.0 0.00 ANOVA 11 0.10 319.00 186.00 -1.80 df SS MS Significance F 0.15 380.00 186.0 -1.80 Regression 3 16.29077331 5.430258 6.506302 0.00490626 13 3.90 350.00 180.00 3.00 Residual 12.51922669 0.834615 14 0.00 380.00 174.00 -1.80 Total 18 28.81 15 0.55 350.00 180.0 0.00 16 0.00 350.00 180.00 -3.00 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% 1b. slope coefficient of -18.691481 is an indication 17 0.05 319.00 174.00 1.80 Intercept -18.691481 7.978947802 -2.3426 0.033354 -35.6982053 -1.68476 -35.6982053 -1.684756 that when all the dependent variables are zero, the 18 0.40 319.00 174.00 1.80 Viscosity 0.01213518 0.008189885 1.481728 0.159114 -0.00532114 0.029592 -0.00532114 0.02959151 expected tear rating is -18.691481 19 4.30 380.00 186.00 1.80 Pressure 0.08442623 0.041355494 2.041476 0.059202 -0.00372092 0.172573 -0.00372092 0.17257338 1c the tear rating would be 19.20133 20 0.00 350.00 180.00 0.00 Plate Gap 0.5 0.137851646 3.627088 0.002484 0.20617617 0.793824 0.206176172 0.79382383 21 1d 22 23 le The p-value velocityis .1591 which is greater tha 24 the .05% level of significance, so the association 25 between velocity and tear rating is statistically 26 insignificant. 27 if The p-value of the pressureis .059202 which is 28 greater than the .05% level of significance 29 The p-value of the plate gap coefficient is .0o2484 30 which is less than the. 05% level of significance there 31 no significant relationship 1g The R-squared value of .5655which means that 56.55% of the observations best fitted the regression 35 model, this is below75% so inferences based on the 36 model cannot be relied on to infer about the whole population. 37 38 1h no you only need to use only plate gap can be us 39 as significant, but 40 41 42 DATA + Ready + 100%