Skip to main content
Back

Descriptive Statistics-Excel definitions

Control buttons has been changed to "navigation" mode.
1/15
  • Descriptive Statistics
    Summary measures that describe features of a dataset, such as central tendency, spread, and frequency of values.
  • Median
    The middle value in an ordered dataset, splitting the data into two equal halves.
  • Mean
    The arithmetic average of a dataset, calculated by summing all values and dividing by the count.
  • Standard Deviation
    A measure of how spread out values are around the mean, indicating variability in the dataset.
  • Maximum
    The largest value present in a dataset, representing the upper bound of observed data.
  • Minimum
    The smallest value present in a dataset, representing the lower bound of observed data.
  • Mode
    The value or values that appear most frequently in a dataset; there can be more than one.
  • Sample Data
    A subset of a population used to estimate characteristics of the whole group.
  • Population Data
    All possible observations or measurements of interest for a particular group.
  • Central Tendency
    A statistical concept referring to the center or typical value within a dataset.
  • Spread
    The extent to which data values differ from each other, often measured by range or standard deviation.
  • Data Range
    A selection of cells in Excel containing the values to be analyzed.
  • Formula Bar
    The area in Excel where functions and calculations are entered and displayed.
  • Cell Reference
    An identifier for a cell or group of cells in Excel, used to specify data locations in formulas.
  • Statistical Process Control
    A method of monitoring and controlling processes using statistical measures to ensure quality.