Question: Copy the following three tables in your word document: Model Summary; ANOVA and Coefficients. Interpret the analysis by examining all four values in your Model

Copy the following three tables in your word

Copy the following three tables in your word

Copy the following three tables in your word

Copy the following three tables in your word

Copy the following three tables in your word document: Model Summary; ANOVA and Coefficients. Interpret the analysis by examining all four values in your Model Summary Table. Next, explain the results in the ANOVA table. Finally, explain your findings by discussing the Unstandardized and Standardized variables in the Coefficients table. Which of the three independent variables is most important? Which one is least important in explaining Customer Satisfaction with Santa Fe Grill? Model Summary R Favorite Mexican Restaurants Santa Fe Grill Adjusted R Std. Error of Model (Selected) R Square Square the Estimate 1 .799 638 .834 .813 a Predictors: (Constant), X15 - Fresh Food, X12 - Friendly Employees, X14 - Large Size Portions ANOVA Sig Sum of Model Squares Mean Square F 1 Regression 165.338 55.113 146.571 000* Residual 93.627 249 376 Total 258.964 252 a Dependent Variable X22 - Satisfaction b. 8electing only cases for which Favorite Mexican Restaurante Santa Fe Grill c. Predictors: (Constant), X15 - Fresh Food, X12 - Friendly Employees, X14 - Large Size Portions Coefficients ab t Sig -1.056 10.077 292 000 Standardized Unstandardized Coefficients Coefficients Model B Std Error Beta (Constant - 246 233 X12 - Friendly 043 410 Employees X14 - Large Size 124 .029 .183 Portions X15 - Fresh Food 559 036 .646 a. Dependent Variable: X22 - Satisfaction b.Selecting only cases for which Favorite Mexican Restaurant - Santa Fe Grill 4.319 000 15.493 000 The last part of the assignment is to develop a regression model for Santa Fe Grill customers only to determine the variables that can help explain customer satisfaction with the Santa Fe Grill. Your dependent variable is Satisfaction (X22). For the independent variables we select variables X12 (Friendly Employees), X14 (Large Size Portions), X15 (Fresh Food). You need to use the Regression command then select Linear. At the next screen (see image below), place the dependent variable in the appropriate section, next place the variables X12, X14, and X15 in the section for Independent(s): variables. Finally, place X_S4 (Favorite Mexican Restaurant) in the Selection Variable panel and use the Rule = 1 to select Santa Fe Grill. At this point you're ready to run the Regression Analysis. Linear Regression Dependent Statistics Plots Block 1 of 1 Save... NE PUS Independentis): golions Bootstrap.. Da Regularly Dine at Have Dined att Gross Annual Inc. Favorite Mexican PIO X1 - Try New and ALEX2 - Party Perso OX3 - People Co. X4 Avoid Fried X5-Likes to Go 40 X6 - Friends Co X7-Self-Confide X8 - Eat Balance X9 - Buy New Pr. X10 - Careful ab X114. Try New Br. X12 -Friendly E X13-Fun Placet Method Enter Selection Variable R Case Labels WLS Weight Reset Cancel Help Copy the following three tables in your word document: Model Summary; ANOVA and Coefficients. Interpret the analysis by examining all four values in your Model Summary Table. Next, explain the results in the ANOVA table. Finally, explain your findings by discussing the Unstandardized and Standardized variables in the Coefficients table. Which of the three independent variables is most important? Which one is least important in explaining Customer Satisfaction with Santa Fe Grill? Model Summary R Favorite Mexican Restaurants Santa Fe Grill Adjusted R Std. Error of Model (Selected) R Square Square the Estimate 1 .799 638 .834 .813 a Predictors: (Constant), X15 - Fresh Food, X12 - Friendly Employees, X14 - Large Size Portions ANOVA Sig Sum of Model Squares Mean Square F 1 Regression 165.338 55.113 146.571 000* Residual 93.627 249 376 Total 258.964 252 a Dependent Variable X22 - Satisfaction b. 8electing only cases for which Favorite Mexican Restaurante Santa Fe Grill c. Predictors: (Constant), X15 - Fresh Food, X12 - Friendly Employees, X14 - Large Size Portions Coefficients ab t Sig -1.056 10.077 292 000 Standardized Unstandardized Coefficients Coefficients Model B Std Error Beta (Constant - 246 233 X12 - Friendly 043 410 Employees X14 - Large Size 124 .029 .183 Portions X15 - Fresh Food 559 036 .646 a. Dependent Variable: X22 - Satisfaction b.Selecting only cases for which Favorite Mexican Restaurant - Santa Fe Grill 4.319 000 15.493 000 The last part of the assignment is to develop a regression model for Santa Fe Grill customers only to determine the variables that can help explain customer satisfaction with the Santa Fe Grill. Your dependent variable is Satisfaction (X22). For the independent variables we select variables X12 (Friendly Employees), X14 (Large Size Portions), X15 (Fresh Food). You need to use the Regression command then select Linear. At the next screen (see image below), place the dependent variable in the appropriate section, next place the variables X12, X14, and X15 in the section for Independent(s): variables. Finally, place X_S4 (Favorite Mexican Restaurant) in the Selection Variable panel and use the Rule = 1 to select Santa Fe Grill. At this point you're ready to run the Regression Analysis. Linear Regression Dependent Statistics Plots Block 1 of 1 Save... NE PUS Independentis): golions Bootstrap.. Da Regularly Dine at Have Dined att Gross Annual Inc. Favorite Mexican PIO X1 - Try New and ALEX2 - Party Perso OX3 - People Co. X4 Avoid Fried X5-Likes to Go 40 X6 - Friends Co X7-Self-Confide X8 - Eat Balance X9 - Buy New Pr. X10 - Careful ab X114. Try New Br. X12 -Friendly E X13-Fun Placet Method Enter Selection Variable R Case Labels WLS Weight Reset Cancel Help

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!