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 (OD), and wall thickness. The quality control department samples and tests gaskets every 15 minutes to ensure conformance to quality characteristics and engineering specifications 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. 5 points: Find the values for the sample statistics indicated in column D. Use a built-in Excel function or formula when appropriate. Place the appropriate function or formula for each statistics in the indicated cell in column E.

b. 5 points: The engineering specifications provide that a gasket should be between 395 mm and 405 mm, otherwise a gasket is defective. Assuming the process is working correctly (i.e., using the population distribution of Normal(400, 2)); find the probability that a randomly selected gasket is not defective. Use Excel's built-in function for the Normal distribution to answer the question, and place the value in cell J2.

c. 5 points: The engineering specifications provide that a gasket should be between 395 mm and 405 mm, otherwise a gasket is defective. Assuming the process is working correctly; find the probability that a randomly selected gasket is defective. Use Excel's built-in function for the Normal distribution to answer the question, and place the value in cell J4.