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

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Dive into a comprehensive 26-minute video tutorial on statistical analysis in Excel, focusing on measures of variation. Learn to calculate and interpret range, variance, standard deviation, and coefficient of variation using both standard formulas and dynamic spilled array formulas. Explore the visual aspects of variation, understand how these measures aid in business decision-making, and apply standard deviation to financial data. Master techniques for selecting cell ranges, interpreting statistical results, and distinguishing between population and sample data calculations. Gain practical skills to enhance your Excel proficiency and statistical analysis capabilities.

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.