Excel 2013 Statistical Analysis #39: Probabilities for Normal (Bell) Probability Distribution
Автор: excelisfun
Загружено: 2015-02-17
Просмотров: 47705
Описание:
Download files (which file shown at begin of video): https://people.highline.edu/mgirvin/A...
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
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
