Verismall Software

Whats NewMost popularterms and conditionsAbout UsContact Us

Home Page > Statistics > Measures of Dispersion Spreadsheet
Measurements of Dispersion Spreadsheet
Teach yourself statistics...


File Size: 37 KB
Date Added: July 2003
Requirements: Microsoft Excel 97 and higher



Second in a series of statistic tutorials in spreadsheet form.  Teach yourself the basics of statistics.

Statistics is the science of collecting, organizing, presenting, analyzing and interpreting numerical data so as to assist in making a more effective decision.  This is also known as descriptive statistics.

This spreadsheet focus on the measurement of dispersion for ungrouped (raw) data.  It measures the distribution of data around a central point.  A large value for the measurement indicates that the mean is not very representative of the data.

The spreadsheet contains a separate page where each of the measurements are described and calculated.  The explanations also describe when it is appropriate to use the particular measurement.  You may change the values and see how it affects the calculation of the measurement.  All pages are preformatted to be printed.

  • Range explained
  • Mean deviation explained
  • Variance explained
  • Standard deviation explained
  • Coefficient of variation explained
Customer Reviews

Copyright 2014 Francois Andlau  -  all rights reserved