Statistical Process Control, SPC All calculations shall be executed via MS Excel formulas/functions. Data I A manufacturing operation has collected 16 samples containing 110 observations each. The components are evaluated based on a defective, or nonconforming state. 1) List the Control Chart Type 2) Calculate the Target, LCL and UCL (z=3) 3) List All Samples Yielding Corrective Action Data II An aircraft overhaul shop has collected data on aircraft that have been overhauled and released for final inspection upon return to service. The discrepancies are typically resultant from abnormal vibration, fluid leaks and electrical malfunctions. Using 20 samples, or aircraft, discrepancies per aircraft have been recorded. 1) List the Control Chart Type 2) Calculate the Target, LCL and UCL (z=3) 3) List All Samples Yielding Corrective Action