Capability Analysis with various subgroups

New to statistics

Involved In Discussions
Hello guys.



I want to perform a Capability analysis. The product is measured from production and quality control.

In production we usually have more measurements is characteristics like diameter, wall thickness etc in comparison with QC.

For example, see below.



  • Order 1 (measurements):
    3 production & 1 in QC.

  • Order 2 (measurements):
5 production & 2 in QC

  • Order 3 (measurements):
    6 production & 1 in QC.

  • Order 4 (measurements):
4 production & 1 in QC

  • Order 5 (measurements):
8 production & 2 in QC

  • Order 6 (measurements):
5 production & 4 in QC

  • Order 7 (measurements):
4 production & 3 in QC

  • Order 8 (measurements):
4 production & 1 in QC

In production we usually have >= 2 up to 20 measurements.
In Quality Control we usually have >=1 up to 6-8 measurements.



I use Minitab for the calculation:


For production I select the subgroups by order

For QC are the data capable to produce a valid result?

Thank you,
 

Bev D

Heretical Statistician
Leader
Super Moderator
Since you are self proclaimed ‘new to statistics’ the one big caution I give to newbies is that you just never grab an existing pile of data and start torturing it with math. A basic fundamental premise of statistical analysis is that the data are representative of what you want to understand. You will almost always get an answer from a mathematical manipulation of data but that doesn’t mean it is the right answer for the physics of the situation. (A great quote here is that no amount of statistical manipulation can save a flawed experimental design).

Without seeing the data and understanding the process(es) and the subgrouping scheme there is little effective advice to give. I might think that if you use all of the production and QC data together and calculate the average and standard deviation of that data AND you plot the raw data in time sequence of manufacture (not testing) against the specification limits then you might have a reasonable idea of the process capability. But I could be wrong.
Some questions:
  • What is the characteristic?
  • How is it measured? Did it pass an MSA?
  • What is the process that creates the characteristic?
  • What is the sample size and frequency of each ‘subgroup’?
  • What happens when a production sample fails? Is there 100% screening and removal or rework before QC? (If so then you shouldn’t use the QC measurements)
  • What is the QC sample size and frequency? How was it determined? AQL? RQL? Percentage of the lot.
Then I would probably have other questions.

As you no doubt are aware statistical analysis isn’t as simple as finding a some data and selecting a formula to manipulate…
 

New to statistics

Involved In Discussions
Hello Bev D

Thank you for your comments.

What is the characteristic?
Its the charecteristic from the product (tube) length, diameter, weight etc.

How is it measured? Did it pass an MSA?
with micrometers. Msa grr was marginal

What is the process that creates the characteristic?

The process creates alla the above

What is the sample size and frequency of each ‘subgroup’?

depends from the amount (kg) per order
until 1.000 kg
for example
production will measure each batch (5 batches so 5 measurements)
qc control it will take one sample so 1 measurement

In case of 2.000 kg 10 measurements for production and 2 for qc

this is the typical sampling but sometimes depends the customer and the norm that it's product it falls

the combination varies



What happens when a production sample fails? Is there 100% screening and removal or rework before QC? (If so then you shouldn’t use the QC measurements).

depends how bad is the product..in some cases we re work the product on other cases we scrap it

What is the QC sample size and frequency? How was it determined? AQL? RQL? Percentage of the lot.

see above but percentage is the best approximate

I am waiting for your response.

best regards
 

Bev D

Heretical Statistician
Leader
Super Moderator
These are very low sample sizes - but that is a different discussion.

You can use all of the measurements (failed and passing) from the production data. Do NOT use any QC data as it is from a censored population and will not give you any idea of the capability. You will need around 25-30 batches. Do not censor or cherry pick which batches you use: use the last 25-30 batches produced. Calculate the capability using the Sd of all of the measurements ie the long term capability. There is no statistical manipulation at this point to calculating short term capability - the sample sizes are just too small to rely on any calculation without seeing the data in time series.

This calculation will not have any statistical or practical precision - it will only give you a rough idea of the capability; it’s a staring point.

If you would like you can post your data here (the actual measurements not the statistical summary) and we can provide better advice..
 

New to statistics

Involved In Discussions
Bev d

QC measurements
OrderValueYear
1​
0,98​
2021​
2​
1,44​
2021​
2​
1,54​
2021​
3​
1,53​
2021​
4​
1,72​
2021​
5​
1,37​
2021​
6​
2,12​
2021​
7​
1,3​
2021​
8​
1,42​
2021​
10​
1,88​
2021​
11​
1,5​
2022​
12​
1,96​
2022​
12​
1,59​
2022​
13​
1,35​
2022​
13​
1,54​
2022​
13​
1,05​
2022​
14​
1,08​
2022​
15​
1,33​
2022​
16​
1,19​
2022​
17​
1,82​
2022​
17​
1,42​
2022​
17​
1,9​
2022​
18​
1,29​
2022​
19​
1,26​
2022​
19​
1,41​
2022​
20​
1,64​
2022​
20​
1,05​
2022​
21​
1,22​
2023​
22​
1,07​
2023​
23​
1,33​
2023​
24​
1,4​
2023​
25​
1,65​
2023​
25​
1,77​
2023​
26​
1,12​
2023​
27​
1,33​
2023​
27​
1,56​
2023​
27​
1,5​
2023​
27​
1,72​
2023​
27​
0,33​
2023​
27​
1,4​
2023​
 

New to statistics

Involved In Discussions
Bev D

Production measurements

OrderValueYear
1​
0,29​
2021​
1​
0,25​
2021​
1​
0,27​
2021​
1​
0,3​
2021​
1​
0,3​
2021​
2​
0,36​
2021​
2​
0,37​
2021​
2​
0,31​
2021​
2​
0,36​
2021​
2​
0,34​
2021​
2​
0,34​
2021​
2​
0,39​
2021​
2​
0,42​
2021​
3​
0,34​
2021​
3​
0,44​
2021​
3​
0,41​
2021​
3​
0,33​
2021​
3​
0,34​
2021​
3​
0,36​
2021​
4​
0,58​
2021​
4​
0,58​
2021​
4​
0,43​
2021​
4​
0,26​
2021​
4​
0,24​
2021​
4​
0,28​
2021​
4​
0,28​
2021​
4​
0,27​
2021​
5​
0,37​
2021​
5​
0,42​
2021​
5​
0,29​
2021​
5​
0,33​
2021​
5​
0,44​
2021​
6​
0,21​
2021​
6​
0,2​
2021​
6​
0,22​
2021​
6​
0,2​
2021​
6​
0,22​
2021​
6​
0,22​
2021​
7​
0,28​
2021​
7​
0,32​
2021​
7​
0,33​
2021​
7​
0,16​
2021​
7​
0,2​
2021​
7​
0,38​
2021​
7​
0,36​
2021​
7​
0,34​
2021​
7​
0,36​
2021​
7​
0,21​
2021​
8​
0,37​
2021​
8​
0,38​
2021​
8​
0,37​
2021​
9​
0,22​
2021​
9​
0,26​
2021​
9​
0,23​
2021​
9​
0,3​
2021​
9​
0,3​
2021​
9​
0,27​
2021​
10​
0,3​
2021​
10​
0,33​
2021​
10​
0,34​
2021​
10​
0,31​
2021​
11​
0,26​
2022​
11​
0,28​
2022​
11​
0,3​
2022​
11​
0,28​
2022​
11​
0,28​
2022​
11​
0,08​
2022​
12​
0,22​
2022​
12​
0,28​
2022​
12​
0,28​
2022​
12​
0,23​
2022​
12​
0,21​
2022​
12​
0,25​
2022​
12​
0,15​
2022​
12​
0,21​
2022​
12​
0,24​
2022​
12​
0,24​
2022​
12​
0,24​
2022​
12​
0,28​
2022​
13​
0,15​
2022​
13​
0,29​
2022​
13​
0,19​
2022​
13​
0,24​
2022​
13​
0,2​
2022​
13​
0,22​
2022​
13​
0,25​
2022​
13​
0,14​
2022​
13​
0,3​
2022​
14​
0,25​
2022​
14​
0,26​
2022​
14​
0,16​
2022​
14​
0,32​
2022​
14​
0,34​
2022​
14​
0,24​
2022​
14​
0,24​
2022​
14​
0,31​
2022​
15​
0,1​
2022​
15​
0,16​
2022​
15​
0,29​
2022​
16​
0,33​
2022​
16​
0,19​
2022​
16​
0,27​
2022​
16​
0,14​
2022​
16​
0,29​
2022​
16​
0,28​
2022​
17​
0,26​
2022​
17​
0,31​
2022​
17​
0,32​
2022​
17​
0,38​
2022​
17​
0,3​
2022​
17​
0,3​
2022​
17​
0,26​
2022​
17​
0,28​
2022​
18​
0,24​
2022​
18​
0,23​
2022​
18​
0,28​
2022​
18​
0,24​
2022​
18​
0,23​
2022​
18​
0,27​
2022​
19​
0,11​
2022​
19​
0,27​
2022​
19​
0,33​
2022​
19​
0,32​
2022​
20​
0,26​
2022​
20​
0,22​
2022​
20​
0,22​
2022​
20​
0,09​
2022​
20​
0,13​
2022​
20​
0,2​
2022​
20​
0,13​
2022​
20​
0,18​
2022​
20​
0,1​
2022​
20​
0,15​
2022​
20​
0,12​
2022​
21​
0,26​
2023​
21​
0,21​
2023​
21​
0,24​
2023​
21​
0,26​
2023​
21​
0,28​
2023​
22​
0,3​
2023​
22​
0,31​
2023​
22​
0,15​
2023​
22​
0,12​
2023​
22​
0,14​
2023​
22​
0,16​
2023​
23​
0,18​
2023​
23​
0,18​
2023​
23​
0,16​
2023​
23​
0,13​
2023​
23​
0,2​
2023​
23​
0,24​
2023​
23​
0,21​
2023​
24​
0,32​
2023​
24​
0,11​
2023​
24​
0,17​
2023​
24​
0,18​
2023​
25​
0,23​
2023​
25​
0,28​
2023​
25​
0,24​
2023​
25​
0,3​
2023​
25​
0,25​
2023​
26​
0,18​
2023​
26​
0,22​
2023​
26​
0,25​
2023​
27​
0,27​
2023​
27​
0,36​
2023​
27​
0,3​
2023​
27​
0,14​
2023​
27​
0,14​
2023​
 

Miner

Forum Moderator
Leader
Admin
Seamless, Does it affect that much?
It helps us better understand the process and the potential sources of variation. Knowing it is seamless means that many of the dimensions will be autocorrelated and that changes will occur over much longer periods of time. Likely sources will be changes in material and changes to process settings.
 
Last edited:

New to statistics

Involved In Discussions
So.. that's affecting also and the analysis (calculations) ?
I mean.. you will do something different?
If you have an examples i would love to or more information about similar operations
 
Top Bottom