please show on excel and how

2. (25 Points) Create an Xbar and s chart for the data on page 220 of your text. Show me the math. Data is attached on the following pages. DEPT. PART NO. GROUP Subgroup Time Date 1 2 3 4 5 6 Machine 01-92 Quality Control 1 07:00:00 01/31/96 3.744 3.753 3.757 3.749 3.757 3.749 PART NAME MACHINE VARIABLE 3 07:36:00 01/31/96 3.749 3.747 3.747 3.757 3.750 3.755 2 07:18:00 01/31/96 3.741 3.744 3.745 3.754 3.745 3.747 Whisk Wheel Cutoff 4 07:54:00 01/31/96 3.745 3.750 3.749 3.745 3.749 3.741 OU CAN 5 08:12:00 01/31/96 3.751 3.737 3.755 3.751 3.751 3.739 Subgroup Time Date 1 2 3 4 5 6 OWN 6 08:30:00 01/31/96 3.751 3.755 3.749 3.753 3.755 3.751 7 08:48:00 01/31/96 3.747 3.753 3.737 3.745 3.749 3.744 8 09:06.00 01/31/96 3.749 3.755 3.743 3.749 3.752 3.749 09:24:00 01/31/96 3.751 3.743 3.753 3.757 3.749 3.744 10 09:42:00 01/31/96 3.747 3.757 3.747 3.745 3.751 3.756 15 11:12:00 01/31/96 Subgroup Time Date 11 10:00:00 01/31/96 12 10:18:00 01/31/96 13 10:36:00 01/31/96 14 10:54:00 01/31/96 OWN 1 2 3 4 5 6 Subgroup Time Date 3.747 3.741 3.751 3.750 3.747 3.740 16 11:30:00 01/31/96 3.751 3.745 3.757 3.747 3.749 3.745 21 01:42:00 01/31/96 3.755 3.742 3.749 3.755 3.745 3.745 17 11:48:00 01/31/96 3.758 3.748 3.743 3.751 3.748 3.759 3.747 3.749 3.755 3.749 3.754 3.746 18 12:06:00 01/31/96 3.745 3.744 3.752 3.743 3.750 3.746 3.754 3.747 3.749 3.751 3.756 3.754 19 01:06:00 01/31/96 3.755 3.753 3.750 3.753 3.751 3.752 3.741 3.739 3.751 3.753 3.749 3.743 20 01:24:00 01/31/96 3.747 3.754 3.741 3.745 3.759 3.747 OWN 1 2 3 4 5 6 Subgroup Time Date 22 02:00:00 01/31/96 23 02:18:00 01/31/96 2 3 3.753 3.755 3.747 3.747 3.751 3.747 DUWN 24 02:36:00 01/31/96 3.751 3.753 3.753 3.752 3.757 3.751 3.755 3.749 3.752 3.750 3.753 3.755 3.747 3.749 3.752 3.745 3.750 3.743 5 6