Excel Statistical Analysis - Range, Variance, Standard Deviation, Coefficient of Variation

Excel Statistical Analysis - Range, Variance, Standard Deviation, Coefficient of Variation

ExcelIsFun via YouTube Direct link

) Calculating Coefficient of Variance.

9 of 12

9 of 12

) Calculating Coefficient of Variance.

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. 1 ) Introduction
  2. 2 ) Learn about variation visually. What is variation or dispersion anyway? How can a Measure of variation help to make business decisions?
  3. 3 ) Notes for formulas
  4. 4 ) Calculating the measures range and interquartile range using Excel worksheet formulas, both standard formulas and dynamic spilled array formulas.
  5. 5 ) How to use Mouse to select a range of cells
  6. 6 ) Interpreting Standard Deviation and calculating Standard Deviation with STDEV.S function.
  7. 7 ) Calculating Standard Deviation long hand.
  8. 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. 9 ) Calculating Coefficient of Variance.
  10. 10 ) Using Standard Deviation for Financial Data
  11. 11 ) Summary
  12. 12 ) Closing and Video Links

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.