How to Construct a Control Chart in Excel

A brief video on how to construct a control chart in Excel.
LCL = Lower Control Limit
UCL = Upper Control Limit
R-Chart
• Statistical Process Co...
c-chart
• SPC 4: c - chart (Cont...
p chart
• Statistical Process Co...
xbar chart
• Statistical Process Co...

[@adegboladeadebote754]

Quick and straight to the point... Thank you

[@annalynsio1359]

this is so helpful!!!!! so straight to the point !! thanks!!!1

[@orangetsh13]

thank u very much, Joshua!

[@shubhanshujain9827]

smooth explanation love it!

[@venkateshnayak6170]

Thank you,Excellent video

[@praveshdanda1525]

Thank you, Joshua

[@quentinfavre-gilly2310]

You saved me for my exam thank you so much

[@crystaldominque2586]

Thank you!

[@tannerstenlund6305]

Great video thanks!

[@sitisarahabdulrahman]

Great video. Really helpful explanation. Will try it for my task.

[@undermygarage]

Thanks Josh!

[@user-bk8js9mp9p]

You the man

[@jelmerwolthuizen8559]

you are the best

[@aiishataal]

bruh thank you i was watching this 9 minute video and this guy was doing tew much

[@Robylazarus]

Brilliant work Joshua, you deserve more views man!!! Subbed with a great deal of gratitude....

[@joshemman]

🙏

[@samruddhiyelikar1921]

Thank youu!!!!!

[@bashirulhaq9508]

Thank you

[@elienc4546]

Excellent video, thank you.

[@tonitoni9368]

Hi there I have a question .... would like to enter the data several times a day ... is that possible or I mark the statistics every time to create the diagram ? thanks

[@joshemman]

If you have several data for each day, you need to first calculate the statistic (e.g mean, range, …) for each day before constructing the control chart.

[@muhindiwapangani6367]

It is very usefull❤

[@zongezileg2212]

I love you I love you so much 🍾

[@nanakwamedanso2419]

Hi. If I should get a negative value for the LCL value and I am using the C values. Example: -2.18. How would I draw the C chart? Would I equate the negative values to zero(0) or I would work with the negatives??

[@joshemman]

If you get a negative LCL, you must set it to zero.

[@TheEngineeringToolboxChannel]

Why would you manually enter the control limits when they should be calculated from the data?

[@adamdring4555]

He might already have the data from the chart and just added in the value for the video 🤯

[@user-xy7hw9jz3k]

is UCL and LCL are predefined ?? if yes then how? I thought we have to collect data first in order to built R chart or X bar Chart. also if values change, do UCL and LCL change or remain Constant ?? How?/

[@joshemman]

UCL and LCL are not predefined. They are calculated from your data. If you change values, UCL and LCL might change.

[@pulakkabir2276]

how to get the LCL and UCL?

[@joshemman]

See if this playlist helps: kzbin.info/www/bejne/ZnTXe319pdd6bKM

[@GuyAfro3000]

anyone else from RMIT here

[@gugushange2964]

Thank you

[@GuyAfro3000]

anyone else from RMIT here