Country Code

profilesmoove
MAT510Week6assignment5template_6_-11.xlsx
Home>Business & Finance homework help>Country Code

Sheet1

-0.0752698621
0.96
0.04

Question number one

country code I would expect average cylce to be between 0-82
country code I would expect average cylce to be between 0-145.31
country code I would expect average cylce to be between 0-102.334
country code I would expect average cycle to between 0-65.164
country code I would expect average cycle to between 0-22944
country code I would expect average cycle to between 0-64.668

Data and Graphs

Country Codes Cycle Time Moving Range Average Range Average Cycle Time UCL LCL Country Code Average CT Average Moving Range UCL LCL Cycle Time Average Cycle Time UCL LCL
0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 1 ERROR:#DIV/0! 0.0 ERROR:#DIV/0! ERROR:#DIV/0! (4.7, 99.1) Hint: This is how you answer for a confidence interval. Cycle Time Average Cycle Time UCL LCL 68 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 5 ERROR:#DIV/0! 0.0 ERROR:#DIV/0! ERROR:#DIV/0! 65 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 64 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 6 ERROR:#DIV/0! 0.0 ERROR:#DIV/0! ERROR:#DIV/0! 53 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 70 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 7 ERROR:#DIV/0! 0.0 ERROR:#DIV/0! ERROR:#DIV/0! 46 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 75 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 8 ERROR:#DIV/0! 0.0 ERROR:#DIV/0! ERROR:#DIV/0! 45 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 70 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 14 ERROR:#DIV/0! 0.0 ERROR:#DIV/0! ERROR:#DIV/0! 66 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 50 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 17 ERROR:#DIV/0! 0.0 ERROR:#DIV/0! ERROR:#DIV/0! 45 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 50 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 31 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 75 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 31 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 32 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 65 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 50 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 42 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 30 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 42 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 20 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 75 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 52 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 40 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 44 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 87 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 86 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 45 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 75 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 56 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Country Codes Cycle Time Moving Range Average Range Average Cycle Time UCL LCL 75 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
Country Codes Cycle Time Moving Range Average Range Average Cycle Time UCL LCL (, )
0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
Country Codes Cycle Time Moving Range Average Range Average Cycle Time UCL LCL (, )
0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
Country Codes Cycle Time Moving Range Average Range Average Cycle Time UCL LCL (, )
0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! (, )
Country Codes Cycle Time Moving Range Average Range Average Cycle Time UCL LCL
0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Country Codes Cycle Time Moving Range Average Range Average Cycle Time UCL LCL
0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
0 0.0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

Country Codes # 6

Country Codes Moving Range 0 0 0 0 0 0 0 Average Range 0 0 0 0 0 0 0 0 Average Cycle Time 0 0 0 0 0 0 0 0 UCL 0 0 0 0 0 0 0 0 LCL 0 0 0 0 0 0 0 0 Cycle Time

Country Code #7

Country Codes Moving Range 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Average Range 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Average Cycle Time 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 UCL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 LCL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Cycle Time

Country Code #8

Average Cycle Time 37.5 37.5 37.5 37.5 37.5 37.5 UCL 65.164000000000001 65.164000000000001 65.164000000000001 65.164000000000001 65.164000000000001 65.164000000000001 LCL 9.8360000000000003 9.8360000000000003 9.8360000000000003 9.8360000000000003 9.8360000000000003 9.8360000000000003 Cycle Time 43 28 19 42 46 47

Country Code #14

Average Cycle Time 59.2 59.2 59.2 59.2 59.2 UCL 229.44 229.44 229.44 229.44 229.44 LCL 0 0 0 0 0 Cycle Time 38 150 24 42 42

Country Code #17

Average Cycle Time 29.285714285714285 29.29 29.29 29.29 29.29 29.29 29.29 UCL 64.668000000000006 64.668000000000006 64.668000000000006 64.668000000000006 64.668000000000006 64.668000000000006 64.668000000000006 LCL 0 0 0 0 0 0 0 Cycle Time 23 41 21 23 13 41 43

Country Code #1

Average Cycle Time 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 UCL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 LCL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Cycle Time Moving Range 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Average Range 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Country Codes

Country Code #5

Country Codes Moving Range 0 0 0 0 0 0 0 Average Range 0 0 0 0 0 0 0 0 Average Cycle Time 0 0 0 0 0 0 0 0 UCL 0 0 0 0 0 0 0 0 LCL 0 0 0 0 0 0 0 0 Cycle Time

Average Cycle Time 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 UCL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 LCL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Cycle Time 65 53 46 45 66 45 31 31 32 65 50 42 30 42 20 75 52 40 44 87 86 45 75 56 75

Average Cycle Time 0 0 0 0 0 0 0 0 UCL 0 0 0 0 0 0 0 0 LCL 0 0 0 0 0 0 0 0 Cycle Time 68 64 70 75 70 50 50 75

Sheet3

6 64 22.4285714286 42.75 102.334 0 Cycle Time Average Cycle Time UCL LCL
6 40 24 22.4 42.75 102.334 0 43 37.5 65.164 9.836
6 79 39 22.4 42.75 102.334 0 28 37.5 65.164 9.836
6 32 47 22.4 42.75 102.334 0 19 37.5 65.164 9.836
6 26 6 22.4 42.75 102.334 0 42 37.5 65.164 9.836
6 47 21 22.4 42.75 102.334 0 46 37.5 65.164 9.836
6 27 20 22.4 42.75 102.334 0 47 37.5 65.164 9.836
6 27 0 22.4 42.75 102.334 0
Cycle Time Average Cycle Time UCL LCL Cycle Time Average Cycle Time UCL LCL
38 59.2 229.44 0 23 29.29 64.668 0
150 59.2 229.44 0 41 29 64.668 0
24 59.2 229.44 0 21 29 64.668 0
42 59.2 229.44 0 23 29 64.668 0
42 59.2 229.44 0 13 29 64.668 0
41 29 64.668 0
43 29 64.668 0

Country Code #18

Average Cycle Time 29.285714285714285 29.29 29.29 29.29 29.29 29.29 29.29 UCL 64.668000000000006 64.668000000000006 64.668000000000006 64.668000000000006 64.668000000000006 64.668000000000006 64.668000000000006 LCL 0 0 0 0 0 0 0 Cycle Time 23 41 21 23 13 41 43