Determining whether a process yeild is normal or non-normal distribution?

niotusen

Registered Visitor
#1
Hello!
Is there any recomendations of evaluating the process normal or non normal?
Any helpfull excel templates or small software to check the process distribution, stability etc. Capability etc is calculated in a software but no normality test?
Any ideas to test/evaluate the process?
 
Elsmar Forum Sponsor

bpritts

Involved - Posts
#2
We use Minitab, which is a great statistical product, for our capability studies... however, it's not free... I think we paid about $1000 USD for it a few years ago.

You can probably get 80% of the way there by plotting a histogram and visually comparing it to the standard normal curve. For example, it should have a single peak, centered at the mean, and the tails should be similar in size to each other. Many manufacturing processes are not normal, and often there are simple reasons. For example, if you have 2 or more process streams (e.g. 2 different dies or molds), you may get a bi-modal
distribution. If this occurs, you should do your SPC on the two dies or molds separately.

Another problem that may happen is that the distribution may be skewed, if for example it's not possible for a negative dimension to occur. We have this problem when we do SPC for flatness; it's not possible to have negative flatness.

If you're really determined, I think that you could use the chi squared distribution to test the normality of the distribution. The chi square
distribution is built into excel. I've never done this in Excel but it shouldn't
be that difficult.

It is well worth the effort to verify that a distribution is normal... most of SPC is based on the assumption of normality, and if the distribution is not normal,
you will be wasting your time and confusing yourself if you use statistics
when the assumption is not accurate.

Regards,
Brad
 

Steve Prevette

Deming Disciple
Staff member
Super Moderator
#3
Chi Square tests in excel are not too bad to pull off, though you will have to do a fair amount of coding yourself.

Another thing to consider is check if the "skewness" and "kurtosis" are both zero.
 
R

rderoeck - 2006

#4
SPC is distribution free and empirically based. Normality is not required.....Shewhart and Deming were clear on this point.

My 2 cents;
Chart your process, identify special causes, eliminate them and improve.

Rich DeRoeck
 

Douglas E. Purdy

Quite Involved in Discussions
#5
I'm Confused

rderoeck said:
SPC is distribution free and empirically based. Normality is not required.....Shewhart and Deming were clear on this point.

My 2 cents;
Chart your process, identify special causes, eliminate them and improve.

Rich DeRoeck
Rich, Steve, or Anyone who can Help,

I have been told that I am wasting my time on a U-Control Chart because we are trying to monitor a Process that is Not Normal, or at least our attempt to monitor the Order Quoting-Entry-Review-Releasing-Billing (QERRB) Process is not accurate enough. So I have been generating a Histogram with Descriptive Statistics to determine if the number of defects falls in a normal distribution or not. So I have been watching the P Value from the Anderson-Darling Normality Test, to see if and when it would go below .05. In the 42 weeks we have been monitoring these defects, the P Value has fallen from around .9 to .4. Am I way off in this effort? Please see attached file for the various worksheets.

Thanks,
Doug
 

Attachments

Steve Prevette

Deming Disciple
Staff member
Super Moderator
#6
You are correct, the U-chart is non-normal. It is in fact related to the Poisson. Do not take control charting as an exercise in probability. It is an empirical rule which has some good theory and testing behind it. I don't see what you are referring to with the .9 and .4 p values.

Looking at the U-chart, there is an out of control low point on week 33. It looks to the eye that something may have shifted in week 25. The effect of this shift may be hidden because you are updating the baseline with new data values. If you were happy with the initial baseline you should leave it alone.

What I would do is weeks 1 - 24 into a baseline and lock that baseline (this is based upon knowing that week 33 was low). Then I think you will see a lowered baseline for weeks 25 to 42, with the exception of a significantly high spike in week 34 (it is interesting it comes after a drop in week 33 - could some stuff have been counted in 34 that should have been counted in 33?)

The Pareto is a good idea, but be sure to do it only over a time interval that the control chart shows is stable.

Now, all this is based upon only looking at the chart. What happened with the process? Did something change around week 25?
 

Jim Wynne

Staff member
Admin
#7
Steve Prevette said:
Do not take control charting as an exercise in probability. It is an empirical rule which has some good theory and testing behind it.
A control chart is nothing if not "an exercise in probability." What's the point in doing control charting if the charts have no predictive value? How can you have predictive value without a basis is statistical probability?
 

Steve Prevette

Deming Disciple
Staff member
Super Moderator
#8
JSW05 said:
A control chart is nothing if not "an exercise in probability." What's the point in doing control charting if the charts have no predictive value? How can you have predictive value without a basis is statistical probability?
This is a point that was made by Dr. Deming on several occasions. It has taken me a while (as a classically trained Operations Researcher) to get used to this idea, but I think it has merit. A lot of folks teach SPC using the normal distribution and making statements like 99.7% of the data will be between the control limits. There are several things which would cause the 99.7% to be incorrect - such as the data aren't normal (which they aren't in the u-chart) and the calculated baseline may be off (sample vs. reality) and the process data may not be stable. A concern for the 99.7% has sent several people off to mathematically transforming their data, or trying to calculate what the 99.7% limits would be for their distribution. This is not necessary.

Dr. Deming was also against the traditional uses of hypothesis testing.

But we do both agree (and so did Dr. Deming) that the control chart's purpose is prediction.
 

Douglas E. Purdy

Quite Involved in Discussions
#9
I Hope You Do Not Get Tired of Me!

Steve Prevette said:
You are correct, the U-chart is non-normal. It is in fact related to the Poisson. Do not take control charting as an exercise in probability. It is an empirical rule which has some good theory and testing behind it. I don't see what you are referring to with the .9 and .4 p values.

Looking at the U-chart, there is an out of control low point on week 33. It looks to the eye that something may have shifted in week 25. The effect of this shift may be hidden because you are updating the baseline with new data values. If you were happy with the initial baseline you should leave it alone.

What I would do is weeks 1 - 24 into a baseline and lock that baseline (this is based upon knowing that week 33 was low). Then I think you will see a lowered baseline for weeks 25 to 42, with the exception of a significantly high spike in week 34 (it is interesting it comes after a drop in week 33 - could some stuff have been counted in 34 that should have been counted in 33?)

The Pareto is a good idea, but be sure to do it only over a time interval that the control chart shows is stable.

Now, all this is based upon only looking at the chart. What happened with the process? Did something change around week 25?
Steve,

Let me see that I have this right. The U-Chart shows that the number of defects monitored over time for our Order QEERB process is not normal. Besides Week 33 being Outside the LCL, we have more than 4 out of 5 points 1 STD above / below the average (wks 13 thru 20), more than 2 out of 3 points 2 STD above / below the average (wks 8 thru 11 again wks 26 thru 32). But it would appear that weeks 35 on are meeting the rules for normalcy, especially if I re-compute the Baseline - right? (see Attached Chart)

I did not know what Poisson meant.

Main Entry: Pois·son distribution
Pronunciation: pwä-'sOn-
Function: noun
Etymology: Siméon D. Poisson died 1840 French mathematician
: a probability density function that is often used as a mathematical model of the number of outcomes obtained in a suitable interval of time and space, that has its mean equal to its variance, that is used as an approximation to the binomial distribution, and that has the form f(x) = e-µµx/x! where µ is the mean and x takes on nonnegative integral values


But the Histogram was looking Bi-Modal. As for the P value, it was with the Descriptive Statistics shown with the Histogram under the Anderon-Darling Normality Test. So even though the P Value was greater than the .05, the number of defects were not representative of a normal distribution.

As for week 33, that was the week before school started and a number of vacations were taken by the people who monitor these defects. It would make you wonder how many jobs were not identified as not conforming to some specification.

I still wonder if I should continue monitoring the Order Quoting-Entering-Review-Release-Billing process in this manner.

Thanks,
Doug

Realized after posting that weeks 36 on looks too trendy for it to even be normal - right!? Then I really wonder if this is helping us to know how our process is running!

Again - Thanks,
Doug
 

Attachments

Last edited:

Tim Folkerts

Super Moderator
#10
Two observations about the data for the U chart:

1) There seems to be a definite downward trend. According to Minitab...

Regression Analysis: Ave. Number of Defects (U) fo_1 versus Week Number
The regression equation is
Ave. Number of Defects (U) = 0.589 - 0.00542 Week Number

Predictor Coef SE Coef T P
Constant 0.58870 0.04669 12.61 0.000
Week Number -0.005419 0.001732 -3.13 0.004


Congratulations. Overall defects are decreasing. However, that would suggest the process in not in control (in a good way!).


2) Every 4 weeks there is a dip followed by an increase. Regular as clock work (well, there is one time it doesn't come back up). Look at weeks 13, 17, 21, 25, 29, 33, 37, 41. Every one has a higher defect rate the previous week. Every one (except 29) has a higher defect rate the following week. Curious. Is there some root cause?

Tim F
 
Thread starter Similar threads Forum Replies Date
S Determining the requirements for the products and services ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
Q Determining Adverse Effects of Corrective/Preventive Actions ISO 13485:2016 - Medical Device Quality Management Systems 2
S Determining sample sizes for PQ Qualification and Validation (including 21 CFR Part 11) 4
M Determining if an Insulin Pen Testing Machine is a Medical Device? EU Medical Device Regulations 4
M Determining a tolerance value for Measuring devices in-house inspection General Measurement Device and Calibration Topics 12
D Determining the the maximum number of reprocessing cycles of attachments CE Marking (Conformité Européene) / CB Scheme 2
R Determining Uncertainty from Gage R&R Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
A IATF 16949 4.3.1 - Determining the scope of the quality management system - supplemental IATF 16949 - Automotive Quality Systems Standard 9
D ISO 9001:2015 4.3 Determining the Scope of the QMS ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
J Determining SPC tolerance Statistical Analysis Tools, Techniques and SPC 21
B Determining SAT Offsets vs TUS Offsets per SAE AMS 2750E AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 0
B Determining sample size for device sterility Inspection, Prints (Drawings), Testing, Sampling and Related Topics 3
D Determining of sample size for 'Operational Qualification' AQL - Acceptable Quality Level 5
R Question on determining defective units - I am not recording fixture to part rejected Statistical Analysis Tools, Techniques and SPC 5
S Clause 8.2.2 Determining the requirements for products and services ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
D Determining Calibration Frequency schedule for items used in production Manufacturing and Related Processes 2
C Determining if Maintenance Contractor is an External Service subject to ISO 9001 Clause 8.4 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 43
S AS9100D PEAR - Examples for organization's method for determining process results? AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 5
I Determining Calibration Tolerance of a Measurement Device General Measurement Device and Calibration Topics 2
J ISO 17025 Documented Procedure for 6.2.5 - Determining competency ISO 17025 related Discussions 4
V Determining FDA 820 (registration) vs ISO 13485 - Supplier gives us the kit ISO 13485:2016 - Medical Device Quality Management Systems 1
J ISO 9001 8.4.1 - Determining controls applied to externally provided processes ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 8
E Determining what is good and what is bad can be subjective - when is it a quality issue? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 9
F Determining what type of scrap to include in my internal PPM calculation Quality Manager and Management Related Issues 5
M Determining number of employees within the "Scope" of the QMS ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 9
A Determining the Scope of the QMS during Stage 1? Registrars and Notified Bodies 11
W Minor Audit Nonconformance Against Determining the scope of QMS IATF 16949 - Automotive Quality Systems Standard 12
D Determining Critical Components for conformity with IEC 60601-1 IEC 60601 - Medical Electrical Equipment Safety Standards Series 21
Q ISO 9001, section 4.3 Determining the scope of our QMS ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 9
R Determining Sample Size for Medical Device Component Validation Inspection, Prints (Drawings), Testing, Sampling and Related Topics 0
A What does 8.2.2.1, Determining the requirements related to products and services,mean IATF 16949 - Automotive Quality Systems Standard 1
A Determining Retention Period for Medical Device QMS documents Document Control Systems, Procedures, Forms and Templates 5
S Surveillance Sampling Test - Determining Sample Size Inspection, Prints (Drawings), Testing, Sampling and Related Topics 5
F ISO 9001:2015 4.3 - Determining the scope of the quality management system ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
B Standards Needed In House - Determining what standards are applicable Various Other Specifications, Standards, and related Requirements 3
W Determining Medical Device Classification in Mexico Other Medical Device Regulations World-Wide 5
K Determining Effect of Failure without a DFMEA (Design FMEA) FMEA and Control Plans 1
W Determining the Status and Importance of the Processes and Areas to be Audited Internal Auditing 7
T Determining Customer Requirements for the US Postal Service (USPS) IATF 16949 - Automotive Quality Systems Standard 4
Crimpshrine13 Rules of achieving and maintaining IATF recognition - Determining audit days IATF 16949 - Automotive Quality Systems Standard 2
R Developing procedure for Determining Company's Context And Interested Parties ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 53
W Determining Asset Life or Depreciation Life for M&TE General Measurement Device and Calibration Topics 1
N Reason for determining no adverse effect on reworked product ISO 13485:2016 - Medical Device Quality Management Systems 8
N Procedure for determining pinhole position in condom Inspection, Prints (Drawings), Testing, Sampling and Related Topics 1
alonFAI Determining PCBA Xray Test Sampling Size Statistical Analysis Tools, Techniques and SPC 1
S Determining sample size for inspection to achieve x% confidence re defects Misc. Quality Assurance and Business Systems Related Topics 10
S Determining Sample Size - AQL & LQ AQL - Acceptable Quality Level 10
R Determining the feasibility/scope for FDA IQ/OQ against a very simple application US Food and Drug Administration (FDA) 2
B Determining the "storage volume" (ISO 8536-8:2004 clause 6.14) Other Medical Device Related Standards 4
N Procedure/calculation for determining the foot pressure of dial thickness gauge General Measurement Device and Calibration Topics 11

Similar threads

Top Bottom