Create Control Charts (X-Bar & R Chart) in Excel | Control Chart | SPC  

Your breakdown of industry standards is invaluable 🏆

I have to admit before watching this video i was trying to get minibar to work and install it first through the free version my school uses and then through the store, but gave up after it refused to work on multiple computers, however when i found this video it had explained the process so well I realized I did not need the program, and in fact made things feel much simpler and helped me finish my assignment, this has got to be one of the best channels that I have found

Thanks sir....I am also a IRCA Certified Internal auditor from TUV nord Noida...and i must say you are doing a really appriciable work by doing this ...i also educate many times by most of these videos ....thanks u again sir

I’ve been able to do my Operations & Supply Chain Management Project because of your help.

Thank you very much for creating this. It was instrumental in completing my school assignment.

Very well explained

Thanks a lot sir for working hard for making simple things simple again One question..... In control charts why do we use sigma derived from constants, why can't we use sigma of data collected. In this video, you have used x bar SD for Xbar chart ucl and lcl but you have used constant tables for R chart control limits

Nice explanation.

I love this man

Excellent explanation. thank you

you should use 3 times sigma for the ucl and lcl when pairing X bar chart with S chart. For X bar R chart, you should use +- A2*R-bar. Anyways, great video thank you.

Dear sir, make some more videos on quality topics. Bcz ur way of deliver the lecture is very helpful for me to understand the difficult topics.

Really helpful sir.. specially the way you covered everything like explaining excel formula also... Thanks a lot.

Thank you sir for teaching me....

It Very good

Hello Thank you very much for the very good explanation .... I have to enter data several times during the day ... Is it also how you describe it in the video? or you can insert a new video?...Thanks

You are the best !

Tremendous explanation Sir. Thank you very much for the video. It helped me alot.

Very very helpful

Sir, in few videos for Xbar chart the UCL is shown as Xdbar + A2 Rbar while your video shows Xdbar + 3sigma, now I have calculated the UCL using both the formulas, both gives different value for the case you have shown. Please clarify which formula to be used for UCL and LCL for Xbar chart.

Thank you sir, it helped my studying a lot, much appreciated!

Well Explained. Thank you

This is VERY helpful! Thank you!

very helpful

Good job!

Thank you so much. Very well explained.

Thank for your teaching.

You are amazing!!! Thank you for the very detailed steps!!!

Thank you so much sir

Dear Sir, why don't you used constant A2 = 0.5777 instead to find UCL and LCL? But for range chart you used the constant D4 and D3. However I assume 3Sigma is equal to A2 x Rbar but the value was not the same. please explain.

Thanks for video, May I know that x bar control chart you have used 3 sigma instead of A2- both are same in all conditions?

Can we use either standard deviation or range chart to set upper limit and lower limit. Am I right? Who set this range chart and ist constant? How do they replace standard deviation?

Thank you sir for your valuable information. Just one question sir, if there are more than one dimensions then how to proceed for x bar and r chart

Which chart is suitable for a single sample of multiple observation?

Thanks! Very easy to understand, and detailed.

Subscribed sir, awesome video

this is the indian guy i ve been looking for

Sir, in X bar chart for UCL & LCL formula is given to use (X-Dbar + A2R) then why used (XDbar + 3*StdDev). Please clear my doubt.

Good explanation , regarding plus 3 sigma it is equal to +A2Rbar and minus 3sigma is equal to -A2rbar Is this correct ?? Please confirm

Very Nice video to easy understand. 🛃

Nice Sir., really helpful

very great and helpful

Sir, Can you please tell, You used control chart limit for X bar chart Xdouble bar+- 3sigma... why you not used Xdouble bar +- A2Rbar..You explained this in sheet constants at 10.50, please explain,which formula to be used??

Hi Sir, I think standard deviation suppose to calculate from total measured data, but you have calculated from average values, is it right ?

nicely explained, Thank you

Thank you.

Very helpful.. But little bit confused in R BAR CHART. Will table of constent be same for every chart?

Thank you for your vide

Very much appreciated

Sir , I have issue in this video UCL and LCL value is more than USL and LSL value. So it's possible or not pls inform me sir because I have confusion in this perticular point.bcz according to me UCL and LCL value always between the USL and LSL value, process voice is always less than customer voice.pls clear it.

Thank a lot it helped me a lot

Super Tutorial, I cannot thank you enough. God Bless

dear sir Please help!! Actual formula for UCL X & LCL x are (x bouble bar+/_A2*R bar) & as i can see you have written (X double bar+/-3 sigma respectively) please explain how A2*R bar is equal to 3 sigma ?/ please reply.

What were the subgroup size and sample size of this example?

Thank you, saved my ass from a group project in college going horrible wrong. Thanks for saving my A!

Thanks for video. Your way of explaining thing s is really good. May God bless you.

Great Sir, X-mR control chart ko bhi samjhaiye Sir

Thanks for the video it was very helpful

Thank you!!!

Awesome video, helped a lot!

May I get online training and certification on PPAP ,SIX Sigma etc. ?

Sir please help me how plot ppm in excel sheet and what reading are taken for that

please explain why there is a difference in Xbar UCL and LCL while calculating by the table given at 13.00 mints.

thank you sir nice spc x bar and r bar chart

your explanation is damn good

Dear sir when i make r chart and average chart than 2 line create seperatly one is ucl and one is lcl in graph.

This was truly amazing thank you SO much!!!

Is there any website to download some sample data so that we practice this ?

Sir could you please share one video with example that how to control draw attribute chart like n chart c chart , same as you shown how to draw control chart in Excel. Thanks

thank u sir god bless you

Thank you sir

sir Mai book khridna chahta hu..... iske lya kya process hai

Thank you!! Incredibly helpful!

Thank you, come again!

Hello Sir...is it 6 or 10 ( sample size )

Thank you!

Thank you for a good lecture.

Very Helpful Professor

Sir ek question hai mera. Jab dimension 2.5 + aur - 0.2 hai To ucl 2.7 aur lcl 2.30 hona chahiye Par aapka ucl 2.91 aur lcl 2.06 Aa raha hai aisa kyun sir???

Thank you so much, It's very useful

God bless you sir worth watching

Good explanation. Check this video if you want to know how to create mean and range chart by using excel. Thank you!

Sir very thank for this useful video in simple language But make this video in Hindi also

X1, x2 in sab me 25 data liye hai ye kuchh v ho sakta hai ya fix h??? Plz tell me

I do not understand where you derive the #3 from in finding your UCL/LCL. Can you please explain? Everything else I understand.

Hello Sir, Plz make videos on I -MR & xbar - S chart

What is the difference between Ppk& Cpk. IF CPK Greater then -1.33, then what is the Ppk value. I think both value will same if any special caused in process.kindly confim me. can consider Same or not same . I,m waiting for your response

Could you please make the frequency tabulation and histogram from the same data?

sir, x chart or r chart dono ke liye standard deviation alag alag ayega. Jo ki apki excell sheet mein dikh rha h

YOU HAVE MADE A GREAT VIDEO BUT I NEED TO CALCULATE Cp AND Cpk VALUES PLS MADE VIDEO ON THAT

Sir what is standard deviation plz tell

Sir Thanks for the video but I have some confusion that u calculate standard deviation by selecting the average value rather then selecting the whole value in this case if my average is same then the standard deviation will zero Ex 5 4 3 6 average is 4.5 8 2 5 3 average is 4.5 In this case as per your calculation std Dev will zero which should be 1.9272 Please clear my confusion

One doubt sir, sigma=R/d2, in which situation we will use this formula, plz explain

Thanks a lot Sir ....

Sir pls make video of 4M change management it's MACE activity

Why you r not answering the comments related to formula confusion?

where can we download this example?

may we obtain the excel sheet for the formulas?

Sigma value which is STD DEVIATION, how did u calculate that??? Is it constant for x bar chart or it is default value - .1338 ???? Please conclude.

What is D 4 in R bar you have selected from your table and not understand what is that