QUESTION 1: Company SEMO manufactures automobile parts (bolts for alternator). The dimensions for bolt are given as below (in millimeters). (25pts) SUBMISSION TYPE: EXCEL + VIDEO (no time limit). Note: Record (screen recording) yourself building the histogram and the chart. While you build the histogram and chart, explain how you build them (teach us as if you are an instructor). Upload your video to onedrive or youtube (or another platform as long as your link works) and provide me a link in the submission. A) Build a histogram in excel (15pts) B) Please draw an appropriate control chart in excel (hint: determine which control chart would work the best for the given data below) and interpret your results (what do you see on the cart, briefly explain) (20pts) Sample 1 2345 28.5 33.2 29.5 32.1 54.3 44.1 37.2 38.2 45.2 45.9 54.5 28.6 32.1 47.6 75.7 46.6 75.2 37.4 37.8 55.9 64.3 63.5 62.2 62.4 18.9 54.4 48.9 61.5 48.0 85.6

QUESTION 1: Company SEMO manufactures automobile parts (bolts for alternator). The dimensions for bolt are given as below (in millimeters). (25pts) SUBMISSION TYPE: EXCEL + VIDEO (no time limit). Note: Record (screen recording) yourself building the histogram and the chart. While you build the histogram and chart, explain how you build them (teach us as if you are an instructor). Upload your video to onedrive or youtube (or another platform as long as your link works) and provide me a link in the submission. A) Build a histogram in excel (15pts) B) Please draw an appropriate control chart in excel (hint: determine which control chart would work the best for the given data below) and interpret your results (what do you see on the cart, briefly explain) (20pts)