Learn how to create an Individuals and Moving Range (ImR) control chart that dynamically formats out of control data points.
In this video, we'll show you how to create an ImR control chart in Excel that formats similar to MiniTab. This control chart is a commonly used tool for measuring process variation, and is a great way to evaluate process control. After watching this video, you'll be able to create an ImR control chart in Excel quickly and easily! No need for MiniTab.
Control Charts are a great tool for engineering, business, and quality Engineers and other quality professionals. The most basic form of control charts are the Individuals and Moving Range chart (XmR chart).
Time Quick Links:
[0:34] - End Product
[1:36] - MR Bar Formula Correction
[4:55] - MR Chart Conditional Columns
[6:22] - Setting Up Test Columns
[9:30] - Rule #1 (Outside control limits - Out of control)
[10:24] - Rule #2 (9 IAR same side of Mean - Process Shift)
[12:50] - Rule #3 (6 IAR Increasing or Decreasing - Trend)
[14:11] - Rule #4 (14 IAR Alternating Inc/Dec Points - Over Control)
[15:38] - Rule #7 (15 IAR within 1 Sigma of mean - Under stratification)
[17:02] - Rule #5 (2/3 Greater than 2 Sigma - Going Out of Control)
[18:22] - Rule #6 (4/5 Greater than 1 Sigma - Going Out of Control)
[18:53] - Rule #8 (8 IAR Greater than 1 Sigma Either Side - Mixture)
[19:55] - Data Labels Column
[21:26] - In Control column
[21:42] - Formatting & Update Chart Data
[26:30] - Bonus Tip
- - - - - - - - - - - - - - - - - - - -
Last Video (Simple ImR Chart): https://www.youtube.com/watch?v=cIP4PcGlZyM
Control Chart Basics: [https://www.youtube.com/Ugcb7Vlp0Ts]
Full Control Chart Playlist: [https://www.youtube.com/playlist?list=PLAVcy54svuke4wGIv6kbP3uoLqiHT5f0g]
- - - - - - - - - - - - - - - - - - - -
Check out my channel for more videos and tutorials for engineers!
Like, follow, share and don't be afraid to drop me a comment/message with feedback, questions, or video suggestions!
Thanks for watching!
Subscribe for More! https://bit.ly/2PmVzwJ
Channel Link: https://www.youtube.com/channel/UCX-H7IOnCfHihvtnypTORMA
- - - - - - - - - - - - - - - - - - - -
Other great content!
Top Free Engineering Software:
https://www.youtube.com/watch?v=PE5hMaQBCn4
Removing Outlier from Excel Pivot Table (Pt 1):
https://www.youtube.com/watch?v=p8mg3EEt6Gw
- - - - - - - - - - - - - - - - - - - -
Follow and interact!
Twitter: https://twitter.com/TheEngToolbox
Facebook: https://www.facebook.com/TheEngineeringToolbox/
- - - - - - - - - - - - - - - - - - - -
#spc
#processcontrol
#engineeringtoolbox
#EngineeringTutorials
#Engineering