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. $$\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?

---

Definitions:

Critical I/O Devices

Input/output devices deemed essential for the operation of a system, whose failure could compromise the system's functionality.

Jump-To-Label Program

A programming construct that allows the execution sequence to jump to a specified point in the code, identified by a label.

NC Contact

An electrical contact that remains closed, allowing current to flow, until actuated open, usually referred to as a Normally Closed Contact in electrical circuits.