Channel: ExcelIsFun

Category: Education

Tags: business statistical analysiseasy statisticsunderstanding standard deviationdata analysisrangehighline collegeexcel statisticsmike girvinvariationesa 13variancespread in the datadata clustered around the meanmicrosoft 365 excelbusn 210measures of variations to make decisionsvisual for standard deviationmike excelisfun girvinstatistical analysisdispersionexcelisfunexcel statistical analysisstandard deviationcoefficient of variation

Description: Download Excel File: excelisfun.net/files/Ch03-ESA.xlsm Learn about how to use measures of variations to make decisions. Learn about variation visually, then learn how to calculate these measures of variation: Range, Variance, Standard Deviation, Coefficient of Variation. Topics: 1. (00:00) Introduction 2. (00:51) Learn about variation visually. What is variation or dispersion anyway? How can a Measure of variation help to make business decisions? 3. (05:23) Notes for formulas 4. (05:38) Calculating the measures range and interquartile range using Excel worksheet formulas, both standard formulas and dynamic spilled array formulas. 5. (05:47) How to use Mouse to select a range of cells 6. (09:15) Interpreting Standard Deviation and calculating Standard Deviation with STDEV.S function. 7. (11:29) Calculating Standard Deviation long hand. 8. (17:58) Calculating Standard Deviation for Population or Sample Data. See Statistical Formulas, including Greek letters for variables: s for sample and lower case sigma for population. 9. (09:13) Calculating Coefficient of Variance. 10. (22:33) Using Standard Deviation for Financial Data 11. (24:56) Summary 12. (25:42) Closing and Video Links