00:01
So in this problem, we're going to be looking at how outliers impact the scatter plot.
00:06
I'm going to be doing this in excel.
00:08
However, if you need to do this in a graphing calculator, i will include the steps for that at the end.
00:15
So first, we're going to be making a scatter plot of the data.
00:19
I'm going to do free because later on in the problem, we're going to need to separate the data into these three sections.
00:30
Right so here's the data set in excel i just highlight two columns go to insert and then over here are the scatter plots so this is going to be the one of all of them the next one we want is without number 15 so to do that i'm going to highlight all of them and hold control on mac it might be different maybe command and then click on the two i want to get rid of so then same thing again, insert a new scatter plot, and i'll retitle this one without 15.
01:14
So now i'm going to make one without 18, and i'll title this one accordingly.
01:36
Okay, next, we need to find the correlation for all three categories, and then i'm going to do the first part of part c at the same time.
01:46
We're going to make the regression line for all three categories.
01:51
Now, doing this in excel, we can just click on the graph.
01:55
Hit this plus button, check the trendline box, and go to more options.
02:01
And from there, we'll put display equation on charts and display r squared on charts.
02:08
And i'll move those up here.
02:11
So i'm just going to go and do that with the other two now.
02:16
Add trendline equation and r2.
02:20
Squared value if these are too small to see i'll write them down at the end again so don't worry if you can't see them trend align more options equation and r squared now don't just copy these down this is r squared we don't want r squared we want r the reason why r squared is called r squared is because it's literally just r squared so to get r all we have to do is take the square root of r squared so i'm going to go back into a problem and i'll write down what we have so far so our first equation i'll put these in order r is equal to 0 .482 and y is equal to 10 .408x plus 66 .429.
03:32
So about 15, we get r is equal to 0 .568 and y is equal to 8 .9 and y is equal to 8 .9204x.
03:47
Plus 69 .487.
03:51
And then about 18, we get r is equal to 0 .533, and y is equal to 12 .194x plus 53 .913...