Make an interactive distribution curve (bell curve) in Excel - Easy Trick 💡

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

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

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

    Beautiful!!

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

    Thanks for this...i Made together with this video and highly satisfied because i made the second bell curve by myself.
    satisfaction like here👇

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

    New concept learned++

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

    Thank you so much Mr. Chandoo!! I hope more people were kind-hearted like you!

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

      Aww.. so nice of you to say that.

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

    Thanks so much for sharing your knowledge in an easy way.

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

      Glad it was helpful!

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

    Great tutorial, Chandoo! I have a question - is there a way to restrict the smoothing curve to stay above the zero line?

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

    This was so helpful! Exactly what I needed

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

      Awesome to hear that... 😀

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

    Thank you Bro! Quick Question: How do you do it if the data is an Employee Scorecard Rating of 1-5 and grouping is by 1?
    I did it with this guide but it does not look like a bell curve.

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

    Hi Chandoo. Nice approach! Thanks for sharing these tips :)) Thumbs up!!

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

    Hi Chandoo, as always something amazing to learn from you.
    Just a query, Is there anyway we can also show some kind of Descriptive Statistics along with the chart.

  • @JasonSmith-yz6nd
    @JasonSmith-yz6nd 2 года назад +4

    Wonderful video. When I try to Group the numbers in column A, I get a message saying that I can not group that selection. Also, when I click on a cell to group it, it highlights the A cell and the B cell. I can not only highlight the A cell. I wonder if that is causing me to not be able to do the grouping. Unfortunately, I can not post a screenshot here. Do you have any suggestions as to what could be going on and how to fix it? Thanks

  • @ns7647
    @ns7647 8 месяцев назад

    You are awesome brother, loved your content.

  • @KKB-tt4lj
    @KKB-tt4lj 3 года назад

    You should have 10,000,000 subscribers!

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

    nice tutorial. good job. thanks

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

    Thanks you so much for the great information sir .

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

    This is amazing! Thank you for your videos!

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

      Glad you like them!

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

    Greetings from Data with Decision Channel. Good job!

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

      Greetings to you too :)

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

    Great stuff. Thank you.

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

    Thanks for such amazing tips! Many blessings!

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

      You are so welcome!

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

    very cool way around long workout with formulas! Only one question: how do I distribute the data that it's in a bell (gaussian) distribution? my data in fact is, but if i visualize the order it is now, I am getting two top mountain, which I want to avoid... Like, after the grouping at 2:07 your data happen to follow gaussian distribution just by itself, it seems so. How do I achieve that?

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

      You can adjust the group size or boundaries. But your data is in a different shape, that is what it is. You can't do much to change it.

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

    Superb explanation done

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

    Excellent explanation thank you so much 💞

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

      You’re welcome 😊

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

    That's nice, easier than frequency arrays. Now the question is, why would the salary increase data be normally distributed? 🤨

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

    You are the best. Awesome👍😊

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

      Thank you so much 😀

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

    amazing! thank you for sharing!

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

    great one, Chandoo

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

    thanks bro

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

    Great!!!

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

    awesome. thx 🙏

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

      You're welcome 😊

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

    You are awesome sir ,I teach in college, I want to master Data Analysis of students, result analysis , and all such task, please suggest me path to master this task in Excel, I mean which topics in Excel should I master

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

      I suggest learning formulas, pivots and charts as a starting point. I am actually making a video on this very topic. Watch out for it.

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

      @@chandoo_ sir I watch everyone of your videos , excellent videos you are making

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

      Big thanks :)

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

    Thanks bro