Completed
) Calculating the measures range and interquartile range using Excel worksheet formulas, both standard formulas and dynamic spilled array formulas.
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
