ZMD is an aerospace company manufacturing commercial aircrafts. ZMD's Aircraft_Series_900 design specifications calls for a certain bolt, Bolt_A, with a minimum ultimate tensile strength of 17.4kN. In addition, ZMD's Quality and Manufacturing department requires all supplier parts conform to 99 percent performance level with respect to part specifications.

You are a design engineer at ZMD. Your manager, Lauren Hull, has sent you the memo below. Ms. Hull has to respond to the Purchasing Department by the end of the working day. She will make a recommendation on behalf of the design department based on your report. In your report, you will address the following:

• Test the data set (provided in Assignment5_Data.xlsx on Blackboard course page) for conformance to a normal probability model, and report on your results.

a) Compute descriptive statistics.
b) Construct a histogram, and a probability plot.
c) Draw a conclusion using results of (a) and (b).

• Report on the probability that a selected bolt will not conform to the specifications.

• Finally, report the level of process variation The Best Bolt Company should hold so that 99 percent of the bolts meet the strength specification.