Scatter plots are a type of chart that plot points on a grid based on x and

y values.

For example, let's take a look at a sample set of data

with different people's heights and weights.

We can create a scatter plot by selecting the two columns of values we want to plot,

in this case, columns B for height and C for weight.

Let's select those columns.

Gotta hold down SHIFT + CTRL and then go, down arrow.

We've selected the entire data series that we want to plot.

Next I'm gonna use my keyboard shortcuts ALT + N for insert.

Then the scatter plot over here is D.

Scatter, and it's entered up here at the top of the screen.

Sometimes if you have a lot of data in your spreadsheet and

you create a chart, the chart will get inserted off of screen.

So you kind of have to go around and find it.

One tip is to zoom out, so you can go down here and zoom out and

you'll be able to see it right away if you're on a huge sheet.

Let's go back to our normal view.

All right, so looking at the output,

we can see that there does seem to be a correlation between height and weight.

Sort of a linear relationship there.

That's the most common use for scatter plots, identifying correlations in data.

We can actually use a function to determine if there is a correlation.

You should be familiar with spreadsheet functions already.

If you didn't take the prerequisites for

this course, I'd recommend you do that now.

I've added a link to the prerequisite content in the teacher's notes.

If you need a refresher,

I've also linked to the stage where we specifically cover functions.

Why don't you try and figure out how to calculate the correlation of height and

weight in this data set.

And in the next video, I'll show you how to do it.