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. (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