please show data table and how to put it in excel. thank you

Bayfield Mud Company In November 2018, John Wells, a customer service representative of Bayfield Mud Company, was summoned to the Houston warehouse of Wet-Land Drilling, Inc., to inspect three boxcars of mud-treating agents that Bayfield had shipped to the Houston firm (Bayfield's corporate offices and its largest plant are located in Orange, Texas, which is just west of the LouisianaTexas border). Wet-Land had filed a complaint that the 50-pound bags of treating agents just received from Bayfield were short-weight by approximately 5%. The short-weight bags were initially detected by one of Wet-Land's receiving clerks, who noticed that the railroad scale tickets indicated that net weights were significantly less on all three boxcars than those of identical shipments received on October 25, 2018. Bayfield's traffic department was called to determine if lighter-weight pallets were used on the shipments. (This might explain the lighter net weights.) Bayfield indicated, however, that no changes had been made in loading or palletizing procedures. Thus, Wet-Land engineers randomly checked 50 bags and discovered that the average net weight was 47.51 pounds. They noted from past shipments that the process yielded bag net weights averaging exactly 50.0 pounds, with an acceptable standard deviation of 1.2 pounds. Consequently, they concluded that the sample indicated a significant short weight. Bayfield was then contacted, and Wells was sent to investigate the complaint. Upon arrival, Wells verified the complaint and issued a 5% credit to Wet-Land. Wet-Land management, however, was not completely satisfied with the issuance of credit. The charts followed by their mud engineers on the drilling platforms were based on 50-pound bags of treating agents. Lighter-weight bags might result in poor chemical control during the drilling operation and thus adversely affect drilling efficiency. (Mud-treating agents are used to Wet-Land management, however, was not completely satisfied with the issuance of credit. The charts followed by their mud engineers on the drilling platforms were based on 50-pound bags of treating agents. Lighter-weight bags might result in poor chemical control during the drilling operation and thus adversely affect drilling efficiency. (Mud-treating agents are used to control the pH and other chemical properties of the core during drilling operation.) This defect could cause severe economic consequences because of the extremely high cost of oil and natural gas well-drilling operations. Consequently, special-use instructions had to accompany the delivery of these shipments to the drilling platforms. Moreover, the short-weight shipments had to be isolated in Wet-Land's warehouse, causing extra handling and poor space utilization. Thus, Wells was informed that Wet-Land might seek a new supplier of mud-treating agents if, in the future, it received bags that deviated significantly from 50 pounds. The quality control department at Bayfield suspected that the lightweight bags might have resulted from growing pains at the Orange plant. Because of the earlier energy crisis, oil and natural gas exploration activity had greatly increased. In turn, this increased activity created increased demand for products produced by related industries, including drilling muds. Consequently, Bayfield had to expand from a one-shift (6:00 A.M. to 2:00 P.M.) to a two-shift (2:00 P.M. to 10:00 P.M.) operation in mid-2013, and finally to a three-shift operation (24 hours per day) in the fall of 2018. The additional night-shift bagging crew was staffed entirely by new employees. The most experienced foremen were temporarily assigned to supervise the night-shift employees. Most emphasis was placed on increasing the output of bags to meet ever-increasing demand. It was suspected that only occasional reminders were made to double-check the bag weight-feeder. (A double-check is performed by systematically weighing a bag on a scale to determine if the proper weight is being loaded by the weight-feeder. If there is significant deviation from 50 pounds, corrective adjustments are made to the weight-release mechanism.) past To verify this expectation, the quality control department randomly sampled the bag output. Six bags were taken and weighed each hour. The table in Excel recorded the results in the three days. The quality control department uses 99.73% confidence level in their analysis (hint: Table $6.2 offers the conversion between confidence level and 2-value). As a quality control analyst, you are tasked to address the following questions: 1. Use the sample values to determine the upper control limit (UCL) and lower control limit (LCL) for the x and R control charts. (keep two decimal places) (10 points) 2. What are the UCL and LCL for the x control chart based on the desired mean and standard deviation? (keep two decimal places) (8 points) 3. To meet the weight requirement, which x control limits should we use? Why? (4 points) 1 2 TIME 6:00 a.m. 7:00 8:00 9:00 10:00 11:00 12 noon 1:00 p.m. 2:00 3:00 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 1 48.6 49.2 50.7 51.7 50.9 49.6 49.9 48.6 49.8 48.5 49.1 55.3 51.9 54.6 50.5 51.5 50.3 48.2 46.7 48.6 2 49.3 49.2 51.2 51.6 52.2 49.2 48.3 46.5 47.7 48.6 50.1 51.8 51.5 54.9 53 52.3 49.9 48.4 49.9 46.7 Bag Weight 3 4 50.2 50.1 50.9 50.8 50.8 49.6 50.6 50.8 50.2 50.5 50.9 50.6 46.9 49.8 48.7 47.1 50.6 49.2 50.7 48.6 49.5 50.4 51.7 50 53 52.2 52.5 53.3 48.5 53.1 49.7 50.1 48.1 49.2 49.3 50.5 45.7 46.3 47.9 47.1 5 49.3 49.5 49.7 50.1 50.2 49.1 47.2 47.6 50.2 48.1 49.6 53.5 49.2 53 49.7 49.6 46.2 47.3 48.3 46.2 6 49.8 51 49.6 51.8 52 49.9 48.7 46.8 47.5 50.5 52.7 53.6 51.1 51.5 52.9 49.4 48.6 48.8 46.8 48.4 4:00 5:00 6:00 7:00 8:00 9:00 10:00 11:00 12 midnight 1:00 a.m. 17 482 H 21 A 12 midnight 1:00 a.m. 2:00 22 23 46.8 48.4 45.4 48.5 47.3 24 3:00 4:00 25 26 49 27 28 5:00 6:00 a.m. 7:00 8:00 9:00 10:00 11:00 29 30 B 46.7 48.6 47 46.5 48.1 48.1 49.6 50.6 51.6 50.9 50 50.5 49.1 52.6 50.2 51.6 45.7 46.6 49.3 48 47.5 46.6 50.2 31 32 49.9 46.7 45.9 45.2 48.2 49.5 50.6 50.9 52 50.4 50.6 49.9 50.1 51.7 50.9 47.9 50.1 47.6 43.7 48.1 45.9 48.7 48.6 D 45.7 47.9 48.2 47.4 45.8 47.1 51.4 49.5 50.2 51.1 51.2 50.8 52.1 51.2 50.3 48.1 47.7 47.6 48.3 50.1 48.4 46 46.5 F 48.3 46.2 45.2 45.5 46.2 47.6 50.5 49.8 50.7 50.6 50 49.4 52 49.8 46.3 47.1 48 45.6 48.3 47.1 48.5 49.7 51.1 50.3 50.1 51.6 52 51.2 50.4 48.9 47.1 45.3 45.3 46.4 44.5 47 48.8 33 34 12 noon 1:00 p.m. 2:00 51 48.1 49.3 51.6 49.8 50.4 49.3 52.1 49.5 50.1 50.9 47.7 46.9 41.9 46.2 45.9 44.6 50.2 35 36 37 38 3:00 4:00 5:00 6:00 pm 39 40 51.4 46.2 44.1 44 48.7 45.5 44.5 46.5 41 42 7:00 8:00 9:00 10:00 43 40 48 41 42 43 48.4 46 46.5 48.8 50.1 50.6 44 45 46 47 7:00 8:00 9:00 10:00 11:00 12 midnight 1:00 a.m. 2:00 3:00 4:00 5:00 6:00 7:00 8:00 9:00 48 49 49.1 46.8 50 51 52 53 54 55 56 57 58 59 60 61 62 47.5 46.6 50.2 49.4 49.5 49.5 50.6 49.9 46.4 44.2 47.8 47.1 48.1 50.7 50 51.7 50.6 50.9 48.8 49.8 50.1 46.7 48.1 45.9 48.7 48.6 47.9 48.8 49 49.4 49.8 49 47.5 47.8 49.3 51.2. 48.4 51.7 49.9 50.7 47.9 48.6 49.5 50 48.5 46.4 44.5 47 48.8 47 49.1 50 51.6 49.1 47.6 44.2 45.7 49.2 47.9 48.7 51.9 53.2 49.8 48.9 50.2 50.5 49.1 48.4 46.9 48.3 49.9 50.5 49.2. 50.3 48.9 50.3 49.8 48.7 49.4 51.2 48./ 45.5 44.5 46.5 49.1 48.5 50.5 49.4 49.2 48.1 45.5 47.8. 48.9 48.2 48.4 52.2 53.2 49.8 50.6 50.8 49.9 50.4 47.1 46.2 45.9 44.6 50.2 47.9 50.2 48.4 51.5 49.7 49.7 44.1 48.4 49.1 49.4 48.8 49.5 51.3 50.9 50 49.8 48.9 49.2 48.8 10:00 11:00 12 noon 1:00 pm 2:00 3:00 4:00 5:00 B E F G H I J K L M N 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 no H E 50.5 48.9 3:00 4:00 5:00 6:00 p.m 7:00 8:00 B 49.8 50.1 46.7 45.7 49.5 50 48.5 49.4 49.9 50.4 47.1 44.7 48.3 9:00 47.1 48.3 50.7 48 49.3 49.1 10:00 48.7 49.4 51.2 48.2 48.1 47.3 47.5 49.9 48.1 47.6 46.9 50.1 49.9 51 51.8 49.1 48.4 45.5 44.6 47 49.4 49.5 49.1 47.1 48.6 51.3 50.2 50.4 51.7 49.2 48.8 44.1 48.7 46.9 48.3 48.2 50.5 47.7 47.7 49.4 50.4 51.1 50.3 47.6 47.6 48.6 48.8 46.3 48.2 48.2 50.3 50.6 51.7 49.4 48.6 12 midnight 1:00 a.m. 2:00 50.2 48.2 47.4 48 50.5 48.5 48.2 50.3 50.4 3:00 4:00 5:00 51.8 50.4 Bayfield Mud Company In November 2018, John Wells, a customer service representative of Bayfield Mud Company, was summoned to the Houston warehouse of Wet-Land Drilling, Inc., to inspect three boxcars of mud-treating agents that Bayfield had shipped to the Houston firm (Bayfield's corporate offices and its largest plant are located in Orange, Texas, which is just west of the LouisianaTexas border). Wet-Land had filed a complaint that the 50-pound bags of treating agents just received from Bayfield were short-weight by approximately 5%. The short-weight bags were initially detected by one of Wet-Land's receiving clerks, who noticed that the railroad scale tickets indicated that net weights were significantly less on all three boxcars than those of identical shipments received on October 25, 2018. Bayfield's traffic department was called to determine if lighter-weight pallets were used on the shipments. (This might explain the lighter net weights.) Bayfield indicated, however, that no changes had been made in loading or palletizing procedures. Thus, Wet-Land engineers randomly checked 50 bags and discovered that the average net weight was 47.51 pounds. They noted from past shipments that the process yielded bag net weights averaging exactly 50.0 pounds, with an acceptable standard deviation of 1.2 pounds. Consequently, they concluded that the sample indicated a significant short weight. Bayfield was then contacted, and Wells was sent to investigate the complaint. Upon arrival, Wells verified the complaint and issued a 5% credit to Wet-Land. Wet-Land management, however, was not completely satisfied with the issuance of credit. The charts followed by their mud engineers on the drilling platforms were based on 50-pound bags of treating agents. Lighter-weight bags might result in poor chemical control during the drilling operation and thus adversely affect drilling efficiency. (Mud-treating agents are used to Wet-Land management, however, was not completely satisfied with the issuance of credit. The charts followed by their mud engineers on the drilling platforms were based on 50-pound bags of treating agents. Lighter-weight bags might result in poor chemical control during the drilling operation and thus adversely affect drilling efficiency. (Mud-treating agents are used to control the pH and other chemical properties of the core during drilling operation.) This defect could cause severe economic consequences because of the extremely high cost of oil and natural gas well-drilling operations. Consequently, special-use instructions had to accompany the delivery of these shipments to the drilling platforms. Moreover, the short-weight shipments had to be isolated in Wet-Land's warehouse, causing extra handling and poor space utilization. Thus, Wells was informed that Wet-Land might seek a new supplier of mud-treating agents if, in the future, it received bags that deviated significantly from 50 pounds. The quality control department at Bayfield suspected that the lightweight bags might have resulted from growing pains at the Orange plant. Because of the earlier energy crisis, oil and natural gas exploration activity had greatly increased. In turn, this increased activity created increased demand for products produced by related industries, including drilling muds. Consequently, Bayfield had to expand from a one-shift (6:00 A.M. to 2:00 P.M.) to a two-shift (2:00 P.M. to 10:00 P.M.) operation in mid-2013, and finally to a three-shift operation (24 hours per day) in the fall of 2018. The additional night-shift bagging crew was staffed entirely by new employees. The most experienced foremen were temporarily assigned to supervise the night-shift employees. Most emphasis was placed on increasing the output of bags to meet ever-increasing demand. It was suspected that only occasional reminders were made to double-check the bag weight-feeder. (A double-check is performed by systematically weighing a bag on a scale to determine if the proper weight is being loaded by the weight-feeder. If there is significant deviation from 50 pounds, corrective adjustments are made to the weight-release mechanism.) past To verify this expectation, the quality control department randomly sampled the bag output. Six bags were taken and weighed each hour. The table in Excel recorded the results in the three days. The quality control department uses 99.73% confidence level in their analysis (hint: Table $6.2 offers the conversion between confidence level and 2-value). As a quality control analyst, you are tasked to address the following questions: 1. Use the sample values to determine the upper control limit (UCL) and lower control limit (LCL) for the x and R control charts. (keep two decimal places) (10 points) 2. What are the UCL and LCL for the x control chart based on the desired mean and standard deviation? (keep two decimal places) (8 points) 3. To meet the weight requirement, which x control limits should we use? Why? (4 points) 1 2 TIME 6:00 a.m. 7:00 8:00 9:00 10:00 11:00 12 noon 1:00 p.m. 2:00 3:00 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 1 48.6 49.2 50.7 51.7 50.9 49.6 49.9 48.6 49.8 48.5 49.1 55.3 51.9 54.6 50.5 51.5 50.3 48.2 46.7 48.6 2 49.3 49.2 51.2 51.6 52.2 49.2 48.3 46.5 47.7 48.6 50.1 51.8 51.5 54.9 53 52.3 49.9 48.4 49.9 46.7 Bag Weight 3 4 50.2 50.1 50.9 50.8 50.8 49.6 50.6 50.8 50.2 50.5 50.9 50.6 46.9 49.8 48.7 47.1 50.6 49.2 50.7 48.6 49.5 50.4 51.7 50 53 52.2 52.5 53.3 48.5 53.1 49.7 50.1 48.1 49.2 49.3 50.5 45.7 46.3 47.9 47.1 5 49.3 49.5 49.7 50.1 50.2 49.1 47.2 47.6 50.2 48.1 49.6 53.5 49.2 53 49.7 49.6 46.2 47.3 48.3 46.2 6 49.8 51 49.6 51.8 52 49.9 48.7 46.8 47.5 50.5 52.7 53.6 51.1 51.5 52.9 49.4 48.6 48.8 46.8 48.4 4:00 5:00 6:00 7:00 8:00 9:00 10:00 11:00 12 midnight 1:00 a.m. 17 482 H 21 A 12 midnight 1:00 a.m. 2:00 22 23 46.8 48.4 45.4 48.5 47.3 24 3:00 4:00 25 26 49 27 28 5:00 6:00 a.m. 7:00 8:00 9:00 10:00 11:00 29 30 B 46.7 48.6 47 46.5 48.1 48.1 49.6 50.6 51.6 50.9 50 50.5 49.1 52.6 50.2 51.6 45.7 46.6 49.3 48 47.5 46.6 50.2 31 32 49.9 46.7 45.9 45.2 48.2 49.5 50.6 50.9 52 50.4 50.6 49.9 50.1 51.7 50.9 47.9 50.1 47.6 43.7 48.1 45.9 48.7 48.6 D 45.7 47.9 48.2 47.4 45.8 47.1 51.4 49.5 50.2 51.1 51.2 50.8 52.1 51.2 50.3 48.1 47.7 47.6 48.3 50.1 48.4 46 46.5 F 48.3 46.2 45.2 45.5 46.2 47.6 50.5 49.8 50.7 50.6 50 49.4 52 49.8 46.3 47.1 48 45.6 48.3 47.1 48.5 49.7 51.1 50.3 50.1 51.6 52 51.2 50.4 48.9 47.1 45.3 45.3 46.4 44.5 47 48.8 33 34 12 noon 1:00 p.m. 2:00 51 48.1 49.3 51.6 49.8 50.4 49.3 52.1 49.5 50.1 50.9 47.7 46.9 41.9 46.2 45.9 44.6 50.2 35 36 37 38 3:00 4:00 5:00 6:00 pm 39 40 51.4 46.2 44.1 44 48.7 45.5 44.5 46.5 41 42 7:00 8:00 9:00 10:00 43 40 48 41 42 43 48.4 46 46.5 48.8 50.1 50.6 44 45 46 47 7:00 8:00 9:00 10:00 11:00 12 midnight 1:00 a.m. 2:00 3:00 4:00 5:00 6:00 7:00 8:00 9:00 48 49 49.1 46.8 50 51 52 53 54 55 56 57 58 59 60 61 62 47.5 46.6 50.2 49.4 49.5 49.5 50.6 49.9 46.4 44.2 47.8 47.1 48.1 50.7 50 51.7 50.6 50.9 48.8 49.8 50.1 46.7 48.1 45.9 48.7 48.6 47.9 48.8 49 49.4 49.8 49 47.5 47.8 49.3 51.2. 48.4 51.7 49.9 50.7 47.9 48.6 49.5 50 48.5 46.4 44.5 47 48.8 47 49.1 50 51.6 49.1 47.6 44.2 45.7 49.2 47.9 48.7 51.9 53.2 49.8 48.9 50.2 50.5 49.1 48.4 46.9 48.3 49.9 50.5 49.2. 50.3 48.9 50.3 49.8 48.7 49.4 51.2 48./ 45.5 44.5 46.5 49.1 48.5 50.5 49.4 49.2 48.1 45.5 47.8. 48.9 48.2 48.4 52.2 53.2 49.8 50.6 50.8 49.9 50.4 47.1 46.2 45.9 44.6 50.2 47.9 50.2 48.4 51.5 49.7 49.7 44.1 48.4 49.1 49.4 48.8 49.5 51.3 50.9 50 49.8 48.9 49.2 48.8 10:00 11:00 12 noon 1:00 pm 2:00 3:00 4:00 5:00 B E F G H I J K L M N 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 no H E 50.5 48.9 3:00 4:00 5:00 6:00 p.m 7:00 8:00 B 49.8 50.1 46.7 45.7 49.5 50 48.5 49.4 49.9 50.4 47.1 44.7 48.3 9:00 47.1 48.3 50.7 48 49.3 49.1 10:00 48.7 49.4 51.2 48.2 48.1 47.3 47.5 49.9 48.1 47.6 46.9 50.1 49.9 51 51.8 49.1 48.4 45.5 44.6 47 49.4 49.5 49.1 47.1 48.6 51.3 50.2 50.4 51.7 49.2 48.8 44.1 48.7 46.9 48.3 48.2 50.5 47.7 47.7 49.4 50.4 51.1 50.3 47.6 47.6 48.6 48.8 46.3 48.2 48.2 50.3 50.6 51.7 49.4 48.6 12 midnight 1:00 a.m. 2:00 50.2 48.2 47.4 48 50.5 48.5 48.2 50.3 50.4 3:00 4:00 5:00 51.8 50.4