Buy Now

Scatter Diagram
Excel Template

 

Analyze and identify a relationship between two sets of data with our Scatter Diagram Excel Template, equipped with an organized table for your inputs and a dynamic chart to easily view trends.
Unlock Access
Video Poster Image

What's Inside the Scatter Diagram Template?

Details | 3 Sheets 

Supported Versions | Excel 2007, 2010, 2013, 2016, 2019, Office 365 (Mac)

Category | Operations, Data Analysis

Tags | Axis, Correlation, Relationship, Plot, Six Sigma, Lean

Why Professionals Choose Simple Sheets

It's simple. Access to the largest library of premium Excel Templates, plus world-class training.

100+ Professional Excel Templates

Optimized for use with Excel. Solve Excel problems in minutes, not hours.

Buy Now

World-Class Excel University

With our university, you'll learn how we make templates & how to make your own.

Explore Catalog

How-To Videos

Each template comes with a guide to use it along with how-to videos that show how it works.

Buy Now

Inside Our Scatter Diagram

Excel Template

Enter your inputs and outputs. They will auto populate on the Scatter plot of our Scatter Diagram Excel Template

Evan Treborn, played by Ashton Kutcher in the 2004 film The Butterfly Effect, is burdened with horrible headaches that cause him to black out and time travel to the past. His time travel leads him to explore difficult moments from his past and identify how the reality he lives in is shaped by the past. While Treborn is analyzing qualitative data to understand the relationship between one variable from his life and another, statisticians have a much more structured approach and the benefit of using quantitative data to further research how one variable is related to another. 

Introducing (even we admit this was a non-traditional introduction) our Scatter Plot Diagram for Excel, built to automate your Scatter Plot charting and calculations. 

If you find this template useful, you’ll also want to check out our other data analysis templates such as Box and Whisker Plot, Stratification Data and Panel Analysis. With these tools at your disposal, you will quickly reduce the time it takes to crunch numbers and more time analyzing the real world impact of what your dataset represents. Our library includes each of the Seven Basic Tools of Quality.

Let’s dive into how to use this template. 

Start in the Scatter Diagram sheet and input your independent variable in the horizontal x-axis input and the dependent variable in the vertical y-axis. Put a symbol where the x-axis value intersects with the y-axis value. 

If your data forms a line or a curve, you can draw the conclusion that there is a relationship between the two variables. You may want to use a regression or correlation analysis for further understanding of the relationship if those two traits are present. 

Divide points on the graph into four quadrants. If there are X points on the graph, count X/2 points from top to bottom and draw a horizontal line. Count X/2 points from left to right and draw a vertical line. Count the points in each quadrant. Do not count points on the line. 

Use the Trend Test table to put in your inputs.

Add the diagonally opposite quadrants. Find the smaller sum and the total points in all quadrants. 

Move to the Test Table sheet and look up the limit for N on the trend test table. If Q is less than the limit, the two variables are related. If Q is greater than or equal to the limit, the pattern could have occurred from random chance. 

And just like that, you are the mathematician Ashton Kutcher...

More Data Analysis Templates For You

Simple Pricing for Full Access

Unlock full access to the entire library for one low price.

Limited

$49

(no bundle savings)

  • 45+ Customizable Excel Templates
  • One User
  • One-Time Payment
BUY NOW

Premium + University

$199

($699 bundle savings)

  • Full Access to Excel University ($399 bundle savings)
  • 100+ Customizable Excel Template
  • Personal Membership Portal
  • Excel, PowerPoint, & Word 101 Courses ($199 bundle savings)
  • Two Users
  • One-Time Payment
BUY NOW

Premium

$99

($299 bundle savings)

  • 100+ Customizable Excel Templates
  • Excel, PowerPoint & Word 101 Courses ($199 bundle savings)
  • One User
  • One-Time Payment
BUY NOW