Need help only with Homework 5 first question! Thank you!

Data Analysis Case Homework 5: QualKote 1. Provide a table of correlations among the variables A23, A31 and A36. Writeup for the regression of A36 as the dependent variable and A23 as the independent variable. id alo a12 123 IET 2.36 3-40 a37 4 1 4 D) 0 + al 7 4 4 3 6 + + 2 3 4 $ 2 2 3 S 1 3 7 5 7 0 3 3 5 6 5 6 7 1 1 5 1 2 2 2 1 1 S S 5 7 6 4 4 3 0 6 5 9 6 0 0 9 4 3 E 4 7 8 9 10 11 5 7 3 E 9 2 3 S 3 3 5 5 3 3 1 3 3 3 4 0 1 0 0 4 S 4 6 4 4 4 E 4 0 4 3 4 1 1 1 6 12 13 7 7 0 4 3 5 S 4 0 6 3 3 4 14 15 16 1 4 ! P 0 0 9 9 3 3 5 2 9 6 $ 5 5 5 4 6 6 4 4 1 2 6 1 6 5 4 18 + + 2 3 3 3 3 2 3 2 1 3 3 0 0 1 0 1 7 3 3 4 + S. 9 9 0 2 6 5 3 4 1 + $ 3 5 2 4 1 1 2 S 4 5 4 4 21 22 23 24 25 26 27 28 29 E 1 1 1 1 1 + 3 3 2 1 4 2 2 3 2 3 2 1 1 4 4 4 4 4 3 3 1 9 0 4 4 3 3 4 5 4 6 7 4 5 4 1 4 7 2 3 0 4 3 4 4 5 5 2 1 3 5 5 5 5 3 6 2 3 2 3 3 2 4 0 0 1 31 32 33 34 35 9 4 0 6 4 5 4 5 3 4 3 1 4 + 9 6 6 1 4 4 6 9 6 4 1 0 5 3 ****?:xd: 7 0 5 3 5 4 9 1 0 18 39 3 3 3 4 4 1 4 + 1 6 0 9 9 9 5 4 4 2 2 1 2 3 2 5 2 2 1 2 2 3 6 $ 5 3 6 4 5 5 4 5 3 5 0 1 3 7 4 5 4 43 44 45 46 47 48 49 4 3 4 1 4 5 4 5 3 5 4 6 5 4 3 3 5 5 3 5 6 7 5 5 4 4 4 1 0 1 0 1 9 9 E 9 0 1 + 4 3 6 6 2 3 2 3 3 3 2 4 3 3 3 3 4 4 2 3 3 3 3 1 5 5 9 9 2 3 3 2 3 3 3 F 1 1 1 52 3 4 5 2 6 4 4 E 5 3 $ 4 ES 0 3 1 3 4 1 1 2 5 54 SS 0 4 4 3 0 4 4 4 5 95 6 99 5 3 0 1 S7 + 9 + 4 Employee Perspectives The plant manager of QualKote Manufacturing is interested in the impact his year-long effort to implement a quality improvement program is having on the satisfaction of his cus- tomers. The plant foreman, assembly-line workers, and engineering staff have closely examined their operations to determine which activities have the most impact on product quality and reliability. Together, the managers and employees have worked to better understand how each particular job affects the final delivered quality of the product as the customer perceives it. To answer his questions about customer satisfaction, the plant manager conducted an internal survey of plant workers and managers using a 7-point Likert scale (endpoints 1 = Strongly Disagree and 7 = Strongly Agree). His plans are to get opinions from within the company first and then do a customer survey on similar topics. He has collected com- pleted surveys from 57 employees. The following are examples of the topics that were covered in the questionnaire: Data from a variety of external sources (customers, competitors, suppliers, etc.) are used in the strategic planning process. Independent variable A10. Customers are involved in the product quality planning process. Independent variable A12. Customer requirements and expectations of the company's products are used in devel- oping strategic plans and goals. Independent variable A17. There is a systematic process to translate customer requirements into new/improved products. Independent variable A23. There is a systematic process to accurately determine customers' requirements and expectations. Independent variable A31. The company's product quality program has improved the level of customer satisfac- tion. Dependent variable A36. . The company's product quality program has improved the likelihood that customers will recommend us. Dependent variable A37. . Gender of the employee responding: Male = 1; Female = 0. Classification variable A40 A multiple regression was run using SPSS with responses of the 57 employees as input to the model. The output is shown in Exhibits 16.19 and 16:20. There is an actual database of QualKote employee responses to these questions available in SPSS format at www.mhhe.com/hair06. The database is labeled C_16_Qualkote MRIA 3e sav. The results indicate there is a statistically significant relationship between the metric dependent variable (A36Satisfaction) and the metric independent variables. The R for the relationship is 67.0. This suggests there are favorable perceptions by employees about the implementation of the quality improvement program. 576 Parts Data Preparation Analysis, and Reporting the Results eXHIBIT 16.19 Descriptive Statistics and Correlations for Variables EN 111 touched 11 DUTERTE The Best EXHIBIT 16.20 Multiple Regression of Satisfaction Variables RENSIS GLEDE Hands-On Exercises 1. Will the results of this regression model be useful to the Qual Kote plant manager? If yes, how? 2. Which independent variables are helpful in predicting A36H-Customer Satisfaction? 3. What other regression models might be examined with the questions from this survey Data Analysis Case Homework 5: QualKote 1. Provide a table of correlations among the variables A23, A31 and A36. Writeup for the regression of A36 as the dependent variable and A23 as the independent variable. id alo a12 123 IET 2.36 3-40 a37 4 1 4 D) 0 + al 7 4 4 3 6 + + 2 3 4 $ 2 2 3 S 1 3 7 5 7 0 3 3 5 6 5 6 7 1 1 5 1 2 2 2 1 1 S S 5 7 6 4 4 3 0 6 5 9 6 0 0 9 4 3 E 4 7 8 9 10 11 5 7 3 E 9 2 3 S 3 3 5 5 3 3 1 3 3 3 4 0 1 0 0 4 S 4 6 4 4 4 E 4 0 4 3 4 1 1 1 6 12 13 7 7 0 4 3 5 S 4 0 6 3 3 4 14 15 16 1 4 ! P 0 0 9 9 3 3 5 2 9 6 $ 5 5 5 4 6 6 4 4 1 2 6 1 6 5 4 18 + + 2 3 3 3 3 2 3 2 1 3 3 0 0 1 0 1 7 3 3 4 + S. 9 9 0 2 6 5 3 4 1 + $ 3 5 2 4 1 1 2 S 4 5 4 4 21 22 23 24 25 26 27 28 29 E 1 1 1 1 1 + 3 3 2 1 4 2 2 3 2 3 2 1 1 4 4 4 4 4 3 3 1 9 0 4 4 3 3 4 5 4 6 7 4 5 4 1 4 7 2 3 0 4 3 4 4 5 5 2 1 3 5 5 5 5 3 6 2 3 2 3 3 2 4 0 0 1 31 32 33 34 35 9 4 0 6 4 5 4 5 3 4 3 1 4 + 9 6 6 1 4 4 6 9 6 4 1 0 5 3 ****?:xd: 7 0 5 3 5 4 9 1 0 18 39 3 3 3 4 4 1 4 + 1 6 0 9 9 9 5 4 4 2 2 1 2 3 2 5 2 2 1 2 2 3 6 $ 5 3 6 4 5 5 4 5 3 5 0 1 3 7 4 5 4 43 44 45 46 47 48 49 4 3 4 1 4 5 4 5 3 5 4 6 5 4 3 3 5 5 3 5 6 7 5 5 4 4 4 1 0 1 0 1 9 9 E 9 0 1 + 4 3 6 6 2 3 2 3 3 3 2 4 3 3 3 3 4 4 2 3 3 3 3 1 5 5 9 9 2 3 3 2 3 3 3 F 1 1 1 52 3 4 5 2 6 4 4 E 5 3 $ 4 ES 0 3 1 3 4 1 1 2 5 54 SS 0 4 4 3 0 4 4 4 5 95 6 99 5 3 0 1 S7 + 9 + 4 Employee Perspectives The plant manager of QualKote Manufacturing is interested in the impact his year-long effort to implement a quality improvement program is having on the satisfaction of his cus- tomers. The plant foreman, assembly-line workers, and engineering staff have closely examined their operations to determine which activities have the most impact on product quality and reliability. Together, the managers and employees have worked to better understand how each particular job affects the final delivered quality of the product as the customer perceives it. To answer his questions about customer satisfaction, the plant manager conducted an internal survey of plant workers and managers using a 7-point Likert scale (endpoints 1 = Strongly Disagree and 7 = Strongly Agree). His plans are to get opinions from within the company first and then do a customer survey on similar topics. He has collected com- pleted surveys from 57 employees. The following are examples of the topics that were covered in the questionnaire: Data from a variety of external sources (customers, competitors, suppliers, etc.) are used in the strategic planning process. Independent variable A10. Customers are involved in the product quality planning process. Independent variable A12. Customer requirements and expectations of the company's products are used in devel- oping strategic plans and goals. Independent variable A17. There is a systematic process to translate customer requirements into new/improved products. Independent variable A23. There is a systematic process to accurately determine customers' requirements and expectations. Independent variable A31. The company's product quality program has improved the level of customer satisfac- tion. Dependent variable A36. . The company's product quality program has improved the likelihood that customers will recommend us. Dependent variable A37. . Gender of the employee responding: Male = 1; Female = 0. Classification variable A40 A multiple regression was run using SPSS with responses of the 57 employees as input to the model. The output is shown in Exhibits 16.19 and 16:20. There is an actual database of QualKote employee responses to these questions available in SPSS format at www.mhhe.com/hair06. The database is labeled C_16_Qualkote MRIA 3e sav. The results indicate there is a statistically significant relationship between the metric dependent variable (A36Satisfaction) and the metric independent variables. The R for the relationship is 67.0. This suggests there are favorable perceptions by employees about the implementation of the quality improvement program. 576 Parts Data Preparation Analysis, and Reporting the Results eXHIBIT 16.19 Descriptive Statistics and Correlations for Variables EN 111 touched 11 DUTERTE The Best EXHIBIT 16.20 Multiple Regression of Satisfaction Variables RENSIS GLEDE Hands-On Exercises 1. Will the results of this regression model be useful to the Qual Kote plant manager? If yes, how? 2. Which independent variables are helpful in predicting A36H-Customer Satisfaction? 3. What other regression models might be examined with the questions from this survey