The Cove Business Standards Discussion Forums More Free Files Forum Discussion Thread Post Attachments Listing Cove Discussion Forums Main Page
QI Macro Histogram - Can someone define *sorted data*?
UL - Underwriters Laboratories - Health Sciences
QI Macro Histogram - Can someone define *sorted data*?
QI Macro Histogram - Can someone define *sorted data*?
QI Macro Histogram - Can someone define *sorted data*?
QI Macro Histogram - Can someone define *sorted data*?
QI Macro Histogram - Can someone define *sorted data*?
QI Macro Histogram - Can someone define *sorted data*?
QI Macro Histogram - Can someone define *sorted data*?
QI Macro Histogram - Can someone define *sorted data*?
QI Macro Histogram - Can someone define *sorted data*?
Go Back   The Elsmar Cove Business Systems and Standards Discussion Forums > >
Forum Username

Elsmar Cove Forum Visitor Notice(s)

Wooden Line

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


Elsmar XML RSS Feed
Elsmar Cove Forum RSS Feed

Monitor the Elsmar Forum
Sponsor Links




Courtesy Quick Links


Links Elsmar Cove visitors will find useful in the quest for knowledge and support:

Jennifer Kirley's
Conway Business Services


Howard's
International Quality Services


Marcelo Antunes'
SQR Consulting, and
Medical Devices Expert Forum


Bob Doering
Bob Doering's Blogs and,
Correct SPC - Precision Machining


Ajit Basrur
Claritas Consulting, LLC



International Standards Bodies - World Wide Standards Bodies

ASQ - American Society for Quality

International Organization for Standardization - ISO Standards and Information

NIST's Engineering Statistics Handbook

IRCA - International Register of Certified Auditors

SAE - Society of Automotive Engineers

Quality Digest

IEST - Institute of Environmental Sciences and Technology


Some Related Topic Tags
data (general), histogram
Reply
 
Thread Tools Search this Thread Rate Thread Content Display Modes
  Post Number #1  
Old 15th September 2017, 04:36 PM
qcman

 
 
Total Posts: 167
Thank You! QI Macro Histogram - Can someone define *sorted data*?

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.
Attached Thumbnails
QI Macro Histogram - Can someone define *sorted data*?-qi-macro-histogram-jpg  

Sponsored Links
  Post Number #2  
Old 18th September 2017, 02:29 AM
reynald's Avatar
reynald

 
 
Total Posts: 279
Re: QI Macro Histogram - Can someone define *sorted data*?

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 by reynald; 18th September 2017 at 02:30 AM. Reason: typo error Pk changed to Ppk
Thank You to reynald for your informative Post and/or Attachment!
Sponsored Links

  Post Number #3  
Old 18th September 2017, 08:10 AM
qcman

 
 
Total Posts: 167
Re: QI Macro Histogram - Can someone define *sorted data*?

Thank you for confirming my suspicions. Still kind of wondering what sorted data means. Sounds like I chose certain data as in hand picked (?)
  Post Number #4  
Old 18th September 2017, 08:32 AM
Miner's Avatar
Miner

 
 
Total Posts: 4,124
Look! Re: QI Macro Histogram - Can someone define *sorted data*?

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.
Thanks to Miner for your informative Post and/or Attachment!
  Post Number #5  
Old 18th September 2017, 10:42 AM
qcman

 
 
Total Posts: 167
Re: QI Macro Histogram - Can someone define *sorted data*?

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.
Attached Files: 1. Scan for viruses before opening, 2. Please report any 'bad' files by Reporting this post, 3. Use at your Own Risk.
File Type: xlsx 23703 DIMENSIONAL LAYOUT - Copy.xlsx (26.5 KB, 15 views)
  Post Number #6  
Old 18th September 2017, 11:03 AM
Miner's Avatar
Miner

 
 
Total Posts: 4,124
Look! Re: QI Macro Histogram - Can someone define *sorted data*?

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.
Attached Thumbnails
QI Macro Histogram - Can someone define *sorted data*?-elsmar-jpg  
Thank You to Miner for your informative Post and/or Attachment!
  Post Number #7  
Old 18th September 2017, 02:14 PM
qcman

 
 
Total Posts: 167
Re: QI Macro Histogram - Can someone define *sorted data*?

Miner you are correct That dip did not register as the cause with me.
  Post Number #8  
Old 19th September 2017, 09:35 PM
reynald's Avatar
reynald

 
 
Total Posts: 279
Re: QI Macro Histogram - Can someone define *sorted data*?

Quote:
In Reply to Parent Post by Miner View Post

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.
.
Impressive! I have not imagined that possibility. Thanks a lot. Always a great feel to learn something new.
Reply

Lower Navigation Bar
Go Back   The Elsmar Cove Business Systems and Standards Discussion Forums > >

Bookmarks



Visitors Currently Viewing this Thread: 1 (0 Registered Visitors (Members) and 1 Unregistered Guest Visitors)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Forum Search
Display Modes Rate Thread Content
Rate Thread Content:

Forum Posting Settings
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Emoticons are On
[IMG] code is On
HTML code is Off


Similar Discussion Threads
Discussion Thread Title Thread Starter Forum Replies Last Post or Poll Vote
Writing a Minitab macro that can manipulate data in all columns minit Using Minitab Software 3 17th April 2013 04:01 AM
Capability Analysis (using Histogram) for Subgrouped Data rdanis Statistical Analysis Tools, Techniques and SPC 16 4th March 2013 02:46 PM
Evaluation of a Histogram - Determine if this histogram looks normal or not fed-up Statistical Analysis Tools, Techniques and SPC 4 14th May 2009 12:54 PM
Macro to connect to Access Database to get to data - Minitab Macro help minitabuser Using Minitab Software 1 12th November 2008 05:54 PM
Why the tight control limits? Histogram of the data is slightly skewed to the left DJCRAI Statistical Analysis Tools, Techniques and SPC 17 25th October 2005 04:33 PM



The time now is 11:33 AM. All times are GMT -4.
Your time zone can be changed in your UserCP --> Options.


 
 
 


NOTE: This forum uses "Cookies"