QI Macro Histogram - Can someone define *sorted data*?

Q

qcman

Registered Visitor
Can someone define *sorted data* as it applies to the screen shot of a histogram I ran. This occurred on one of the 15 different dimensions consisting of 30 readings each on an extrusion profile.
 

Attachments

  • QI Macro Histogram .JPG
    QI Macro Histogram .JPG
    42.5 KB · Views: 261
R

reynald

Quite Involved in Discussions
The conclusion given by the Excel macro comment is wrong. Cpk>Ppk does not mean your process is unstable.
So I guess you don't have to trust that "sorted" data comment as well. I personally never heard of that term in a capability analysis.
 
Last edited:
Q

qcman

Registered Visitor
Thank you for confirming my suspicions. Still kind of wondering what sorted data means. Sounds like I chose certain data as in hand picked (?)
 
Miner

Miner

Forum Moderator
Leader
Admin
The comment regarding sorted data actually does make sense. If the data were sorted low to high (or high to low) the moving or subgroup ranges would be different than they would have been had they been in time series order. This could cause some unusual results when calculating capability indices.

Can you attach your data? Or at least the time series plot of the data?

Also, I noticed this is extrusion data. What type of extrusion product? There is a good chance that your data is also auto correlated, which can also influence control limits and capability indices.
 
Q

qcman

Registered Visitor
Attached are the 15 readings taken for dim #2 on a 100pc aluminum extrusion run. Data collector is not here this week so I can not confirm if the readings are random. Based on the numbers I received and knowing the process I would say they are sequential parts.
 

Attachments

  • 23703 DIMENSIONAL LAYOUT - Copy.xlsx
    26.5 KB · Views: 238
Miner

Miner

Forum Moderator
Leader
Admin
The data appear to be in time series order, and there is some instability in the process as can be seen from the attachment. There was some instability in subgroups 4 - 12, then the process appears to have stabilized. After removing subgroups 4 - 12, the data were normal.
 

Attachments

  • Elsmar.jpg
    Elsmar.jpg
    33.7 KB · Views: 179
R

reynald

Quite Involved in Discussions
Miner said:
The comment regarding sorted data actually does make sense. If the data were sorted low to high (or high to low) the moving or subgroup ranges would be different than they would have been had they been in time series order. This could cause some unusual results when calculating capability indices.
.
Click to expand...

Impressive! I have not imagined that possibility. Thanks a lot. Always a great feel to learn something new.
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
V Minitab GRR crossed Xbar and r method macro needed Using Minitab Software 9
D minitab macro to pull access query with parameters Using Minitab Software 1
J Macro Question: Get Column Name by Column Number / or Use Text constant to link on a Using Minitab Software 1
V Validation of macro - scripts - programs used in statistical software (Minitab-SAS... Qualification and Validation (including 21 CFR Part 11) 5
F Run Minitab Macro from Excel Using Minitab Software 3
M Minitab macro to add reference line to graph Using Minitab Software 1
M Writing a Minitab macro that can manipulate data in all columns Using Minitab Software 3
L Webcam with Macro Capability for Skype between our facility and a satellite location Inspection, Prints (Drawings), Testing, Sampling and Related Topics 2
B Macro Process Mapping (pre-GAP analysis) ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
B Using a File Name as a Variable in an Excel Macro Excel .xls Spreadsheet Templates and Tools 11
J Excel Macros - "Button" on a form that executes a macro Excel .xls Spreadsheet Templates and Tools 8
M Insert Empty Column Using Minitab Macro Using Minitab Software 2
B Wheeler Honest Gauge R&R macro wanted Excel .xls Spreadsheet Templates and Tools 2
B Minitab R14 macro for Power Analysis Using Minitab Software 1
T Minitab - Getting a Minitab Macro to look up a Column Name Using Minitab Software 23
M Minitab Macro-Command 'NUMERIC' to convert a text column to an numeric column Using Minitab Software 8
M Minitab 15 - READ, SET from keyboard or file doesn't work in my macro Using Minitab Software 4
A Process Mapping - for "Audits" - Detailed process map + macro map + FMEA Process Maps, Process Mapping and Turtle Diagrams 10
M Macro to fill up columns when shorter then others Using Minitab Software 4
J RANCOVA (rank ANCOVA) macro for minitab Using Minitab Software 2
M Problem creating a Macro in Minitab Using Minitab Software 4
A A macro-process structure approach to auditing for ISO 9001:2000(8) General Auditing Discussions 19
M Macro to connect to Access Database to get to data - Minitab Macro help Using Minitab Software 1
M Minitab macro vs. Layout tool Using Minitab Software 9
A Effectiveness of Training... micro or macro? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 29
M Macro that will perform a normality test and capability analysis - Minitab help Using Minitab Software 1
M Where to find an acceptance sampling excel macro or .xls template? Inspection, Prints (Drawings), Testing, Sampling and Related Topics 6
M SPC Excel macro add-in - File Attached Excel .xls Spreadsheet Templates and Tools 23
B Histogram beginner dilemma - Manual Calculation vs. JMP 7 Quality Tools, Improvement and Analysis 12
T Change Histogram Binning Using Minitab Software 6
G MS Excel for LSL, USL in Histogram and Standard Deviation Six Sigma 26
R Capability Analysis (using Histogram) for Subgrouped Data Statistical Analysis Tools, Techniques and SPC 16
G Histogram Interpretation when a process is "running too high" or "running too low"? Quality Tools, Improvement and Analysis 4
F Evaluation of a Histogram - Determine if this histogram looks normal or not Statistical Analysis Tools, Techniques and SPC 4
J Can you change the test specifications based on Histogram? Manufacturing and Related Processes 6
O Histogram Attributes and Requirements Statistical Analysis Tools, Techniques and SPC 21
C What Histogram Chart is Good for Varying Measurements? Statistical Analysis Tools, Techniques and SPC 11
D Why the tight control limits? Histogram of the data is slightly skewed to the left Statistical Analysis Tools, Techniques and SPC 17
I Help me make a normal bell curve on my histogram Statistical Analysis Tools, Techniques and SPC 1
Manix How can I add a Normal Distribution Bell Curve to an Excel Histogram? Excel .xls Spreadsheet Templates and Tools 20
V Free Quality Tools for drawing Ishikawa Diagram, Pareto Diagram, Histogram, etc. Quality Assurance and Compliance Software Tools and Solutions 7
V Seeking: Free Quality Tools - Ishikawa diagram, Pareto diagram, histogram, etc. Quality Tools, Improvement and Analysis 5
K Someone asked me this morning what a pulse oximeter was? Other Medical Device and Orthopedic Related Topics 2
M Can someone help me with this CMM programming question? Manufacturing and Related Processes 2
B Can someone help me explain P-Value with a simple word please? Capability, Accuracy and Stability - Processes, Machines, etc. 11
S Placing a calibration sticker with someone other than your initials Records and Data - Quality, Legal and Other Evidence 8
A When someone refuses to follow a process.... Misc. Quality Assurance and Business Systems Related Topics 30
M Can someone share a scrubbed version of Clinical Evaluation Plan (CEP) EU Medical Device Regulations 8
I "On the job training" as a response to how someone was trained? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 92
I Root Cause Analysis when someone simply stops performing a task? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 16

Similar threads

Top Bottom