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

preview_player
Показать описание
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
Рекомендации по теме
Комментарии
Автор

Excel 2013 Statistical Analysis #31: Create Discrete Probability Distribution, Calculate Mean and SD
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

excelisfun
Автор

Thank you Mike! Stats is really my favorite series!

chriswang
Автор

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

rrrprogram
Автор

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

Kevin-sqgn
Автор

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

JoshuaDHarvey
Автор

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

vaniad