Question

1 Approved Answer

Posted on Sep 05, 2024

Also please write a conclusion of the findings. Complete the case problem within the Excel 2019 text. 1. Click on the file link and save

image text in transcribed Also please write a conclusion of the findings.

Complete the case problem within the Excel 2019 text. 1. Click on the file link and save to your computer. 2. Open the file and follow the instructions (steps) as given in the text. 3. Be sure to save your progress as you complete the steps. HINT(S): Step 6. a) cell W10 - calculation takes the absolute reference of V5 minus V10 multiplied by the absolute reference of V6 Step 6. b) cell X10 - calculation takes the absolute reference of V5 plus V10 multiplied by the absolute reference of V6 Step 6 (sample image of first few records): Batch Average (Xbar) Average Batch Range (Rbor) 625.03 14.14 Sample Size Quality Control Limits A2 2 1.880 3 1.023 4 0.729 5 0.577 6 0.483 7 0.419 8 0.373 9 0.337 10 0.308 LCL 598.45 610.56 614.72 616.87 618.20 619.10 619.75 620.26 620.67 UCL 651.61 639.49 635.34 633.19 631.86 630.95 630.30 629.79 629.381 Step 7: Use the VLOOKUP function to complete. The lookup value is the sample size, the table array is the range of data of the quality control limits, column index number refers to either LCL or UCL, and we want an exact match to the lookup. For example, for the first item in cell P6, we can use =VLOOKUP(M6, $U$9:$X$33, 3, FALSE) Step 8: Same type of function is needed, but now we shift the column index number to 4 to capture the UCL values. Step 8: Same type of function is needed, but now we shift the column index number to 4 to capture the UCL values. Step 9: Use the IF function to determine whether "In Control" or "Out of Control" where we use the logical test of the average is less than the LCL value (06 26) Step 7-11 (sample image of first few records): Range 15 16 19 20 Sample Size 10 10 10 10 8 10 10 8 101 Quality Control Summary Average LCL UCL 624.40 620.67 629.38 630.30 620.67 629.38 624.00 620.67 629.38 626.30 620.67 629.38 623.13 619.75 630.30 625.00 620.67 629.38 624.70 620.67 629.38 625.63 619.75 630.30 618.50 620.67 629.38 LCL Result UCL Result In Control In Control In Control Out of Control In Control In Control In Control In Control In Control In Control In Control In Control In Control In Control In Control In Control Out of Controll In Control 6 16 16 9 23 Step 12: Provide a short summary of the results in regards to the machines. This does not need to be extensive. A short paragraph about the machines which are 'out of control is fine. Multex Digital Author Date Purpose To perform a quality control analysis on fifty batches of semiconductor wafers to determine whether the wafer thickness (measured in microns) is within control 1 Multex Digital 2 Quality Control Data 3 Semiconductor Thickness (microns) 4 5 Batch Quality Control Summary Average LCL UCL Sample Size Range LCL Result UCL Result Batch Average (Xbar) Average Batch Range (Rbar) 624 629 617 629 629 6321 629 618 629 6341 620 626 623 629 629 Sample Size 628 635 624 623 620 633 619 LCL UCL 621 6231 615 629 623 627 616 629 622 623 6211 624 628 627 619 6231 627 6311 612 615 626 625 619 634 624 621 617 622 623 618 629 632 630 615 632) 623 6221 626 623 627 623 612 626 626 635 633 625 627 626 630 623 627 623 627 623 635 6341 6221 6211 6241 623 631 624 617 622 625 626 626 625 634 626 629 627 624 625 622 617 621 636 623 633 6251 630 633 629 638 625 623 628 627 615 622 629 618 627 627 618 625 623 620 627 624 622 626 627 618 615 630 632 620 6311 615 6321 626 624 632 625 611 619 628 624 621 620 633 629 620 615 624 622 634 626 633 624 626 634 621 622 6301 627 630 631 622 632 625 625 625 629 620 620 636 627 456789mmBH BB=Ba888888 88888ggggggg=898588w88 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 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 54 55 56 Quality Control Limits A2 2 1.880 3 1.023 4 0.729 51 0.577 6 0.483 7 0.419 8 0.373 9 0.337 10 0.3081 11 0.2851 12 0.266 13 0.249 14 0.235 15 0.223 16 0.212 17 0.203 18 0.194 19 0.187 201 0.180 21 0.173 221 0.167 23 0.162 24 0.157 0.153 621 622 628 627 621 623 621 619 617 6311 626 630 6241 627 622 628 621 624 617 625 618 628 615 6301 630 627 621 620 627 628 624) 622 633 631 629 6271 632 615 620 628 618 631 624 629 621 616 631 627 635 624 625 6211 622 626 624 621 629 614 632 618 620 630 624 629 623 623 623 624 619 626 629 623 630 626 620 632 625 624 622 626 617 619 631 625 635 616 627 631 621 625 626 25 625 625 614 630 6251 616 625 622 621 619 631 618 630 626 618 625 618 627 626 633 617 626 622 616 630 620 627 618 631 637 621 619 622 620 625 618 635 6261 6261 6191 6271 634 628 627 624 628 622 621 625 627 619 628 624 6301 6241 618 619 627 627 6241 618 624 621 629 6311 623 628 624 625 618 626 6291 6241 6171 628 628 622 630 623 625 628 625 627 626 613 631 623 611 628 637 634 612 613 624 628 621 629 629 630 628 631 622 625 629 630 616 622 630 629 624 631 623 622 624 624 625 624 623 633 630 627 632 622 615 631 619 619) 622 635 628 622 631 636 621 6281 625 623 621 615 633 621 632 618 626 615 622 628 613 622 628 619 635 627 633 627 626 622 626 629 625 6281 622 629 621 626 615 630 630 6171 620 625 627 631 625 626 619 629 621 623 617 626 629 6421 638 641 Complete the case problem within the Excel 2019 text. 1. Click on the file link and save to your computer. 2. Open the file and follow the instructions (steps) as given in the text. 3. Be sure to save your progress as you complete the steps. HINT(S): Step 6. a) cell W10 - calculation takes the absolute reference of V5 minus V10 multiplied by the absolute reference of V6 Step 6. b) cell X10 - calculation takes the absolute reference of V5 plus V10 multiplied by the absolute reference of V6 Step 6 (sample image of first few records): Batch Average (Xbar) Average Batch Range (Rbor) 625.03 14.14 Sample Size Quality Control Limits A2 2 1.880 3 1.023 4 0.729 5 0.577 6 0.483 7 0.419 8 0.373 9 0.337 10 0.308 LCL 598.45 610.56 614.72 616.87 618.20 619.10 619.75 620.26 620.67 UCL 651.61 639.49 635.34 633.19 631.86 630.95 630.30 629.79 629.381 Step 7: Use the VLOOKUP function to complete. The lookup value is the sample size, the table array is the range of data of the quality control limits, column index number refers to either LCL or UCL, and we want an exact match to the lookup. For example, for the first item in cell P6, we can use =VLOOKUP(M6, $U$9:$X$33, 3, FALSE) Step 8: Same type of function is needed, but now we shift the column index number to 4 to capture the UCL values. Step 8: Same type of function is needed, but now we shift the column index number to 4 to capture the UCL values. Step 9: Use the IF function to determine whether "In Control" or "Out of Control" where we use the logical test of the average is less than the LCL value (06 26) Step 7-11 (sample image of first few records): Range 15 16 19 20 Sample Size 10 10 10 10 8 10 10 8 101 Quality Control Summary Average LCL UCL 624.40 620.67 629.38 630.30 620.67 629.38 624.00 620.67 629.38 626.30 620.67 629.38 623.13 619.75 630.30 625.00 620.67 629.38 624.70 620.67 629.38 625.63 619.75 630.30 618.50 620.67 629.38 LCL Result UCL Result In Control In Control In Control Out of Control In Control In Control In Control In Control In Control In Control In Control In Control In Control In Control In Control In Control Out of Controll In Control 6 16 16 9 23 Step 12: Provide a short summary of the results in regards to the machines. This does not need to be extensive. A short paragraph about the machines which are 'out of control is fine. Multex Digital Author Date Purpose To perform a quality control analysis on fifty batches of semiconductor wafers to determine whether the wafer thickness (measured in microns) is within control 1 Multex Digital 2 Quality Control Data 3 Semiconductor Thickness (microns) 4 5 Batch Quality Control Summary Average LCL UCL Sample Size Range LCL Result UCL Result Batch Average (Xbar) Average Batch Range (Rbar) 624 629 617 629 629 6321 629 618 629 6341 620 626 623 629 629 Sample Size 628 635 624 623 620 633 619 LCL UCL 621 6231 615 629 623 627 616 629 622 623 6211 624 628 627 619 6231 627 6311 612 615 626 625 619 634 624 621 617 622 623 618 629 632 630 615 632) 623 6221 626 623 627 623 612 626 626 635 633 625 627 626 630 623 627 623 627 623 635 6341 6221 6211 6241 623 631 624 617 622 625 626 626 625 634 626 629 627 624 625 622 617 621 636 623 633 6251 630 633 629 638 625 623 628 627 615 622 629 618 627 627 618 625 623 620 627 624 622 626 627 618 615 630 632 620 6311 615 6321 626 624 632 625 611 619 628 624 621 620 633 629 620 615 624 622 634 626 633 624 626 634 621 622 6301 627 630 631 622 632 625 625 625 629 620 620 636 627 456789mmBH BB=Ba888888 88888ggggggg=898588w88 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 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 54 55 56 Quality Control Limits A2 2 1.880 3 1.023 4 0.729 51 0.577 6 0.483 7 0.419 8 0.373 9 0.337 10 0.3081 11 0.2851 12 0.266 13 0.249 14 0.235 15 0.223 16 0.212 17 0.203 18 0.194 19 0.187 201 0.180 21 0.173 221 0.167 23 0.162 24 0.157 0.153 621 622 628 627 621 623 621 619 617 6311 626 630 6241 627 622 628 621 624 617 625 618 628 615 6301 630 627 621 620 627 628 624) 622 633 631 629 6271 632 615 620 628 618 631 624 629 621 616 631 627 635 624 625 6211 622 626 624 621 629 614 632 618 620 630 624 629 623 623 623 624 619 626 629 623 630 626 620 632 625 624 622 626 617 619 631 625 635 616 627 631 621 625 626 25 625 625 614 630 6251 616 625 622 621 619 631 618 630 626 618 625 618 627 626 633 617 626 622 616 630 620 627 618 631 637 621 619 622 620 625 618 635 6261 6261 6191 6271 634 628 627 624 628 622 621 625 627 619 628 624 6301 6241 618 619 627 627 6241 618 624 621 629 6311 623 628 624 625 618 626 6291 6241 6171 628 628 622 630 623 625 628 625 627 626 613 631 623 611 628 637 634 612 613 624 628 621 629 629 630 628 631 622 625 629 630 616 622 630 629 624 631 623 622 624 624 625 624 623 633 630 627 632 622 615 631 619 619) 622 635 628 622 631 636 621 6281 625 623 621 615 633 621 632 618 626 615 622 628 613 622 628 619 635 627 633 627 626 622 626 629 625 6281 622 629 621 626 615 630 630 6171 620 625 627 631 625 626 619 629 621 623 617 626 629 6421 638 641