Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 |
Step by Step Solution
★★★★★
3.41 Rating (157 Votes )
There are 3 Steps involved in it
Step: 1
Create ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started