Descriptive Statistics: Measures of Location

Measures of Location

  • Definition: Sample statistic; a point estimator of the corresponding population parameter.
  • Types of Measures of Location:
    • Mean
    • Median
    • Mode
    • Weighted Mean
    • Geometric Mean
    • Percentiles
    • Quartiles

Mean

  • Description: A crucial measure of location; represents a measure of central location.
  • Formula: The sample mean is the point estimator of the population mean ( \mu ).
    • ( \bar{x} = \frac{\sum{i=1}^{n} xi}{n} )
    • Where:
    • ( n ) = number of observations
    • ( x_i ) = data values in the sample

Median

  • Definition: The median is the middle value when data is arranged in ascending order.
  • Use Cases: Preferred when data contains extreme values (e.g., annual income, property values) to avoid distortion in mean.
  • Finding Median:
    • Odd number of observations: Middle value directly.
    • Even number of observations: Average of the two middle values.

Mode

  • Definition: The mode is the value that appears most frequently in a data set.
  • Types of Modes:
    • Bimodal: Exactly two modes.
    • Multimodal: More than two modes.

Using Excel for Mean, Median, and Mode

  • Mean Function: =AVERAGE(data cell range)
  • Median Function: =MEDIAN(data cell range)
  • Mode Function: =MODE.SNGL(data cell range)
  • For multiple modes, use =MODE.MULT(data cell range).

Weighted Mean

  • Description: Calculated by weighting each observation according to its importance.
  • Example: Weighted GPA, where weights depend on the number of credit hours for grades.
  • Formula:
    • ( \bar{x} = \frac{\sum{i=1}^{n} wixi}{\sum{i=1}^{n} w_i} )
    • Where:
    • ( w_i ) = weight for observation ( i )
    • ( x_i ) = value of observation ( i )

Geometric Mean

  • Definition: The nth root of the product of n values, useful for rates.
  • Applications: Common in growth rates (e.g., financial data, population growth).
  • Finding Geometric Mean: Use the formula
    • ( g = \sqrt[n]{x1 \cdot x2 \cdots x_n} )
  • Example Calculation: Finding the average annual growth rate from annual returns.

Percentiles

  • Definition: A method to describe the distribution of data. The pth percentile separates lower p% of data from 100 - p%.
  • Usage: Often used in reporting college admission test scores.

Quartiles

  • Definition: Specific percentiles that split data into quarters:
    • First Quartile (Q1): 25th Percentile
    • Second Quartile (Q2): 50th Percentile (Median)
    • Third Quartile (Q3): 75th Percentile
  • Excel Functions:
    • Percentile Function: PERCENTILE.EXC(array, p/100)
    • Quartile Function: QUARTILE.EXC(array, QUART)