Hint: Use the F4 key to make a cell a fixed reference in Excel [20] QUESTION 6 You have recently qualified as an Industrial Engineer and found employment at an organisation manufacturing nails. The company manufacture quality nails in lengths of 1 inch, 2-inch, 3-inch, 4-inch and 5-inche for various uses. Management requested you to investigate quality issues. During your investigation you have found an overrun occurs where nails are slightly defective. The defective nails are placed in a common bin and is sold to the public. In yesterday's production run, 654 of the 1-inch nails, 246 of the 2-inch nails, 44 of the 3-inch nails 49 of the 4- inch nails and 336 of the 5-inch nails was placed in the bin. To advance tour investigation, you would like to determine the probability of finding a certain length of nail if you reach into the bin. Compute the probability that: 6.1 Reaching into the bin you will find a 4-inch nail. (8) (2) 6.2 Reaching into the bin you will find a 5-inch nail. 6.3 If a certain application requires a nail that is 3 inches or shorter, that you will be able to satisfy the requirement of the application. What is the conclusion that can be drawn from the information? (2) [12] ITURN OVERI