How to Plot a Normal Distribution (Bell Curve) in Excel - with Shading!

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

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

  • @ravells
    @ravells 9 месяцев назад +9

    absolutely superb! Thank you. I'm a slightly above average excel user and my stats knowledge is at high school level. I was able to create a distribution chart of children in my class running laps over time. Thank you!

  • @ValentinaLwin
    @ValentinaLwin 7 месяцев назад +1

    MUST better and quicker explanation than MS Office. thank you

  • @RahimUddin-im5vo
    @RahimUddin-im5vo 9 месяцев назад +7

    Thanks for making an excellent and very helpful video!

  • @BobVanMol
    @BobVanMol 25 дней назад

    Awesome Enrique, very helpful and easy to follow.
    Thank you

  • @swikriti8351
    @swikriti8351 7 месяцев назад

    Thank you this was very helpful.

  • @hadial-sagur1170
    @hadial-sagur1170 3 дня назад

    Brilliant!

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

    Incredible! Thank you for sharing your knowledge.

  • @driss-m6v
    @driss-m6v 14 дней назад

    Many thanks; very helpful.

  • @manasik280479
    @manasik280479 11 месяцев назад +1

    Very very useful, thanks for making this video

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

    Very helpful, thank you!

  • @A3Nargi
    @A3Nargi Год назад +9

    This is a great example to learn from but you FLY through each click and step. For someone trying to learn, I think I spent more time rewinding because you move faster than can copy and learn.

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

    Super helpful. My bell curve looks like a millipede path though 😅

  • @mspreddi1
    @mspreddi1 3 месяца назад

    Two short ones: 1) should the grades be in ascending order? 2) how to plot if the data contains a mix of positive, negative numbers and zero? thank you.

  • @FFF-ir8sc
    @FFF-ir8sc 6 месяцев назад

    Hi Enrique, question : why U use Mean and not Median value ? Thanks by Italy 🇮🇹

  • @HarwellMejia
    @HarwellMejia 7 месяцев назад +1

    Wow!!! So great, I was finding this kind of explanation for years!!! Thanks a lot for this sharing

  • @JennTheWriter
    @JennTheWriter 11 месяцев назад

    Great video! Looks so easy! :)

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

    A quick question: why did you make data in Column G, not using data in Column B?

  • @Tubeytime
    @Tubeytime 6 месяцев назад

    Absolute GOAT

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

    Thank you very much

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

    Excellent!

  • @catirerubio
    @catirerubio 9 месяцев назад

    There is A LOT to know/memorize.

  • @gregnixon1296
    @gregnixon1296 28 дней назад

    When I double click on the lower right corner of the first distribution cell, I get a #NUM! error below. No other distribution values are shown. Driving me nuts. The first cell displays as it should, but those below do not. Where could the error be?

  • @elijahmanuel8686
    @elijahmanuel8686 10 месяцев назад

    Can this be applied for independent t-test?

  • @AishuMohan-k6l
    @AishuMohan-k6l Год назад

    Hi Maven, Do you have any video similar to this in the Tableau. I have created the shading but it passes diagonally , how to change it to pass straightly down. Can you help me out.

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

    Out of box🎉❤

  • @IonCubekhanz
    @IonCubekhanz 7 месяцев назад

    What if my dataset is returning NDIST() > 1 ?

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

    I am just curious, why have you taken 60 as the lowest? Is it based on your assumption or the data set doesn't contain a value lower than 60?

    • @perdedor3571
      @perdedor3571 11 месяцев назад

      the data set is the MBA grade. taking a peak it looks like there are no grades below 60. so he likely just used 60 arbitrarily because it's a nice even number below the lowest number of the data set which was 66.9.

  • @enamulhaque630
    @enamulhaque630 5 месяцев назад

    How many minimum data do i need to plot bell curve?

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

    Great Video! Keep up the good work,

  • @colorboxmedia5866
    @colorboxmedia5866 5 месяцев назад

    Could you help me?
    I'm confusing with this :
    △ = 8 * (WRS1 - WRS2) / 1000 = 8 * (415-192) / 1000 = 1.784
    C1 = -1.060
    result = ~N(0,1)(C1 + △) = 76.5%
    How to calculate the formula to get result 76.5% ?
    That Normal Distribution Average = 0 and Standard Deviation = 1
    Thxs a alot before

  • @broonzy2006
    @broonzy2006 10 месяцев назад

    Top skills! Love this.

  • @manasik280479
    @manasik280479 11 месяцев назад +1

    My data did not get a smooth line as yours, I assuming because it was not a made up data but real one, please advise if you feel otherwise

    • @sshubhamsingh46
      @sshubhamsingh46 11 месяцев назад +1

      Yeah mine too. I think if the data is not evenly distributed we aren't going to get a perfect bell curve.

    • @TrevX2001
      @TrevX2001 9 месяцев назад

      Check your X-Axis values... if you're getting blocky fill , then make the increments small. I was counting by 2's but then changed it to count by 1's and got a perfectly smooth fill@@sshubhamsingh46

  • @tıbhendese
    @tıbhendese 5 месяцев назад

    1:18 how you did that thing, your explanation is too fast man I am watchin it 5th time

    • @tıbhendese
      @tıbhendese 5 месяцев назад

      update: I done it by pressing F4 , but my graphs didnt look like the bell shape. what can be the reason?

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

    Very bad presentation

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

      I think you meant to say very good! No worries though, I misspell things all the time so I get it😉