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):    • Unlock the Power of ImR (XmR) Control...  

Control Chart Basics: [   / ugcb7vlp0ts  ]

Full Control Chart Playlist: [   • Control Charting  ]

- - - - - - - - - - - - - - - - - - -

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:    / @theengineeringtoolboxchannel  

- - - - - - - - - - - - - - - - - - -

Other great content!

Top Free Engineering Software:
   • EVERY Engineer Should Know About This...  

Removing Outlier from Excel Pivot Table (Pt 1):
   • Excel Removing Outliers from Pivot Ta...  

- - - - - - - - - - - - - - - - - - -

Follow and interact!

Twitter:   / theengtoolbox  
Facebook:   / theengineeringtoolbox  

- - - - - - - - - - - - - - - - - - -
#spc
#processcontrol
#engineeringtoolbox
#EngineeringTutorials
#Engineering