Question: Below is the sample data needed for this problem, thank you! I have included the question in the first image and the sample data needed

Below is the sample data needed for this problem, thank you!




I have included the question in the first image and the sample data needed is images 2-5 for this problem, thank you!
Based on a data sample in file "TOM3010_OM_HW3_Question22_Data.xlsx", you need to construct one Xbar-chart and one R-chart with the following guidelines: - Background, equations, lookups and Excel examples (with videos) are in Module 05. - Charts must have titles, labels, and clear presentation of different lines. (a)[5] You need to have one Xbar-chart. The Xbar-chart should have the vertical axis format as: Min = 35; Max = 70; and Major Unit = 5. The horizontal axis has 60 points. Besides the chart, present the following mini table (points will be deducted if you show the big table of full data). Give interpretations of the chart results: the process is in control or out of control, and why. (b) [5] You need to have one R-chart. The R-chart should have the vertical axis format as: Min = 0 ; Max = 80; and Major Unit = 10. The horizontal axis has 60 points. Besides the chart, present the following mini table (points will be deducted if you show the big table of full data). Give interpretations of the chart results: the process is in control or out of control, and why. \begin{tabular}{|l|l|} \hline Sample size (n) & 12 \\ \hline \#Samples (k) & 60 \\ \hline \end{tabular} Data for 60 samples (12 items in each sample) in pounds per item (weight) \begin{tabular}{|c|c|} \hline 59 & 60 \\ \hline 63.906 & 55.544 \\ \hline 73.750 & 81.461 \\ \hline 55.969 & 60.127 \\ \hline 88.759 & 69.947 \\ \hline 55.019 & 48.210 \\ \hline 55.236 & 64.345 \\ \hline 50.572 & 53.841 \\ \hline 73.193 & 73.835 \\ \hline 41.602 & 61.856 \\ \hline 63.086 & 55.637 \\ \hline 43.019 & 61.292 \\ \hline 77.239 & 62.903 \\ \hline \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
