Chris

VIsit Chris's website

Scatter plots are used to see the trend of the data set as a whole instead of the sequential pattern of the data.

1. Start by creating a two-column table that contains the data for the graph. The first column will be the X-axis and the second will be the Y-axis. The rows do not have to be in any particular order because the scatter plot trendline finds the relationship between the X and Y values.




Notice that the data does not have to be numerically increasing.

2. Next, Select the entire table and click Insert -> Scatter -> Scatter with only markers
   You should end up with a graph similar to this:
   This is the basic scatter plot. We have many more options past this point.



3. If you double-click on the graph, the chart design tools open and provide design options for the graph.



4. Each option organizes the graph differently. Also, the chart tittle and the axises labels can be changed by clicking on the current labels. These objects can also be deleted by clicking on them to select and the Delete key to delete.

   

5. To add a trendline, right click on any point of the graph and select “add Trendline…”
6. A new option menu will appear with choices for the trendline. These choices include the type of trend, line color and style, and equation displays. Some important features to look for in this menu are the “Display Equation on chart” and the “Display R-squared value on chart” options. The “Display Equation on chart” option toggles the equation that Excel used to draw trendline. This is written in standard form. The “Display R-squared value on chart” option displays the accuarcy of the trendline.