Control limit calculation (Xbar R charts) using Minitab

D

dkharif

#1
Hello,

I have been trying to calculate control limits (Xbar R charts) for 100 variables using Minitab. :bonk:

Variable types: 100
subgroup size: 5

All of this data is stored in excel columns in this way:

date | x1 | x2 | x3 | x4 | x5 | Variable type

Somebody knows how to perform limits calculation (Xbar, R) for each of the variables without performing "copy paste" each one of the 100 variable types?:confused:

Thanks,
Dave
 
Elsmar Forum Sponsor

Miner

Forum Moderator
Staff member
Admin
#2
It is not totally clear what you are requesting because you have to copy and paste from Excel into Minitab. If you mean how do you get the data from the 5 columns (1 column per measurement) into a format that Minitab can analyze, you need to use Minitab's Data, Stack Columns command. Then tell Minitab that you want to stack columns X1 through X5.
 
D

dkharif

#3
It is not totally clear what you are requesting because you have to copy and paste from Excel into Minitab. If you mean how do you get the data from the 5 columns (1 column per measurement) into a format that Minitab can analyze, you need to use Minitab's Data, Stack Columns command. Then tell Minitab that you want to stack columns X1 through X5.
Thanks for the reply but this is not what I meant. :)
I have a process with approximately 100 Jigs.
At each Jig I measure 5 points (X1 through X5)
and wish to calculate the limits for each of the 100 Jigs.
So basically I want to use the Xbar chart, in which each point is represented by an average of mentioned above 5 points - x1 through x5.

Ok, now the problematic part :rolleyes:
All of the data for all of the Jigs is present in one excel file in form:
date | x1 | x2 | x3 | x4 | x5 | Jig#

and I need to calculate the limits for each of the 100 Jigs.
I know that I need to copy paste the information into minitab, but how to perform the calculation so I will receive limits per each Jig?
 

Bev D

Heretical Statistician
Staff member
Super Moderator
#5
I'm not exactly clear as to what the OP means by limits?

BUT the Xbar R chart won't give him what he wants. The Xbar Chart will only calculate Statistical Control Limits for the 100 AVERAGES as a whole - a single uppper control limit and a single lower control limit. It will also calculate a single RANGE control limit for the acerage range of the 100 subgroups of 5 readings each.

It sounds as if the OP is asking how to use a screwdriver as a drill.

If the OP can clarify:
  • What is the function or purpose of the jigs?
  • What are the 5 readings? for example are they 5 different features on the jig? or are they 5 different parts processed on the jig?
  • What are the "limits" you want? for example: calibration limits for the jig? or is it for the product processed on teh jig?
 
D

dkharif

#6
What is the function or purpose of the jigs?
Mechanical assembly

What are the 5 readings? for example are they 5 different features on the jig? or are they 5 different parts processed on the jig?
5 reading of the same part - measurement of the same dimensions in 5 locations (these 5 points will represent the Jig)

What are the "limits" you want? for example: calibration limits for the jig? or is it for the product processed on teh jig?
Based on 5 points measured per part (those 5 points will represent the "Jig" status) I want to calculate the control limits.

Hope I clarified myself correctly this time :eek:
 
A

Ashmot - 2010

#7
Do all 100 Jigs assemble produce same assembly or different assemblies? :confused:
It might be easy to provide part of the data and a few pictures with locations where data is being collected on Assemblies (to help understand from your explanation provided thus far.)
Sorry could not be of much help.
 

Bev D

Heretical Statistician
Staff member
Super Moderator
#8
to clarify further: the jigs are used to assemble parts. You have taken one part assembled on each of teh 100 jigs. you measured the same feature on each part in 5 different locations on the feature.

is this correct?

Now what are you trying to control or monitor? the feature as assembled? (is the feature a result of assembly of sub parts on the jig?)

on the surface this doesn't sound like a rational subgrouping scheme. in general each jig would have it's own chart and one would subgroup by 5 parts - not 5 readings on a single part - for each jig. There are other approaches that may be appropriate but without more data and a better explanation of waht exactly you are trying to monitor or control we can't help you
 
A

Ashmot - 2010

#9
to clarify further: the jigs are used to assemble parts. You have taken one part assembled on each of teh 100 jigs. you measured the same feature on each part in 5 different locations on the feature.

is this correct?

Now what are you trying to control or monitor? the feature as assembled? (is the feature a result of assembly of sub parts on the jig?)

on the surface this doesn't sound like a rational subgrouping scheme. in general each jig would have it's own chart and one would subgroup by 5 parts - not 5 readings on a single part - for each jig. There are other approaches that may be appropriate but without more data and a better explanation of waht exactly you are trying to monitor or control we can't help you
Bev,
I agree with your comments, hence request to get more clarification. Pictures are worth 1000 words.
Typically in assembly line a jig is used to assemble and create a feature that should be measured and controlled. Multiple operators using multiple jigs producing same part in an assembly cell type of situation can support using Xbar-R control chart for a CTQ feature for customer reporting.
But again I am not sure if I am in-line with what is being asked so any help can be provided:confused::confused:.
 
D

dkharif

#10
Bev,
I agree with your comments, hence request to get more clarification. Pictures are worth 1000 words.
Typically in assembly line a jig is used to assemble and create a feature that should be measured and controlled. Multiple operators using multiple jigs producing same part in an assembly cell type of situation can support using Xbar-R control chart for a CTQ feature for customer reporting.
But again I am not sure if I am in-line with what is being asked so any help can be provided:confused::confused:.
Hi Bev and Ashmot,

I am Attaching a sample of the SPC Data.
I agree with you that this case is not a typical "subgroup by 5 parts" - but 5 readings. The main reason is convenience and monitor.
In order to control those 5 readings I would need 5 charts (per Jig). But after evaluating the data, it was found that combining those readings into Xbar/R chart will fit the needs as well.
So basically reducing the monitor of 500 charts to 200.
My problem is how to calculate the control limits (not the equation) - performing the calculation for 100 Jigs with Minitab.
 

Attachments

Thread starter Similar threads Forum Replies Date
L P-Chart Control Limit Calculation help Statistical Analysis Tools, Techniques and SPC 1
S SPC Control Limit Calculation Statistical Analysis Tools, Techniques and SPC 2
L Why the difference in control limit value when using different calculation methods? Statistical Analysis Tools, Techniques and SPC 2
I X-MR Control Limit calculation question Statistical Analysis Tools, Techniques and SPC 4
S Control chart limit calculation confusion concerning SPC control limit calculation Statistical Analysis Tools, Techniques and SPC 30
H How to control when control limit is out of Specs limit Statistical Analysis Tools, Techniques and SPC 11
R How to calculate UCL (Upper COntrol Limit) and LCL (Lower Control Limit) Statistical Analysis Tools, Techniques and SPC 5
A CQE exam primer Control Limit question Statistical Analysis Tools, Techniques and SPC 2
B Setting Lower Control Limit on Attributes Charts Statistical Analysis Tools, Techniques and SPC 9
I Shewhart Constants vs Central Limit Theorem in calculating Control Limits Statistical Analysis Tools, Techniques and SPC 18
A Change Ratio [Guideline in Control Limit Update] Statistical Analysis Tools, Techniques and SPC 3
D Why a Lower Control Limit on Range and Sigma Statistical Analysis Tools, Techniques and SPC 7
S S-Type Tolerances: How to calculate Cs? Control Limit(s)? Statistical Analysis Tools, Techniques and SPC 8
K Calculating UCL (Upper Control Limit) and LCL (Lower Control Limit) Statistical Analysis Tools, Techniques and SPC 14
K How to establish critical limit for Critical Control Points (CCPs) Food Safety - ISO 22000, HACCP (21 CFR 120) 7
J What Control Chart should be used for Microbial Limit (NMT 100 cfu/m3) Statistical Analysis Tools, Techniques and SPC 12
L When really deserve to compress the Control Limit as an Improvement? Statistical Analysis Tools, Techniques and SPC 9
J Xbar - R Control Chart taking into account the Probability Limit Using Minitab Software 8
B Analytical Lab Environmental Condition (Temperature & Humidity Control Limit) General Measurement Device and Calibration Topics 5
Q UCL (Upper Control Limit) Calculations - Sample Problem Statistical Analysis Tools, Techniques and SPC 11
R ISO9001:2000 "Control of Documents"- What's the limit? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 21
2 What type of Control Chart? USL of 3 and a lower spec limit of 1 Statistical Analysis Tools, Techniques and SPC 1
H When shall I recalculate control limit? Capability, Accuracy and Stability - Processes, Machines, etc. 5
J Control and Handling of Limit or Boundary Sample - Molding company and we get flash Quality Tools, Improvement and Analysis 6
C Designing Control Charts - Variable with Small Variation and Tight Control Limit Statistical Analysis Tools, Techniques and SPC 20
G Changing LCL (Lower Control Limit) on a Minitab Control Chart Using Minitab Software 13
M Subgroup Size for Control Limit Calculations - SPC Statistical Analysis Tools, Techniques and SPC 5
M How to Calculate UCL (Upper Control Limit) & LCL (Lower Control Limit) & CL Statistical Analysis Tools, Techniques and SPC 73
A Point Outside of Control Limit for R Chart - This is not SPC...It's GR&R study Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
M Bias - Upper and Lower control Limit - Bias Study page 88 of the MSA 3rd Edition Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
K SPC for One-sided Specification - Setting the Lower Control Limit Statistical Analysis Tools, Techniques and SPC 4
B How do I calculate Cpk with a single Control Limit? Capability, Accuracy and Stability - Processes, Machines, etc. 15
K Control limit - How is table for x-bar & R control chart derived? Statistical Analysis Tools, Techniques and SPC 7
M Does 4.5 - Alternative RISK CONTROL apply to the Particular Standards? IEC 60601 - Medical Electrical Equipment Safety Standards Series 2
H Control of Change i.e. process and WI IATF 16949 - Automotive Quality Systems Standard 9
Sonja D AIAG VDA PFMEA and Control Plan training FMEA and Control Plans 6
F Quality Control in Electrical Calibration ISO 17025 related Discussions 0
Z Why Control Limits are not the same depending on type of exclusion of data points Using Minitab Software 7
D Engineering Change order vs. Change Control ISO 13485:2016 - Medical Device Quality Management Systems 3
D Computer access, password control ISO 13485:2016 - Medical Device Quality Management Systems 6
A How to control distribution list? Document Control Systems, Procedures, Forms and Templates 2
A Control plan for IATF - example? FMEA and Control Plans 1
J ISO 9001:2015 Clause 8.5.1 Control of Production and service provision - Help with Work Instruction Access ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 13
A Final quality control corrective actions ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 10
J Training on the importance of Document Control Document Control Systems, Procedures, Forms and Templates 3
G How to implement H&S and Quality Control Requirements in Contract for Potential Supplier? Contract Review Process 6
D GAMP CAT 5 Change Control Qualification and Validation (including 21 CFR Part 11) 9
D Use Error Risk Controls and Control Verification ISO 14971 - Medical Device Risk Management 6
S Maintenence related action in Control plan FMEA and Control Plans 3
M ISO 13485 and document control for programs ISO 13485:2016 - Medical Device Quality Management Systems 6

Similar threads

Top Bottom