Create ‘Histogram’ in Excel Sheet (हिंदी में सीखे )-'हिस्टोग्राम' बनाने के दो तरीके सीखे।

Поделиться
HTML-код
  • Опубликовано: 11 дек 2024

Комментарии • 137

  • @Drkalaamarab
    @Drkalaamarab 4 года назад +3

    So simple and great demonstration 👍👏
    Finally I got right example to understand. More videos on statistics and excel data visualization and analysis.
    Thank you so much sir

  • @dipakn1244
    @dipakn1244 4 года назад +1

    Thank you sir,
    Very easy explanation and step by step guidelines.

  • @shivanibhandari6590
    @shivanibhandari6590 4 года назад +1

    Very well explained each n every part.....ty very much sir.....i was finding this n no 1 explained this so well n in easy manner.....

  • @ankursingh462
    @ankursingh462 4 года назад +3

    Most of this comment are confuse why we divide by 9 or mei bi ishi ko le kar confuse hu but other wise all concept are clear,please sir clear karo

  • @mohamedjunaid1556
    @mohamedjunaid1556 5 лет назад +4

    same question where most of them are getting stuck,why take 9 for interval calculation ???? plz reply !!

  • @jitu150
    @jitu150 2 года назад +1

    Tq sir for right information

  • @rakeshgupta5738
    @rakeshgupta5738 4 года назад +1

    Thank you Sir. It is a very helpful video.

  • @rohitkhadakwalliya1573
    @rohitkhadakwalliya1573 4 года назад +1

    Thank you sir
    For your valuable guidance.

  • @RajeshSingh-mq1jr
    @RajeshSingh-mq1jr 5 лет назад +1

    Process capability ka video banaiye for variable data ke liye minitab me or excel sheet me graph banaiye

  • @rizwanshaikh3231
    @rizwanshaikh3231 10 месяцев назад +1

    Superb sir thank u so much

  • @vikramkumar-nk7yc
    @vikramkumar-nk7yc 7 лет назад +2

    Sir
    Good learning
    Pls also prepare video of control chart also

  • @ajayswami4680
    @ajayswami4680 6 лет назад +3

    So simple language. Thnks sir. But i want to know why u divide range by 9 for calculate the class interval. Pl reply. What is formula for this.

  • @geetanjalithakur4021
    @geetanjalithakur4021 3 года назад

    Knowledgeable video

  • @parsuramnaik500
    @parsuramnaik500 Год назад +1

    great video thansk

  • @sarveshsharma7478
    @sarveshsharma7478 3 года назад

    Welding defects ka histogram kaise banayenge uske liye bhi air ek video banaiye please..

  • @QualityHUBIndia
    @QualityHUBIndia  3 года назад

    Visit us for Free and Paid Courses www.qualityhubindia.com
    Join us: Facebook - facebook.com/QualityHUBIndia
    Instagram - instagram.com/qualityhubindia/
    LinkedIn - www.linkedin.com/company/quality-hub-india/
    Telegram - t.me/qualityhubindia
    WhatsApp - wa.me/message/QC63CZJJUFVLK1
    Problem Solving Tools (7QC+7M) and Root Cause Analysis : bit.ly/3tOsa6x

    • @pedroemmett3509
      @pedroemmett3509 3 года назад

      i dont mean to be off topic but does anyone know of a tool to log back into an instagram account??
      I somehow lost the account password. I would love any help you can offer me

    • @zyairenixon1498
      @zyairenixon1498 3 года назад

      @Pedro Emmett Instablaster :)

    • @pedroemmett3509
      @pedroemmett3509 3 года назад

      @Zyaire Nixon i really appreciate your reply. I got to the site thru google and im waiting for the hacking stuff atm.
      Takes a while so I will reply here later with my results.

    • @pedroemmett3509
      @pedroemmett3509 3 года назад

      @Zyaire Nixon it worked and I now got access to my account again. Im so happy:D
      Thanks so much you saved my ass!

    • @zyairenixon1498
      @zyairenixon1498 3 года назад

      @Pedro Emmett No problem :)

  • @sandeepsain8648
    @sandeepsain8648 4 месяца назад +1

    Tys sir 😊😊

  • @isteyakahmad9977
    @isteyakahmad9977 5 лет назад +4

    Minimum tree height is 17.8
    So the frequency should be 1 instead of 0. Kindly clarify sir

  • @madhurpandey6434
    @madhurpandey6434 4 года назад +1

    Sir Ji, video banakar upload to kar di but why did you pick 9 for class intervals.. Can you pls put some light on it

  • @RamSingh-uf6wx
    @RamSingh-uf6wx 6 лет назад +1

    Nice sir it's very helpful for us

  • @oasis_6501
    @oasis_6501 7 лет назад +2

    Dear sir, plz make a video to add normal distribution curve in this histogram diagram

  • @AjitavNayak-do6ez
    @AjitavNayak-do6ez Год назад +1

    Why should we divide 9 for interval ?

  • @Uttarakhandroots77
    @Uttarakhandroots77 6 лет назад +1

    Thanks for this fundamental but important video.

  • @firex2dakshveer3dop2
    @firex2dakshveer3dop2 3 года назад +2

    Why it was divided by 9 ? To calculate interval

    • @shivkumarlodhi8387
      @shivkumarlodhi8387 2 года назад

      Same question?

    • @apchennel6691
      @apchennel6691 2 года назад

      Jo shi trika k vo ye h eske liye= SQRT (100) then we get no.of interval =10

    • @apchennel6691
      @apchennel6691 2 года назад

      Then we will calculate the interval width= range / no.of interval

  • @arjitkumarshrivastav1881
    @arjitkumarshrivastav1881 4 года назад +1

    Helpful

  • @kanchanverma6568
    @kanchanverma6568 6 лет назад +1

    sir which windows is this because the F4 function is not working in mine

  • @mohamedjunaid1556
    @mohamedjunaid1556 5 лет назад +2

    for creating a good histogram,one must take 8 to 10 intervals right...thats y u have 9 for interval calculation i believe!!!

    • @QualityHUBIndia
      @QualityHUBIndia  5 лет назад

      Right

    • @neeraj.bisht7
      @neeraj.bisht7 4 года назад

      @@QualityHUBIndia How I can identify how many interval rights should be created for different histogram data?

  • @rksuman14
    @rksuman14 5 лет назад

    Thank you very much sir

  • @sonukumar-nh1iy
    @sonukumar-nh1iy 5 лет назад

    Good sir thanku

  • @sandeepgupta7440
    @sandeepgupta7440 4 года назад +1

    How 17.8 frequency is 0 even it is minimum number of tree hight. It should be at least 1.

  • @Nimu1964
    @Nimu1964 6 лет назад +1

    very good, grand

  • @KamleshElearning
    @KamleshElearning 5 лет назад

    Dear Sir,
    One more request plz
    make an excel tutorial of
    1) Difference b/w control chart & spc .
    2) create a spc chart

  • @vikasdubey4650
    @vikasdubey4650 6 лет назад

    Nice video sir

  • @KamleshElearning
    @KamleshElearning 5 лет назад +1

    thanks very much.......
    you r great

  • @maheshparanda2994
    @maheshparanda2994 6 лет назад +1

    Thank you sir

  • @montyb5246
    @montyb5246 7 лет назад +1

    Dear Sir,why you take 9 for interval calculation...

  • @sachingunjal3845
    @sachingunjal3845 8 месяцев назад +1

    NICE

  • @parveenkalonia7127
    @parveenkalonia7127 4 года назад

    At 4:42 min u divide max-min by 9 .... Y?...... It's a formula ?

  • @AjaySharma-pv3rq
    @AjaySharma-pv3rq 6 лет назад +1

    Very good

  • @m.ajmalmahaboobjan4286
    @m.ajmalmahaboobjan4286 6 лет назад +1

    Good

  • @VishalGoswami-hc6hc
    @VishalGoswami-hc6hc 7 месяцев назад +1

    What is the reason to divide by 9 to calculate in interval

  • @dhaneshkumar9735
    @dhaneshkumar9735 6 лет назад +3

    Sir why we take 9 for interval calculation.

    • @practicemakesthemanperfect771
      @practicemakesthemanperfect771 5 лет назад

      Tell me plz sir

    • @bhavyapatel4603
      @bhavyapatel4603 2 года назад

      Please if you know give answer in comment ...... Other are divide 10 this video divided 9 this reason how to decide class interval devide value ......

  • @vikramkumar-nk7yc
    @vikramkumar-nk7yc 7 лет назад

    Sir kuch important Excel word or PowerPoint ki important command btaiye jo presentation ya report bnane m help kare

  • @yatinpatel15
    @yatinpatel15 4 года назад +1

    how to use or create a tally mark in histogram chart in excel ?

  • @punamsingh5693
    @punamsingh5693 6 лет назад

    Bucket wise analyze ke sath video banaeye

  • @pratikkumarpatel6916
    @pratikkumarpatel6916 6 лет назад

    pls make video about Itakona project.

  • @chinudidikipathshala6281
    @chinudidikipathshala6281 2 года назад

    Sir interval formule mai aapne max-min/9..ye 9 se hi devide kyo kiya koi or number se kyo nahi?...

  • @tanaysrivastava9696
    @tanaysrivastava9696 5 лет назад +4

    Sir why u take 9 for dividation in class interval

    • @ankursingh462
      @ankursingh462 4 года назад

      Ye baat mughe bi samaj mei nahi aa rahi agar hamare pas 50 data h to hum kis no. Se divide karenge please clear this sir

  • @musicjasleen374
    @musicjasleen374 4 года назад +1

    Thank you so much.. but I hv a question. To calculate interval, you took 9. Why so? and is this digit fix

  • @learnearn5182
    @learnearn5182 4 года назад

    Sir I have one query during calculation of interval , why you divided here by 9 ??

    • @navnathkumbhar7742
      @navnathkumbhar7742 4 года назад +1

      As per Thumb rule we can take 7-10 bin of less than 100 dimensions.. 10-15 for more than 100 observations... as well there is formula for calculation = 1+ 3.322log(n)

  • @shubham-uc5zm
    @shubham-uc5zm 7 лет назад

    Sir, quality circle ki case study please upload kr krdijiye..

  • @yogeshmina9344
    @yogeshmina9344 3 года назад +1

    Data analysis method me histogram me more options aa rha hai uska data kese dekh sakte hain ????
    Kisi ko pta ho to batao

  • @sonudiwakar2947
    @sonudiwakar2947 6 лет назад +1

    Thnk u sir ..

  • @krishandev9741
    @krishandev9741 2 года назад

    Pls clear confusions, first one is why u dividing by 9 and second one is if maxi value is 22.4 ,then why u showing maxi 22.86.pls clear

  • @navnathkumbhar7742
    @navnathkumbhar7742 4 года назад

    Sir min dim 17.8 hai..
    Or aapne 17.8 ki frequency 0 likhi hai.. please explain sir 🙏🏻 I’m waiting for your reply

  • @shallykamboj9956
    @shallykamboj9956 2 года назад

    SIR 9 HI KU prefer kiya divide ke liye interval me

  • @pathakullahrubina3743
    @pathakullahrubina3743 7 лет назад

    Could you share standard of bins selection?

  • @adarshjaiswal5731
    @adarshjaiswal5731 6 месяцев назад +1

    How to add bins/ intervals??

    • @QualityHUBIndia
      @QualityHUBIndia  6 месяцев назад +1

      Simple method is square root of total data points. E.g 100 data points = 10 bins

  • @amolbadekar6925
    @amolbadekar6925 6 лет назад

    Pls make video on attribute data of control chart

  • @RaviKumar-vz8ct
    @RaviKumar-vz8ct 5 лет назад

    Please help me to understand that why we have divided by 9 at interval...

  • @007_Alpha
    @007_Alpha 7 лет назад

    dear sir plz make a powerfull sa video on GD&T thanks...

  • @mukeshyadav-oe2fy
    @mukeshyadav-oe2fy 4 года назад

    Sir humney interval ko kyu 9 sey divide kiya kisi aur no sey nhi ker suktey kya pls explain

  • @shaheenalarmalarmeddyu6705
    @shaheenalarmalarmeddyu6705 4 месяца назад

    Interval mai max minus mini then 9 se hi kyu divide karte hai😊

  • @gurukullearningacademy6736
    @gurukullearningacademy6736 6 лет назад +1

    how to make frequency polygon

  • @TheDeepak00
    @TheDeepak00 4 года назад

    It was fine but you should have logic for considering 9 in calculations

  • @akshaykumar2612
    @akshaykumar2612 7 лет назад +1

    Dear sir ..i requested to you many times sir..plz upload videos on GD&T but till date ...no uploaded..plz check Ur comments many users request to you regarding this ..but sorry to say sir... You didn't fulfill our requests

    • @QualityHUBIndia
      @QualityHUBIndia  7 лет назад

      This will take time, have patience. Meanwhile you can check our other videos. There are some ongoing projects . Once we are through we those, then we shall work on this.

    • @QualityHUBIndia
      @QualityHUBIndia  7 лет назад

      How about 'Lean Six Sigma Yellow Belt Certification' from QHI. If interested , contact at qhi2017@gmail.com
      Regards............Team QHI

    • @akshaykumar2612
      @akshaykumar2612 7 лет назад

      I will contact you soon...bcz right now i m not prepared all urs videos

  • @ashishkumbhar6667
    @ashishkumbhar6667 7 лет назад

    please give one example of cp cpk in excel

  • @akanshachaudhary7956
    @akanshachaudhary7956 4 года назад

    How 17.8 frequency came 0 when it was min...means it was in the array..

  • @ajayswami4680
    @ajayswami4680 7 лет назад

    Dear sir, histohram vedio not playing. Pl solve it.

  • @gajrajsolanky7656
    @gajrajsolanky7656 6 лет назад

    Dear sir please make video on GD&T.

  • @RajeshKumar-wy9cl
    @RajeshKumar-wy9cl 4 года назад

    Class interval ke liye 9 se kyo divide kiya sir plse explain

  • @Englishmust
    @Englishmust 4 года назад +1

    9 sy kyu division kiya 29 sy kyu nhi ??

  • @deepaksaxena2802
    @deepaksaxena2802 5 лет назад

    I am unable to understand why are you divide by 9 so please sir tell us about this logic

  • @shivamsaxena7468
    @shivamsaxena7468 3 года назад +1

    divide by 9 kaise aaya

  • @daulatkumarupadhayay273
    @daulatkumarupadhayay273 2 года назад

    Sir maximum value is 22.4
    But here the last value is showing 22.86

  • @jadhavrani.jadhav4485
    @jadhavrani.jadhav4485 4 года назад +2

    Hi

  • @kanchanverma6568
    @kanchanverma6568 6 лет назад

    why my output range is not working

  • @Okgulam
    @Okgulam 6 лет назад

    SIR HOW TO CALCULATE INTERVAL AND WHY DID YOU DIVIDED BY 9 FOR INTERVAL CALCULATION

  • @vijaykumar-xk3gv
    @vijaykumar-xk3gv 3 года назад

    interval me hm Maximum -minimum÷by 9 kyu le rhe hai .

  • @mustafaraza5750
    @mustafaraza5750 4 года назад

    sir interval find krne ke liye 9 se hi kyun divide kiya

  • @adhipdas2970
    @adhipdas2970 3 года назад +1

    Sir why divided by 9?

  • @vikasgupta-xp6hz
    @vikasgupta-xp6hz 7 лет назад

    Sir Gd&t ka video uplod kare

  • @kpmaurya3583
    @kpmaurya3583 5 лет назад

    Good evening sir
    Histogram ka use kab aur kyu karte hai

  • @pravinpandey760
    @pravinpandey760 Год назад

    Sir interval me 9 se q devide kiya gya, plz samjhaye

  • @ravikumarravikumar9536
    @ravikumarravikumar9536 5 лет назад

    Please provide in English Sir

  • @kirankoli5871
    @kirankoli5871 4 года назад

    Interval in why you divided by 9, why not 10,15 or 8

  • @mohitsharma-ie4ot
    @mohitsharma-ie4ot 6 лет назад

    9 ka kya funda h isme

  • @pankajpandey7641
    @pankajpandey7641 5 лет назад

    Sir ..class intrewal..ko..9 se kyon divide kiya..

  • @samarjitdas5824
    @samarjitdas5824 6 лет назад

    sir, interval main 9 se divide kiu kia??

  • @devarajapateld3483
    @devarajapateld3483 3 года назад

    Why you took while calculating interval

  • @Alammohammad99
    @Alammohammad99 3 года назад

    Why devided by 9 during class intervel

  • @SomnathChatterjee-fc6cm
    @SomnathChatterjee-fc6cm 10 месяцев назад

    Why u taken st. Dev and mean?

  • @diptisrivastava6755
    @diptisrivastava6755 3 года назад

    Sir why it divided by 9 only

  • @aeshapatel3880
    @aeshapatel3880 5 лет назад

    9 sa kyu divided kiya

  • @shubhamvashistha3926
    @shubhamvashistha3926 Год назад

    Isma 9 sa devide kyu Kiya sir

  • @ravindarkumarverma9018
    @ravindarkumarverma9018 Год назад

    Kya likha hai wo dikh nhi rha hai kya samjheng log

  • @sandeepgupta7440
    @sandeepgupta7440 4 года назад

    You are not giving the answers of any comment. This is not fair sir.

  • @Pcmovies369
    @Pcmovies369 2 месяца назад

    Fake

  • @Zulfiqarehaidri
    @Zulfiqarehaidri 7 лет назад +2

    Dear sir,
    Why you take 9 for interval calculation