# Scatter Diagram and Regression Analysis

Jul 11th, 2014
Anonymous
Category:
Mathematics
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

(Top Tutor) magnettatish
School: UT Austin

Studypool has helped 1,244,100 students

Review from student
Anonymous
" Totally impressed with results!! :-) "

1822 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