• Home
  • Tools
    • PPC Signal
    • PPCexpo Keyword Planner
    • PPC Audit
    • ChartExpoTM PPC Charts
    • PPCexpo PPC Reports
    • Combinations Calculator
  • Pricing
  • Contact us
  • Resources
    • PPC Signal Dashboard
    • PPC Reports Templates
    • PPC Guide
    • Join Our Facebook Group
    • Charts
      • CSAT Score Survey Chart
      • Likert Scale Chart
      • Pareto Chart
      • Sankey Diagram
  • Blog
Categories
All Digital Marketing PPC SEO SMM Data Visualization
All Digital Marketing PPC SEO SMM Data Visualization

We use cookies

This website uses cookies to provide better user experience and user's session management.
By continuing visiting this website you consent the use of these cookies.

Ok
Home > Blog > Digital Marketing > Data Visualization >

5 Scatter Plot Examples to Get You Started with Data Visualization

You’ll agree when we say understanding the fundamental relationship between key metrics in data is critical to the growth of a business.

Why?

The key to solving a problem is identifying its root cause. And this implies digging deeper to uncover the causal factors and their relationship to the problem you’re trying to alleviate.

scatter plot examples

This is where Scatter Plot comes in.

Scatter Plots are best suited to visualize data for causal relationship insights. Visualizing data using this insightful and easy-to-interpret chart should not stress you or even consume your valuable time, especially if you’re an ardent user of Google Sheets.

Yes, you read that right.

Google Sheets comes with pretty basic Scatter Plot templates, which require a ton of customizations to align with your data story.

It turns out you don’t have to do away with this freemium data visualization tool (Google Sheets). You can supercharge it with third-party apps (add-ons) to access highly intuitive and easy-to-interpret Scatter Plot examples.

This blog will walk you through the easy-to-follow steps to get started with this visualization. You’ll come across a ton of Scatter Plot examples to get you started with data storytelling quickly. In this blog you will learn:

  • What is Scatter Plot?
  • Uses of Scatter Chart
  • Video Tutorial: How to Create Scatter Plot in Few Clicks?
  • Top 5 Scatter Plot Examples and How to Create them? Step by Step Guide with Scatter Plot Data
  • Different Types of Scatter Plot
  • Scatter Plot Real-World Applications
  • Pros and Cons of Using a Scatter Plot
  • Type of Data You Can Visualize using Scatter Plot

You don’t want to miss the rest of the blog if your goal is to elevate your Google Sheets game to the A-level.

Before we cover the Scatter Plot examples we promised, let’s go through the definition part.

What is Scatter Plot?

A Scatter Chart (also called a Scatter Plot, Scatter Graph, or Scatter Diagram) is a visualization design that uses Cartesian coordinates to display values in dots.

Besides, this chart distills key insights into the collection of points, along x and y-axes.

So when should you use this chart?

Uses of Scatter Chart:

Use a Scatter Plot to compare two key variables in your data to determine their relationship. For instance, you can use this chart to track the relationship between click-through rate and conversion metrics in digital marketing.

In this scenario, you would want to know whether the growth of click-through rate (CTR) impacts conversion value.

Essentially, you can use Scatter Plot examples to determine relationships or associations between key data points.

The actual analysis comes in when you discern the type of relationship existing between key metrics you’re tracking closely.  You can use Scatter Diagrams to uncover hidden “cause-and-effect” relationships between two key variables in your data.

Below are the scenarios you can apply Scatter Plot examples to get the maximum from your raw data.

  • There’re pairs of variables in data.
  • Dependent variables have multiple values for each figure associated with the independent variable.
  • There are signs of a relationship between two variables in data.

How to Create Scatter Plot in Few Clicks? Complete Video Guide

scatter plot examplesscatter plot examples

Top 5 Scatter Plot Examples and How to Create them? Step by Step Guide with Scatter Plot Data

This section is loaded with a ton of Scatter Plot examples to get you started with this visualization faster.

As we said earlier, freemium data visualization tools like Google Sheets come with pretty basic Scatter Plot examples. You need to rework these charts, which means additional time spent.

If you feel you’ve outgrown the basic charts offered by Google Sheets and you’re on the hunt for hidden insights: try ChartExpo.

ChartExpo is an add-on you can install in Google Sheets and Excel to access advanced Charts, such as Scatter Plot.

ChartExpo produces charts that are incredibly easy to interpret. Besides, it comes loaded with 50-plus advanced charts you’ll never find freemium data visualization tools, such as Excel and Google Sheets. If you want to create Scatter plot in excel you can refer to our guide How to Make a Scatter Plot in Excel.

You don’t need to learn programming or coding to use ChartExpo.

In the next section, you’ll come across 5 Scatter Plot examples created using Scatter Plot Generator.

Example 1

Imagine you want to analyze the height, weight, and age of school-going children in your neighborhood. Let’s assume the data below is what you collected.

Age Height Weight in kg Weight Legend
3 2.3 6 Weight
4 2.4 9 Weight
5 2.5 10 Weight
6 3 8 Weight
7 3.2 7 Weight
8 2.9 9 Weight
9 4 12 Weight
10 4.5 15 Weight
11 4.3 18 Weight
12 3.8 22 Weight
13 5 19 Weight
14 5.7 20 Weight

To visualize the data below with ChartExpo’s Scatter Plot, follow the easy steps below:

  • Open your Google Sheets desktop application.
  • Open the worksheet and click the Add-ons menu button.
  • Once the ChartExpo-Best Data Visualization Tool drop-down menu shows, click the Open button.
scatter plot examples
  • Click the Create New Chart button.
scatter plot examples
  • You’ll see six main categories of spreadsheet charts.
scatter plot examples
  • Click the PPC Charts tab to access Scatter Plot, as shown above. Copy data from above table and paste in sheet.
scatter plot examples
  • Fill in your metrics and dimensions. In our example, we have two metrics, namely age and height. The dimensional variable to fill in is Weight in Kg and weight in legend.
  • The resulting chart should look like the one below.
scatter plot examples
scatter plot examplesscatter plot examples

Insights

There’s a positive correlation between height and age of the children. In other words, the height rises with the age of the children. Moreover few are below the average and few above the average line.

Example 2

Imagine you want to investigate whether there’s a relationship between the number of students and the marks scored.

Let’s assume the data below is what you collected.

No of students Marks Obtained Percentage Of Students
5 40 2.5
6 60 3
25 70 12.5
11 65 5.5
30 80 15
4 50 2
6 55 3
10 75 5
14 90 7
18 45 9
20 40 10
22 95 11
2 100 1
11 35 5.5
16 25 8

To visualize the data above with ChartExpo’s Scatter Plot, follow the easy steps below:

  • Copy the table above into Google Sheets.
  • Open your Google Sheets desktop application.
  • Open the worksheet and click the Add-ons menu button.
  • Once the ChartExpo-Best Data Visualization Tool drop-down menu shows, click the Open button.
  • Follow the exact instructions we used in Example #1
scatter plot examples
  • After filling in your metrics and dimensional variables and clicking the Create Chart button, your final chart should look like this (below).
scatter plot examples

Insights

  • 7 students have above-average
  • 8 students have below-average
  • There’s no correlation between the number of students and marks. The dots are scatted all over in the Scatter Plot example above.
  • The size of the dot represents what is the percentage of students remained, who obtained the particular marks. Larger the dot, the larger the percentage of students who got such marks. E.g 15% of the total students got 80 marks while only 1% got 100 marks.

Example 3

Imagine you want to determine the relationship between the outdoor temperature and the cricket chirps Besides, you have gathered enough data(hypothetical data) samples for visualization.

Let’s visualize the data below using Scatter Plot examples.

Temperature (Fahrenheit) Number of Chirps (in 15 Seconds) Total Cricket
57 18 2
28 20 5
64 21 10
65 23 15
68 27 6
71 30 8
74 34 10
77 39 15
20 10 10
24 8 8
25 7 7
58 5 2
71 2 10
74 14 5
77 30 7
20 34 8
24 26 3
25 16 4
58 8 2
71 12 1

To visualize the data above with ChartExpo’s Scatter Plot examples, follow the easy steps below:

  • Copy the table above into Google Sheets.
  • Open the worksheet and click the Add-ons menu button.
  • Once the ChartExpo-Best Data Visualization Tool drop-down menu shows, click the Open button.
  • Follow the exact instructions we used in Examples #1 and #2
scatter plot examples
  • Fill in your metrics and dimensional variables and click the Create Chart button. Your final chart should look like this (below).
scatter plot examples
scatter plot examplesscatter plot examples

Insights

It’s incredibly easy to interpret the Scatter Plot example above. The x-axis represents the number of chirps. On the other hand, the y-axis represents the temperature. Size of the Dot represent no. of Chirps

Example 4

Let’s suppose you’re a retail store owner and you want to assess the relationship between cost, number of orders, and profits. Let’s assume the table below represents your data.

Products Type Products Profit cost no. of orders
Cosmetic Face Primer 15.79 90 10
Cosmetic Foundation 20.13 70 12
Cosmetic Concealer 38.62 190 9
Cosmetic Blush 34.62 880 16
Cosmetic Highlighter 71.84 900 22
Cosmetic Bronzer 71.84 600 23
Cosmetic Powder 32.77 600 42
Cosmetic Eye Primer 21.8 1300 19
Electronics TVs 110 590 28
Electronics refrigerators 12.61 390 11
Electronics washing machines 70.21 490 41
Electronics air conditioners 70.21 390 18
Electronics printers 68.83 260 17
Electronics speakers 17.55 210 2
Electronics keyboards 54.74 170 23
Electronics e-readers 12.66 170 13
Garments mobile phones 47.36 140 27
Garments Sweater 83.64 110 13
Garments Hoodies 83.64 110 12
Garments T-shirts 22 760 6
Garments Jeans 75 1500 7
Garments sweatshirts 11.75 1000 19
Garments formal trousers 98 150 10
Garments polo shirts 27.77 380 14

To visualize the data above with ChartExpo’s Scatter Plot examples, use the steps below:

  • Copy the table above into Google Sheets.
  • Follow the exact instructions we used in Examples #1 and #2.
scatter plot examples
  • Fill in your metrics and dimensional variables (as shown above) and click the Create Chart button.
  • Check out the final Scatter Plot Chart (below).
scatter plot examples

Insights

  • All the products that are above the average profit line are the most profitable.
  • All the products on the right side of the average cost line are bleeding the business of its profits.
  • Size of Dot is showing no. of orders.
  • There’s no correlation between profits and costs. The dots are all over the place with no identifiable trend.

Example 5

Imagine you want to know whether there’s a correlation between age and the performance of employees in different departments in an organization. Let’s assume the data below is what you collected, and you intend to analyze for insights.

Size of the dot in the below table showing the attendance (0.1 for min 1 for max)

Department Age Performance score Name Size of dot
Research and development 24 20 Timothy 0.5
Research and development 26 30 Richard 0.5
Research and development 29 25 Michael 0.5
Research and development 23 27 Paul 0.4
Research and development 30 28 Bowles 0.4
Research and development 32 36 Christopher 0.6
Research and development 45 34 David 0.5
Research and development 27 42 Joseph 0.5
Research and development 26 43 Patrick 0.4
Research and development 40 47 Pryor 0.5
Accounts and Finance 60 28 Johnson 0.4
Accounts and Finance 55 60 Colbert 0.5
Accounts and Finance 45 65 Bowman 0.4
Accounts and Finance 50 50 Francis 0.4
Accounts and Finance 42 55 Collins 0.5
Accounts and Finance 30 58 Jonathan 0.7
Accounts and Finance 60 56 Eric 0.6
Accounts and Finance 29 53 Pruden 0.6
Accounts and Finance 30 24 Thompson 0.6
Accounts and Finance 40 59 Frank 0.6
Sales and marketing 22 63 Jerome 0.7
Sales and marketing 28 70 Ronald 0.6
Sales and marketing 30 75 Walker 0.5
Sales and marketing 44 86 Guerrier 0.6
Sales and marketing 33 90 Carlson 0.7
Sales and marketing 24 95 Petersen 0.6
Sales and marketing 29 97 Boyle 0.6
Sales and marketing 31 99 Rendon 0.6
Sales and marketing 44 100 Gomez 0.6
Sales and marketing 27 43 Winship 0.7

To visualize the data above with ChartExpo’s Scatter Plot examples, use the steps below:

  • Copy the table above into Google Sheets.
  • Follow the exact instructions we used in Scatter Plot Examples #1 and #2

scatter plot examples

  • Fill in your metrics and dimensional variables (as shown above) and click the Create Chart button.
scatter plot examples
scatter plot examplesscatter plot examples

Different Types of Scatter Plot

Scatter Charts come in different variants based on the following factors:

  • Correlation
  • Slope type

Scatter Charts are divided into 3 types, based on correlation:

  • Strong Correlation

scatter plot examples

In this Scatter Plot example, the data is plotted in dots, keeping the dependent and independent variables in the y and x-axes, respectively.

As shown (above), all the markers or data dots are closely arranged linearly so a trend line can be plotted. And, this means there’s a strong correlation between key data points.

Therefore, the diagram above qualifies to be called a Scatter Diagram with a high degree of correlation.

  • Scatter Chart with Moderate Correlation

scatter plot examples

In the diagram above, the data points are arranged somewhat closer to each other.

Essentially, there’re not fully linear, which means you cannot draw a straight line through them. However, as you observe closely, you’ll notice there’s a less significant relationship between the variables.

This chart is also known as Scatter Diagram with a low degree of correlation.

  • Scatter chart with No correlation

scatter plot examples

In this Scatter Plot example, data points are scattered all over the place. Besides, it’s not easy to decode relationships between data points.

This data visualization design qualifies to be called a Scatter Diagram with no degree of correlation.

Keep reading because, in the coming section, we’ll take you through a ton of Scatter Plot examples to simplify everything.

Scatter Plot Real-World Application

  • Displaying hidden relationship between two variables

Scatter Charts are widely used to display the relationships between two variables.

The relationships you can uncover using this visualization design are categorized as:

  • Positive or negative
  • Non-linear or linear
  • Strong or weak

The dots, which appear on Scatter Plot examples, represent the individual values of each of the critical data points. More so, they allow you to extract trend insights from data faster.

  • Identification of Correlational Relationships

You can use this insightful chart to uncover hidden correlational relationships that exist in your raw business data.

Interpreting Scatter Plot examples is incredibly easy.

The key to interpreting this chart is always to remember the independent variables (metrics) sit on the horizontal axis (x-axis). And, the dependent variables are situated on the vertical axis (y-axis) in a Cartesian plane.

  • Identification of Data Patterns

Use a Scatter Plot to identify the general trend of your critical variables in your raw data.

Data points in this chart are grouped based on how close their values are, which makes it easier to identify outliers. You don’t want to base your business decisions on outliers because they are outright misleading.

Interestingly, the nature of the correlations can also be estimated based on a specified confidence level.

  • Positive correlation depicts an uptrend. Essentially, in a Scatter Plot with a positive correlation, data points slope upwards from the lower-left corner of the chart towards the upper-right.
  • A negative correlation depicts a downtrend. Key data points slope downwards from the upper-left corner of the chart towards the lower-right.
  • Data points that are neither positively nor negatively correlated are considered uncorrelated (null).

What are the Pros and Cons of Using a Scatter Plot?

Each chart and graph you use to visualize raw data has its strengths and weaknesses. A Scatter Chart is not an exception. Let’s go through its advantages:

  • Scatter charts are incredibly crucial, especially if your goal is to display correlational insights.
  • You can use this chart to display the correlation between critical metrics in your data.
  • Data visualization experts consider a Scatter Plot an apt visualization design to show the non-linear relationship in data.
  • Scatter Plots are amazingly easy to read, even for non-technical audiences.
  • The range of flow of data in Scatter Plot examples is readily visible. And this means you can point out the maximum and minimum points in your data at a snap of the fingers.
  • Many people think that scatter plot and line graph are similar but when you compare scatter plot vs. line graph you can find out both charts are different in tasks.

There are some weaknesses associated with a Scatter Plot Chart you have to keep in mind. Let’s check them out.

  • You cannot use this chart to display the correlation of more than two key variables.
  • Only data you can numerically compare is best visualized using a Scatter Plot.
  • Although Scatter Diagram uncovers hidden relationships in data, avoid assuming a particular variable is the causal agent of the problem you’re trying to solve.

We recommend you dig deeper to find more insights to confirm what a Scatter Plot is displaying.

Remember, if the diagram shows no relationship; investigate whether the independent (x-axis) variable has been varied widely. Why?

Sometimes a relationship is not apparent because the data sample you’re using is smaller.

What Type of Data Can you Visualize using Scatter Plot Examples?

You can use both continuous and discrete data types with Scatter Plot charts. Why?

Continuous data makes it easier for you to measure trends and relationships between data. You can choose to use discrete data on one axis and continuous data on the other axis of a Scatter Chart.

For example: for the discrete data, you’d have to put it into some kind of quantified band, like let’s say 1-10 on a customer satisfaction score.

FAQs:

What is a Scatter Plot?

A Scatter Plot is a chart you can use to uncover hidden relationships between key variables, such as metrics you’re tracking in your data.

Data points in a Scatter Plot can have the following type of relationships, namely:

  • Linear or non-linear
  • Positive or negative
  • No correlation

What is the main purpose of a scatter plot?

The Scatter Plot has two primary uses, namely, showing trends and relationships between key data points. Besides, dots in this chart can report the values of individual data points and the general trends and patterns that exist in data.

Use Scatter Plot examples to establish causal-effect relationships, especially when solving problems.

How can you create Scatter Plot in Google Sheets?

Google Sheets produces Scatter Charts that are very basic. Besides, the charts produced (by Google Sheets) require a lot of customization to align with your data stories.

The solution is to install third-party applications, such as ChartExpo, in your Google Sheets to access advanced and intuitive Scatter Plot templates.

Wrap Up

Visualizing your data to extract trends and relationship insights should never stress you or even consume significant amounts of your valuable time.

Use a Scatter Plot because it’s designed primarily to display hidden relationships between variables. Besides, the dots or data point markers can easily show you the general trend of the variables.

Google Sheets has a Scatter Plot template that’s basic and less intuitive. The solution is not to do away with Google Sheets but take full advantage of add-ons, such as ChartExpo.

ChartExpo comes loaded with 50-plus advanced charts, including Scatter Plot examples. You don’t need coding or programming skills to visualize your data using ChartExpo’s expansive chart library. More so you can easily export your chart in PNG and JPEG, the world’s most recognized formats.

Sign up for ChartExpo’s 7-day FREE trial today to access intuitive and easy-to-interpret Scatter Plots for your data stories.

How much did you enjoy this article?

We will help your ad reach the right person, at the right time

PPC Signal

Your Data. Your Insights.

Actionable insights discovered for you. Now you can do more in less time.

PPCexpo Keyword Planner

Find the Perfect Keyword. Surprise Yourself.

PPCexpo Keyword Planner will help you align your keywords with the customers’ intent.

PPC Audit

Free Google Ads Audit Report.

Frequent audits will help you optimize your PPC campaign for success.

ChartExpo PPC Charts

Picture a Thousand Numbers. See the Big Picture.

Visualizations give you the ability to instantly grasp the insights hidden in your numbers.

PPCexpo PPC Reports

Simple and Easy PPC Reporting. For Everyone.

Experience the new revolution in reporting … click your way to insights, don’t scroll.

Combinations Calculator

Do the Math.

Calculate the number of combinations in your PPC campaign. It may surprise you.

Insightful pay-per-click tips and tricks, delivered to your inbox weekly.

CTR Survey

ppc signal ad
chartexpo ad
ppc audit ad
keyword planner ad
111522

Related articles

next previous
Data Visualization11 min read

Top 5 Types of Business Charts You Must Try

Click to discover the top 5 types of business charts you must try to present your data well.

ChartExpo10 min read

Top 10 Creative Data Visualization Examples You Must Know

Click to learn the top 10 creative data visualization examples. Also, we’ll address the following question: What is data visualization, and why is it important?

Data Visualization10 min read

How to Get Started With a Sales Dashboard in Google Sheets?

Click to learn how to get started with sales dashboard in Google Sheets. Also, we’ll address the following question: what is a sales dashboard?

Data Visualization10 min read

How to Use a Word Cloud Generator for Keyword Analysis?

Click to learn how to use a Word Cloud generator for keyword analysis. We’ll also address the following question: What are word clouds?

Data Visualization4 min read

The Tested and Proven Month-to-Month Comparison Excel Chart

Click to learn the tested and proven month-to-month comparison Excel chart. Also, we’ll address: what is a comparison chart, and why do we use it?

PPCexpo

  • Home
  • Tools
  • Pricing
  • Contact us
  • PPC Guide
  • Blog
  • Sitemap
  • © 2022 PPCexpo, all rights reserved.

Company

  • Contact us
  • Privacy policy
  • Security
  • Patent

Tools

  • PPC Signal
  • PPCexpo Keyword Planner
  • PPC Audit
  • ChartExpo™ PPC Charts
  • PPCexpo PPC Reports
  • Combinations Calculator

Quick Links

  • PPC Guide
  • PPC Signal Dashboard
  • PPC Reports Templates
  • ChartExpo™ for Google Sheets
  • ChartExpo™ for Microsoft Excel
  • PPCexpo Keyword Planner Google Chrome Extension

Charts

  • CSAT Score Survey Chart
  • Likert Scale Chart
  • Pareto Chart
  • Sankey Diagram

Category

  • PPC
  • SEM
  • SEO
  • SMM
  • Data Visualization
  • Others
Join our group

Benefits

  • Q&A on PPC advertising
  • Get expert advice
  • Great PPC discussions
  • Stay updated with PPC news
  • Quick support on tools
  • Discounts and special offers