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 OFF MAP ... Starbucks.xIsx - Read-Only Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Av L8 Queries & Connections Group III 21 7 2 % Clear Flash Fill to Data Validation v + Analysis Tools Properties Reapply Ungroup Get Data from Refresh Stocks Geography J Sort Filter Text to Remove Duplicates = Consolidate What-If Data Analysis Data Picture All Edit Links Advanced Columns Analysis Subtotal S2 X V fx E H I K L M N 0 P Q R S U V W X Viscosity Pressure Plate Gap SUMMARY OUTPUT 350.00 180.00 0.00 1 B 350.00 170.00 0.00 Regression Statistics 319.00 186.0 1.80 Multiple R 0.75196 O VOUIDWNH 380.00 174.0 1.80 Square 0.5654555: 350.00 180.00 0.00 Adjusted R Square 0.47854661 300.00 180.0 ).00 Standard Error 0.91357272 400.00 180.00 0.00 Observations 19 350.00 190.00 0.00 350.00 180.0 0.00 ANOVA 319.00 186.00 -1.80 SS MS Significance F 380.00 186.0 1.80 Regression 3 16.29077331 5.430258 6.506302 0.00490626 350.00 180.00 3.00 Residual 12.51922669 0.834615 14 380.00 174.00 1.80 Total 18 28.81 15 350.00 180.0 0.00 16 350.00 180.00 -3.00 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% 17 319.00 174.00 1.80 Intercept -18.691481 7.978947802 -2.3426 0.033354 -35.6982053 -1.68476 -35.6982053 -1.684756 18 319.00 174.00 1.80 Viscosity 0.01213518 0.008189885 1.481728 0.159114 -0.00532114 0.029592 -0.00532114 0.02959151 19 380.00 186.00 1.80 Pressure 0.08442623 0.041355494 2.041476 0.059202 -0.00372092 0.172573 -0.00372092 0.17257338 20 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 22 19.20133175 24 25 26 27 28 29 30 31 35 36 37 38 39 40 41 42 Zoom Out DATA B C D E F G H + Enter + 100%