How to Find the Equation of a Scatter Plot

••• SunnyGraph/iStock/GettyImages

A scatter plot is a graph that shows the relationship between two sets of data. Sometimes it is helpful to use the data contained within a scatter plot to obtain a mathematical relationship between two variables. The equation of a scatter plot can be obtained by hand, using either of two main ways: a graphical technique or a technique called linear regression.

Creating a Scatter Plot

Use graph paper to create a scatter plot. Draw the x- and y- axes, ensure they intersect and label the origin. Ensure that the x- and y- axes also have correct titles. Next, plot each data point within the graph. Any trends between the plotted data sets should now be evident.

Line of Best Fit

Once a scatter plot has been created, assuming there is a linear correlation between two data sets, we can use a graphical method to obtain the equation. Take a ruler and draw a line as close as possible to all of the points. Try to ensure that there are as many points above the line as there are below the line. Once the line has been drawn, use standard methods to find the equation of the straight line

Equation of Straight Line

Once a line of best fit has been placed upon a scatter graph it is straightforward to find the equation. The general equation of a straight line is:

y = mx + c

Where m is the slope (gradient) of the line and c is the y-intercept. To obtain the gradient, find two points upon the line. For the sake of this example, let's assume that the two points are (1,3) and (0,1). The gradient can be calculated by taking the difference in the y-coordinates and dividing by the difference in the x-coordinates:

m = \frac{3 - 1}{1 - 0} = \frac{2}{1} = 2

The gradient in this case is equal to 2. Thus far, the equation of the straight line is

y = 2x + c

The value for c can be obtained by substituting in the values for a known point. Following the example, one of the known points is (1,3). Plug this into the equation and rearrange for c:

3 = (2 × 1) + c \\ c = 3 - 2 = 1

The final equation in this case is:

y = 2x + 1

Linear Regression

Linear regression is a mathematical method that can be used to obtain the straight-line equation of a scatter plot. Start by placing your data into a table. For this example, let us assume that we have the following data:

(4.1, 2.2) (6.5, 4.5) (12.6, 10.4)

Calculate the sum of the x-values:

x_{sum} = 4.1 + 6.5 + 12.6 = 23.2

Next, calculate the sum of the y-values:

y_{sum} = 2.2 + 4.4 + 10.4 = 17

Now sum the products of each data-point set:

xy_{sum} = (4.1 × 2.2 ) + (6.5 × 4.4 ) + (12.6 × 10.4) = 168.66

Next, calculate the sum of the x-values squared and the y-values squared:

x^2_{sum} = (4.1^2) + (6.5^2) + (12.6^2) = 217.82
y^2_{sum} = (2.2^2) + (4.5^2) + (10.4^2) = 133.25

Finally, count the number of data points you have. In this case we have three data points (N=3). The gradient for the best-fit line can be obtained from:

m = \frac{(N × xy_{sum}) - (x_{sum} × y_{sum})}{(N × x^2_{sum}) - (x_{sum} × x_{sum})} \\ \, \\ = \frac{(3 × 168.66) - (23.2 × 17)}{(3 × 217.82) - (23.2 × 23.2)} \\ \, \\ = 0.968

The intercept for the best-fit line can be obtained from :

\begin{aligned} c &= \frac{(x^2_{sum} × y_{sum} ) - (x_{sum} × xy_{sum})}{(N × x^2_{sum}) - (x_{sum} × x_{sum})} \\ \,\\ &= \frac{ (217.82 × 17) - (23.2 × 168.66)}{(3 × 217.82) - (23.2 × 23.2)} \\ \,\\ &= -1.82 \end{aligned}

The final equation is therefore:

y = 0.968x - 1.82

Related Articles

How to Determine the Y-Intercept of a Trend Line
How to Create Linear Equations
How to Calculate SSE
How to Calculate Regression Coefficient
How to Write a Linear Regression Equation
How to Write the equation of a Linear Function whose...
How to Solve for Both X & Y
How to Interpret Linear Equations
How to Find Perpendicular Slope
How to Calculate LSRL
How to Graph and Find the Solution on a Calculator
How to Convert Graphs to Equations
How to Calculate the Slope of a Line of Best Fit
How to Find X & Y Intercepts on a Graphing Calculator
How to Find a Parallel Line
How to Calculate the Distance Between Two Parallel...
How to Find the Slope & the Equation of the Tangent...
What is Slope Intercept Form?
How to Find the Intersection of Two Linear Equations
To Calculate Arcsine, What Buttons Do You Press on...