Free Tutorial Central Home | Basic Statistical Analyses with Excel |

Basic Statistical Analysis with Excel Lesson 1: Describing Univariate Data with Excel

In Lesson 1, you learn how to compute basic univariate statistics. Procedures for computing the following measures of central tendency are explained: mean, median, mode, trimean, and trimmed mean. Measures of variability (range, semi-interquartile range, variance, and standard deviation), skew, and kurtosis are covered.

Click the "Download" button (upper right) to download this free lesson in PDF format.

Objectives: Be able to compute the following.

  1. mean
  2. median
  3. mode
  4. trimean
  5. trimmed mean
  6. range
  7. semi-interquartile range
  8. variance
  9. standard deviation


  10. man working computer