Excel 2013 Statistical Analysis #39: Probabilities for Normal (Bell) Probability Distribution

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

[excelisfun]

Excel 2013 Statistical Analysis #39: Probabilities for Normal (Bell) Probability Distribution
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

[ConnieVargasintl]

can't express how grateful I am for this stats series...not sure if others feel the same but your teaching style is incredible

[tracybashala]

Only God knows how grateful I am for this page!!

Thank you

[LeeHarvey]

I am saying all day now!  Great videos!!!!

[Danny-kytc]

Never underestimate the usefulness of drawing a picture :)

[rrrprogram]

enjoying all the series wonderful videos

[andycobraaor]

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

[ChrisP]

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

[NYGoddess]

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?

[mohammedalmasri]

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

[maczilla]

How do I download this? I have a MacBook Air.

[ashishsharma]

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 :)

[alexchase]

I cant find the file?? Its not under the same name you mention on the page