Basic Excel Business Analytics #24: Empirical Rule, Calculating Probability NORM.DIST & NORM.S.DIST

Learn How to use the Excel Normal Distribution Functions to calculate Probabilities for distributions that have a symmetrical or near symmetrical distribution. Learn how to use the NORM.DIST function, calculate z-score and use the NORM.S.DIST function:
1) (00:11) Empirical Rule
2) (01:06) calculate the probability of getting a particular value or less with NORM.DIST and NORM.S.DIST functions.
3) (04:58) Calculate the probability of getting a particular value or more with NORM.DIST and NORM.S.DIST functions.
4) (06:48) Calculate the probability of getting a particular value between an upper and lower number with NORM.DIST and NORM.S.DIST functions.
5) (09:23) Seattle Gas Price example for calculating probabilities with the Normal Curve and the functions NORM.DIST and NORM.S.DIST.

Download Excel File Not: After clicking on link, Use Ctrl + F (Find) and search for “Highline BI 348 Class” or for the file name as seen at the beginning of the video.

[IVIaedhros]

As someone from a non-business background getting ready for an MBA this fall, I was very intimidated when everyone told me I would really need to know Excel. Then I found your channel and I've been working through all your videos, starting at your basics course and I feel so much better. Thank you so much - you really are an amazing example of the promise of the internet. I just wish I could somehow subscribe or like twice.

[milindsagar]

respected sir, you are the true definition of teacher, the way of teaching is just
i just fell in love with excel and lots of more math stuff.
thank you sir.

[shubhampawar]

Never had done statistics in excel ..thanks a lot ❤️

[livinindubai]

Amazing video. I had no idea you covered normal distribution!

[abhijitghosh]

I am ur fan... great vedios.. quick question, Does this all apply when we have a normal dist? Generally getting normal dist is very rare. How is all this done in that case?

[zhanghongsong]

Hi I have a question for you of this video in normal distribution, you personally set SD as 10, or is it really 10? could you please tell me how do you get the SD?
I tried to get SD by myself and it seems as 23.52658071. Hope you can answer my questions