Xbar and R chart I Create Control chart in Excel I Create Xbar R chart in Excel | 7 QC Tools

Xbar and R chart I Create Control chart in Excel I Create Xbar R chart in Excel
My KZbin Gears / Devices & Equipments
My Smartphone: amzn.to/3bvY9xt
My Microphone: amzn.to/3lRobQl
My Laptop: amzn.to/2QWSHKz
About the Video:
Create Control chart in Excel
X bar and R chart is a control chart used for Variable Data. Control chart is part of SPC (Statistical Process Control). Control chart is also one of the 7 qc Tools. Xbar & R chart in nothing but combination of two charts. Average chart (Measurement of Central Tendency of Data) and Range Chart (Measurement of Dispersion of Data). Also explained here is how to create X bar and Rchart in Excel step by step.
How to create Xbar and Rchart is explained here which includes, how to calculate;
1. Xbar - Average
2. Xdbar = Average of Averages
3. R - Range
4. Rbar - Average of Ranges
5. UCL and LCL of Xbar chart
6. UCL and LCL of R chart etc…
#xbarrchart #controlchart #xbarchart #rchart #qualityexcellencehub #qehenglish
Quality Excellence Hub Channel introduction:
Hi,
I am Parthasarthi Virda. Welcome to my KZbin channel "Quality Excellence Hub".
Thank you so much for watching my videos. Watch other videos from ‘Quality Excellence Hub’- Link of video Gallery / @qualityexcellencehub
Also find videos on other topics as below
Videos in Hindi Language
1. 7 QC Tools - Hindi • 7 QC Tools | 7 Quality...
2. What is Quality - Hindi • What is Quality in Hin...
3. What is Audit - Hindi • What is Audit in Hindi...
4. What is Kaizen - Hindi • What is Kaizen I Kaize...
5. SMED - Hindi • SMED I Single Minute E...
6. Cost of Quality - Hindi • COST OF QUALITY IN HIN...
7. QA vs QC - Hindi • QA vs QC in Hindi I Qu...
8. 5W & 1H - Hindi • 5W and 1H in Hindi I H...
9. Verification vs Validation • Verification vs Valida...
10. Checksheet - Hindi • Check sheet | Check sh...
11. What is Histogram - Hindi • What is Histogram I Hi...
12. Mean Median Mode - Hindi • Mean Median Mode with ...
13. Takt time cycle time lead time Throughput time - Hindi • Takt time vs Cycle tim...
14. Overall Equipment Effectiveness (OEE) - Hindi • Overall Equipment Effe...
15. Paretochart - Hindi • Pareto chart in Hindi ...
16. How to create Pareto chart in Excel - Hindi - • How to create Pareto c...
Videos in English Language
17. 7 QC Tools - English • 7 QC Tools | 7 Quality...
18. What is Quality - English • Quality | What is Qual...
19. Cost of Quality - English • Cost of Quality I Cost...
20. What is an Audit - English • What is an Audit | Typ...
21. Quality Assurance vs Quality Control - English • Quality assurance vs Q...
22. Verification vs Validation - English • Verification vs Valida...
23. Production Part Approval Process (PPAP) - English • Production Part Approv...
24. Measurement System Analysis (MSA) - • MSA I Measurement Syst...
25. 5W & 1H - English • 5W1H I 5W and 1H l How...
26. What is Kaizen - English • What is Kaizen l Kaize...
27. Takt time cycle time lead time Throughput time - English • Takt Time | Cycle Time...
28. Single Minute Exchange of Die (SMED) - English • SMED I Single Minute E...
29. Checksheet - English • Checksheet I 7QC Tools...
30. Pareto chart - English • Pareto I Pareto chart ...
31. Corrective Action and Preventive Action (CAPA) - English • CAPA I Corrective Acti...
32. Histogram - English • Histogram I Histogram ...
33. Tatistical Process Control (SPC) - • SPC I Statistical Proc...
34. Mean Mode Median - English • Mean Median and Mode I...
Other Social Links of channel:
KZbin - / qualityexcellencehub
Facebook - / qualityexcellence.hub
LinkedIn - / parthasarthi-virda-88b...
Pinterest - / qehub2018
Instagram - p_virda?hl=en
Email - [e-mail]
music and video from
www.incompetech.com
www.pixabay.com
www.yummy-sounds.com
www.productioncrate.com

[@user-pn2bn1es6f]

Excellent Sir

[@QualityExcellenceHub]

Thank you. Happy Learning Ahead

[@suhelmomin3485]

Very informative

[@QualityExcellenceHub]

Thanks. Happy Learning ahead.....

[@stalink3203]

Too good and easy way to understand for beginners also .... Thanks

[@QualityExcellenceHub]

You are welcome. Happy Learning ahead...

[@dodje1585]

thank you for this. this saved my life!!!!

[@QualityExcellenceHub]

You ate welcome. Happy Learning ahead....

[@aniketbagul9410]

Excellently explained👍

[@QualityExcellenceHub]

Thanks

[@martinhodge394]

Thank you!

[@QualityExcellenceHub]

You are welcome. Happy Learning ahead.

[@srk3786]

Thanks sir.

[@QualityExcellenceHub]

You are welcome

[@edwindsouza7157]

Nicely explained

[@QualityExcellenceHub]

Thanks. Happy Learning.

[@fathiafarag944]

Good morning sir In X bar chart can I add uwl and lwl to the curve beside UCL , LCL ??

[@QualityExcellenceHub]

You can add Specification limits. Happy Learning ahead...

[@Samynathan_SDM]

Thankyou so much for video sir....great efforts...and I have one doubt .. In the excel sheet ,the sheet 4(constant & some formula are showing to calculate UCL and LCL for Average mean chart..... But you not using the A2 constant values....you are using standard deviations....I have consfuesd... please calrify sir... Thanks in advance... UCL

[@vivekkumar-tw2zl]

Very interesting video, thanks Kindly share the Excel sheet.. Or provide the link to download

[@QualityExcellenceHub]

It is a simple excel sheet. Nothing special. It can be generated in 5 minutes. Request you to create by yourself as that will give you more clarity about the topic.

[@sbm3799]

Thank you for the video. However, can you explain why you used 3 Sigma instead of A2 for X bar Chart?

[@QualityExcellenceHub]

Please specify the timeline to let me understand your query.

[@manikandanas8344]

Hi sir ur video is really valueable but not audible pls increase ur volume quality

[@QualityExcellenceHub]

Thanks for your input. Happy Learning....

[@kaliraj7820]

Hi sir, i have some doubt, please clarify me. To calculate the UCL , you used Xbar+3*sigma, but i can see the formula as UCL=Xd.bar+A2*Rbar . What is the difference? Which is correct, please clarify.

[@om_arogara_godworld6375]

Kindly make video of xbar -s chart

[@QualityExcellenceHub]

Sure, I will. Please give me some time. Happy Learning ahead....

[@sajalbanik6066]

Is there any online training available ?

[@QualityExcellenceHub]

You can through this video for free. If you have any doubts, can ask here.

[@assortedbeats691]

what are the next steps in case their is beyong ucl and lcl?

[@QualityExcellenceHub]

Watch my video on interpretation of control chart. Happy Learning ahead.

[@MI-gr6lg]

@@QualityExcellenceHub Nice video sir, but could you use a better mic 🎤 system for better voice clarity and overall video experience.

[@QualityExcellenceHub]

Sure. Thank you for the feedback. Happy Learning ahead....

[@MI-gr6lg]

@@QualityExcellenceHub Thanks sir for taking it positively.

[@jayaseelans5255]

Sir Why you r put 3 for UCL calculation...

[@QualityExcellenceHub]

Please elaborate your query.

[@QualityExcellenceHub]

We have taken 3 sigma spread for UCL and 3 sigma spread for LCL. Actually it is 3 standard Deviation on Upperside and 3 standard deviation lower side of target line or average line. Happy Learning ahead.

[@ganeshmagar6314]

Sir , I excel sheet UCL and LCL calculated using formula (Xdouble bar+3 sigma) & (Xdouble bar -3 sigma) respectively. But formula for same is given as (Xdouble bar + A2.Rbar) & (Xdoubel bar - A2.Rbar).Why so ??

[@QualityExcellenceHub]

Can be calculated in both ways. It is the same. Hope its clear now. Happy Learning ahead.

[@ganeshmagar6314]

@@QualityExcellenceHub no sir ,calculations are slightly different

[@QualityExcellenceHub]

True. Calculation is definitely different. Will not be able to make you understand fully here. Base is A2 rbar formula. For thumb rule calculation u can take 3sigma formula. For detailed calculation of cp and cpk, please check related video on my channel. Happy Learning Ahead.

[@zikrullahakhtar9735]

X bar R and xdbar R different hota h kya

[@QualityExcellenceHub]

X bar ek subgroup ka average hai aur XDbar sare subgroups ke average ka average hai.

[@ikkuchaudhary7456]

X bar chart ka formula tha x double bar + 3sigma. Ab ye change kese ho gya

[@QualityExcellenceHub]

Xbar chart me UCL and LCL ka formula hota hai. Normal distribution ke liye aapne jo likha vo Hona chahiye. Actual video me hai. Aur koi query hai to puchh sakte ho. Happy Learning ahead....

[@ikkuchaudhary7456]

@@QualityExcellenceHub thanx sir, but normal distribution me bhi to x bar chart hi bnta he.or phir hum dono me se konsa use kare please tell us bahut person confuse he

[@QualityExcellenceHub]

Aapko kahan use karna hai ye bataiye to mai bata paunga ki konsa use karna chahiye.

[@ikkuchaudhary7456]

@@QualityExcellenceHub interview me kya btana chahiye..

[@QualityExcellenceHub]

Video me bataya hai vahi batana hai

[@gsengottaiyan9052]

I'm a repeated audience

[@QualityExcellenceHub]

Thanks. Happy Learning ahead....