Scatter plots in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a scatter plot used for in Google Sheets?

A scatter plot shows the relationship between two sets of numbers by plotting points on a grid. It helps you see if one number changes when the other changes.

beginner

How do you create a scatter plot in Google Sheets?

Select your two columns of data, then click Insert > Chart. In the Chart Editor, choose 'Scatter chart' as the chart type.

beginner

What do the X and Y axes represent in a scatter plot?

The X axis shows the first set of numbers (independent variable), and the Y axis shows the second set (dependent variable). Each point shows one pair of values.

intermediate

How can you add a trendline to a scatter plot in Google Sheets?

In the Chart Editor, go to the 'Customize' tab, open 'Series', then check 'Trendline' to add a line that shows the general direction of the data points.

intermediate

Why is it helpful to use a scatter plot instead of a bar chart?

Scatter plots show how two numbers relate to each other, not just their size. Bar charts compare sizes but don’t show relationships or patterns between pairs of numbers.

What type of data do you need to create a scatter plot?

A Two sets of related numbers

B Only one list of numbers

C Text labels only

D Dates and times only

Scatter plots require two sets of numbers to plot points showing their relationship.

Where do you select the scatter plot chart type in Google Sheets?

A Data > Sort range

B Insert > Chart, then Chart Editor > Setup > Chart type

C Format > Number

D Tools > Script editor

You create a scatter plot by inserting a chart and choosing 'Scatter chart' in the Chart Editor's Setup tab.

What does a trendline in a scatter plot show?

A The general direction or pattern of the data points

B The average value of all points

C The exact value of each point

D The total sum of all data

A trendline helps visualize the overall pattern or direction in the data points.

If your data points form a straight line going up, what does that mean?

A No relationship between the numbers

B As one number increases, the other decreases

C As one number increases, the other also increases

D The data is random

A rising straight line means both numbers increase together, showing a positive relationship.

Which axis usually shows the independent variable in a scatter plot?

A Neither axis

B Y axis

C Both axes

D X axis

The X axis usually shows the independent variable, the one you control or choose.

Explain how to create and customize a scatter plot in Google Sheets.

Think about the steps from selecting data to adding a trendline.

Describe what information a scatter plot can show and why it is useful.

Focus on what the dots represent and what you learn from them.

Practice

1. What does a scatter plot primarily show in Google Sheets?

easy

A. The relationship between two sets of numbers

B. The total sum of a data column

C. The average value of a dataset

D. The frequency of a single number

Solution

1. Step 1: Understand scatter plot purpose

   A scatter plot displays points representing pairs of values from two data sets.

2. Step 2: Identify what it shows

   It shows how two variables relate or if there's a pattern between them.

3. Final Answer:

   The relationship between two sets of numbers -> Option A

4. Quick Check:

   Scatter plot = relationship between two data sets [OK]

Hint: Scatter plots compare two data sets visually [OK]

Common Mistakes:

• Thinking it shows totals or averages
• Confusing with bar or pie charts
• Assuming it shows frequency counts

2. Which menu option do you use in Google Sheets to insert a scatter plot?

easy

A. Tools > Script editor

B. Data > Pivot table

C. Format > Conditional formatting

D. Insert > Chart

Solution

1. Step 1: Locate chart insertion

   Scatter plots are created by inserting a chart from the Insert menu.

2. Step 2: Choose correct menu path

   Insert > Chart opens chart options including scatter plot type.

3. Final Answer:

   Insert > Chart -> Option D

4. Quick Check:

   Insert menu > Chart for scatter plots [OK]

Hint: Insert menu always has chart options [OK]

Common Mistakes:

• Choosing Data or Format menus instead
• Looking for scatter plot outside Insert menu
• Confusing with script editor tools

3. Given data in columns A and B, what will the scatter plot show if column A has values 1, 2, 3 and column B has values 2, 4, 6?

medium

A. A horizontal line at value 3

B. Points forming a straight line showing a doubling pattern

C. Random scattered points with no pattern

D. A vertical line at value 2

Solution

1. Step 1: Analyze data pairs

   Pairs are (1,2), (2,4), (3,6) showing B is double A.

2. Step 2: Understand scatter plot pattern

   Points will align on a straight line with slope 2, showing doubling.

3. Final Answer:

   Points forming a straight line showing a doubling pattern -> Option B

4. Quick Check:

   Scatter plot shows linear doubling pattern [OK]

Hint: Look for simple numeric relationships in pairs [OK]

Common Mistakes:

• Assuming points are random
• Confusing line directions
• Thinking it forms horizontal or vertical lines

4. You created a scatter plot but it shows all points in a straight vertical line. What is the most likely cause?

medium

A. Y data column has identical values, X varies

B. Both X and Y data columns have the same values

C. X data column has identical values, Y varies

D. Data contains text instead of numbers

Solution

1. Step 1: Understand vertical line in scatter plot

   A vertical line means all X values are the same, Y values differ.

2. Step 2: Identify cause from options

   X data column has identical values, Y varies states X data identical, Y varies, matching the vertical line cause.

3. Final Answer:

   X data column has identical values, Y varies -> Option C

4. Quick Check:

   Vertical line = same X values [OK]

Hint: Vertical line means X values don't change [OK]

Common Mistakes:

• Thinking identical Y values cause vertical line
• Assuming text data causes vertical line
• Confusing vertical with horizontal line causes

5. You want to compare sales and advertising spend for 12 months using a scatter plot in Google Sheets. Which steps correctly create this scatter plot?

hard

A. Select sales and advertising columns, then Insert > Chart, choose Scatter chart type

B. Select sales column only, then Insert > Chart, choose Scatter chart type

C. Select advertising column only, then Insert > Chart, choose Line chart type

D. Select sales and advertising columns, then Insert > Chart, choose Pie chart type

Solution

1. Step 1: Select both data columns

   Scatter plots need two sets of data to compare, so select sales and advertising columns.

2. Step 2: Insert scatter chart

   Go to Insert > Chart and choose Scatter chart type to plot the relationship.

3. Final Answer:

   Select sales and advertising columns, then Insert > Chart, choose Scatter chart type -> Option A

4. Quick Check:

   Select two columns + Scatter chart = correct plot [OK]

Hint: Always select both data sets before inserting scatter chart [OK]

Common Mistakes:

• Selecting only one column
• Choosing wrong chart type like pie or line
• Not selecting data before inserting chart