Excel 2013 Statistical Analysis #31: Create Discrete Probability Distribution, Calculate Mean and SD 

Excel 2013 Statistical Analysis #31: Create Discrete Probability Distribution, Calculate Mean and SD Download files: people.highline.edu/mgirvin/excelisfun.htm Topics in this video: 1. (00:12) Discussion about Discrete Probability Distributions, Random Variables, Continuous Random Variables, Discrete Random Variables, Discrete Probability Functions, Steps for creating Discrete Probability Distributions and calculating Expected Value (Mean) and Standard Deviation from a Discrete Probability Distributions. 2. (12:50) Create Discrete Probability Distributions for Isaac’s Italian Restaurant where we need to calculate probabilities for the random variable “Number of Banquet Rooms Used in One Day 3. (15:14) Calculate Expected Value (Mean) from Discrete Probability Distributions using SUMPRODUCT. 4. (16:55) Test to see if Expected Value formula works by calculating Mean for original Data Set 5. (17:15) Calculate Standard Deviation from Discrete Probability Distributions Long Hand. 6. (20:32) Test to see if Standard Deviation formula works by calculating Standard Deviation for original Data Set using STDEV.P 7. (21:28) Calculate Standard Deviation from Discrete Probability Distributions in a single cell using SUMPRODUCT and SQRT functions 8. (24:49) Calculate Probabilities from Discrete Probability Distributions for Isaac’s Italian Restaurant where we need to calculate probabilities for the random variable “Number of Banquet Rooms Used in One Day 9. (26:12) Create Discrete Probability Distributions and calculate Expected Value and Standard Deviation and calculate probabilities from Discrete Probability Distributions For Dick’s Hamburger Drive In Customer Arrival Data

Thank you Mike! Stats is really my favorite series!

I'm finally understanding! Had to watch this video twice but I am!

I love the way you teach❤

This is brilliant series.... Loving statistical with excel... Statistics can only be fun with excelisfun

Great video thank you. Question Prof. Gervinho, when does a population become a population and not a sample?

I am trying to apply the information from this video to a set of data, but I am not sure if I did it correctly and how to read the results. Is there a chance to send a file for a professional advice? I know it's too much to ask, but ... desperate times :))

Thanks!