Graphs, Scatter Plots and Trend Analysis Notes for XAT: Concepts, Formulas, Worked Examples & Practice

Graphs, Scatter Plots and Trend Analysis notes for XAT: 41 study cards covering concepts, formulas, shortcuts and exam traps, plus solved practice questions.

Introduction to Scatter Plots

Orientation

Introduction to Scatter Plots

Topic Hero: Visualize and analyze the relationship between two quantitative variables using a two-dimensional coordinate system.

What you will learn here:

Understand the structure of a scatter plot (X-axis and Y-axis representing two variables).
Identify the direction (positive/negative), form (linear/non-linear), and strength of a relationship.
Interpret trend lines and lines of best fit.
Compare multiple datasets or groups within the same plot.

Chapter: Graphs, Scatter Plots and Trend Analysis

The Three Pillars of Scatter Plot Analysis

Concept

The Three Pillars of Scatter Plot Analysis

The Core Principle

Every scatter plot relationship is defined by three characteristics:

Relationship = Direction + Form + Strength

1. Direction

Positive: X increases, Y increases (upward trend).
Negative: X increases, Y decreases (downward trend).
No Association: No clear pattern.

2. Form

Linear: Points follow a straight-line path.
Non-linear: Points follow a curved path (e.g., U-shaped).

3. Strength

Strong: Tightly clustered around the form.
Weak: Widely scattered with noise.

Trend Lines and Line of Best Fit

Method

Trend Lines and Line of Best Fit

The Strategy

A trend line summarizes the overall pattern of the data, smoothing out random fluctuations to reveal the underlying relationship.

Key Properties

Minimizes Distance: Sum of squared distances from points to the line is minimized (Ordinary Least Squares).
Not a Connection: It does not connect the dots. It represents the average trend.
Slope Indicates Direction:
- Positive slope $\to$ Positive association.
- Negative slope $\to$ Negative association.
- Zero slope $\to$ No linear association.

Estimation Technique

Locate the X-value on the horizontal axis, move vertically to the trend line, and then horizontally to the Y-axis to read the estimated value.

Comparative Analysis of Two Groups

Worked Example

Comparative Analysis of Two Groups

Scenario

Comparing "Hours Studied" (X) and "Test Score" (Y) for Group A (circles) and Group B (triangles).

Group A

Strong, positive linear trend. Scores increase steadily with hours.

Group B

Weak, positive linear trend. General upward movement, but high scatter.

Deductions

Strength: Group A has a stronger correlation between study time and score.
Efficiency: Group A achieves higher scores for the same amount of study time (higher Y-intercept/level).
Prediction: Group A's trend line will have a steeper slope or higher intercept than Group B's.

Graphs, Scatter Plots and Trend Analysis: Solved Questions with Step-by-Step Explanations (2 Problems)

Question 1 · Quantitative Aptitude and Data Interpretation (QA & DI) MCQ

Refer to the hypothetical dataset describing 12 regions. Graph A plots "Per Capita Healthcare Spend ( $) " o n X - a x i s v s " L i f e E x p ec t an cy (Y e a r s) " o nY - a x i s . G r a p h B pl o t s " P er C a p i t a H e a l t h c a r e S p e n d ($ )" on X-axis vs "Patient Satisfaction Score (0-10)" on Y-axis.

Observations:

In Graph A, points form a steep positive curve for spends up to $3, 000, t h e n f l a tt e n co m pl e t e l y in t o ah or i z o n t a l l in e f or s p e n d s >$ 3,000.
In Graph B, points show a steady linear upward trend across the entire spend range ( $500 t o$ 8,000).

Based ONLY on these graphs, which inference is MOST valid?

A.
Increasing healthcare spend beyond $3,000 yields no additional benefit to patients.
B.
Life expectancy is biologically capped, whereas patient satisfaction is subjective and unbounded by physiological limits.
C.
For regions spending > $3,000, marginal gains in life expectancy are negligible, but marginal gains in satisfaction persist.
D.
Regions with highest satisfaction scores necessarily have the highest life expectancy.

Correct Answer:

Step-by-Step Solution

Key idea: This is a multi-graph synthesis question. It tests the ability to reconcile conflicting/divergent trends across two related visualizations and avoid over-generalization.

Step 1: Interpret Graph A (Life Expectancy).

Shape: Logarithmic/Saturation. Steep rise then plateau.

Meaning: Marginal utility of spend on LE drops to zero after $3k.

Step 2: Interpret Graph B (Satisfaction).

Shape: Linear. Constant positive slope.

Meaning: Marginal utility of spend on Sat remains constant/positive even at high spend.

Step 3: Synthesize.

At spend > $3 k :$ \Delta LE \approx 0 $, b u t$ \Delta Sat > 0$.

This directly supports Option C.

Step 4: Reject distractors.

A: False. Says "no additional benefit." Ignores Satisfaction benefit shown in Graph B.

B: Invalid. Introduces external biological/psychological theory not present in data. Data shows correlation, not cause/mechanism.

D: False. Correlation between Sat and LE is not established. High spend regions have high Sat but flat LE. They might have same LE as mid-spend regions.

Answer: C

Question 2 · Quantitative Aptitude and Data Interpretation (QA & DI) NAT

A scatter plot consists of 10 data points. The summary statistics for these 10 points are:

$\sum X = 50$ , $\sum Y = 110$ , $\sum X^{2} = 310$ , $\sum X Y = 730$ .

The line of best fit (OLS) for these 10 points is $Y = 2 X + 1$ .

One point is identified as an outlier and removed. The new line of best fit for the remaining 9 points is $Y = 3 X - 2$ .

What is the $Y$ -coordinate of the removed outlier point?

Correct Answer:

-7

Step-by-Step Solution

Key idea: This is a reverse engineering question using the algebraic properties of OLS summary statistics.

Step 1: Set up the equations for the means

Let the removed point be $(x_{0}, y_{0})$ .

For the 10 points, $\overset{ˉ}{X} = 5, \overset{ˉ}{Y} = 11$ .

For the 9 points, the new means $\overset{ˉ}{X}^{'}, \overset{ˉ}{Y}^{'}$ must lie on the new line $Y = 3 X - 2$ .

$\overset{ˉ}{X}^{'} = \frac{50 - x _{0}}{9}$ , $\overset{ˉ}{Y}^{'} = \frac{110 - y _{0}}{9}$ .

Substituting into the new line equation:

$\frac{110 - y _{0}}{9} = 3 (\frac{50 - x _{0}}{9}) - 2$

$110 - y_{0} = 150 - 3 x_{0} - 18$

$110 - y_{0} = 132 - 3 x_{0} ⟹ y_{0} = 3 x_{0} - 22$ .

Step 2: Use the slope condition for the 9 points

The slope for the 9 points is $m^{'} = \frac{S _{X Y}^{'}}{S _{X X}^{'}} = 3$ .

$S_{X X}^{'} = \sum_{9} X^{2} - \frac{( \sum _{9} X ) ^{2}}{9} = (310 - x_{0}^{2}) - \frac{( 50 - x _{0} ) ^{2}}{9}$ .

$S_{X Y}^{'} = \sum_{9} X Y - \frac{( \sum _{9} X ) ( \sum _{9} Y )}{9} = (730 - x_{0} y_{0}) - \frac{( 50 - x _{0} ) ( 110 - y _{0} )}{9}$ .

Step 3: Simplify and solve for $x_{0}$

Substitute $110 - y_{0} = 132 - 3 x_{0}$ :

$S_{X X}^{'} = \frac{2790 - 9 x _{0}^{2} - ( 2500 - 100 x _{0} + x _{0}^{2} )}{9} = \frac{290 + 100 x _{0} - 10 x _{0}^{2}}{9}$ .

$S_{X Y}^{'} = 730 - x_{0} (3 x_{0} - 22) - \frac{( 50 - x _{0} ) ( 132 - 3 x _{0} )}{9}$

$= \frac{6570 - 27 x _{0}^{2} + 198 x _{0} - ( 6600 - 282 x _{0} + 3 x _{0}^{2} )}{9}$

$= \frac{- 30 + 480 x _{0} - 30 x _{0}^{2}}{9}$ .

We need $S_{X Y}^{'} = 3 S_{X X}^{'}$ :

$- 30 + 480 x_{0} - 30 x_{0}^{2} = 3 (290 + 100 x_{0} - 10 x_{0}^{2})$

$- 30 + 480 x_{0} - 30 x_{0}^{2} = 870 + 300 x_{0} - 30 x_{0}^{2}$ .

The quadratic terms cancel out perfectly!

$180 x_{0} = 900 ⟹ x_{0} = 5$ .

Step 4: Find $y_{0}$

$y_{0} = 3 (5) - 22 = 15 - 22 = - 7$ .

Answer: -7

Graphs, Scatter Plots and Trend Analysis Notes for XAT: Concepts, Formulas, Worked Examples & Practice

Introduction to Scatter Plots

Introduction to Scatter Plots

What you will learn here:

The Three Pillars of Scatter Plot Analysis

The Three Pillars of Scatter Plot Analysis

The Core Principle

1. Direction

2. Form

3. Strength

Trend Lines and Line of Best Fit

Trend Lines and Line of Best Fit

The Strategy

Key Properties

Estimation Technique

Comparative Analysis of Two Groups

Comparative Analysis of Two Groups

Scenario

Group A

Group B

Deductions

Graphs, Scatter Plots and Trend Analysis: Solved Questions with Step-by-Step Explanations (2 Problems)

Step-by-Step Solution

Step-by-Step Solution

More notes in this unit

A question from this chapter

Login to view the complete notes

Personalised first. High quality throughout.

Built around you, not around a syllabus PDF

Revision that hits your weak spots

Questions calibrated to the real exam

Notes written for recall, not for volume

One place for everything

Honest progress

Unlock the whole course