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

This course explains variation and dispersion visually, then demonstrates how to calculate and interpret range, interquartile range, variance, standard deviation, and coefficient of variation in Excel, including sample and population data.

Syllabus

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