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 > Statistical Analysis Tools, Techniques and SPC
Forum Username


Search the Elsmar Cove
Custom Search
Monitor the Elsmar Forum
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 Twitter Feed
Elsmar Cove Groups
Elsmar Cove Google+ Group  Elsmar Cove LinkedIn Group  Elsmar Cove Facebook Group
Sponsor Links





Donate and $ Contributor Forum Access

Click the graphic above.
Courtesy Quick Links

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

Howard's
International Quality Services
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
business plans, control charts (general), control limits, data analysis, data control, data distributions, statistical analysis and studies, tensile strength and tensile strength testing
Reply
 
Thread Tools Search this Thread Rating: Thread Rating: 1 votes, 5.00 average. Display Modes
  #1  
Old 12th October 2006, 11:06 AM
maxfusion maxfusion is offline
Shy Poster (1 to 5 Posts)

 
Registration Date: Oct 2006
Location: spore
 
Posts: 5
Thanks Given to Others: 0
Thanked 0 Times in 0 Posts
Karma Power: 32
Karma: 10
maxfusion has less than 100 Karma points so far.
Let Me Help You How to Calculate UCL (Upper Control Limit) & LCL (Lower Control Limit) & CL

Hi all

how do i calculate the UCL,LCL & CL for the below data. it has a total of 30 datas and i need to find out also the formula for UCL,LCL & CL as i need to use excel to do the calculations. PLS HELP ME!!!

Tensile strength
2.1
2.5
3.1
3.2
2.3
1.9
2.1
2.2
2.5
3.1
1.8
2.2
3.2
1.4
1.6
2.0
3.1
2.5
3.6
3.3
2.3
2.1
1.9
1.4
1.5
2.5
3.1
4.0
3.5
3.2

Sponsored Links
  #2  
Old 12th October 2006, 12:31 PM
Bev D's Avatar
Bev D Bev D is offline
Heretical Statistician

 
Registration Date: Jan 2003
Location: New England
 
Posts: 2,930
Thanks Given to Others: 1,221
Thanked 2,074 Times in 1,235 Posts
Karma Power: 373
Karma: 16595
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.Bev D is appreciated, and has over 1700 Karma points.
Re: How to Calculate UCL (Upper Control Limit) & LCL (Lower Control Limit) & CL?

calculate the moving range between each value: MR1 = the absolute absolute value of the second value - first value. MR2 = the absolute absolute value of the third value - second value and so on. you will have 29 of these values.
then calculate the average of these 29 values. this is the average moving range, MR Bar

The CL = is the average of the 30 readings.
LCL = average - 2.66*MRbar
UCL = average + 2.66*MRbar

this will ONLY work if the tensile values are in order of PRODUCTION of hte parts. if you dont' know the order of production and you only know the order of the tensile measurements you cannot do the control chart. teh dat must in production time sequence.

But I have to add that I am concerned (no offense intended) that this is a very basic question that can be readily answered by a simpel google search or any SPC book that is lying around. You provide very little background as to the nature of the problem. You seem to have almost no knowledge of SPC and I wonder why you are tasked - feel tasked - to do this on your own (my assumption since you're here)?
Thanks to Bev D for your informative Post and/or Attachment!
Sponsored Links

  #3  
Old 12th October 2006, 02:33 PM
preetham - 2007's Avatar
preetham - 2007 preetham - 2007 is offline
Involved - Posts

 
Registration Date: Feb 2006
Location: india,karnataka,bangalore
 
Posts: 52
Thanks Given to Others: 0
Thanked 0 Times in 0 Posts
Karma Power: 0
Karma: 83
preetham - 2007 has less than 100 Karma points so far.
Image or Photo Re: How to Calculate UCL (Upper Control Limit) & LCL (Lower Control Limit) & CL?

I would like put some comment on this,

Just calculating the UCL & LCL will not tell you that the process is capable of producing the parts per customer requirement.

The UCL,LCL & CL only tells you that the readings you have got are in statistically under control or Not,you have to calculate the Process capability & index then only you will find out that the obtained values are good enough to satisfy the customer specification.CP & CPk value tells that the process is capable of producing the parts per the customer specification .
  #4  
Old 12th October 2006, 03:29 PM
Bev D's Avatar
Bev D Bev D is offline
Heretical Statistician

 
Registration Date: Jan 2003
Location: New England
 
Posts: 2,930
Thanks Given to Others: 1,221
Thanked 2,074 Times in 1,235 Posts
Karma Power: 373
Karma: 16595
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.Bev D is appreciated, and has over 1700 Karma points.
Re: How to Calculate UCL (Upper Control Limit) & LCL (Lower Control Limit) & CL?

of course the LCL and UCL do not provide an assessment fo capability. But, the OP had a very limited and specific question. I answered that question but only after thinking about it for awhile as the OP had obviously not researched the quesiton on their own and provided so little information on his issue that any answer we could give would be highly likely to be mis-used.
  #5  
Old 13th October 2006, 12:41 PM
maxfusion maxfusion is offline
Shy Poster (1 to 5 Posts)

 
Registration Date: Oct 2006
Location: spore
 
Posts: 5
Thanks Given to Others: 0
Thanked 0 Times in 0 Posts
Karma Power: 32
Karma: 10
maxfusion has less than 100 Karma points so far.
Re: How to Calculate UCL (Upper Control Limit) & LCL (Lower Control Limit) & CL?

my apologies if mine question is not through enough.

i actually want to draw a x-bar control chart using the data that i have
but i just do not know the formula and what should i use for the variables

i would like to know if it is possible to draw a x bar control chart for individual measurement as all 30 datas are individual

Last edited by maxfusion; 13th October 2006 at 12:59 PM.
  #6  
Old 13th October 2006, 01:51 PM
Bev D's Avatar
Bev D Bev D is offline
Heretical Statistician

 
Registration Date: Jan 2003
Location: New England
 
Posts: 2,930
Thanks Given to Others: 1,221
Thanked 2,074 Times in 1,235 Posts
Karma Power: 373
Karma: 16595
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.Bev D is appreciated, and has over 1700 Karma points.
Re: How to Calculate UCL (Upper Control Limit) & LCL (Lower Control Limit) & CL?

The formulas I described in my original response ARE the formulas you are looking for.
  #7  
Old 14th October 2006, 01:04 AM
maxfusion maxfusion is offline
Shy Poster (1 to 5 Posts)

 
Registration Date: Oct 2006
Location: spore
 
Posts: 5
Thanks Given to Others: 0
Thanked 0 Times in 0 Posts
Karma Power: 32
Karma: 10
maxfusion has less than 100 Karma points so far.
Re: How to Calculate UCL (Upper Control Limit) & LCL (Lower Control Limit) & CL?

How does 2.66 comes about beacuse in some books they were using d2 as 1.128 under Chart for RANGES. does your 2.66 A3 comes under chart for AVERAGE. please enlighten me.
Thanks
  #8  
Old 8th January 2007, 05:08 PM
Marc's Avatar
Marc Marc is online now
Your Elsmar Cove Host

 
Registration Date: Jan 1996
Location: West Chester - Southern Ohio - USA
Age: 64
 
Posts: 24,037
Thanks Given to Others: 9,463
Thanked 5,161 Times in 3,278 Posts
Blog Entries: 4
Karma Power: 400
Karma: 31947
Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.
Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.
Question Re: How to Calculate UCL (Upper Control Limit) & LCL (Lower Control Limit) & CL?

Quote:
In Reply to Parent Post by maxfusion View Post

How does 2.66 comes about because in some books they were using d2 as 1.128 under Chart for RANGES. does your 2.66 A3 comes under chart for AVERAGE. please enlighten me.
Thanks
Can anyone answer this?

__________________

A Search is a terrible thing to waste!
One Test is Worth 1000 Expert Opinions - The plural of anecdote is not data - Correlation does not imply Causation
We can't solve problems by using the same kind of thinking we used when we created them. - Unknown
Reply

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

Do you find this discussion thread helpful and informational?


Bookmarks


Visitors Currently Viewing this Thread: 3 (0 Registered Visitors (Members) and 3 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
Changing LCL (Lower Control Limit) on a Minitab Control Chart George Davis Using Minitab Software 13 3rd May 2012 10:14 AM
How to Calculate UCL (Upper Control Limits) and LCL (Lower Control Limits) KCIPOH Statistical Analysis Tools, Techniques and SPC 18 30th December 2011 09:56 PM
Calculating UCL (Upper Control Limit) and LCL (Lower Control Limit) Kenwatch Statistical Analysis Tools, Techniques and SPC 14 19th October 2011 09:12 AM
Capability with an Upper Limit but a Lower Limit which is Nominal Value Ospif1 Capability, Accuracy and Stability - Process, Machine, etc. 4 21st August 2011 07:04 PM
UCL (Upper Control Limit) Calculations - Sample Problem QE Statistical Analysis Tools, Techniques and SPC 11 4th January 2010 06:50 AM



The time now is 10:57 PM. 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, Olde West Chester, Ohio 45069-1929
513 341-6272