How to Create a Histogram with Normal curve overlay in Excel,Add normal curve, insert bell curve to

แชร์
ฝัง
  • เผยแพร่เมื่อ 26 พ.ย. 2024

ความคิดเห็น • 36

  • @davincimemes3631
    @davincimemes3631 ปีที่แล้ว +3

    I WISH I could give you more than just 1 upvote! This is PERFECTLY DONE! SUBSCRIBED!!!

  • @hoangphio3284
    @hoangphio3284 11 หลายเดือนก่อน +1

    Thank you so much for this. Wish you the best!

  • @hariskakakheal813
    @hariskakakheal813 ปีที่แล้ว +3

    I don't understand what you did @ 7:11 of the video. And what's the formula you have created for X. Can you explain?

  • @nataliarodriguezarias8545
    @nataliarodriguezarias8545 ปีที่แล้ว

    ¡Muchas gracias!. Por fin encontre un video tutorial que me sirvio.

  • @minhinh8403
    @minhinh8403 ปีที่แล้ว +2

    Your series are really helpful, thank you so much!

    • @LeanSixSigmaGlobal
      @LeanSixSigmaGlobal  ปีที่แล้ว

      Thanks for joining us.

    • @LeanSixSigmaGlobal
      @LeanSixSigmaGlobal  ปีที่แล้ว

      Thank you for your consideration, and I hope to see you inside the membership program soon!th-cam.com/channels/YQMvu3YszW1dgKi97Fmzow.htmljoin

  • @umutozer1292
    @umutozer1292 ปีที่แล้ว +1

    Great work, thank you for sharing.

    • @LeanSixSigmaGlobal
      @LeanSixSigmaGlobal  ปีที่แล้ว

      Thank you for your consideration, and I hope to see you inside the membership program soon!th-cam.com/channels/YQMvu3YszW1dgKi97Fmzow.htmljoin

  • @HappyMinds_SSP
    @HappyMinds_SSP ปีที่แล้ว +1

    Superb... thanks brother ❤

  • @satvikkompella9912
    @satvikkompella9912 ปีที่แล้ว +3

    why did you divide 6*std dev by 100 for the increment? And why did you first subtract (3*stdev) from mean and then took the (point * 6-stddev)?

  • @anitak8339
    @anitak8339 2 ปีที่แล้ว +1

    Thank you so much for this tutorial. It helped a lot!

    • @LeanSixSigmaGlobal
      @LeanSixSigmaGlobal  ปีที่แล้ว

      Thank you for your consideration, and I hope to see you inside the membership program soon!th-cam.com/channels/YQMvu3YszW1dgKi97Fmzow.htmljoin

  • @asbinanceasbinance1473
    @asbinanceasbinance1473 3 ปีที่แล้ว +1

    Thanx dude. That was helpful.

  • @sumcheeyee9125
    @sumcheeyee9125 3 ปีที่แล้ว +1

    SO GOOD. Thank you so much.

  • @nandk1981
    @nandk1981 2 หลายเดือนก่อน

    Great 👍

  • @bl0ndi334
    @bl0ndi334 3 ปีที่แล้ว +1

    Thank you so much for this tutorial! Its was really helpful

  • @germangomezsolarte
    @germangomezsolarte 3 ปีที่แล้ว +1

    Good job man, thanks a lot!

  • @hoangphuong631
    @hoangphuong631 3 ปีที่แล้ว

    A lot of good thing. Thanks so much!

  • @eagle93616
    @eagle93616 3 ปีที่แล้ว +2

    for the inc formula, what's the 6 stands for? and for the formula you used to calculate X, $c$3-3, why minus 3?

    • @Great_America
      @Great_America 2 ปีที่แล้ว

      The "6" value is for 6 standard deviations, or 6 Sigma. The calculation for the x points; $c$3-3*$C$5, he was subtracting 3 standard deviations and was not just subtracting a value of 3. Cell C5 had the standard deviation (STDEV) value for the data population. He created the 100 randomized points in order to create a cleaner, symmetric bell curve that would allow for him to illustrate the 1, 2, and 3 Sigma distributions.

  • @traiphamngoc9772
    @traiphamngoc9772 3 ปีที่แล้ว

    so good. thanks

  • @dragonvietnam866
    @dragonvietnam866 3 ปีที่แล้ว +2

    Thanks

  • @juelalas7287
    @juelalas7287 3 ปีที่แล้ว +1

    Hi. Thank you for the video. But I seem to have a problem. After I clicked "select data source" then "add", I can only select for the y axis and not for the x axis. Basically, there is only one slot for selecting an axis. Do you know what's wrong? Thanks!

    • @essenceserendipity
      @essenceserendipity 3 ปีที่แล้ว

      Try using the Y values for the ‘Series Name’ and the X values for the ‘Series Value’. It worked for me that way. You might need to cut the values so that the lines may fit on the histogram graph. There’s a ‘smoothed line’ option if the line looks jagged. Hope this helps!

  • @oswaldocouto7302
    @oswaldocouto7302 3 ปีที่แล้ว

    Very good, ....Thanks for share this video

  • @ea5hhi84
    @ea5hhi84 ปีที่แล้ว

    where can i download the template

  • @shansiganarumuganathan30
    @shansiganarumuganathan30 2 ปีที่แล้ว

    I'm looking to get the percentage of the histogram outside of the curve, is that possible? If so, how can I do it?

  • @JonathanMiddleton-v6q
    @JonathanMiddleton-v6q ปีที่แล้ว +1

    Couldn't hear you very well