I do not know what you mean by truncated. But here is a video from my analytics class that shows how to create various distribution random variables, including normal: czcams.com/video/7NNtUs5xAkw/video.html
That is not the formula that was typed. Mean - 4 standard deviations = 74-10*4 = 34 = start value to plot all the way down to 4 SD. Maybe you need glasses lol
Thanks Mike! Statistically, you have a 100% chance of publishing a great video on any given day...
Thanks for that funny probability statement, Chris M : ) : ) : ) : ) lol
@@excelisfun Intelligent Comment with Intelligent Reply Sirji...👌👌😃
@@maheshvinchhi3785 : ) : ) : ) : )
The best teacher I ever seen in my life, simply spectacular.
I am so glad to be of service, Rodrigo!!!!!!
That's Amazing Mike ....I think it's time for Excel developers to allow hashtag operator (#) in all dialogue boxes ....
100% TRUE!!!!! What is Microsoft Thinking!?!?!? Why even invent # if it does not work everywhere?
Wow, very instructive as ever.
Charting is fun!!!!! ; )
Boom!Super Cool Chart Tips And A Awesome Statistical Class...Thank You Mike :)
You are welcome for the CCT (Cool Chart Tips), darryl!!!!!
Thanks Mike for this EXCELlent video.
You are welcome, Fellow Teacher!!!
next level!
thanks sir
good teaching
You are welcome, Mohammad!!!!
Thanks Mike!!!
You are welcome, Formula Guy John!!!!
Wow! You really spell it out for your students.
It’s not funny anymore: they have it way too easy! LOL! :-)
I better change the channel name to: waytooeasyisfun : ) : ) : ) :) LOL
wow!!! awesome!!!!
Glad you like it, Edina!!!!
@@excelisfun very much! :)
Mike can I make movable cross hairs in my charts like the ones on yahoo finance charts?
I am sorry but I do not know how to do that... : (
1st comment
I have create a dynamic bell curve with Excel using Scroll Bar. You can check it here: czcams.com/video/jzLGWoxPL8M/video.html
@ExcellIsFun is there a way to make the right hand side of the orange area straight up and down, instead of diagonal?
I have create a dynamic bell curve with Excel using Scroll Bar. You can check it here: czcams.com/video/jzLGWoxPL8M/video.html
It's good, why i cannot access your web site?
The server is up and running. I am not sure why you can't access.
Hi, It is possible generating random variables in excel from truncated normal distribution?
I do not know what you mean by truncated. But here is a video from my analytics class that shows how to create various distribution random variables, including normal:
czcams.com/video/7NNtUs5xAkw/video.html
@@excelisfun 😅Thanks , sorry, i too ask in other your video.
How to add last 3 digits on excel plz any one reply the formula
=SUMPRODUCT(RIGHT(Range,3)+0)
@@excelisfun Thanks a lot bro🤩🤩👍😀😀
@@vinothkumar7377 : )
You lost me at 1:02. How in the world does (74-10) *4 = 34?
That is not the formula that was typed. Mean - 4 standard deviations = 74-10*4 = 34 = start value to plot all the way down to 4 SD. Maybe you need glasses lol