.. Copyright (C)  Google, Runestone Interactive LLC
    This work is licensed under the Creative Commons Attribution-ShareAlike 4.0
    International License. To view a copy of this license, visit
    http://creativecommons.org/licenses/by-sa/4.0/.

Creating a Scatter Plot in Sheets 
=================================

In this section, you will learn how to make a scatter plot in Sheets. You will 
work with the temperature data. Latitude will be the explanatory variable, and
July mean temperature will be the explained variable. 



How to make a scatter plot
--------------------------

First, copy over the city, state, latitude and July mean temperature columns 
from the weather data here_ into a new sheet.

.. image:: figures/create_a_scatter_copy_data.png
   :alt: A screenshot of a Sheet with the weather data's city, state, latitude, and July.
   :align: center 

Afterwards, select the two columns containing the latitude and mean temperature
data then click “Insert > Charts.”

.. image:: figures/create_a_scatter_insert_chart.png
   :alt: A screenshot of how to insert a chart. 
   :align: center 


Then in the chart editor click “Setup > Chart type > Scatter.”

.. image:: figures/create_a_scatter_plot_choose_scatter.png
   :alt: A scrrenshot of how to customize a chart to be a scatter chart. 
   :align: center 


Sometimes Sheets will correctly assign the columns to be either the explanatory
variable or the explained variable, but it is always good to know how to 
manually assign them. 

Go to “Chart Editor > X-axis > Edit ” to choose which column of data will be 
the explanatory variable. 

.. image:: figures/create_a_scatter_xaxis1.png
   :alt: A screenshot of how to choose the independent variable data. 
   :align: center 

Then put in the range of cells where you put the latitude data (the explanatory
variable). 

.. image:: figures/create_a_scatter_xaxis2.png
   :alt: A screenshot of how to specify the cell range of the independent variable. 
   :align: center 


To choose which column of data will be the explained variable, you will go 
through a similar process. Go to “Chart Editor > Series > Edit.”

.. image:: figures/create_a_scatter_yaxis1.png 
   :alt: A screenshot of how to choose the dependent variable data. 
   :align: center 


Then put in the range of cells where you put the weather data (the explained 
variable). 

.. image:: figures/create_a_scatter_yaxis2.png
   :alt: A screenshot of how to specify the cell range of the dependent variable.
   :align: center 


To add a title, go to “Chart Editor > Customize > Title.”

.. image:: figures/create_a_scatter_title.png
   :alt: A screenshot of how to change a chart's title. 
   :align: center 

To choose the horizontal and vertical axis labels, go to 
“Chart Editor > Customize > Chart & axis title.”

.. image:: figures/create_a_scatter_axistitle1.png  
   :alt: A screenshot of how to change the axis titles. 
   :align: center 


Then select “Horizontal axis title” and “Vertical axis title” respectively to 
add a descriptive horizontal axis label and a descriptive vertical axis label.

.. image:: figures/create_a_scatter_horizontal_label.png
   :alt: A screenshot of how to change the horizontal axis title. 
   :align: center 

.. image:: figures/create_a_scatter_vertical_label.png 
   :alt: A screenshot of how to change the vertical axis title. 
   :align: center 

You now have a scatter plot for latitude versus July mean temperature. Using 
the scatter plot, answer the questions below. 

.. fillintheblank:: furthest_right_city

   What city represents the point furthest to the right on the scatter plot? |blank|

   - :Seattle: Correct
     :x: Incorrect


.. fillintheblank:: furthest_left_city

   What city represents the point closest to the y-axis on the scatter plot? |blank|

   - :Miami-Hialeah: Correct
     :x: Incorrect
     
.. _here: https://docs.google.com/spreadsheets/d/17QUmVsFJGSSXI03XVO6pW6iXwJEY2YR8m-_tLqRHKLM/edit?usp=sharing