Question: Read the Measure phase of the MSD Purchasing case study below and answer the following question. MSD Purchasing Analyze Phase.docx Using the data provided in

 Read the Measure phase of the MSD Purchasing case study below
and answer the following question. MSD Purchasing Analyze Phase.docx Using the data
provided in Table 1, create dot plots or box plots (with groups)

Read the Measure phase of the MSD Purchasing case study below and answer the following question. MSD Purchasing Analyze Phase.docx Using the data provided in Table 1, create dot plots or box plots (with groups) for each pair of X and Y (for a total of 8 pairs), and analyze if any of the X has an impact on Y. You can either have both Ys in the same plot or separate plots. Table 1. Baseline Data \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline Sample & Day & Hour & X1 & X2 & X3 & XT & Y1 & Y2 \\ \hline 1 & Mon & 1 & 1 & 0 & 0 & 7 & 2 & 5 \\ \hline 2 & Mon & 2 & 0 & 1 & 0 & 7 & 2 & 9 \\ \hline 3 & Mon & 3 & 0 & 0 & 1 & 7 & 10 & 7 \\ \hline 4 & Mon & 4 & 0 & 1 & 0 & 7 & 1 & 4 \\ \hline 5 & Mon & 5 & 0 & 0 & 0 & 7 & 7 & 3 \\ \hline 6 & Mon & 6 & 0 & 1 & 1 & 7 & 2 & 5 \\ \hline 7 & Mon & 7 & 0 & 1 & 1 & 7 & 1 & 9 \\ \hline 8 & Mon & 8 & 0 & 0 & 0 & 7 & 7 & 5 \\ \hline 9 & Tue & 1 & 0 & 1 & 0 & 8 & 2 & 8 \\ \hline 10 & Tue & 2 & 0 & 1 & 0 & 8 & 1 & 7 \\ \hline 11 & Tue & 3 & 0 & 1 & 0 & 8 & 1 & 13 \\ \hline 12 & Tue & 4 & 1 & 1 & 1 & 8 & 9 & 5 \\ \hline 13 & Tue & 5 & 1 & 1 & 0 & 8 & 9 & 9 \\ \hline 14 & Tue & 6 & 1 & 1 & 1 & 8 & 10 & 11 \\ \hline 15 & Tue & 7 & 1 & 1 & 1 & 8 & 10 & 11 \\ \hline 16 & Tue & 8 & 0 & 0 & 1 & 8 & 8 & 9 \\ \hline 17 & Wed & 1 & 1 & 1 & 1 & 9 & 8 & 11 \\ \hline 18 & Wed & 2 & 1 & 0 & 0 & 9 & 1 & 11 \\ \hline 19 & Wed & 3 & 1 & 1 & 1 & 9 & 10 & 11 \\ \hline 20 & Wed & 4 & 0 & 0 & 0 & 9 & 7 & 11 \\ \hline 21 & Wed & 5 & 1 & 1 & 1 & 9 & 9 & 9 \\ \hline 22 & Wed & 6 & 0 & 0 & 1 & 9 & 9 & 5 \\ \hline 23 & Wed & 7 & 1 & 0 & 1 & 9 & 2 & 11 \\ \hline 24 & Wed & 8 & 1 & 0 & 0 & 9 & 1 & 10 \\ \hline 25 & Thu & 1 & 1 & 0 & 1 & 10 & 1 & 14 \\ \hline 26 & Thu & 2 & 0 & 1 & 1 & 10 & 1 & 10 \\ \hline 27 & Thu & 3 & 1 & 1 & 1 & 10 & 8 & 13 \\ \hline 28 & Thu & 4 & 0 & 0 & 1 & 10 & 10 & 12 \\ \hline 29 & Thu & 5 & 0 & 0 & 0 & 10 & 7 & 14 \\ \hline 30 & Thu & 6 & 0 & 1 & 1 & 10 & 3 & 13 \\ \hline 31 & Thu & 7 & 0 & 0 & 0 & 10 & 9 & 13 \\ \hline 32 & Thu & 8 & 1 & 1 & 1 & 10 & 8 & 11 \\ \hline 33 & Fri & 1 & 0 & 1 & 0 & 1 & 2 & 0 \\ \hline 34 & Fri & 2 & 0 & 1 & 0 & 1 & 2 & 1 \\ \hline 35 & 7 & 0 & 0 & 1 & 1 & 10 & 0 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline 40 & Fri & 8 & 0 & 1 & 0 & 1 & 2 & 0 \\ \hline 41 & Mon & 1 & 0 & 1 & 1 & 4 & 3 & 4 \\ \hline 42 & Mon & 2 & 0 & 1 & 0 & 4 & 3 & 7 \\ \hline 43 & Mon & 3 & 0 & 1 & 1 & 4 & 3 & 3 \\ \hline 44 & Mon & 4 & 0 & 0 & 0 & 4 & 10 & 2 \\ \hline 45 & Mon & 5 & 1 & 1 & 0 & 4 & 8 & 5 \\ \hline 46 & Mon & 6 & 0 & 1 & 1 & 4 & 3 & 4 \\ \hline 47 & Mon & 7 & 1 & 0 & 0 & 4 & 1 & 4 \\ \hline 48 & Mon & 8 & 0 & 0 & 1 & 4 & 10 & 5 \\ \hline 49 & Tue & 1 & 1 & 1 & 1 & 5 & 11 & 6 \\ \hline 50 & Tue & 2 & 1 & 0 & 1 & 5 & 3 & 4 \\ \hline 51 & Tue & 3 & 1 & 1 & 0 & 5 & 10 & 6 \\ \hline 52 & Tue & 4 & 1 & 0 & 1 & 5 & 3 & 5 \\ \hline 53 & Tue & 5 & 1 & 0 & 0 & 5 & 2 & 4 \\ \hline 54 & Tue & 6 & 0 & 0 & 0 & 5 & 9 & 5 \\ \hline 55 & Tue & 7 & 0 & 0 & 1 & 5 & 9 & 5 \\ \hline 56 & Tue & 8 & 0 & 1 & 0 & 5 & 3 & 7 \\ \hline 57 & Wed & 1 & 0 & 0 & 1 & 6 & 9 & 5 \\ \hline 58 & Wed & 2 & 1 & 1 & 0 & 6 & 9 & 7 \\ \hline 59 & Wed & 3 & 0 & 0 & 0 & 6 & 9 & 5 \\ \hline 60 & Wed & 4 & 1 & 0 & 0 & 6 & 2 & 6 \\ \hline 61 & Wed & 5 & 1 & 0 & 1 & 6 & 2 & 5 \\ \hline 62 & Wed & 6 & 1 & 1 & 1 & 6 & 10 & 5 \\ \hline 63 & Wed & 7 & 0 & 1 & 0 & 6 & 1 & 7 \\ \hline 64 & Wed & 8 & 0 & 1 & 0 & 6 & 2 & 5 \\ \hline 65 & Thu & 1 & 0 & 0 & 1 & 7 & 10 & 7 \\ \hline 66 & Thu & 2 & 1 & 1 & 0 & 7 & 9 & 5 \\ \hline 67 & Thu & 3 & 1 & 0 & 0 & 7 & 1 & 7 \\ \hline 68 & Thu & 4 & 0 & 1 & 0 & 7 & 2 & 5 \\ \hline 69 & Thu & 5 & 1 & 0 & 1 & 7 & 1 & 6 \\ \hline 70 & Thu & 6 & 0 & 1 & 0 & 7 & 1 & 5 \\ \hline 71 & Thu & 7 & 1 & 0 & 0 & 7 & 1 & 8 \\ \hline 72 & Thu & 8 & 1 & 1 & 1 & 7 & 10 & 5 \\ \hline 73 & Fri & 1 & 0 & 1 & 1 & 8 & 3 & 7 \\ \hline 74 & Fri & 2 & 1 & 1 & 1 & 8 & 9 & 7 \\ \hline 75 & 4 & 0 & 1 & 1 & 8 & 2 & 8 \\ \hline 75 & 5 & 0 & 1 & 1 & 8 & 3 & 9 \\ \hline 75 & 1 & 1 & 1 & 8 & 8 & 10 \\ \hline 75 & 0 & 1 & 8 & 10 & 11 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!