Scatter Diagram and Regression Analysis

Jul 11th, 2014
Steve1995
Category:
Statistics
Price: $20 USD

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

(Top Tutor) Daniel C.
(997)
School: Rice University
PREMIUM TUTOR

Studypool has helped 1,244,100 students

8 Reviews


Summary
Quality
Communication
On Time
Value
pmallory
Dec 3rd, 2016
" Totally impressed with results!! :-) "
mixedballz
Nov 24th, 2016
" excellent work as always thanks for the help "
Five Star Tutor
Nov 22nd, 2016
" Outstanding Job!!!! "
kiln82
Nov 10th, 2016
" awesome work thanks "
darnay
Nov 1st, 2016
" The best tutor out there!!!! "
likeplum4
Oct 28th, 2016
" Excellent work as usual "
kpcutie
Oct 5th, 2016
" Excellent job "
Joemoe
Sep 26th, 2016
" <3 it, thanks for saving me time. "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1827 tutors are online

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