SPC in excel sheet, Cp & Cpk calculation with graph OR control chart

Поділитися
Вставка
  • Опубліковано 19 лют 2020
  • HI I am S.K Sharma
    Welcome you on UA-cam channel hub of knowledge
    here you can Learn Industrial technical documentation
    TOPICS as giSPC in Excel sheet
    Cp , Cpk calculate in excel
    control limit calculation
    Average calculation
    range calculation
    standard deviation calculation
    histogram in excel
    what is bar braph
    what is control chart
    how to make and draw control chart for Xbar & Rbar
    control limit in xbar chart and rbar chart
    contact for documentation 8076920822
  • Наука та технологія

КОМЕНТАРІ • 85

  • @abhaytanwar9831
    @abhaytanwar9831 4 роки тому +2

    Very good sir ... Dear sir mene QHI dekha Ask mechology dekha but Mera doubt abjake clear hua h... thanks

  • @syedfaizan991
    @syedfaizan991 Місяць тому

    Great video please complete full video

  • @dharmveeryadav4399
    @dharmveeryadav4399 2 роки тому

    Most simplify and easy to understand sir g👌

  • @manishkumar-nk1er
    @manishkumar-nk1er 2 роки тому

    Nice video
    Excellent explanation

  • @user-pn2bn1es6f
    @user-pn2bn1es6f 2 місяці тому

    Excellent presentation Hats off

  • @debanandamahapatra1849
    @debanandamahapatra1849 Місяць тому

    So nicely elaborated sir. Grate video..👍

  • @kingshukdas3678
    @kingshukdas3678 Рік тому

    Clearly explained sap in excel. Nice vedio

  • @skaslam3455
    @skaslam3455 Місяць тому

    Great❤❤❤

  • @The_Engineer123
    @The_Engineer123 7 місяців тому

    Nice, it's very useful for an engineer

  • @pranalichougale2193
    @pranalichougale2193 3 роки тому

    Hello sir , very informative video .Loved it .Learning is easy in your style.plz make histogram video .And plz clear wether control chart is required for cp cpk

  • @amuthankarunamurthi9293
    @amuthankarunamurthi9293 4 роки тому

    Hello Mr Sharma, it is very useful, Thank you so much.

    • @HUBOFKNOWLEDGEMECH
      @HUBOFKNOWLEDGEMECH  4 роки тому +1

      Amuthan do you interested for getting industrial documentation training

  • @RamDev-le8zp
    @RamDev-le8zp Рік тому

    First class hats off ur mind blowing Teacher sir.... ❤️

  • @upendrakumaryadav8199
    @upendrakumaryadav8199 Рік тому

    Excellent video sir

  • @zikrullahakhtar9735
    @zikrullahakhtar9735 4 роки тому

    What is fee for in-house training for 7qc tool and 5core tool

  • @sachinvashist3343
    @sachinvashist3343 3 роки тому

    Sir ur spc session is amazing....but how can we get remaining session of this video...

  • @Alphatradert
    @Alphatradert Рік тому

    Nice explanation sir ji

  • @ajeettiwari4643
    @ajeettiwari4643 2 роки тому

    Sir kindly tell me, what a minimum tolerance limit for SPC performing

  • @abhijeetsinghbasera600
    @abhijeetsinghbasera600 Рік тому

    Nice explanation sir

  • @channappag.p7898
    @channappag.p7898 2 роки тому

    Great lecture

  • @ramjeevanrathore3458
    @ramjeevanrathore3458 4 роки тому +1

    Hello Mr. Sharma video is very good however please mention control chart 8 rules which indicates where process is in control or not, because your process seems to be in control but we need to follow 8 rules.

  • @emptyminds4860
    @emptyminds4860 2 роки тому

    why I am getting different result of ucl and lcl using formula xdbar+3sigma and xdbar-3sigma ?

  • @anilkumarh8693
    @anilkumarh8693 3 роки тому

    Hi Sir, please teach how to make histogram in spc format.
    It's a nice teaching and we hope u will make more videos related to quality.
    Thanking you very much.

  • @anilyaho1995
    @anilyaho1995 4 роки тому

    Badiya sir

  • @proudtobesanatani4770
    @proudtobesanatani4770 Рік тому

    God bless u sir

  • @MANISHKUMAR-cj9pi
    @MANISHKUMAR-cj9pi 2 роки тому

    Nice explain sir

  • @AnkushKumar-yj8uk
    @AnkushKumar-yj8uk 5 місяців тому

    Please upload second part of histogram

  • @bhavyapatel4603
    @bhavyapatel4603 Рік тому

    Please sir give link for next histogram topic in spc same this data please continue video

  • @MohitSharma-lo2rz
    @MohitSharma-lo2rz Рік тому

    Sir Interval or Freq. Kse dali jati hai

  • @sureshhs9269
    @sureshhs9269 2 роки тому

    Nice practical

  • @daulatkumarupadhayay273
    @daulatkumarupadhayay273 Рік тому

    Sir if we take LCL(Xbar) up to two decimals only then the value 6.645220 would become 6.65

  • @ajeettiwari4643
    @ajeettiwari4643 2 роки тому

    Sir what is A2 and D2& D4 in spc and where we can get

  • @AutomotiveEngineer
    @AutomotiveEngineer Рік тому

    Great day today

  • @mr.wangadu1936
    @mr.wangadu1936 Рік тому

    Drawing me to bahot Sara dimensions hota hai kis dimension ke liye spc banaya jaye???

  • @darshandarshan9773
    @darshandarshan9773 Рік тому

    Very good sir

  • @erdeols
    @erdeols 2 роки тому

    Can i get the template, please?

  • @ajaysingh-fe5lj
    @ajaysingh-fe5lj 4 роки тому

    Nice video

  • @ajeettiwari4643
    @ajeettiwari4643 Рік тому

    Sir why cpk is less than cp kindly tell me

  • @narayanjuti3403
    @narayanjuti3403 3 роки тому

    Thank you

  • @ashutoshsahu81
    @ashutoshsahu81 3 роки тому

    Sir ye USL LSL kaha se aata hai? Maine ye topic bht jyada nhi pdha hai lekin mjhe Cp &Cpk calculate krna hai
    Kisi ko pta hai to plz reply?

  • @MrRohithkp
    @MrRohithkp 3 роки тому

    Hi sir,
    How did you get the D2 value..

    • @shivammishra7331
      @shivammishra7331 3 роки тому

      Bhai woh ek standart value hoti hai.. jaise quality main iso hota hai usme bhi kayi standard hote hn to d2 ki value fix hoti hai

  • @zikrullahakhtar9735
    @zikrullahakhtar9735 4 роки тому

    Sir yaha
    CP lower cp uppper Kaha se aaya

  • @sattukumar594
    @sattukumar594 3 роки тому

    Thank sir

  • @superhitindianmovies894
    @superhitindianmovies894 3 роки тому

    Sir ,
    How to take A2,D2,D3
    I don't know
    Please exlain

  • @rahuldhama9930
    @rahuldhama9930 2 роки тому

    Explain d2 and a2 value

  • @Asifnamesiddiqui
    @Asifnamesiddiqui 2 роки тому

    What is d2 Value

  • @priyabratasamanta7532
    @priyabratasamanta7532 2 місяці тому

    सर इसमें आप a2 d2 कैसेकैलकुलेट करें

  • @syedfaizan991
    @syedfaizan991 Місяць тому

    And also where did the standard values taken please reply

  • @SadhnaPankajKiRasoi9755223495
    @SadhnaPankajKiRasoi9755223495 2 роки тому

    Why cpkl value is more than cp value

  • @amarjitsingh7457
    @amarjitsingh7457 2 місяці тому

    Sir can you send me Excel format

  • @superhitindianmovies894
    @superhitindianmovies894 3 роки тому

    Histrogram cha mention kiya nahi ,spc concept complete nahi hua aisa lagata hi sir

  • @user-py5tc5bw1s
    @user-py5tc5bw1s 4 роки тому

    Thanks 🙏

    • @HUBOFKNOWLEDGEMECH
      @HUBOFKNOWLEDGEMECH  4 роки тому +1

      Please subscribe channel and share to your friends

    • @HUBOFKNOWLEDGEMECH
      @HUBOFKNOWLEDGEMECH  4 роки тому

      Do u come interested for getting started online documentation training course

  • @er.sanjeev9597
    @er.sanjeev9597 2 роки тому

    What is a D2 A2 and d4

  • @HUBOFKNOWLEDGEMECH
    @HUBOFKNOWLEDGEMECH  4 роки тому

    Thanks u sir

  • @pyariananya9823
    @pyariananya9823 4 роки тому +1

    Dear sir , pls tell us how to calculate D2 ,A2 and D4 .please sir

    • @HUBOFKNOWLEDGEMECH
      @HUBOFKNOWLEDGEMECH  4 роки тому

      Jagabandhu thanks for visiting my video...dost D2,A2, D3 are constant of variations taking from standard table,..... please share my videos to your friends

    • @pyariananya9823
      @pyariananya9823 4 роки тому

      @@HUBOFKNOWLEDGEMECH sure sir...

    • @HUBOFKNOWLEDGEMECH
      @HUBOFKNOWLEDGEMECH  4 роки тому

      Hello dear do you interested for getting online documentation training course

    • @HUBOFKNOWLEDGEMECH
      @HUBOFKNOWLEDGEMECH  4 роки тому

      Jagabandhu do u interested for getting industrial documentation training

  • @RahulSharma-wv3hs
    @RahulSharma-wv3hs 3 роки тому

    Sir d2 samjh me nhi aya

  • @pawandubey3559
    @pawandubey3559 26 днів тому

    How how to define D3 or D4 and D2

  • @Saini2703
    @Saini2703 2 роки тому +1

    How to calculate USL and LSL

    • @HUBOFKNOWLEDGEMECH
      @HUBOFKNOWLEDGEMECH  2 роки тому

      Thanks for approaching me, watch my video for calculation of USL and LSL, LCL and UCL

    • @HUBOFKNOWLEDGEMECH
      @HUBOFKNOWLEDGEMECH  2 роки тому

      Video name is specefic limit Vs Control limit

  • @goofy2676
    @goofy2676 Місяць тому

    Bhai download link dedete

  • @tejwindersingh1058
    @tejwindersingh1058 3 роки тому

    Do you teach online?

    • @HUBOFKNOWLEDGEMECH
      @HUBOFKNOWLEDGEMECH  3 роки тому

      Yes right now I am teaching online if you interested contact on WhatsApp 9891719133

  • @mramanpandey
    @mramanpandey 4 роки тому

    please sir send to us spc format

  • @soundforgerecorder742
    @soundforgerecorder742 3 роки тому

    what is formule USL and LSL? why is USL= 6.700 and LSL=6.600? WHY ARE YOU CALCULATİON?

  • @user-pn2bn1es6f
    @user-pn2bn1es6f 2 місяці тому

    Both Hindi and English shall be better

  • @daulatkumarupadhayay273
    @daulatkumarupadhayay273 Рік тому

    Sir if we calculate standard deviation with the mathematical formula then the value comes out is
    0.0099378066

  • @MAYURGUPTA9
    @MAYURGUPTA9 2 роки тому

    Nice video