Learn how to use measures of variation such as Range, Variance, Standard Deviation, and Coefficient of Variation to make informed decisions. This course covers visually understanding variation, calculating these measures using Excel formulas, interpreting Standard Deviation, and using it for financial data analysis. The teaching method includes practical demonstrations in Excel. This course is intended for individuals interested in statistical analysis using Excel for business decision-making.
Excel Statistical Analysis - Range, Variance, Standard Deviation, Coefficient of Variation
ExcelIsFun via YouTube
Overview
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.
Taught by
ExcelIsFun
