Excel 2013 Statistical Analysis #39: Probabilities for Normal (Bell) Probability Distribution
HTML-код
- Опубликовано: 16 фев 2015
- Download files (which file shown at begin of video): people.highline.edu/mgirvin/A...
Topics in this video:
1. (00:11) Using Handwritten notes, discuss characteristics of the Normal (Bell) Distribution, how to calculate probabilities using Excel functions and the four situations for calculating probabilities and x or z values.
2. (12:18) Excel Chart Example for family of Normal (Bell) Curves.
3. (15:04) Calculate probability on the low end of the curve using NORM.DIST function with x values and NORM.S.DIST function with z values.
4. (17:50) Calculate probability on the high end of the curve using NORM.DIST function with x values and NORM.S.DIST function with z values.
5. (19:22) Calculate probability between two values using NORM.DIST function with x values and NORM.S.DIST function with z values.
6. (21:51) Find x values using NORM.INV function function or find z value using NORM.S.INV function
Excel 2013 Statistical Analysis #39: Probabilities for Normal (Bell) Probability Distribution
Download files: people.highline.edu/mgirvin/excelisfun.htm
Topics in this video:
1. (00:11) Using Handwritten notes, discuss characteristics of the Normal (Bell) Distribution, how to calculate probabilities using Excel functions and the four situations for calculating probabilities and x or z values.
2. (12:18) Excel Chart Example for family of Normal (Bell) Curves.
3. (15:04) Calculate probability on the low end of the curve using NORM.DIST function with x values and NORM.S.DIST function with z values.
4. (17:50) Calculate probability on the high end of the curve using NORM.DIST function with x values and NORM.S.DIST function with z values.
5. (19:22) Calculate probability between two values using NORM.DIST function with x values and NORM.S.DIST function with z values.
6. (21:51) Find x values using NORM.INV function function or find z value using NORM.S.INV function
Only God knows how grateful I am for this page!!
Thank you
can't express how grateful I am for this stats series...not sure if others feel the same but your teaching style is incredible
+Connie Vargas , You are welcome! I am glad that the videos help!
Love this series 😊
Glad you love it! Stats are fun ; )
I am saying "brrrroooooop" all day now! Great videos!!!!
Lee Han Glad you like them!!!
Thanks!
Never underestimate the usefulness of drawing a picture :)
enjoying all the series wonderful videos
Glad you like them!
Awesome presentation, thank you
You are welcome!
Hi, Just noticed that Area Charts don't drop to the vertical when using " ". So in the If function, I needed to use the NA() instead with Excel 2016. Hope this helps others
Sir;
Great super job, I wish I would it know what you know, to conduct a LOTTERY probability investigation study's how to get close to the lottery winning numbers. Also, you really know how to works those Excel formulas, please make a video how you designed those beautiful graphics formulas with Excel, really educative, I will be the first one to download it and learn from it. I love math, and especially statistics. Anyways, thanks, great video.
Respectfully;
Andy
amazing
Glad you like it!
Thanks
You are welcome, clifford! This is a good video : )
Do you have a video show us how to set up the actual data chart and bell curve that you have in this video? I have to start from scratch. My Stat project is to determine which math professor is best to take according to distribution of exam grades. I have to first create the data chart in order to do the actual distribution chart right?
NYGoddess77 , charting is shown in next video:
ruclips.net/video/VXFeI8Tm9pM/видео.html
ExcelIsFun Thank you. Will you show me how to input multiple bell curves in one graph? I have to show 2 different grading distributions from 2 different math classes on one chart.
How do I download this? I have a MacBook Air.
Hi there, thanks a lot for these great videos, can you please advise me how I can contact you for specific issue with excel, I am lost with all of the videos you are posting and I don't know where to look for this. Basically, I have stock data in a text file that look the the following line and I don't know how to separate them , any help would be appreciated.
[{"date":"2013-05-01","open":57.7993,"high":57.8604,"low":56.4898,"close":57.127,"volume":126720237,"unadjustedVolume":18102891,"change":-0.453855,"changePercent":-0.788,"vwap":57.1217,"label":"May 1, 13","changeOverTime":0},{"date":"2013-05-02","open":57.4508,"high":58.3364,"low":57.3013,"close":57.9372,"volume":105449078,"unadjustedVolume":15064154,"change":0.810175,"changePercent":1.418,"vwap":58.0741,"label":"May 2, .
I also have other questions, Please advise how can I contact you guys,
Thanks Mo
Hi, how to download the class notes (handwritten ones), I have searched the link given below the video but I could not locate the one for "Probabilities for Normal (Bell) Probability Distribution normal distribution" video/class 39.
Pls help.
And thank you so much for uploading these beautiful videos :)
I am also looking for the same.
Dear excell team, I want to calculate the probability to achieve my sla goal based on the 15 first days of the month. Is this the best video to watch in your channel ? Thanks in advance !
I cant find the file?? Its not under the same name you mention on the page
Here is the link: people.highline.edu/mgirvin/AllClasses/210Excel2013/210/Busn210.htm It is chapter 6 section.
Are you watching just this single video or the whole class?