assignment 3 - these cells must be green. o Create a...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
QUALITY ASSURANCE AND ISO 9000 ASSIGNMENT 3 A shaft with specifications of .495 to .505 inch is being turned on a CNC turning centre. Measurements was taken and recorded on the data table below. Using this data perform all the necessary calculations to complete the process output analysis form attached t the end of “Lesson 6”. Create and complete the form on an Excel spreadsheet template. Include the following enhancements in your spreadsheet: Place a border around all cells with a formula; Protect all cells that contain a formula; Merge a number of cells to add the following comments and conditions based on the results of the C pk calculations: o “PROCESS NOT ACCEPTABLE, Cpk is less than 1.33”; when Cpk is less than 1.33. The pattern of these cells must be ‘red’. o “PROCESS IS ACCEPTABLE, Cpk is equal to or greater than 1.33”. When Cpk is equal to or greater than 1.33. The pattern of
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: these cells must be green. o Create a histogram of the process and draw the following: The USL and LSL The mean of the process, and The process capability Data Table. 0.502 0.496 0.501 0.502 0.5 0.498 0.502 0.498 0.499 0.504 0.497 0.501 0.502 0.503 0.5 0.501 0.5 0.499 0.5 0.502 0.496 0.502 0.5 0.499 0.505 0.496 0.499 0.502 0.5 0.504 0.495 0.499 0.503 0.499 0.504 0.499 0.501 0.502 0.499 0.498 0.499 0.501 0.503 0.498 0.501 0.501 0.5 0.502 0.5 0.5 0.501 0.498 0.503 0.499 0.498 0.5 0.501 0.502 0.503 0.499 0.5 0.502 0.501 0.5 0.499 0.5 0.501 0.499 0.5 0.501 0.501 0.494 0.5 0.501 0.499 0.502 0.502 0.501 0.5 0.501 0.499 0.5 0.502 0.499 0.498 0.5 0.499 0.5 0.502 0.497 0.5 0.502 0.501 0.5 0.5 0.503 0.502 0.501 0.495 0.501 0.501 0.499 0.5 0.504 0.497 0.5 0.501 0.496 0.5 0.501 0.498 0.5 0.5 0.5 0.502 0.501 0.501 0.497 0.501 0.505 0.501 0.503 0.498 0.501 0.503 Submit for evaluation...
View Full Document

Ask a homework question - tutors are online