youtor.org
#############################
Video Source: www.youtube.com/watch?v=jT6qKLLPxZ0
Download Excel File: https://excelisfun.net/files/Ch03-ESA... • 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
#############################
New on site
