Excel Statistical Analysis 29: HYPGEOM.DIST Function for Conditional Probabilities Across # Trials

Sdílet
Vložit
  • čas přidán 11. 09. 2024

Komentáře • 51

  • @darrylmorgan
    @darrylmorgan Před 2 lety +3

    Boom!Great Statistical Class With The Awesome HYPGEOM.DIST Function,Allready Looking Forward To The Next Class...Thank You Mike :)

    • @excelisfun
      @excelisfun  Před 2 lety

      You are welcome, darryl!!! Next video is all hand written messy notes, but should be ok...

  • @chrism9037
    @chrism9037 Před 2 lety +4

    Very cool Mike, I've never used this function! Great video as always from the master

    • @excelisfun
      @excelisfun  Před 2 lety

      Yes sir, at your service, Chris M!!!! Glad you liked this : ) : ) : ) : )

    • @spilledgraphics
      @spilledgraphics Před 2 lety +1

      Hands down, Mike = Master .... or Master Mike ! 🙏🔥

  • @waitplanwp4129
    @waitplanwp4129 Před 2 lety

    Mike, Thank you very much, I will remember you all my life, you changed my destiny for me and my family. May God bless you and your family!

    • @excelisfun
      @excelisfun  Před 2 lety +1

      I am so very happy to hep you so you can do better : ) That has been my goal for 14 years here at CZcams. You are welcome, WaitPlan Wp!!!

  • @SyedMuzammilMahasanShahi
    @SyedMuzammilMahasanShahi Před 2 lety +2

    Thanks for this EXCELlent video Amazing Mike.

    • @excelisfun
      @excelisfun  Před 2 lety +1

      You are welcome, Fellow Teacher : ) : )

  • @excelwithmark
    @excelwithmark Před 2 lety +2

    Great video thanks for sharing

    • @excelisfun
      @excelisfun  Před 2 lety

      You are welcome, TechWithMark!!!!

  • @bamakaze
    @bamakaze Před 2 lety +3

    So glad you went over hypergeometric. I think in the previous stats videos, you did geometric but not hyper geometric.

  • @richardhay645
    @richardhay645 Před 2 lety +1

    Great Video of the "Poker Distribution"!! Two distributions joined at the hip and fighting over a CARD! Draw a card and keep it: Hypergeometric; draw a card and put it back: Binomial. BTW Excel --esp with the .dist fhnctions--has permitted the world to forget the Tyranny of Factorials! LOL

    • @excelisfun
      @excelisfun  Před 2 lety

      I actually cal it that is class!?!?!? Or the tyranny of tables in the back of the book or Integral Calculus... Wait, Integral calculations is cool, not tyrannical lol
      LOVE this note to relate the two different distributions: Draw a card and keep it: Hypergeometric; draw a card and put it back: Binomial. : ) : ) : ) : )

  • @yulinliu850
    @yulinliu850 Před 2 lety +2

    Awesome 👍

    • @excelisfun
      @excelisfun  Před 2 lety

      Glad this is awesome for you, Yulin!!!!

  • @KeyserTheRedBeard
    @KeyserTheRedBeard Před 2 lety +1

    fantastic upload ExcelIsFun. I killed the thumbs up on your video. Always keep up the high quality work.

    • @excelisfun
      @excelisfun  Před 2 lety +1

      Glad you like the upload. Thanks for the killed Thumbs Ups : )

    • @KeyserTheRedBeard
      @KeyserTheRedBeard Před 2 lety +1

      @@excelisfun no problem at all. always happy to support my fellow content creators. i am looking forward to improving on my own current video format i have uploaded and, in the future, trying to create content as good as yours in the long term.

    • @excelisfun
      @excelisfun  Před 2 lety +1

      @@KeyserTheRedBeard Awesome, CZcams Teammate : )

  • @clalgbarros
    @clalgbarros Před 2 lety

    It couldn´t be better than this, as usual.

  • @user-yi8mx5pq7q
    @user-yi8mx5pq7q Před 2 lety +2

    Superb video

    • @excelisfun
      @excelisfun  Před 2 lety

      Glad the video was superb for you : )

  • @spilledgraphics
    @spilledgraphics Před 2 lety +1

    Like n° 72, comment 20 = glad to be back Mike! 🔥

    • @excelisfun
      @excelisfun  Před 2 lety

      I am glad that you boomeranged back : ) : )
      Did you see this: czcams.com/video/8Kik-2iHQbI/video.html
      O, I see you did : ) : ) : ) : )

    • @spilledgraphics
      @spilledgraphics Před 2 lety +1

      So many good example Mike! awesome to see the COMBIN function!
      And above all, the spilling ranges with the HYPGEOM.DIST is amazing!

    • @excelisfun
      @excelisfun  Před 2 lety

      @@spilledgraphics Spilled Arrays just make our live easier : ) : ) : ) : )

    • @spilledgraphics
      @spilledgraphics Před 2 lety +1

      @@excelisfun MUCH MUCH! easier and better ! haha 👌👌👌

  • @johnborg5419
    @johnborg5419 Před 2 lety +1

    Thanks Mike. :) :)

    • @excelisfun
      @excelisfun  Před 2 lety

      You are welcome, Formula Guy : ) : )

  • @msantosh1220
    @msantosh1220 Před 2 lety +4

    Thanks!

    • @excelisfun
      @excelisfun  Před 2 lety +1

      You are amazing!!! Thank you for your kind Teammate work, Santosh : ) : ) : ) : )
      P.S. Do you have to use statistics in your work, Santosh Mekale?

    • @msantosh1220
      @msantosh1220 Před 2 lety +3

      Yes sir, I'm in recruitment team and have 0.5million data. Statistics tells me what will the joining ratio for each onboarding planned.

    • @msantosh1220
      @msantosh1220 Před 2 lety +2

      All these videos are directly helping me.

    • @excelisfun
      @excelisfun  Před 2 lety +3

      @@msantosh1220 That is wonderful. I am so glad that I can help. Have you seen my full Statistics playlist (75 videos): czcams.com/play/PLrRPvpgDmw0ngx_uPhvasTbOWLOztsaBj.html and my full analytics playlist (75 videos): czcams.com/users/playlist?app=desktop&list=PLrRPvpgDmw0mSJCZaqQPFj0eto4qnzkCZ

    • @excelisfun
      @excelisfun  Před 2 lety +2

      @@msantosh1220 I am glad that they can directly help you : ) : ) : ) : )

  • @drsteele4749
    @drsteele4749 Před 2 lety +2

    My uncle once had a hypergeometric distribution and the surgeon hacked it out.

  • @circuitstudios1930
    @circuitstudios1930 Před 2 lety +1

    I don't get it, but its RAD,!! Go Nuggs ;)

    • @excelisfun
      @excelisfun  Před 2 lety +1

      I love your comment : ) : ) : ) : ) : ) : )

    • @circuitstudios1930
      @circuitstudios1930 Před 2 lety +1

      @@excelisfun I love your enthusiasm and incredible depth of knowledge! Game 3 tonight!

    • @excelisfun
      @excelisfun  Před 2 lety

      @@circuitstudios1930 You know I was born and raised in Oakland. Go Oakland Warriors!!! It is in Denver, so maybe your Team can get one?