create an Xbar and S-chart along with histograms in excel

Battery Diameter: \begin{tabular}{|c|c|c|c|c|} \hline Subgroup & Part 1 & Part 2 & Part 3 & Part 4 \\ \hline 1 & 15.55 & 16.04 & 19.30 & 18.35 \\ \hline 2 & 17.35 & 15.38 & 13.81 & 18.67 \\ \hline 3 & 16.10 & 16.89 & 15.95 & 17.00 \\ \hline 4 & 17.24 & 17.86 & 15.53 & 18.00 \\ \hline 5 & 18.33 & 19.40 & 17.88 & 18.73 \\ \hline 6 & 16.78 & 17.95 & 15.24 & 18.98 \\ \hline 7 & 20.40 & 15.63 & 17.00 & 17.89 \\ \hline 8 & 16.68 & 14.82 & 19.36 & 15.51 \\ \hline 9 & 16.81 & 21.62 & 18.59 & 20.85 \\ \hline 10 & 16.06 & 16.81 & 16.01 & 15.87 \\ \hline 11 & 15.96 & 17.48 & 19.82 & 17.24 \\ \hline 12 & 15.43 & 14.96 & 16.32 & 17.11 \\ \hline 13 & 16.73 & 18.96 & 16.23 & 14.86 \\ \hline 14 & 13.47 & 16.89 & 17.99 & 15.31 \\ \hline 15 & 16.13 & 17.47 & 17.39 & 19.53 \\ \hline 16 & 17.43 & 15.96 & 18.08 & 18.11 \\ \hline 17 & 15.48 & 19.93 & 17.11 & 16.98 \\ \hline 18 & 15.79 & 15.89 & 15.79 & 14.56 \\ \hline 19 & 19.53 & 15.35 & 19.08 & 15.21 \\ \hline 20 & 18.32 & 17.28 & 14.79 & 17.96 \\ \hline 21 & 15.84 & 19.99 & 17.55 & 17.88 \\ \hline 22 & 15.17 & 13.88 & 17.70 & 15.62 \\ \hline 23 & 18.65 & 18.86 & 15.33 & 15.61 \\ \hline 24 & 13.74 & 16.16 & 17.11 & 18.59 \\ \hline 25 & 17.05 & 18.05 & 17.01 & 19.37 \\ \hline 26 & 18.26 & 17.44 & 17.90 & 14.79 \\ \hline 27 & 16.93 & 13.74 & 16.17 & 18.24 \\ \hline 28 & 18.93 & 16.57 & 14.24 & 17.93 \\ \hline 29 & 16.48 & 18.71 & 18.60 & 17.78 \\ \hline 30 & 16.30 & 19.00 & 17.33 & 16.18 \\ \hline 31 & 16.08 & 17.55 & 16.53 & 18.21 \\ \hline 32 & 17.65 & 16.22 & 15.73 & 18.21 \\ \hline 33 & 17.60 & 15.74 & 16.88 & 16.98 \\ \hline 34 & 18.33 & 17.09 & 16.20 & 14.28 \\ \hline 35 & 18.32 & 17.22 & 16.81 & 18.07 \\ \hline 36 & 15.57 & 17.04 & 17.00 & 18.89 \\ \hline 37 & 19.46 & 17.31 & 15.86 & 16.75 \\ \hline 39 & 17.46 & 16.81 & 18.26 & 17.97 \\ \hline 19.25 & 18.33 & 18.11 & 17.89 \\ \hline 14.23 & 15.55 & 16.56 & 20.02 \\ \hline \end{tabular} Battery Length \begin{tabular}{|c|c|c|c|c|} \hline Subgroup & Part 1 & Part 2 & Part 3 & Part 4 \\ \hline 1 & 35.46 & 35.30 & 33.59 & 36.53 \\ \hline 2 & 3.45 & 32.92 & 33.86 & 35.8 \\ \hline 3 & 4.21 & 33.61 & 35.26 & 33.0 \\ \hline 4 & 32.76 & 32.50 & 33.75 & 35.42 \\ \hline 5 & 34.31 & 33,41 & 36.08 & 33,01 \\ \hline 6 & 38.40 & 37.09 & 37.31 & 36.00 \\ \hline 7 & 33.17 & 35.33 & 35.00 & 34.17 \\ \hline 8 & 36.59 & 36.14 & 32.23 & 34.98 \\ \hline 9 & 32.69 & 35,01 & 32.93 & 35,84 \\ \hline 10 & 34.13 & 35.30 & 34.98 & 35.85 \\ \hline 11 & 34.59 & 34.89 & 32.88 & 34.72 \\ \hline 12 & 35.17 & 33.92 & 34.11 & 32.90 \\ \hline 13 & 33.99 & 34.12 & 34.26 & 35,21 \\ \hline 14 & 2.31 & 34.32 & 34.05 & 35.17 \\ \hline 15 & 33,18 & 32,61 & 34.78 & 33,30 \\ \hline 16 & 34.77 & 36.44 & 34.59 & 35.68 \\ \hline 17 & 33.42 & 36.10 & 34.65 & 37.24 \\ \hline 18 & 4.19 & 36.24 & 34.51 & 35.60 \\ \hline 19 & 35.04 & 33.43 & 34.98 & 36.98 \\ \hline 20 & 36.51 & 34.67 & 35.13 & 31.96 \\ \hline 21 & 35.59 & 33.59 & 34.23 & 34,12 \\ \hline 22 & 33.62 & 34,03 & 32.25 & 31.31 \\ \hline 23 & 35.14 & 32.00 & 37.06 & 34.28 \\ \hline 24 & 35.37 & 32,47 & 35.14 & 34.64 \\ \hline 25 & 35.08 & 37.79 & 36.15 & 34.00 \\ \hline 26 & 34.62 & 33.26 & 34.87 & 31.19 \\ \hline 27 & 30.96 & 35,31 & 35.90 & 34,75 \\ \hline 28 & 34.09 & 33.52 & 34.98 & 32.75 \\ \hline 29 & 35.98 & 34.64 & 31.00 & 31.65 \\ \hline 30 & 35,47 & 34.86 & 35.19 & 33,02 \\ \hline 31 & 38.48 & 35.07 & 35.33 & 34,64 \\ \hline 32 & 33,75 & 35,89 & 34.60 & 31.56 \\ \hline 33 & 33.15 & 35,71 & 32.25 & 34.26 \\ \hline 34 & 35.56 & 36.26 & 34.82 & 35.74 \\ \hline 35 & 32.98 & 35,24 & 36.82 & 31.89 \\ \hline 36 & 34.35 & 35,36 & 35.99 & 37,29 \\ \hline 37 & 32.02 & 31.99 & 36,35 & 35.19 \\ \hline 38 & 34.00 & 34.98 & 36,43 & 33.73 \\ \hline 39 & 36.03 & 33.02 & 33,74 & 33.88 \\ \hline 40 & 32.29 & 33,06 & 33,09 & 33.69 \\ \hline \end{tabular} Recorded in the manufacturing logBook the following was observed: - Upon the early start-up, the production associate was concerned with typical start-up of the line and notes her concerns and makes a minor tweak of the machinery after data set \#6. -Data set \# 20, by midday a new lot of battery tubes were used. -Data set 38 the "Calibrated" vernier calibers. was misplaced and a non-calibrated caliber was used instead. QA requires a Xbar and S chart be created for the production run and report on the overall quality by performing a PCA. QC is knowledgeable on how to proceed with the analysis and then proceeds to perform the analysis. QA knows that their Excel template is a great tool, however, they know that they are the "Analyst" and need to articulate the results of the findings. They will create a report with narrative of 250 words or less along with the charts and PCA analysis. Process analysis hints: For creating a Histogram of the Battery Diameter; use a lowest "Bin Limit" of 13 for the battery diameter and a "Bin Size" of 1 For creating a Histogram of the Battery Length; use a lowest "Bin Limit" of 30 for the battery length and a "Bin Size" of 1