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?

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.

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

Lunch 9.26 7

Lunch 21.20 2

Lunch 26.09 1

Lunch 11.41 6

Lunch 15.22/ 4

Lunch 28.48 /1

Lunch 27.22 /1

Lunch 8.06 /7

Lunch 8.45 /9

Lunch 17.54 /2

Lunch 4.56 /9

Lunch 20.05 /2

Lunch 7.81 /8

Lunch 22.86 /2

Lunch 13.92 /6

Lunch 17.56 /3

Lunch 11.44 /6

Lunch 11.19 /5

Lunch 13.71 /5

Lunch 12.17 /6

Lunch 15.47 /5

Lunch 17.35 /4

Lunch 13.09 /7

Lunch 13.21 /6

Lunch 6.73 /5

Lunch 5.11 /9

Lunch 24.82 /2

Lunch 9.20 /7

Lunch 12.47 /5

Lunch 22.93 /2

Dinner 18.84 /5

Dinner 17.12 /3

Dinner 5.18 /5

Dinner 21.77 /3

Dinner 3.25 /4

Dinner 16.44 /5

Dinner 22.65 /6

Dinner 19.34 /1

Dinner 19.41 /4

Dinner 12.48 /2

Dinner 13.55 /3

Dinner 16.02 /6

Dinner 26.22 /5

Dinner 11.13 /2

Dinner 29.91 /6

Dinner 8.34 /5

Dinner 26.14 /5

Dinner 5.44 /3

Dinner 6.77 /4

Dinner 18.94 /4

Dinner 19.31 /3

Dinner 2.62 /6

Dinner 19.75 /4

Dinner 14.68 /4

Dinner 19.36 /3

Dinner 26.08 /4

Dinner 6.90 /7

Dinner 26.28 /6

Dinner 25.46 /3

Dinner 28.41 /3

PARTS 2 & 3 - Perform the same analysis as PART 1, 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.

What is the correlation coefficient?

What is the regression equation?

What percentage ofvariation 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.

Based on an ANOVA of the regression equation, is the regression equation statistically significant at 5% alpha risk? Yes or No

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. What is the null hypothesis for ANOVA for a regression equation?

PART 2: Using Only Lunch Data

What is the correlation coefficient for Lunch?

What is the regression equation for Lunch?

What percentage ofvariation 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.

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

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.

Given the results of this study, what should your Black Belt do next to improve customer satisfaction at lunch?

PART 3: Using Only Dinner Data

What is the correlation coefficient for Dinner?

What is the regression equation for Dinner?

What percentage ofvariation 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.

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

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.

Given the results of this study, what should your Black Belt do next to improve customer satisfaction at dinner?