Completed
) Summary
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Statistical Analysis - Range, Variance, Standard Deviation, Coefficient of Variation
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) Learn about variation visually. What is variation or dispersion anyway? How can a Measure of variation help to make business decisions?
- 3 ) Notes for formulas
- 4 ) Calculating the measures range and interquartile range using Excel worksheet formulas, both standard formulas and dynamic spilled array formulas.
- 5 ) How to use Mouse to select a range of cells
- 6 ) Interpreting Standard Deviation and calculating Standard Deviation with STDEV.S function.
- 7 ) Calculating Standard Deviation long hand.
- 8 ) 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 ) Calculating Coefficient of Variance.
- 10 ) Using Standard Deviation for Financial Data
- 11 ) Summary
- 12 ) Closing and Video Links
