Please answer and show excel calculations.

Problem Al B) -- 15 pts Continued from Problem 4 (A), the manager would like to further investigate the situation of overall voltage output and its variability for batteries produced at the plant in upstate New York. She has taken one sample per hour from the production line for a day, where each sample contains 18 batteries (see the table below). Two types of control charts are needed to meet her purpose. Make these two control charts and show your analysis/calculation. Your charts should be generated by being linked to the data on the worksheet. 18 batteries in a sample Hour sample taken 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 50.2 53.7 48.6 49.3 51.1 52.3 47.3 50.1 50.5 50.2 52.3 46.9 50.1 50.5 52.3 49.9 51.1 50.2 50.8 48.8 52.8 48.6 45.4 50.6 49.9 46.1 53.6 46.2 50.6 49.9 56.1 50.2 49.9 47.9 45.4 52.6 50.2 48.3 52.6 46.9 53.3 49.2 47.9 54.1 50.6 52.1 54.0 50.6 48.8 53.8 47.9 53.3 53.3 46.9 49.5 48.8 54.9 53.2 53.6 51.1 52.6 52.6 49.5 51.8 47.8 52.3 48.3 52.6 53.3 53.1 53.6 50.5 52.3 51.7 50.5 50.5 50.5 43.7 45.7 50.6 50.5 50.2 48.3 52.6 48.5 50.2 49.9 53.6 50.5 53.6 50.6 49.9 46.1 53.6 53.6 52.6 50.6 50.9 44.4 51.9 45.7 50.2 51.1 52.3 47.9 52.3 53.6 50.6 46.4 54.1 50.6 49.2 52.3 48.3 45.3 49.9 46.1 53.6 49.9 46.1 50.6 49.9 50.3 52.6 52.3 46.1 52.5 52.6 46.9 50.2 50.6 49.9 49.9 47.9 54.7 50.6 52.6 51.1 49.9 46.1 50.3 53.6 50.6 53.1 51.5 50.3 50.5 46.7 49.2 47.9 48.6 52.6 52.6 46.3 50.2 45.7 56.1 55.3 49.9 52.6 49.2 52.6 49.3 45.1 50.6 48.3 52.6 53.3 52.6 49.6 50.2 52.3 45.7 47.9 54.5 51.2 50.6 47.9 52.6 52.3 49.9 46.1 57.3 53.1 53.2 53.1 55.3 48.3 52.6 53.3 52.6 46.6 50.2 50.6 49.9 49.2 53.2 50.6 48.6 48.9 50.6 49.9 46.1 53.6 52.6 52.6 46.9 51.8 51.5 49.8 50.5 46.7 49.9 51.1 46.1 46.1 45.7 50.5 50.5 46.2 51.1 52.3 47.9 50.9 50.5 50.2 46.7 49.2 47.9 46.7 51.1 43.7 51.1 50.6 47.7 50.2 56.1 50.2 45.1 50.6 49.9 46.1 53.6 46.2 48.3 52.6 53.3 52.3 45.7 52.6 45.1 46.1 48.1 50.8 48.8 53.8 53.3 49.2 47.9 54.0 50.6 52.1 48.1 49.5 50.5 51.1 51.7 48.3 53.3 50.5 52.9 55.3 48.3 52.6 52.6 49.1 50.5 52.1 48.3 52.6 49.9 46.1 53.6 47.8 53.6 49.9 52.6 53.6 48.6 50.3 50.6 49.9 46.1 52.3 48.8 52.2 50.5 49.1 46.4 53.1 49.2 47.9 54.4 46.4 46.1 52.6 51.9 48.5 50.2 52.2 50.1 50.6 49.9 46.1 53.6 52.6 52.5 52.6 44.3 50.8 55.3 52.5 50.1 47.9 49.3 51.1 52.3 49.6 47.9 54.7 50.6 48.1 50.3 50.5 51.1 52.3 45.7 46.1 53.6 46.9 47.9 49.2 49.3 50.6 49.9 50.6 47.7 47.8 52.3 52.7 48.3 48.8 48.9 50.6 49.9 50.6 49.2 50.5 47.7 51.1 50.6 49.9 46.1 50.2 56.1 45.9 49.2 52.3 49.4 48.3 49.9 46.1 53.6 53.6 52.6 53.6 56.1 43.7 49.2 47.9 54.2 53.3 52.6 48.1 50.8 48.8 52.8 46.7 54.6 50.6 49.2 52.3 45.7 50.6 52.6 52.6 49.3 51.1 52.3 45.7 50.8 50.5 43.7 52.8 48.6 52.7 49.9 46.1 52.3 45.7 50.1 50.2 50.8 48.3 54.1 45.7 49.9 50.5 50.2 45.8 50.2 56.1 49.9 56.1 50.1 50.5 46.7 49.2 47.9 51.9 50.2 50.8 16 17 18 19 20 21 22 23 24