The Elsmar Cove Wiki More Free Files The Elsmar Cove Forums Discussion Thread Index Post Attachments Listing Failure Modes Services and Solutions to Problems Elsmar cove Forums Main Page Elsmar Cove Home Page

Go Back   The Elsmar Cove Forum > Common Quality Assurance Processes and Tools > SPC Monitoring and Statistical Analysis Techniques
Forum Username


Elsmar Cove Forum Sidebar
Custom Search
Monitor the Elsmar Forum
Monitor New Forum Posts
Follow Marc & Elsmar
Elsmar Cove Forum RSS Feed  Marc Smith's Google+ Page  Marc Smith's Linked In Page   Marc Smith's Elsmar Cove YouTube Page  Marc Smith's Facebook Page
Elsmar Cove Groups
Elsmar Cove Google+ Group  Elsmar Cove LinkedIn Group  Elsmar Cove Facebook Group
Sponsor Links







Donate and $ Contributor Forum Access
Sponsored Links
Courtesy Quick Links

Links that Elsmar Cove visitors will find useful in your quest for knowledge:


Howard's
International Quality Services

Atul's
Symphony Technologies

Marcelo Antunes'
SQR Consulting

Bob Doering's
Correct SPC - Precision Machining


NIST's Engineering Statistics Handbook

IRCA - International Register of Certified Auditors

SAE - Society of Automotive Engineers

Quality Digest Portal

IEST - Institute of Environmental Sciences and Technology

ASQ - American Society for Quality


Related Topic Tags
attribute data, data analysis, pull test, statistical analysis and studies, confidence level (statistics)
Reply
 
Thread Tools Search this Thread Rate Thread Content Display Modes
  #1  
Old 10th June 2011, 11:01 AM
Conquer Conquer is offline
Getting Involved (6 to 9 Posts)

 
Registration Date: Feb 2007
Location: Canada
 
Posts: 9
Thanks Given to Others: 2
Thanked 0 Times in 0 Posts
Karma Power: 26
Karma: 10
Conquer has less than 100 Karma points so far.
Please Help! Analyzing Attribute Data - Mechanical Pull Testing of Joint

Fellow Elsmar members, I need some input.

At my company we were trying to validate a process for joining two plastics together. In the process, we will using mechanical pull testing of the joint to ensure it meets the 20 N minimum.

After the validation was completed, I reviewed the data and presented by the team and determined that the data was not normally distributed. The root cause of this was that the test method didn't always result in a failure of the joint, but rather a failure of the joint used to prepare the sample for testing.

So, now I am left with a bunch of data that I can only treat as attribute data and am trying to determine at what confidence I know that my pull strength will meet the 20N minimum. What statistical tools for attribute data can I use to provide me with confidence that I will meet the 20 N minimum.

Any help you could provide would be greatly appreciated.

Sponsored Links
  #2  
Old 10th June 2011, 12:05 PM
Bev D's Avatar
Bev D Bev D is offline
Heretical Statistician

 
Registration Date: Jan 2003
Location: New England
 
Posts: 2,532
Thanks Given to Others: 991
Thanked 1,661 Times in 1,014 Posts
Karma Power: 320
Karma: 12776
Bev D is appreciated, and has over 1700 Karma points.Bev D is appreciated, and has over 1700 Karma points.Bev D is appreciated, and has over 1700 Karma points.Bev D is appreciated, and has over 1700 Karma points.
Bev D is appreciated, and has over 1700 Karma points.Bev D is appreciated, and has over 1700 Karma points.Bev D is appreciated, and has over 1700 Karma points.Bev D is appreciated, and has over 1700 Karma points.Bev D is appreciated, and has over 1700 Karma points.Bev D is appreciated, and has over 1700 Karma points.Bev D is appreciated, and has over 1700 Karma points.
Re: Analyzing Attribute Data - Mechanical Pull Testing of Joint

If you post your data we can provide better help. you do not necessarrily have to treat your data as categorical.
__________________
Statistics without physics is gambling; Physics without statistics is psychics
Sponsored Links

  #3  
Old 10th June 2011, 12:18 PM
Statistical Steven's Avatar
Statistical Steven Statistical Steven is offline
Statistician

 
Registration Date: May 2005
Location: New Jersey
Age: 48
 
Posts: 932
Thanks Given to Others: 206
Thanked 328 Times in 230 Posts
Karma Power: 134
Karma: 4069
Statistical Steven is appreciated, and has over 1700 Karma points.
Statistical Steven is appreciated, and has over 1700 Karma points.Statistical Steven is appreciated, and has over 1700 Karma points.Statistical Steven is appreciated, and has over 1700 Karma points.Statistical Steven is appreciated, and has over 1700 Karma points.Statistical Steven is appreciated, and has over 1700 Karma points.Statistical Steven is appreciated, and has over 1700 Karma points.Statistical Steven is appreciated, and has over 1700 Karma points.Statistical Steven is appreciated, and has over 1700 Karma points.
Send a message via Yahoo to Statistical Steven
Re: Analyzing Attribute Data - Mechanical Pull Testing of Joint

Quote:
In Reply to Parent Post by Conquer View Post

Fellow Elsmar members, I need some input.

At my company we were trying to validate a process for joining two plastics together. In the process, we will using mechanical pull testing of the joint to ensure it meets the 20 N minimum.

After the validation was completed, I reviewed the data and presented by the team and determined that the data was not normally distributed. The root cause of this was that the test method didn't always result in a failure of the joint, but rather a failure of the joint used to prepare the sample for testing.

So, now I am left with a bunch of data that I can only treat as attribute data and am trying to determine at what confidence I know that my pull strength will meet the 20N minimum. What statistical tools for attribute data can I use to provide me with confidence that I will meet the 20 N minimum.

Any help you could provide would be greatly appreciated.
You can use the binomial confidence interval to determine the limit on the percent outside the 20N limit.
__________________
Steven Walfish
When in doubt, ask your company statistician!
  #4  
Old 10th June 2011, 12:27 PM
bobdoering's Avatar
bobdoering bobdoering is offline
Stop X-bar/R Madness

 
Registration Date: May 2002
Location: LaGrange, OH
 
Posts: 3,817
Thanks Given to Others: 1,229
Thanked 1,360 Times in 1,044 Posts
Blog Entries: 20
Karma Power: 443
Karma: 8773
bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.
bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.
Send a message via Yahoo to bobdoering
Re: Analyzing Attribute Data - Mechanical Pull Testing of Joint

Quote:
In Reply to Parent Post by Conquer View Post

At my company we were trying to validate a process for joining two plastics together. In the process, we will using mechanical pull testing of the joint to ensure it meets the 20 N minimum.

After the validation was completed, I reviewed the data and presented by the team and determined that the data was not normally distributed. The root cause of this was that the test method didn't always result in a failure of the joint, but rather a failure of the joint used to prepare the sample for testing.

So, now I am left with a bunch of data that I can only treat as attribute data and am trying to determine at what confidence I know that my pull strength will meet the 20N minimum. What statistical tools for attribute data can I use to provide me with confidence that I will meet the 20 N minimum.
I have this very same issue with weld pull tests, and it does render the data questionable. Typically, the idea is to understand the strength of the weld, not the material - so when the material breaks first the weld is good, but the data does not represent the weld strength. It must by its nature under-represent the weld strength. One would want to throw out that data point because the break did not represent the weld, but you do not know the actual weld strength. That is important, because you may be throwing out high data that would have beneficially affected your capability.

If the question is will the joint system meet 20 N, (so breakage at any point), then you can develop your statistics from the data you have using non-normal distribution statistical analysis for the appropriate distribution model.

The bottom line is you surely can not tell the capability of the joint strength itself accurately with this kind of data - although people will attempt to in order to appease myopic customers.

Ultimate Tensile Strength is usually the worst for repeatability. Often people will use yield to get a more consistent data point for tensile data, but that may still be confounded with the base material yield force in your case distorting the conclusion. I would not likely help your case.

I agree with Bev D - it would be nice to see the data. Also, do you ever get the tensile curves? They would also be nice to see.
__________________
If we didn't care, we wouldn't share. That's why we're there.
Thanks to bobdoering for your informative Post and/or Attachment!
  #5  
Old 10th June 2011, 12:40 PM
Conquer Conquer is offline
Getting Involved (6 to 9 Posts)

 
Registration Date: Feb 2007
Location: Canada
 
Posts: 9
Thanks Given to Others: 2
Thanked 0 Times in 0 Posts
Karma Power: 26
Karma: 10
Conquer has less than 100 Karma points so far.
Re: Analyzing Attribute Data - Mechanical Pull Testing of Joint

Thank you Bev, Steven and Bob for your reply. I have attached my data to this post to provide some insight.

How the data was run was in 3 seperte lots at nominal processing conditions. As you can see from the histograms for the lots, the data is skewed because some break at the actual material joint while others break at the joint created to be able to conduct the test

In reply to Steven, I checked into the binomial confidence interval and all looks good accept that I have a p value of 1. In fact, I will always have a p-value of 1 because if anything fails my product fails.

Also, in the last tab on the sheet I have tried to use an equation for calcuating the sample size needed based on a zero-acceptance sampling plan. I used the equation to work backwards and determine based on a total sample size of 90 peices and a confidence interval how many pieces I could expect to be non-conforming. Not sure if any of you have a comment on this concept.
Attached Files: 1. Scan for viruses before using, 2. Please report any 'bad' files by Reporting this post, 3. Use at your Own Risk.
File Type: xls Pull test data.xls (253.0 KB, 55 views)
  #6  
Old 10th June 2011, 12:55 PM
Statistical Steven's Avatar
Statistical Steven Statistical Steven is offline
Statistician

 
Registration Date: May 2005
Location: New Jersey
Age: 48
 
Posts: 932
Thanks Given to Others: 206
Thanked 328 Times in 230 Posts
Karma Power: 134
Karma: 4069
Statistical Steven is appreciated, and has over 1700 Karma points.
Statistical Steven is appreciated, and has over 1700 Karma points.Statistical Steven is appreciated, and has over 1700 Karma points.Statistical Steven is appreciated, and has over 1700 Karma points.Statistical Steven is appreciated, and has over 1700 Karma points.Statistical Steven is appreciated, and has over 1700 Karma points.Statistical Steven is appreciated, and has over 1700 Karma points.Statistical Steven is appreciated, and has over 1700 Karma points.Statistical Steven is appreciated, and has over 1700 Karma points.
Send a message via Yahoo to Statistical Steven
Re: Analyzing Attribute Data - Mechanical Pull Testing of Joint

Quote:
In Reply to Parent Post by Conquer View Post

Also, in the last tab on the sheet I have tried to use an equation for calcuating the sample size needed based on a zero-acceptance sampling plan. I used the equation to work backwards and determine based on a total sample size of 90 peices and a confidence interval how many pieces I could expect to be non-conforming. Not sure if any of you have a comment on this concept.
Here is the analysis of your data using the upper confidence interval on the binomial. It uses the SAME approach as your last sheet (though instead of solving for n, I solve for p in the binomial for a given sample size.

N Confidence Reliability PPM Upper Limit
150 90% 98% 19835 2.0%
95% 98% 24319 2.4%
99% 96% 35223 3.5%

30 90% 91% 94803 9.5%
95% 89% 114726 11.5%
99% 84% 160327 16.0%
__________________
Steven Walfish
When in doubt, ask your company statistician!
Thank You to Statistical Steven for your informative Post and/or Attachment!
  #7  
Old 10th June 2011, 01:01 PM
bobdoering's Avatar
bobdoering bobdoering is offline
Stop X-bar/R Madness

 
Registration Date: May 2002
Location: LaGrange, OH
 
Posts: 3,817
Thanks Given to Others: 1,229
Thanked 1,360 Times in 1,044 Posts
Blog Entries: 20
Karma Power: 443
Karma: 8773
bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.
bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.
Send a message via Yahoo to bobdoering
Re: Analyzing Attribute Data - Mechanical Pull Testing of Joint

As a quick test I put all of the data together into Distribution Analyzer and attached the results. Remember, this data does NOT represent the joint strength, just the joint system strength (including failures other than the joint itself)
Attached Files: 1. Scan for viruses before using, 2. Please report any 'bad' files by Reporting this post, 3. Use at your Own Risk.
File Type: doc joint pull test.doc (98.5 KB, 45 views)
__________________
If we didn't care, we wouldn't share. That's why we're there.
  #8  
Old 10th June 2011, 01:09 PM
Jim Wynne's Avatar
Jim Wynne Jim Wynne is offline
Cross Forum Moderator

 
Registration Date: Jan 2005
Location: Southeast Wisconsin
 
Posts: 13,323
Thanks Given to Others: 1,778
Thanked 5,331 Times in 3,422 Posts
Blog Entries: 2
Karma Power: 1444
Karma: 39099
Jim Wynne is appreciated, and has over 1700 Karma points.Jim Wynne is appreciated, and has over 1700 Karma points.Jim Wynne is appreciated, and has over 1700 Karma points.Jim Wynne is appreciated, and has over 1700 Karma points.Jim Wynne is appreciated, and has over 1700 Karma points.
Jim Wynne is appreciated, and has over 1700 Karma points.
Re: Analyzing Attribute Data - Mechanical Pull Testing of Joint

Quote:
In Reply to Parent Post by bobdoering View Post

I have this very same issue with weld pull tests, and it does render the data questionable. Typically, the idea is to understand the strength of the weld, not the material - so when the material breaks first the weld is good, but the data does not represent the weld strength. It must by its nature under-represent the weld strength. One would want to throw out that data point because the break did not represent the weld, but you do not know the actual weld strength. That is important, because you may be throwing out high data that would have beneficially affected your capability.

If the question is will the joint system meet 20 N, (so breakage at any point), then you can develop your statistics from the data you have using non-normal distribution statistical analysis for the appropriate distribution model.
This is a good reason that cohesion failure (the material coming apart before the weld does) should be accounted for. In many instances of pull testing it's expected that the adhesive bond will be stronger than the cohesive properties of the materials joined material(s). If a bond is expected to withstand a pull force of x units, and there's cohesive failure before that limit is reached, the bond is considered adequate. This results in attributes data, which should be considered an acceptable way of validating the process.
__________________
We aim to please. You aim too, please.
Reply

Lower Navigation Bar
Go Back   The Elsmar Cove Forum > Common Quality Assurance Processes and Tools > SPC Monitoring and Statistical Analysis Techniques

Do you find this discussion thread helpful and informational?


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
Smilies 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
Transforming your Data - Analyzing a DOE MasterBB Six Sigma 5 8th January 2010 06:25 AM
ANOVA Help Analyzing Extrusion Data Naby7 SPC Monitoring and Statistical Analysis Techniques 7 15th June 2009 11:20 AM
Analyzing Data with a Non-Normal distribution Cognizant SPC Monitoring and Statistical Analysis Techniques 41 21st March 2009 08:46 PM
Can we use the data in intertek or TUV lab testing report as bench testing data? luloo117117 Other US Medical Device Regulation Topics 2 18th March 2009 11:53 AM
Attribute vs. Variables Data - Variable data preferred over Attribute - Auto Industry amanbhai SPC Monitoring and Statistical Analysis Techniques 3 14th June 2005 12:04 AM



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


   


Marc Timothy Smith - Elsmar.com
8466 LeSourdsville-West Chester Road, West Chester, Ohio 45069-1929
513 341-6272