Create a Xbar- S chart for the data below.

this data set continues down 7550 lines in an excel spread sheet, please just list the steps needed to complete the bar chart (with formulas to use within excel) I have also divided the data into 3 separate excel sheets, ML 1, ML 2 and ML 3 to attempt in breaking up the extremely large data set. I have also deleted any data that had incomplete information.

ML Time:	Time from entry to Station 1 to completion of Station 3
QC Time	Time taken by QC to inspect and accept/reject assembled drone
Shifts	Shift 1: 0600-1100 Shift 2: 1100-1600 Shift 3: 1600-2100

Event ID	Date	ML Time In	ML Time Out	QC Time In	QC Time Out	Manufactoring Line	Quality Control Station	QC Result
21	7/29/18	7:06:30	7:14:13	7:16:20	7:17:58	0	1	PASS
649	8/1/18	9:25:27	9:34:24	9:36:08	9:37:49	0	1	PASS
1046	8/3/18	7:12:46	7:20:30	7:22:25	7:24:44	0	1	FAIL
2173	8/8/18	10:28:37	10:38:27	10:40:22	10:42:25	0	1	PASS
2404	8/9/18	10:58:13	11:06:21	11:08:15	11:10:25	0	1	PASS
3200	8/13/18	10:02:29	10:12:01	10:13:57	10:16:13	0	1	PASS
3959	8/16/18	20:07:58	20:19:39	20:21:38	20:22:39	0	2	FAIL
4821	8/21/18	6:25:19	6:32:48	6:34:54	6:36:27	0	1	PASS
4986	8/21/18	17:44:29	17:50:30	17:52:41	17:54:41	0	2	PASS
5914	8/25/18	18:44:59	18:55:55	18:57:40	19:01:05	0	2	PASS

Answer rating: 100% (QA)

Create ... View the full answer