please help!

Mouthwatering Candy Inc. makes high quality Choco Bits. These tiny candy bits are typically used as sprinkles on baked goods. They are starting a new process for packaging the bits in a new 5- ounce bag size. They want to develop a variable data control chart to use for process quality monitoring on the bag weight. A quality analyst has recorded the weight per bag during a pre-production run, taking three bags at a time off the packaging line every 15 minutes. You have decided to construct an X-Bar & R Chart and have received the collected data shown below. Table 1. Process Data for Mouthwatering Choco Bits Sample Weight 1 Our 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 4.5 5.1 $ S 52 4.8 5.3 45 4. 47 32 4.8 3.3 4.7 5.4 53 5.4 5.1 4.9 Weight 2 Weight 3 Du Ounces $ $3 49 49 59 5 45 $ 45 3.3 52 53 $3 $ $3 49 $ 5.4 52 $ 52 33 4.7 49 $3 32 $ S $3 1.1 12 49 4.3 51 49 $2 5.7 4.7 4.5 For this assignment, perform each of the following: a. For the data in Table 1, develop Range and X-Bar tables and use the bag weight information to create a Range graph and an X-Bar graph in Excel. Make sure to use Excel formulas to calculate the table values when possible. The power of the spreadsheet is that when one number changes everything in the spreadsheet is automatically updated (see Canvas Excel tutorial). Plot each graph on its own sheet in Excel. Make sure graphs are properly labeled and are sized to fill the sheet (vertical axis may need adjusting). b. Upon examination of your graphs, are there any out-of- control conditions? If so, identify the specific samples involved with a comment or textbox. Limit your answer to the following out-of-control rules