C D + Moon Fields Cat 1993 30000 Ow MA LS M G DOLE 226 Magan Sum of Sale Columns How Label 1712021 210021 912094 410004 Grand Total Ander Race 21 1180 3120 6 Bucu 3020 2550 1900 1900 Cated 9310 40 110 25000 3120 3 Day 3050 15 1200 905 285 Ful 22263026 2000 1900 10 Jan 3100 30 11 Pasie Garrett 5850 235 239570 11500 12 7180 10 19 Gando 2095 100 1480 1515 14 15 NR NN 0254 GE Ander AutoSave T3_Tshirt Production_Data Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial 10 - A A % v Conditional Formatting E Format as Table 2 Cell Styles Paste A. Number Colls Editing Analyze Data A1 4x fx BATCH A B D E F G ONDON NUM DEFECTIVE 16 10 13 12 20 14 17 19 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 ON 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 MACHINE 5 7 6 8 6 7 8 5 6 7 5 7 8 6 7 5 6 8 7 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 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 4444 BATCH SIZE 500 10000 5000 1000 1000 5000 10000 10000 5000 500 500 1000 5000 10000 10000 5000 500 500 500 1000 10000 10000 10000 5000 1000 DOO O Noua cowo wo 5 21 15 15 12 10 678787 12 Sheet1 + 27 Tahir Production Data M Home Insert DrawPage Layout Formulas Data Review View Tell me Share Comments Arial - 10 -AA 1 weet General 2.17.0. 0 - - De Fowl $. 96 % Cand out FO Cel BE Brie F38 X C D E G B H 1000 5000 10000 15 13 11 23 14 27 2B 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 88888888888888888888 20 20 30 30 30 10 10 20 30 30 20 10 30 10 10 20 20 30 20 30 20 20 30 30 6 6 7 8 5 6 5 7 5 8 6 7 8 6 7 5 6 8 6 7 8 7 5 8 1111 2222 3333 4444 5555 4444 5555 3333 2222 4444 1111 3333 2222 4444 2222 2222 2222 2222 3333 1111 4444 2222 5555 4444 500 500 10000 500 5000 1000 1000 5000 500 10000 5000 1000 1000 5000 10000 500 500 10000 500 5000 1000 o + 2 + d = c a 15 18 15 She + M 2 T Tahir Production Data Home Insert DrawPage Layout Formulas Data Review View Tell me Share Comments Artal - 10 AA weet General Eart- Orie 2:27. - BT a. $. 96 Con Car FOTOS Brie F38 Xf3 F H 1 K V 15 4 50 51 52 53 54 55 50 57 58 %, nu A 49 50 51 52 53 54 65 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 78 00 61 62 63 64 65 66 BY 66 60 70 71 72 73 74 75 76 77 78 Yo 80 wmummmmmmmm B 30 10 10 10 10 20 10 20 30 30 20 20 20 30 30 30 19 10 20 30 20 10 30 30 a 6 7 5 6 7 7 6 5 7 6 7 8 8 6 7 5 6 7 6 7 8 6 7 5 7 6 7 4444 5555 1111 2222 3333 4444 5555 2222 1111 3333 2222 4444 3333 5555 4444 1111 2222 1111 2222 3333 4444 1000 1000 5000 500 10000 500 5000 1000 1000 5000 500 10000 5000 1000 1000 5000 10000 5 18 11 23 14 3 9 17 19 4 7 5 8 21 15 6 9 500 2222 500 10000 500 10000 5000 1000 500 500 10000 1000 5555 4444 5555 3333 1111 56:55 15 12 10 0 0 e8 5 6 0 0 0 3 2 12 20 10 19 he + Assignment Instructions: You will work on Problem 11 on page 14 of Plugin 13 ("Production Errors"). You can obtain the required spreadsheet data file for this assignment by clicking here. Your solution must contain at least one Pivot table, but will likely contain several worksheets that set forth your analysis. Your submission for this assignment will consist of two files, both of which should be uploaded to the dropbox for the assignment: One will be your assignment spreadsheet, containing the worksheets you have used to solve this problem (pivot tables, custom tihers & conditional formatting), The second file will be a one page Word document, in which you communicate your solution to this problem (as you identify what factors are causing the production errors. .e. which variables appear to be most significantly associated as causes of errors in the production batches) and in which you reference each of the worksheets you created in order to justify your answers (Le verbally describing what each of your data analysis worksheets shows and what conclusions can be drawn from it). Helpful Hint: To achieve especially good presentation / substantiation of your answers, don't hesitate to use conditional formatting upon select rows/columns on your pivot table(s) to better highlight the computations and conclusions which underlie your answers and your overall solution narrative, Moreover, in composing your document, while addressing all exercise questions, please try to also go beyond this by telling a coherent and unified story