Overview Using the Excel date file you used in for TA3: Pivot Tables & Decision Support, you will create 2 different charts that visually depict
Overview
Using the Excel date file you used in for TA3: Pivot Tables & Decision Support, you will create 2 different charts that visually depict the Batch Error data and its associated factors.
Whether or not you succeeded with TA3: Pivot Tables & Decision Support, you will use that source data to create 2 different Excel charts (like a bar chart and line chart) that depict the batch error data and its associated factors. The choice of which 2 charts is up to you. Indeed this assignment will offer you more latitude in learning and trying things out. However the following guidelines are offered for this assignment and will be used by the instructor as the basis of assessment:Instructions
- You should create a new column called batch error rate - this will be the batch errors divided by the size of the batch. This new column should really be the basis of your Charts (not simply the raw number of batch errors). .
- You chart should really have a Chart title and a legend (not to mention colors etc.)
- Please provide a short document explaining why you selected these 2 particular types of charts and what they show.
BATCH 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 PRODUCT 10 20 30 30 20 20 30 10 10 30 20 30 10 30 30 10 10 10 10 20 10 20 30 30 20 20 MACHINE 5 7 6 8 6 7 8 5 6 7 5 7 8 6 7 5 6 8 7 6 7 8 7 8 7 6 EMPLOYEE 3333 5555 2222 4444 3333 1111 2222 3333 1111 5555 3333 4444 2222 3333 1111 1111 1111 4444 3333 2222 5555 3333 4444 2222 5555 1111 BATCH SIZE 500 10000 5000 1000 1000 5000 10000 10000 5000 500 500 1000 50 10000 10000 5000 500 500 500 1000 10000 10000 10000 5000 1000 1000 NUM DEFECTIVE 16 10 13 12 5 9 20 14 17 19 4 7 5 8 21 15 6 9 0 15 12 10 8 12 6 8 % DEFECTIVE 0.032 0.001 0.0026 0.012 0.005 0.0018 0.002 0.0014 0.0034 0.038 0.008 0.007 0.001 0.0008 0.0021 0.003 0.012 0.018 0 0.015 0.0012 0.001 0.0008 0.0024 0.006 0.008 5 18 - - 8 6 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 8 20 30 30 30 10 10 20 30 30 20 10 30 10 10 20 20 30 20 30 20 20 30 30 10 10 10 10 - 0 - 0 0 0 0 - 0 0 - 0 0 2222 3333 4444 5555 4444 5555 3333 2222 4444 1111 3333 2222 4444 2222 2222 2222 2222 3333 1111 4444 2222 5555 4444 5555 1111 2222 3333 5000 10000 500 500 10000 500 5000 1000 1000 5000 500 10000 5000 1000 1000 5000 10000 500 500 10000 500 5000 1000 1000 5000 500 10000 4 13 5 18 11 23 14 3 9 1 15 19 3 0 12 0.001 0.0018 0.03 0.008 0.0013 0.01 0.0036 0.011 0.023 0.0028 0.006 0.0009 0.0002 0.015 0.019 0.0006 0 0.024 0.012 0.0008 0.01 0.0036 0.015 0.004 0.0026 0.01 0 0018 5 8 - 500 10000 500 5000 1000 1000 5000 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 500 10 10 20 10 20 30 30 20 20 20 30 30 30 10 10 20 30 20 10 30 30 30 20 10 10 6 7 7 6 5 7 6 7 8 8 6 7 5 2222 3333 4444 5555 2222 1111 3333 2222 4444 3333 5555 4444 1111 2222 1111 2222 3333 4444 2222 5555 4444 5555 3333 1111 5555 5 18 11 23 14 3 9 17 19 4 7 5 8 21 15 6 9 0 15 12 10 8 12 6 8 0.01 0.0018 0.022 0.0046 0.014 0.003 0.0018 0.034 0.0019 0.0008 0.007 0.005 0.0016 0.0021 0.03 0.012 0.0009 0 0.0015 0.0024 0.01 0.016 0.024 0.0006 0.0016 10000 5000 1000 1000 5000 10000 500 500 10000 500 10000 5000 1000 500 500 10000 5000 7 CON 7 8 6 7 5 7 6 7 BATCH 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 PRODUCT 10 20 30 30 20 20 30 10 10 30 20 30 10 30 30 10 10 10 10 20 10 20 30 30 20 20 MACHINE 5 7 6 8 6 7 8 5 6 7 5 7 8 6 7 5 6 8 7 6 7 8 7 8 7 6 EMPLOYEE 3333 5555 2222 4444 3333 1111 2222 3333 1111 5555 3333 4444 2222 3333 1111 1111 1111 4444 3333 2222 5555 3333 4444 2222 5555 1111 BATCH SIZE 500 10000 5000 1000 1000 5000 10000 10000 5000 500 500 1000 50 10000 10000 5000 500 500 500 1000 10000 10000 10000 5000 1000 1000 NUM DEFECTIVE 16 10 13 12 5 9 20 14 17 19 4 7 5 8 21 15 6 9 0 15 12 10 8 12 6 8 % DEFECTIVE 0.032 0.001 0.0026 0.012 0.005 0.0018 0.002 0.0014 0.0034 0.038 0.008 0.007 0.001 0.0008 0.0021 0.003 0.012 0.018 0 0.015 0.0012 0.001 0.0008 0.0024 0.006 0.008 5 18 - - 8 6 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 8 20 30 30 30 10 10 20 30 30 20 10 30 10 10 20 20 30 20 30 20 20 30 30 10 10 10 10 - 0 - 0 0 0 0 - 0 0 - 0 0 2222 3333 4444 5555 4444 5555 3333 2222 4444 1111 3333 2222 4444 2222 2222 2222 2222 3333 1111 4444 2222 5555 4444 5555 1111 2222 3333 5000 10000 500 500 10000 500 5000 1000 1000 5000 500 10000 5000 1000 1000 5000 10000 500 500 10000 500 5000 1000 1000 5000 500 10000 4 13 5 18 11 23 14 3 9 1 15 19 3 0 12 0.001 0.0018 0.03 0.008 0.0013 0.01 0.0036 0.011 0.023 0.0028 0.006 0.0009 0.0002 0.015 0.019 0.0006 0 0.024 0.012 0.0008 0.01 0.0036 0.015 0.004 0.0026 0.01 0 0018 5 8 - 500 10000 500 5000 1000 1000 5000 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 500 10 10 20 10 20 30 30 20 20 20 30 30 30 10 10 20 30 20 10 30 30 30 20 10 10 6 7 7 6 5 7 6 7 8 8 6 7 5 2222 3333 4444 5555 2222 1111 3333 2222 4444 3333 5555 4444 1111 2222 1111 2222 3333 4444 2222 5555 4444 5555 3333 1111 5555 5 18 11 23 14 3 9 17 19 4 7 5 8 21 15 6 9 0 15 12 10 8 12 6 8 0.01 0.0018 0.022 0.0046 0.014 0.003 0.0018 0.034 0.0019 0.0008 0.007 0.005 0.0016 0.0021 0.03 0.012 0.0009 0 0.0015 0.0024 0.01 0.016 0.024 0.0006 0.0016 10000 5000 1000 1000 5000 10000 500 500 10000 500 10000 5000 1000 500 500 10000 5000 7 CON 7 8 6 7 5 7 6 7
