Descriptive Statistics: Measures of Central Tendency, Variation, and Relative Position

Descriptive Statistics

Introduction

Descriptive statistics are essential tools in business statistics, providing methods to summarize, organize, and interpret data. The main categories include measures of central tendency, measures of variability, and measures of relative position. These concepts help in understanding the distribution, spread, and ranking of data within a dataset.

Measures of Central Tendency

Definition and Overview

Measures of central tendency describe the center or typical value of a dataset. The three primary measures are the mean, median, and mode. Each measure provides different insights and is appropriate under different circumstances.

• Mean (Arithmetic Average): The sum of all values divided by the number of observations.

• Median: The middle value when data are arranged in order.

• Mode: The value that appears most frequently in the dataset.

The Mean

• Sample Mean Formula: $\bar{x} = \frac{\sum_{i=1}^{n} x_i}{n}$

• Population Mean Formula: $\mu = \frac{\sum_{i=1}^{N} x_i}{N}$

• Weighted Mean Formula: $\bar{x}_w = \frac{\sum_{i=1}^{n} w_i x_i}{\sum_{i=1}^{n} w_i}$

• Example: Calculating the mean for a dataset: $87.2, 118.9, 76.2, 107.7, 61.5$ yields $\bar{x} = 90.3$.

• Weighted Mean Example: If exam, project, and homework scores are weighted 50%, 35%, and 15% respectively, the weighted mean is calculated as: $\bar{x}_w = \frac{(94 \times 0.5) + (92 \times 0.35) + (100 \times 0.15)}{0.5 + 0.35 + 0.15} = 94.2$

The Median

• Definition: The value that divides the dataset into two equal halves.

• Finding the Median: Arrange data in order. If $n$ is odd, the median is the middle value. If $n$ is even, it is the average of the two middle values.

• Median Position Formula: $i = 0.5n$

• Example: For the dataset $70, 74, 81, 83, 86, 88, 91, 92, 95$, the median is $86$ (the fifth value).

The Mode

• Definition: The value with the highest frequency in the dataset.

• Types: Unimodal (one mode), Bimodal (two modes), Multimodal (more than two modes), or No mode.

• Example: In the dataset $6, 7, 7, 8, 8, 8, 8, 8, 9, 9, 9, 10, 10, 11, 11, 11, 14, 14$, the mode is $8$.

Choosing the Appropriate Measure

• Mean: Best for symmetric distributions without outliers.

• Median: Preferred when data are skewed or contain outliers.

• Mode: Useful for categorical data.

Measures of Variability

Definition and Overview

Measures of variability describe the spread or dispersion of data. Common measures include the range, variance, standard deviation, and coefficient of variation.

• Range: Difference between the highest and lowest values. $R = \text{Max} - \text{Min}$

• Variance (Sample): $s^2 = \frac{\sum_{i=1}^{n} (x_i - \bar{x})^2}{n-1}$

• Variance (Population): $\sigma^2 = \frac{\sum_{i=1}^{N} (x_i - \mu)^2}{N}$

• Standard Deviation: Square root of variance. $s = \sqrt{s^2}$ or $\sigma = \sqrt{\sigma^2}$

• Coefficient of Variation (CV): Expresses standard deviation as a percentage of the mean.

  • Sample: $CV = \frac{s}{\bar{x}} \times 100$

  • Population: $CV = \frac{\sigma}{\mu} \times 100$

Example: Calculating Variance and Standard Deviation

• Given data: $10, 10, 4, 8, 13, 6, 11$

• Sample variance: $s^2 = 9.48$

• Sample standard deviation: $s = 3.08$

Coefficient of Variation Example

• Nike: $CV = \frac{3.70}{49.77} \times 100 = 7.4\%$

• Google: $CV = \frac{47.96}{719.62} \times 100 = 6.7\%$

• Interpretation: Lower CV indicates more consistency relative to the mean.

Using the Mean and Standard Deviation Together

Shapes of Frequency Distributions

• Symmetric: Mean = Median

• Left-skewed: Median < Mean

• Right-skewed: Mean < Median

Quality Control Example

Histograms can be used to visualize the distribution of data and assess conformity to specifications. The mean and standard deviation together help determine the proportion of data within specification limits.

The z-Score

Definition and Calculation

The z-score indicates how many standard deviations a value is from the mean. It is used to standardize values for comparison.

• Population z-score: $z = \frac{x - \mu}{\sigma}$

• Sample z-score: $z = \frac{x - \bar{x}}{s}$

• Interpretation: A z-score of 0 means the value equals the mean; positive values are above the mean, negative values are below.

• Outliers: Values with $|z| > 3$ are considered extreme outliers.

Empirical Rule

• For bell-shaped (normal) distributions:

• ~68% of data within ±1 standard deviation

• ~95% within ±2 standard deviations

• ~99.7% within ±3 standard deviations

Chebyshev’s Theorem

• For any distribution (not just normal):

• At least $1 - \frac{1}{z^2}$ of data falls within $z$ standard deviations of the mean, for $z > 1$.

• At least 75% within ±2 standard deviations, 89% within ±3, 94% within ±4.

Measures of Relative Position

Percentiles and Quartiles

• Percentiles: Divide data into 100 equal parts. The pth percentile is the value below which p% of the data fall.

• Quartiles: Divide data into four equal parts:

  • Q1: 25th percentile

  • Q2: 50th percentile (median)

  • Q3: 75th percentile

• Index for Percentile: $i = \frac{p}{100} n$

Box-and-Whisker Plots

A boxplot visually displays the five-number summary: minimum, Q1, median (Q2), Q3, and maximum. It also identifies outliers using the interquartile range (IQR).

• IQR: $IQR = Q3 - Q1$

• Outlier Limits:

  • Upper Limit: $Q3 + 1.5 \times IQR$

  • Lower Limit: $Q1 - 1.5 \times IQR$

Using Excel for Descriptive Statistics

Descriptive Statistics Tool

Excel provides built-in functions and analysis tools for calculating descriptive statistics such as mean, median, mode, standard deviation, variance, percentiles, and quartiles.

Summary

• Descriptive statistics summarize data using measures of central tendency, variability, and relative position.

• Choosing the appropriate measure depends on the data’s distribution and the presence of outliers.

• Excel is a powerful tool for performing these calculations efficiently.