Excel Statistical Analysis 13: Range, Variance, Standard Deviation, Coefficient of Variation

Download Excel File: https://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. (19: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