The Right Way to Create Xbar & R charts using MS Excel!

[@envcas31]

Hey man! me again, thanks for putting all the info in one concise video. really insightful and helpful. I wish i had this a few months ago!

[@TheEngineeringToolboxChannel]

No problem! Always happy to make videos If there is anything else you want to see. 👍

[@jamisoncrawford9868]

Excellent walkthrough! Thanks so much for your help on this.

[@1powerchevy]

What formula did you do when you created the columns L,M,N,O,P? XbarBar+2SE etc...?

[@bobbysack254]

Can you explain where you got that table on the Const_Lookup sheet. Is that standard table used to find Sigma or is it a table you created based on your own data?

[@TheEngineeringToolboxChannel]

It is a table of standard conatants that are used to calculate control limits or sigma values for various control chart types and sample sizes. You can find these tables in the back of stats books or online.

[@jamisoncrawford9868]

Here's one: web.mit.edu/2.810/www/files/readings/ControlChartConstantsAndFormulae.pdf

[@aravinder5509]

video is running fast

[@TheEngineeringToolboxChannel]

Slow it down to .75 👍

[@impromptu-No4]

Didn't see the source for the table of constants in this video.. guess, I need to watch the other videos

[@TheEngineeringToolboxChannel]

Yes, sorry. Otherwise they are very easy to find online with a quick Google search of “control chart constants”