the 'Note' is date to submit it.

You are being hired as a Quality Assurance technician at the final testing section of an engine assembly plant at PeroTIGA, which is the third national car of Malaysia. By referring to Table 2, analyse the inspection result using EXCEL spreadsheet. (40 marks) Table 2: Preliminary data of engine assembly final test. Subgroup Number Number Inspected (n) Number of Nonconforming (np) 2385 5 2 8 1451 1935 3 10 4 2450 4 s 1997 9 6 5 2168 1941 7 7 8 1962 4 9 9 10 5 2244 1238 2289 1464 11 5 12 6 13 2061 7 14 1667 4 15 2350 16 8 17 8 18 2354 1509 2190 2678 2252 0 19 3 20 8 21 1641 14 22 1782 29 23 30 1993 2382 24 37 25 2132 46 26 1788 50 27 60 28 1890 2001 2000 65 29 70 30 1980 80 You are being hired as a Quality Assurance technician at the final testing section of an engine assembly plant at PeroTIGA, which is the third national car of Malaysia. By referring to Table 2, analyse the inspection result using EXCEL spreadsheet. (40 marks) Table 2: Preliminary data of engine assembly final test. Subgroup Number Number Inspected (n) Number of Nonconforming (np) 2385 5 2 8 1451 1935 3 10 4 2450 4 s 1997 9 6 5 2168 1941 7 7 8 1962 4 9 9 10 5 2244 1238 2289 1464 11 5 12 6 13 2061 7 14 1667 4 15 2350 16 8 17 8 18 2354 1509 2190 2678 2252 0 19 3 20 8 21 1641 14 22 1782 29 23 30 1993 2382 24 37 25 2132 46 26 1788 50 27 60 28 1890 2001 2000 65 29 70 30 1980 80