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:

Combustion

The process of burning something in the presence of oxygen, resulting in the release of heat and light.

Bomb Calorimeter

An apparatus used for measuring the heat of combustion of a particular reaction.

Combustion

A chemical process involving the rapid oxidation of substances, resulting in the release of energy, light, and heat.

Activation Energy

The minimum amount of energy that must be provided to compounds to induce a chemical reaction.