sampling and inspection scheme can be modeled as a Binomial process with parameters a?and 2.? Dene a'gto be the number of defective microprocessors out of 5 sampled and inspected . Use the spreadsheet named Gateway . a. (3 points ) Starting in cell A3 , moving down , list all possible values for the number of defective microprocessors (out of 5 sampled ). b. (7 points ) Suppose that Intel Corp .'s shipment contains 10% defective microprocessors Use Excel's built in function for the Binomial distribution to calculate the probability for each outcome you listed in column A. Start the probability calculations in cell B3 and move down . o Also , show that you ensured that the sum of the probabilities of all possible outcomes is 1. c. (2 points ) Again , suppose that Intel Corp .'s shipment contains 10% defective microprocessors . In cell C11 , calculate the average number of defectives we expect in a sample of 5 microprocessors by inserting a formula instead of the final value . d. (4 points ) Again , suppose that Intel Corp .'s shipment contains 10% defective microprocessors . In cell C13 , calculate the probability that the entire shipment will be returned (assuming 10% defect rate and 5 microprocessors sampled )by inserting a formula instead of the nal value . e. (4 points ) In cell C15 , calculate the probability that the entire shipment will be kept by Gateway even though the shipment has 10% defective microprocessors assuming 5 microprocessors are sampled . Problem 3 Asterex Inc. produces silicon gaskets that are used to connect piping materials for the petroleum industry . The gaskets are ring shaped , and look like a thin donut with a big hole in the center . It is important that the gaskets have the proper inside diameter (ID), outside diameter (0D ), and wall thickness . The quality control department samples and tests gaskets every 15 minutes to ensure conformance to quality characteristics and engineering specications for the three quality dimensions . Recently , there has been some concern about the OD of the gaskets . A sample of 100 gasket OD measures was taken and the data is in column B. If the gasket production machine is working properly , the population of gasket OD measures can be reasonably modeled by a normal distribution with mean OD = 400 mm and standard deviation OD = 2 mm . Use the spreadsheet named Asterex . a. (8 points ) Find the values for the sample statistics indicated in colurrm D. Use a built -in Excel mction or formula when appropriate . Place the appropriate function or formula for each statistic in the indicated cells E2 :E5. b. (4 points )Notice that the sample mean you calculated in the previous question was just one of many that could have been obtained . That is, many samples of size 100 could have been