ASSIGNMENTS

Statistical Quality Control and Acceptance Sampling

1

Assignment #4

(10 pts) 1. Construct a trend chart using the data labeled "HWK#4.1" using Excel or other software of your choosing. Make it "presentation quality" with proper labeling, format, etc.

(10 pts) 2. Question #5 on the last two assignments discussed a Poisson process with an average rate of l = 4. Calculate the Poisson probabilities for this process for c = 0, 1, 2, ..., 10. Then graph those probabilities against c and label the graph accordingly. (This becomes a probability density function graph.)

(10 pts) 3. For the data labeled "HWK#4.3", do the following using Excel or other software of your choosing:

a) Calculate the standard deviation (that is, using an Excel function or statistical output from the other software and identify the value) .

b) Calculate the average.

c) Calculate the 75^th Percentile.

d) Construct two histograms, one with a class interval width of 1.0, one with a class width interval of 2.0. Indicate which histogram you would present and the reason why you selected it.

(10 pts) 4. Calculate the C_p, C_pu and C_pl for the /s chart you constructed in Assignment #3 using the Specification Limits of USL = 25.2 and LSL = 24.8. Comment on the interpretation of the C_pand the resulting C_pk that you additionally calculate. (Review the material in the previous module's PowerPoint on how to get an estimate of s.)

(10 pts) 5. Construct an /R chartusing Dataset A using Excel or other software of your choosing. Make sure you properly identify each chart and provide your analysis of the respective charts.