Solved

The Owner of a Grocery Store Is Interested in Providing

Question 53

Essay

The owner of a grocery store is interested in providing better service to his customers with respect to the wait time at the billing counter. The data on 20 waiting customers are given below.  Customer  Number  Wait Time (min)  Purchase Amount ($)  Customer Age  Credit Score 12.35184269422.85923387933.25983853143.48454050953.46482986964.26954677773.28444247081.44704071496.448824517107.852737794110.584332351129.87044367313582456846141.857035735156.150339816163.448344516177.870733729182.879642591191.248546866209.572750879\begin{array}{l}\text { Customer }\\\begin{array} { l l l l l } \text { Number } & \text { Wait Time (min) } & \text { Purchase Amount (\$) }&\text { Customer Age } & \text { Credit Score } \\\hline 1 & 2.3 & 518 & 42 & 694 \\2 & 2.8 & 592 & 33 & 879 \\3 & 3.2 & 598 & 38 & 531 \\4 & 3.4 & 845 & 40 & 509 \\5 & 3.4 & 648 & 29 & 869 \\6 & 4.2 & 695 & 46 & 777 \\7 & 3.2 & 844 & 42 & 470 \\8 & 1.4 & 470 & 40 & 714 \\9 & 6.4 & 488 & 24 & 517 \\10 & 7.8 & 527 & 37 & 794\\11 & 0.5 & 843 & 32 & 351 \\12 & 9.8 & 704 & 43 & 673 \\13 & 5 & 824 & 56 & 846 \\14 & 1.8 & 570 & 35 & 735 \\15 & 6.1 & 503 & 39 & 816\\16 & 3.4 & 483 & 44 & 516 \\17 & 7.8 & 707 & 33 & 729 \\18 & 2.8 & 796 & 42 & 591 \\19 & 1.2 & 485 & 46 & 866 \\20 & 9.5 & 727 & 50 & 879\\\end{array}\end{array}
a. Use XLMiner to create a scatter chart matrix for these data. Include the variables wait time, purchase amount, customer age, and credit score.
b. What can you infer about the relationships between these variables from the scatter chart matrix?

Correct Answer:

verifed

Verified

a. blured image b. The waiting time appear...

View Answer

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions