Excel Business Analytics Free Course - Forecasting, Linear Programming, Simulation & more. - Basic Excel Business Analytics #24: Empirical Rule, Calculating Probability NORM.DIST & NORM.S.DIST

Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/AllFilesBI348Analytics.htm 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.