Explore BrainMass
Share

Statistical Process Control Assignment

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

I. (S6.10) A process that is considered to be in control measures an ingreidnet in ounces. Below are the last 10 samples (each of size n =5) taken.
(Sample numbers in the columns and individual observation results below)
1 2 3 4 5 6 7 8 9 10
10 9 13 10 12 10 10 13 8 10
9 9 9 10 10 10 11 10 8 12
10 11 10 11 9 8 10 8 12 9
9 11 10 10 11 12 8 10 12 8
12 10 9 10 10 9 9 8 9 12

a. What is the estimate of the process standard deviation?
b. What are the control limits for the mean chart? (assume 3 sigma limits)
c. What are the control limits for the range chart?
d. Is the process in control?

II. (S6.15) The results of inspection of DNA samples taken over the past 10 days are given below. Sample size is 100.
day defective
1 7
2 6
3 6
4 9
5 5
6 6
7 0
8 8
9 9
10 1

a. Construct a 3-sigma p-chart using this information
b. If the number of defectives on the next three days are 12, 5, and 13, is the process in control?

© BrainMass Inc. brainmass.com October 25, 2018, 7:07 am ad1c9bdddf
https://brainmass.com/statistics/statistical-figures/statistical-process-control-assignment-491673

Attachments

$2.19
See Also This Related BrainMass Solution

Manufacturing Process Statistical Analysis

An Introduction to Gage R & R - Simplified Gauge Verification

Sir/ Ma'am,
I understand the basic premise that Gage R&R helps determine the magnitude of the variation in a measurement system as well as the sources of this variation. I also see that while the sources of variation can be numerous, three of these sources are fundamental: part-to-part variation, repeatability and reproducibility. What I am struggling with are the Excel formulas that are required to chart the specific steps in the verification process. The directions below require Excel formula operations that I am not successful with. Please help me to understand the exact Excel process to chart the activities below.
*************
Suppose in the manufacturing process, a part needs to be 2.5 inches. Due to the random errors, it cannot be 2.5 inches exactly. Here are readings from three inspectors in a verification test. Find the % of gauge error. How does the gauge verification improve the performance of a manufacturing process?

Data from three Inspectors

Master Part Diameter Reading =2.5 in.
Allowable Dimensions:
....Max= 2.55 in.
....Min = 2.35 in.
Reading Diameter Dimension
Inspector A 1 2.51
2 2.53
3 2.55
4 2.54
5 2.49

Inspector B 1 2.50
2 2.52
3 2.39
4 2.41
5 2.43

Inspector C 1 2.52
2 2.53
3 2.47
4 2.48
5 2.39
Assignment Expectations
Provide a report with your analysis. Answer questions with clarity and show the detailed steps for calculation. Use Excel for the calculations. Upload your Excel file into Additional Files.

View Full Posting Details