Quantitative Techniques & Data Literacy

Chapter 3
Descriptive Statistics and Data Visualization

Graduate Program in Business Administration (GBA)
Quantitative Techniques & Data Literacy   •   Graduate

Descriptive Statistics and Data Visualization

Introduction

Descriptive statistics convert raw observations into interpretable evidence. In business administration, managers rarely make decisions from an unprocessed spreadsheet containing thousands of transactions, customer responses, or operational records. They need to know what is typical, how much variation exists, where observations sit relative to one another, whether unusual values are credible, and how results can be communicated accurately to decision-makers.

Descriptive analysis does not, by itself, establish causality or generalize from a sample to a population. Its purpose is to organize, summarize, and display observed data. Nevertheless, high-quality descriptive analysis is foundational to forecasting, hypothesis testing, performance management, customer analytics, financial reporting, and managerial communication.

This chapter develops a systematic approach to distributions, central tendency, dispersion, position, shape, outliers, tables, dashboards, and visual narratives. Particular attention is given to choosing statistics and charts that match the measurement scale, analytical purpose, and audience.

Learning Objectives

By the end of this chapter, you should be able to:

  1. Distinguish populations, samples, variables, observations, and measurement scales.
  2. Construct and interpret frequency and relative-frequency distributions.
  3. Compute and evaluate measures of central tendency, dispersion, position, and shape.
  4. Identify potential outliers using principled methods and investigate their causes.
  5. Select appropriate tables and visualizations for managerial questions.
  6. Design dashboards and visual narratives that are accurate, accessible, and decision-oriented.
  7. Recognize the limitations, ethical risks, and governance requirements of descriptive analytics.

1. Data Foundations for Descriptive Analysis

A population is the complete set of units relevant to a question; a sample is a subset observed from that population. A variable is a characteristic recorded for each unit, and an observation is one recorded value. For example, in a customer dataset, the population might be all active customers, a sample might be 500 surveyed customers, and variables might include tenure, monthly spending, satisfaction score, and region.

Variables are commonly classified by measurement scale:

ScaleMeaningExamplesAppropriate summaries
NominalCategories without orderRegion, product typeCounts, percentages, mode
OrdinalOrdered categories, unequal distances not assumedSatisfaction levelCounts, percentages, median, percentiles
IntervalEqual numerical intervals, no meaningful zeroTemperature in °C, calendar yearMean, standard deviation, correlation
RatioEqual intervals and meaningful zeroRevenue, units sold, waiting timeAll arithmetic summaries

A code such as 1 = male and 2 = female is nominal, even though it uses numbers. Computing its mean would have no substantive meaning. Similarly, a five-point satisfaction scale is ordinal unless there is a defensible reason to treat its categories as approximately equally spaced.

Before calculating statistics, analysts should inspect data types, missing values, duplicate records, impossible values, units, and the time period covered. Descriptive results are only as reliable as the data-generation and data-cleaning processes behind them.

2. Distributions and Frequency Summaries

A distribution describes how values are allocated across categories or numerical intervals. For a categorical variable, a frequency table reports the number of observations in each category. If category i has frequency fᵢ and the total number of observations is n, its relative frequency is:

pᵢ = fᵢ ÷ n

Here, pᵢ is the proportion in category i, fᵢ is its frequency, and n is the total sample size. The percentage is 100pᵢ. Frequencies should sum to n, and relative frequencies should sum to 1, subject to rounding.

For numerical data, observations may be listed individually or grouped into intervals. Grouping is useful for large datasets but sacrifices detail. Class intervals should be mutually exclusive and collectively exhaustive. For example, age bands might be 18–24, 25–34, 35–44, and 45–54; the boundaries must be defined so that no observation can belong to two classes or to none.

Worked Example 1: A Frequency Distribution

Suppose ten account managers record the number of new accounts opened in a month:

12, 8, 15, 10, 8, 20, 11, 15, 9, 12.

The frequency table is:

New accountsFrequencyRelative frequency
820.20
910.10
1010.10
1110.10
1220.20
1520.20
2010.10
Total101.00

The mode is not necessarily unique: 8, 12, and 15 each occur twice. The observation 20 is relatively uncommon, but it is not automatically an error or an outlier; that judgment requires context and a formal rule.

A histogram displays frequencies for numerical intervals. Unlike a bar chart, the bars of a histogram normally touch because the horizontal axis represents a continuous numerical scale. A bar chart is used for discrete categories, and its bars are separated to emphasize categorical distinctions.

3. Measures of Central Tendency

Central tendency identifies a typical or central value. The three principal measures are the mean, median, and mode.

3.1 Arithmetic Mean

For n observed values x₁, x₂, …, xₙ, the sample mean is:

x̄ = (∑ᵢ₌₁ⁿ xᵢ) ÷ n

The mean uses every observation and is appropriate for numerical data when the scale and distribution make averaging meaningful. It is sensitive to extreme values. For a population, the corresponding mean is denoted μ and the population size is N.

3.2 Median

The median is the middle ordered value. If n is odd, it is the value at position (n + 1) ÷ 2. If n is even, it is the average of the values at positions n ÷ 2 and (n ÷ 2) + 1. The median is resistant to extreme values and is often preferable for income, house prices, transaction values, and other right-skewed variables.

3.3 Mode

The mode is the most frequently occurring value or category. It is the only common measure of central tendency directly applicable to nominal data. A distribution can be unimodal, bimodal, or multimodal, and it may have no mode if all values occur equally often.

Worked Example 2: Comparing Mean and Median

Consider monthly customer spending, in dollars:

40, 45, 50, 55, 60, 65, 70, 300.

The mean is:

x̄ = (40 + 45 + 50 + 55 + 60 + 65 + 70 + 300) ÷ 8 = 685 ÷ 8 = 85.625

The ordered data have eight observations, so the median is the average of the fourth and fifth values:

Median = (55 + 60) ÷ 2 = 57.5

The mean of $85.63 is substantially above the median of $57.50 because one unusually large purchase pulls the mean upward. Reporting only the mean would give an incomplete picture of a typical customer.

Choosing a Center

The mean is useful for symmetric numerical data and for subsequent statistical modeling. The median is often better for skewed data or when outliers are legitimate but not representative. The mode is useful for categories and discrete decisions, such as the most frequently purchased package. In executive reporting, presenting the mean alongside the median can reveal distributional asymmetry.

4. Measures of Dispersion

Two datasets can have the same mean but very different levels of risk, consistency, or operational control. Dispersion measures quantify variability.

4.1 Range

The range is:

Range = maximum − minimum

It is simple but depends only on two observations and is therefore highly sensitive to extremes.

4.2 Variance and Standard Deviation

For a sample, the variance is:

s² = ∑ᵢ₌₁ⁿ (xᵢ − x̄)² ÷ (n − 1)

The sample standard deviation is:

s = √s²

The symbol s² denotes sample variance, s denotes sample standard deviation, xᵢ is an observation, x̄ is the sample mean, and n is the sample size. The denominator n − 1 is used when sample data estimate population variability; it provides the usual unbiased estimator of population variance under random sampling. If the entire population is observed, population variance divides by N:

σ² = ∑ᵢ₌₁ᴺ (xᵢ − μ)² ÷ N

Variance is expressed in squared units, whereas standard deviation has the same units as the original variable. Consequently, standard deviation is easier to interpret operationally.

Worked Example 3: Sample Standard Deviation

For the sample 2, 4, 6, 8, the mean is 5. Deviations are −3, −1, 1, and 3; squared deviations are 9, 1, 1, and 9. Their sum is 20. Thus:

s² = 20 ÷ (4 − 1) = 6.667
s = √6.667 ≈ 2.582

The sample standard deviation is approximately 2.58 units.

4.3 Interquartile Range

The first quartile Q₁ is the 25th percentile and the third quartile Q₃ is the 75th percentile. The interquartile range is:

IQR = Q₃ − Q₁

The IQR measures the spread of the middle 50% and is resistant to extreme values. Different software conventions exist for calculating quartiles, especially with small samples; analysts should document the method used.

4.4 Coefficient of Variation

For a positive-valued ratio variable with a nonzero mean, the coefficient of variation is:

CV = s ÷ x̄

It is often expressed as a percentage by multiplying by 100. CV is useful for comparing relative variability across measures with different units or means, but it is inappropriate when the mean is zero, near zero, or not meaningful, and it is generally unsuitable for interval scales such as Celsius temperature.

5. Measures of Position

Measures of position locate an observation within a distribution.

  • A percentile is a value below which a specified percentage of observations falls.
  • Quartiles divide ordered data into four parts: Q₁, Q₂ (the median), and Q₃.
  • Deciles divide data into ten parts.
  • A z-score expresses distance from the mean in standard-deviation units:
z = (x − x̄) ÷ s

For a population-standardized value, μ and σ replace x̄ and s. A z-score of 2 means the observation is two standard deviations above the mean, provided the standardization is appropriate. Z-scores are useful for comparing values measured on different scales, but they do not automatically imply unusualness unless the distribution and decision context are considered.

Percentile calculations vary among statistical packages because interpolation rules differ. For high-stakes decisions, such as compensation or credit scoring, the organization should specify and consistently apply a documented method.

6. Shape, Skewness, and Kurtosis

The shape of a distribution affects the interpretation of its center and spread.

  • A symmetric distribution has roughly balanced tails around its center.
  • A right-skewed distribution has a long upper tail; typically mean > median.
  • A left-skewed distribution has a long lower tail; typically mean < median.
  • A uniform distribution has relatively similar frequencies across its range.
  • A bimodal distribution has two prominent peaks and may indicate different subpopulations.

Skewness can be summarized using several formulas. One commonly used sample moment coefficient is:

g₁ = [n ÷ ((n − 1)(n − 2))] × ∑ᵢ₌₁ⁿ [(xᵢ − x̄) ÷ s]³

Definitions and small-sample corrections differ across software. The sign indicates direction, but the magnitude should not be interpreted without considering sample size, visualization, and context. Kurtosis measures tail weight and concentration relative to a reference distribution, but competing definitions—particularly whether excess kurtosis or raw kurtosis is reported—make software documentation essential.

A box plot communicates median, quartiles, IQR, and potential outliers compactly. It is especially useful for comparing distributions across departments, products, or regions. A box plot does not show every observation and can conceal multimodality; it should sometimes be paired with a dot plot or histogram.

7. Outliers and Data Quality

An outlier is an observation unusually distant from the rest of the data. It may arise from data-entry error, measurement failure, fraud, a rare but valid event, or an important structural change. Outlier detection is therefore an investigative process, not a license to delete inconvenient observations.

The 1.5-IQR rule identifies potential outliers below:

Lower fence = Q₁ − 1.5 × IQR

and above:

Upper fence = Q₃ + 1.5 × IQR

Values outside these fences are often marked as potential outliers in box plots. The rule is descriptive and heuristic; it is not a universal test of error.

A disciplined response is to:

  1. Verify the original record and units.
  2. Check whether the value is plausible in the business process.
  3. Determine whether it represents a different subgroup or period.
  4. Correct confirmed errors using an auditable procedure.
  5. Retain valid extreme observations, possibly reporting robust and non-robust summaries together.
  6. Conduct sensitivity analysis with and without the observation when appropriate.

Winsorizing, transformation, or trimming may be suitable in some analytical models, but each changes the data and must be justified and documented. In fraud, safety, or compliance settings, unusual observations may be the most important cases and must not be automatically removed.

8. Tables and Data Visualization

Visualization is a reasoning tool, not merely a presentation device. A chart should answer a clearly stated question: What changed? Which category is largest? How variable is performance? Is there a relationship? Where are exceptions?

Chart Selection

Analytical purposeSuitable displayImportant caution
Compare categoriesSorted bar chartAvoid excessive categories
Show compositionStacked bar; cautiously, pie chartSmall segments are hard to compare
Show a trendLine chartUse meaningful time intervals
Show a distributionHistogram, box plot, dot plotDefine bins transparently
Compare distributionsSide-by-side box plots or violinsInclude sample sizes
Show associationScatter plot with fitted line if justifiedAssociation is not causation
Show geographic patternMapRates are usually better than raw counts
Show performance against targetBullet chart or well-designed bar chartMake target and scale explicit

A table is preferable when exact values, ranks, or small differences matter. A chart is preferable when patterns, comparisons, trends, or exceptions matter. Tables and charts should complement rather than duplicate one another.

Principles of Accurate Visual Design

Use honest scales, clear titles, direct labels, consistent units, and restrained color. A zero baseline is generally important for bar charts because bar length encodes magnitude; truncating the axis can exaggerate differences. Line charts may use a focused scale when the purpose is to show small changes, but the scale and limits must be visible.

Avoid three-dimensional effects, decorative backgrounds, unexplained abbreviations, excessive precision, and color schemes that exclude viewers with color-vision deficiencies. Use annotations to explain meaningful events, such as a pricing change or supply disruption. State whether values are nominal or inflation-adjusted, whether revenue is gross or net, and whether percentages use the full population or a filtered subgroup.

Dashboards and Visual Narratives

An executive dashboard should connect metrics to decisions. A useful structure is:

  1. Headline: the principal business message.
  2. Context: period, population, target, and comparison baseline.
  3. Evidence: a small number of relevant charts and supporting metrics.
  4. Exception view: segments or observations requiring attention.
  5. Action: decision owner, proposed response, and next review date.

A dashboard is not a warehouse for every available metric. Metric definitions, refresh times, data owners, filters, and calculation logic should be documented. Interactive filters should display the selected population and prevent users from mistaking a filtered result for an organization-wide result.

9. Illustrative Case: Regional Service Performance

The following is a fictional illustrative case.

Background and Problem

A service company reviews resolution times for 1,200 support tickets across three regions. The executive team wants to know whether the regions differ and whether a reported average of 18 hours accurately represents customer experience.

Analysis

The analyst first validates that resolution time is measured in hours from ticket creation to closure, removes duplicate ticket IDs, and identifies 37 unresolved tickets. Because unresolved tickets have no final resolution time, they are not silently coded as zero; they are reported separately. The analyst computes mean, median, Q₁, Q₃, IQR, and standard deviation for each region and produces box plots with ticket counts.

Results are summarized as follows:

RegionTickets analyzedMean hoursMedian hoursIQRPotential outliers
North39015.211.012.018
Central40521.714.019.027
South36817.113.014.021

The overall mean of 18 hours hides substantial skewness: a small number of very long cases increase the mean, particularly in Central. Median performance is lower than the mean in every region, indicating right-skewed distributions. The Central region also has the widest IQR, signaling inconsistent service rather than merely a higher typical time.

Approach and Outcome

The operations team investigates the potential outliers and finds that many are legitimate escalations requiring specialist approval. Instead of deleting them, the team separates standard tickets from escalated tickets, introduces an escalation queue, and establishes a service-level target for each ticket type. The dashboard displays median resolution time, the 90th percentile, unresolved-ticket count, and escalation rate. The 90th percentile is added because customers affected by long waits are operationally important even if they are not represented by the median.

Learning Points

The case demonstrates that one average can conceal skewness, heterogeneity, and operationally distinct processes. Segmenting by region and ticket type improves managerial interpretation. It also shows why data quality checks, explicit denominators, robust summaries, and investigation of unusual cases are essential before taking action.

10. Ethical, Governance, and Technological Considerations

Descriptive statistics can create ethical harm when categories or denominators are concealed. Reporting a complaint rate without stating the number of customers, for example, can make a small group appear disproportionately important. Suppression rules may be needed for very small cells to protect privacy, especially when combining attributes could re-identify individuals.

Organizations should establish data ownership, definitions, lineage, access controls, retention policies, and audit trails. Personally identifiable information should not be placed in a dashboard unless necessary and authorized. Analysts should examine whether missingness differs by demographic group; a simple overall percentage may conceal systematic exclusion.

AI and automated analytics tools can accelerate chart generation and detect unusual patterns, but they do not remove the need for human judgment. Automatically generated narratives may misstate causality, confuse correlation with explanation, or summarize biased data. Every automated insight should be traceable to the underlying data, calculation, filter, and time period. Version-controlled definitions and reproducible code are particularly important when dashboards support regulatory, employment, lending, or customer decisions.

11. Best-Practice Workflow

A defensible descriptive analysis follows this sequence:

  1. Define the managerial question and unit of analysis.
  2. Identify the population, sample, period, variables, and measurement scales.
  3. Audit data quality, missingness, duplicates, units, and impossible values.
  4. Examine distributions before selecting summary statistics.
  5. Report both center and dispersion, using robust measures when appropriate.
  6. Investigate potential outliers rather than deleting them automatically.
  7. Segment results only when the segmentation is substantively justified.
  8. Choose a visualization that matches the analytical question.
  9. Label denominators, units, filters, targets, and uncertainty or limitations.
  10. State the decision implication and preserve an auditable record of methods.

Chapter Summary

Descriptive statistics organize observed data into interpretable evidence. Frequency distributions summarize categorical and numerical allocation; the mean, median, and mode describe central tendency; range, variance, standard deviation, IQR, and CV describe dispersion; percentiles and z-scores describe position; and skewness and tail behavior describe shape. Outliers require investigation because they may represent errors, rare valid events, fraud, or meaningful process differences.

Effective visualization begins with a question and depends on the measurement scale, distribution, comparison, and audience. Tables support exact lookup, while charts reveal patterns and exceptions. Executive dashboards should use transparent definitions, honest scales, meaningful denominators, accessible design, and an explicit connection to action. Ethical and governance practices—including privacy protection, data lineage, reproducibility, and cautious use of AI—are integral to credible descriptive analysis.

Key Terms

Population: Complete set of units relevant to a study.

Sample: Subset of a population that is observed.

Variable: Characteristic recorded for each unit.

Observation: A recorded value for one unit.

Frequency: Number of observations in a category or interval.

Relative frequency: Frequency divided by the total number of observations.

Mean: Arithmetic average of numerical observations.

Median: Middle value of ordered observations.

Mode: Most frequently occurring value or category.

Variance: Average squared deviation, with the denominator determined by population or sample status.

Standard deviation: Square root of variance, expressed in original units.

Quartile: Value dividing ordered data into four parts.

Interquartile range: Difference between the third and first quartiles.

Percentile: Cut point below which a specified percentage of observations falls.

Z-score: Standardized distance from a mean in standard-deviation units.

Skewness: Direction and degree of asymmetry in a distribution.

Outlier: Observation unusually distant from other observations.

Histogram: Graph of frequencies for numerical intervals.

Dashboard: Coordinated display of metrics and visualizations for monitoring and decision-making.

Review Questions

5 Short Answer Questions

  1. Why is measurement scale important when selecting descriptive statistics?
  2. Distinguish a histogram from a bar chart.
  3. Why is the median often preferred to the mean for highly right-skewed data?
  4. What does the interquartile range measure?
  5. Why should an outlier not be deleted automatically?

5 Long Answer Questions

  1. Explain the differences among mean, median, and mode, and evaluate their usefulness for nominal, ordinal, and ratio data.
  2. Derive and interpret the sample variance and standard deviation formulas, including the reason for using n − 1.
  3. Discuss how skewness affects managerial interpretation of averages and dispersion measures.
  4. Develop guidelines for choosing tables, charts, and dashboard components in executive communication.
  5. Explain the ethical and governance risks associated with descriptive dashboards and automated analytical narratives.

3 Analytical / Application Questions

  1. A business reports average delivery time of 4.2 days, while the median is 2.6 days and the 90th percentile is 9.5 days. Interpret the distribution and recommend additional metrics for an operations dashboard.
  2. Construct a frequency table and calculate the mean, median, range, and sample standard deviation for the observations 6, 7, 7, 8, and 12. Explain which statistic best represents a typical observation.
  3. A regional dashboard shows complaint counts but not customer counts. Explain why this can mislead executives and propose a fairer comparison using appropriate denominators and visualizations.

Multiple Choice Questions with Answers

Question 1

Which measure of central tendency is generally most resistant to an extreme value?

A. Mean

B. Median

C. Variance

D. Range

Correct Answer: B. Median

Question 2

A sample contains 50 observations. What denominator is used in the usual sample variance formula?

A. 49

B. 50

C. 51

D. 25

Correct Answer: A. 49

Question 3

If Q₁ = 10 and Q₃ = 22, what is the IQR?

A. 12

B. 16

C. 32

D. 2

Correct Answer: A. 12

Question 4

Which display is most appropriate for examining the distribution of a continuous variable?

A. Histogram

B. Nominal bar chart only

C. Pie chart

D. Organizational chart

Correct Answer: A. Histogram

Question 5

A distribution with a long upper tail is typically described as:

A. Left-skewed

B. Right-skewed

C. Uniform

D. Symmetric

Correct Answer: B. Right-skewed

Question 6

For the values 2, 4, 6, and 8, the sample mean is:

A. 4

B. 5

C. 6

D. 20

Correct Answer: B. 5

Question 7

Which statistic is expressed in the same units as the original variable?

A. Variance

B. Standard deviation

C. Squared deviation

D. Relative frequency

Correct Answer: B. Standard deviation

Question 8

Under the 1.5-IQR rule, the upper potential-outlier fence is:

A. Q₃ + 1.5 × IQR

B. Q₁ + 1.5 × IQR

C. Q₃ − 1.5 × IQR

D. Mean + IQR

Correct Answer: A. Q₃ + 1.5 × IQR

Question 9

Which chart is usually most suitable for showing a trend over time?

A. Line chart

B. Pie chart

C. Box plot

D. Nominal frequency table only

Correct Answer: A. Line chart

Question 10

A z-score of 2 indicates that an observation is:

A. Two units above the median

B. Two standard deviations above the mean

C. Twice the mean

D. In the top two observations

Correct Answer: B. Two standard deviations above the mean

Quantitative Techniques & Data Literacy
Chapter 3 of 15