Elsmar Cove Forum Header Graphic 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
Miner's MSA (Measurement Systems Analysis) Blog 
Go Back   The Elsmar Cove Forum > Common Quality Assurance Processes and Tools > Statistical Analysis Tools, Techniques and SPC
Forum Username

Wooden Line

How to Calculate UCL (Upper Control Limits) and LCL (Lower Control Limits)

Wooden Line
Search the Elsmar Cove
Search Elsmar
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
Donate and $ Contributor Forum Access
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
control chart limits, spc (statistical process control), statistical analysis and studies, control charts (general)
Reply
 
Thread Tools Search this Thread Rate Thread Content Display Modes
  #1  
Old 28th December 2011, 09:42 PM
KCIPOH

 
 
Posts: 178
Question How to Calculate UCL (Upper Control Limits) and LCL (Lower Control Limits)

Hello Cove members,

I need help and would like someone to guide me on how to calculate UCL and LCL for the following attachment.

Can show me in detail for calculating the Mean, Std Dev (step by step)

Need help
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 UCL and LCL_a.xls (14.0 KB, 182 views)

Sponsored Links
  #2  
Old 29th December 2011, 04:41 AM
Stijloor's Avatar
Stijloor

 
 
Posts: 14,647
Re: How to Calculate UCL (Upper Control Limits) and LCL (Lower Control Limits)

A Quick Bump!

Can someone help?

Thank you very much!

Stijloor.
Sponsored Links

  #3  
Old 29th December 2011, 08:35 AM
bobdoering's Avatar
bobdoering

 
 
Posts: 3,939
Re: How to Calculate UCL (Upper Control Limits) and LCL (Lower Control Limits)

By looking at this data, I would have to ask what is this process? What kind of variable are you looking at? To calculate UCL and LCL, you have to pick the correct control chart. I see subgroups, but am not sure if they are adequate. What do the subgroups represent? Do you really want to calculate standard deviation long hand? Do you have a calculator or Excel?
  #4  
Old 29th December 2011, 09:38 AM
Darius's Avatar
Darius

 
 
Posts: 538
Re: How to Calculate UCL (Upper Control Limits) and LCL (Lower Control Limits)

Sorry for deleting the previous response, I attached a file for powerpoint 2007 and saw that the file posted was on a previous version, so it can be seen, change it to 2003.
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: ppt Average and Range Control Chart.ppt (192.5 KB, 277 views)
Thank You to Darius for your informative Post and/or Attachment!
  #5  
Old 29th December 2011, 09:45 AM
bobdoering's Avatar
bobdoering

 
 
Posts: 3,939
Re: How to Calculate UCL (Upper Control Limits) and LCL (Lower Control Limits)

Quote:
In Reply to Parent Post by Darius View Post

I attached a file for powerpoint 2007 ...
Great post. I still bothers me to dump data into a chart without understanding if the chart - or the data - is adequate. It is just a bad way to look at SPC. Borders rubber stamp. That's why I posed the questions before posting the chart.
Thanks to bobdoering for your informative Post and/or Attachment!
  #6  
Old 29th December 2011, 11:50 AM
AnaMariaVR2's Avatar
AnaMariaVR2

 
 
Posts: 512
Re: How to Calculate UCL (Upper Control Limits) and LCL (Lower Control Limits)

Darius...how do you obtain A2 & D4 from the tables?
  #7  
Old 29th December 2011, 12:05 PM
iamtroll

 
 
Posts: 70
Re: How to Calculate UCL (Upper Control Limits) and LCL (Lower Control Limits)

Quote:
In Reply to Parent Post by AnaMariaVR2 View Post

Darius...how do you obtain A2 & D4 from the tables?
It depends on the sample size "n", see slide 4
Thanks to iamtroll for your informative Post and/or Attachment!
  #8  
Old 29th December 2011, 12:12 PM
iamtroll

 
 
Posts: 70
Re: How to Calculate UCL (Upper Control Limits) and LCL (Lower Control Limits)

Quote:
In Reply to Parent Post by bobdoering View Post

Great post. I still bothers me to dump data into a chart without understanding if the chart - or the data - is adequate. It is just a bad way to look at SPC. Borders rubber stamp. That's why I posed the questions before posting the chart.
I agree, but you have to start somewhere. If you have been tasked with charting a process, you often need to get on with it since your boss is not always willing to wait for you to gain the necessary knowledge to be an expert. I would hope that then that individual would recognize that their needs goes beyond the mechanics and must extend to the level of understanding. That understanding is not going to be found in this forum, as statistics need some fairly extensive study and training however we can help folks by giving folks a taste of what the statistics can tell them.
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: 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
How to Calculate UCL (Upper Control Limit) & LCL (Lower Control Limit) & CL maxfusion Statistical Analysis Tools, Techniques and SPC 73 25th October 2013 12:36 AM
Calculating UCL (Upper Control Limit) and LCL (Lower Control Limit) Kenwatch Statistical Analysis Tools, Techniques and SPC 14 19th October 2011 09:12 AM
Calculation of Upper and Lower Control Limits for Control Chart? samsung Statistical Analysis Tools, Techniques and SPC 7 13th July 2011 03:11 PM
Moving Range Upper and Lower Control Limits when alpha=0.002 jp519 Statistical Analysis Tools, Techniques and SPC 4 26th February 2010 12:35 PM
When or how often should we update SPC (UCL and LCL) Control Limits? Every month? alfawei Statistical Analysis Tools, Techniques and SPC 7 20th August 2004 08:12 AM



The time now is 02:37 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, Olde West Chester, Ohio 45069-1929
513 341-6272
NOTE: This forum uses "cookies".