The Cove Business Standards Discussion Forums More Free Files Forum Discussion Thread Post Attachments Listing Cove Discussion Forums Main Page
UL - Underwriters Laboratories - Health Sciences
Go Back   The Elsmar Cove Business Systems and Standards Discussion Forums > Common Quality Assurance Processes and Tools > Statistical Analysis Tools, Techniques and SPC
Forum Username

Elsmar Cove Forum Visitor Notice(s)

Wooden Line

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


Elsmar XML RSS Feed
Elsmar Cove Forum RSS Feed

Monitor the Elsmar Forum
Sponsor Links



Courtesy Quick Links

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


ASQ - American Society for Quality

International Standards Organization - ISO Standards and Information

Atul's
Quality Forum Online

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

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


Related LinkedIn Groups

ISO 9001 for Small Businesses

ISO 9001:2015 Revision Discussions

Information Security Community

Medical Devices Group

Quality and Regulatory Network

FDA (Food and Drugs)

AS91XX Series - Tips and Advice


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
  Post Number #1  
Old 28th December 2011, 10:42 PM
KCIPOH

 
 
Total 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, 215 views)

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

 
 
Total Posts: 15,005
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

  Post Number #3  
Old 29th December 2011, 09:35 AM
bobdoering's Avatar
bobdoering

 
 
Total Posts: 3,992
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?
  Post Number #4  
Old 29th December 2011, 10:38 AM
Darius's Avatar
Darius

 
 
Total Posts: 551
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, 328 views)
Thank You to Darius for your informative Post and/or Attachment!
  Post Number #5  
Old 29th December 2011, 10:45 AM
bobdoering's Avatar
bobdoering

 
 
Total Posts: 3,992
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!
  Post Number #6  
Old 29th December 2011, 12:50 PM
AnaMariaVR2's Avatar
AnaMariaVR2

 
 
Total 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?
  Post Number #7  
Old 29th December 2011, 01:05 PM
iamtroll's Avatar
iamtroll

 
 
Total Posts: 81
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!
  Post Number #8  
Old 29th December 2011, 01:12 PM
iamtroll's Avatar
iamtroll

 
 
Total Posts: 81
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 Business Systems and Standards Discussion Forums > Common Quality Assurance Processes and Tools > Statistical Analysis Tools, Techniques and SPC

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
Calculating Lower and Upper 3 Sigma Control Limits dmk_miz Statistical Analysis Tools, Techniques and SPC 2 24th January 2014 09:40 PM
Calculation of Upper and Lower Control Limits for Control Chart? samsung Statistical Analysis Tools, Techniques and SPC 7 13th July 2011 03:11 PM
If I know x-bar, spec limits, and Cpk, can I calculate the control limits? brgman63 Capability, Accuracy and Stability - Processes, Machines, etc. 16 4th November 2010 01:07 PM
Moving Range Upper and Lower Control Limits when alpha=0.002 jp519 Statistical Analysis Tools, Techniques and SPC 4 26th February 2010 01:35 PM
Geometric Tolerancing and SPC - Calculating position upper and lower control limits lee01 Statistical Analysis Tools, Techniques and SPC 36 8th July 2008 11:02 AM



The time now is 04:25 PM. All times are GMT -4.
Your time zone can be changed in your UserCP --> Options.


 


NOTE: This forum uses "Cookies" -- The Elsmar Cove is *Copyright Free*.
A Peachfarm LLC Internet Property