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.
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!
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!
I WISH I could give you more than just 1 upvote! This is PERFECTLY DONE! SUBSCRIBED!!!
Thanks for joining us
Thank you so much for this. Wish you the best!
Thanks. Hope it helps
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?
¡Muchas gracias!. Por fin encontre un video tutorial que me sirvio.
Your series are really helpful, thank you so much!
Thanks for joining us.
Thank you for your consideration, and I hope to see you inside the membership program soon!th-cam.com/channels/YQMvu3YszW1dgKi97Fmzow.htmljoin
Great work, thank you for sharing.
Thank you for your consideration, and I hope to see you inside the membership program soon!th-cam.com/channels/YQMvu3YszW1dgKi97Fmzow.htmljoin
Superb... thanks brother ❤
Thanks
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)?
Thank you so much for this tutorial. It helped a lot!
Thank you for your consideration, and I hope to see you inside the membership program soon!th-cam.com/channels/YQMvu3YszW1dgKi97Fmzow.htmljoin
Thanx dude. That was helpful.
Thanks
SO GOOD. Thank you so much.
Great 👍
Thank you so much for this tutorial! Its was really helpful
Thanks
Good job man, thanks a lot!
thanks
A lot of good thing. Thanks so much!
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?
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.
so good. thanks
Thanks
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!
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!
Very good, ....Thanks for share this video
Thanks
where can i download the template
I'm looking to get the percentage of the histogram outside of the curve, is that possible? If so, how can I do it?
Couldn't hear you very well