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?

Question

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?

Quizplus · Accepted Answer

The Answer of 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?

The Owner of a Grocery Store Is Interested in Providing