Question: Please help with step by step on how to create an X control chart in excel with the following numbers Country Code Cycle Time Country
Please help with step by step on how to create an X control chart in excel with the following numbers
| Country Code | Cycle Time | Country Code | Cycle Time |
|---|---|---|---|
| 1 | 20 | 5 | 29 |
| 1 | 24 | 6 | 40 |
| 1 | 46 | 7 | 157 |
| 1 | 26 | 8 | 19 |
| 14 | 38 | 5 | 24 |
| 1 | 15 | 1 | 81 |
| 1 | 15 | 7 | 53 |
| 17 | 23 | 7 | 26 |
| 1 | 31 | 1 | 28 |
| 1 | 31 | 1 | 34 |
| 6 | 64 | 1 | 34 |
| 5 | 29 | 7 | 50 |
| 5 | 44 | 1 | 52 |
| 1 | 32 | 1 | 19 |
| 1 | 15 | 1 | 44 |
| 7 | 11 | 14 | 150 |
| 7 | 14 | 7 | 29 |
| 1 | 89 | 17 | 23 |
| 17 | 41 | 6 | 79 |
| 7 | 41 | 17 | 13 |
| 1 | 36 | 6 | 32 |
| 8 | 43 | 7 | 61 |
| 17 | 21 | 8 | 42 |
| 8 | 28 | 8 | 46 |
| 7 | 18 | 7 | 88 |
| 8 | 47 | 14 | 24 |
| 6 | 26 | 7 | 7 |
| 6 | 47 | 1 | 33 |
| 5 | 9 | 5 | 129 |
| 7 | 42 | 17 | 41 |
| 5 | 5 | 17 | 43 |
| 6 | 27 | 14 | 42 |
| 6 | 27 | 14 | 42 |
| 1 | 33 | 7 | 53 |
| 7 | 44 | 7 | 53 |
| 1 | 21 | 7 | 48 |
| 1 | 22 | 5 | 21 |
| 1 | 50 | 1 | 19 |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help