Scatter Plots

Scatter Diagram or Plot is a graphical representation of relationship between two quantities variables, and a trend line is a line that provides an approximation of the relationship.
A graph of bivariate data in which the independent variable is on the horizontal axis and dependent is on vertical axis.

Consider the following example for scatter Diagram

Observations X Y
1 -22 22
2 -33 49
3 2 8
4 29 -16
5 -13 10
6 21 -28
7 -13 27
8 -23 35
9 14 -5
10 3 -3
11 -37 48
12 34 -29
13 9 -18
14 -33 31
15 20 -16
16 -3 14
17 -15 18
18 12 17
19 -20 -11
20 -7 -22

scatter diagram homework help

To Construct the Scatter Plot in excel.

Step 1: Select the data set in excel
Step 2: Click the insert tab on ribbon.
Step 3: In the chart group select Scatter

A trend line can be added to the scatter diagram as follows.
Step 1: Position the mouse pointer over any data point in the scatter diagram and right click to display a list of options.
Step 2: Choose Add trend line.

Types of relationship depicted by scatter diagrams.

positive relationship scatter diagram
positive relationship
negative relationship scatter diagram
negative relationship