# Scatter Diagram and Regression Analysis

**Question description**

Objective:

A team member has been saying since day one that there is a relationship between wait time and customer

satisfaction ratings (1 being the worst and 10 being the best). Should the team have listened?

Perform correlation and regression analysis to see if she is correct.

Instructions for you:

PART 1 - Do you suspect the variables may be related? Determine the correlation coefficient as well as perform a regression analysis on the data provided to answer the questions below.

PARTS 2 & 3 - The team suspects that the time of day may have an effect on the results, so the team decides to

perform another analysis by analyzing the same results sorting by the time of day (lunch or dinner).

Perform the same analysis as PART 1, however be sure to use only the data for the respective time of

day. Perform one analysis with the 30 data points for Lunch and another analysis for the 30 data points

for Dinner and answer the questions below.

Time of Day | Wait Time (minutes) | Customer Satisfaction (1-10) |

Lunch | 9.5548 | 7 |

Lunch | 21.4950 | 3 |

Lunch | 26.3915 | 1 |

Lunch | 11.7057 | 6 |

Lunch | 15.5191 | 5 |

Lunch | 28.7761 | 1 |

Lunch | 27.7146 | 1 |

Lunch | 8.5575 | 7 |

Lunch | 8.9540 | 8 |

Lunch | 18.0349 | 4 |

Lunch | 4.0550 | 9 |

Lunch | 20.5527 | 4 |

Lunch | 8.2985 | 8 |

Lunch | 23.3592 | 3 |

Lunch | 14.4198 | 6 |

Lunch | 18.0643 | 3 |

Lunch | 11.9445 | 6 |

Lunch | 11.4930 | 7 |

Lunch | 14.1029 | 4 |

Lunch | 12.5650 | 6 |

Lunch | 15.8737 | 5 |

Lunch | 17.7516 | 4 |

Lunch | 13.4854 | 7 |

Lunch | 13.5948 | 6 |

Lunch | 7.1309 | 5 |

Lunch | 5.4951 | 8 |

Lunch | 25.4996 | 2 |

Lunch | 9.6127 | 7 |

Lunch | 12.8767 | 5 |

Lunch | 26.2330 | 3 |

Dinner | 18.8415 | 5 |

Dinner | 16.9362 | 3 |

Dinner | 5.1428 | 5 |

Dinner | 21.6323 | 3 |

Dinner | 2.0000 | 4 |

Dinner | 16.4363 | 5 |

Dinner | 22.7496 | 6 |

Dinner | 19.4474 | 1 |

Dinner | 19.4078 | 4 |

Dinner | 12.4674 | 2 |

Dinner | 13.6108 | 3 |

Dinner | 16.0315 | 6 |

Dinner | 26.4012 | 5 |

Dinner | 11.1324 | 2 |

Dinner | 29.9518 | 6 |

Dinner | 8.3968 | 3 |

Dinner | 26.1407 | 5 |

Dinner | 5.3498 | 3 |

Dinner | 6.7547 | 5 |

Dinner | 18.9429 | 4 |

Dinner | 19.3040 | 3 |

Dinner | 2.0946 | 6 |

Dinner | 19.7982 | 4 |

Dinner | 14.4754 | 5 |

Dinner | 19.3599 | 3 |

Dinner | 26.0793 | 4 |

Dinner | 6.9378 | 7 |

Dinner | 29.2652 | 5 |

Dinner | 25.4606 | 2 |

Dinner | 28.4090 | 3 |

AboveWay Sandwich, Inc. Customer Satisfaction Improvement | |

Deliverable: | Scatter Diagram & Regression Analysis |

Student last name: | |

PART 1: Using Lunch & Dinner Data | |

What is the correlation coefficient? | |

What is the regression equation? | |

What percentage of variation is explained by the model? HINT: There are 2 related values that can be used to answer this question. Show them BOTH and explain which value you would recommend using and why. | Type your answer here. (Use at most 25 words.) |

Based on an ANOVA of the regression equation, is the regression equation statistically significant at 5% alpha risk? | YES |

Why do you you say that it is either statistically significant or not? HINT: Use the results of your ANOVA as the basis for your answer. | P value is 0.00, P values higher than 0.05 suggests results are insignificant, we must reject the null hypothesis and conclude that at least one independent varibale is correlated with the dependent variable. |

What is the null hypothesis for ANOVA for a regression equation? | |

Type your answer here. (Use at most 15 words.) | |

PART 2: Using Only Lunch Data | |

What is the correlation coefficient for Lunch? | Type here (use 3 decimal places) |

What is the regression equation for Lunch? | Type here (use 3 decimal places) |

What percentage of variation is explained by the Lunch model? HINT: There are 2 related values that can be used to answer this question. Show them BOTH and explain which value you would recommend using and why. | Type your answer here. (Use at most 25 words.) |

Based on an ANOVA of the regression equation, is the regression equation statistically significant at 5% alpha risk? | Type "YES" or "NO" here |

Why do you you say that it is either statistically significant or not? HINT: Use the results of your ANOVA as the basis for your answer. | Type your answer here. (Use at most 25 words.) |

Given the results of this study, what should your Black Belt do next to improve customer satisfaction at lunch? | Type your answer here. (Use at most 25 words.) |

PART 3: Using Only Dinner Data | |

What is the correlation coefficient for Dinner? | Type here (use 3 decimal places) |

What is the regression equation for Dinner? | Type here (use 3 decimal places) |

What percentage of variation is explained by the Dinner model? HINT: There are 2 related values that can be used to answer this question. Show them BOTH and explain which value you would recommend using and why. | Type your answer here. (Use at most 25 words.) |

Based on an ANOVA of the regression equation, is the regression equation statistically significant at 5% alpha risk? | Type "YES" or "NO" here |

Why do you you say that it is either statistically significant or not? HINT: Use the results of your ANOVA as the basis for your answer. | Type your answer here. (Use at most 25 words.) |

Given the results of this study, what should your Black Belt do next to improve customer satisfaction at dinner? | Type your answer here. (Use at most 25 words.) |

## Tutor Answer

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors