But it is you can find the features, the functionality, the button, names won't change. Again, compare the difference here. The point is this one, you'd be able to see it. It's about twenty. And it's not just sort of guessing. So it gives you all the same information and sometimes just depending on the tool you're working with, you might want one or the other one. Also, we have the normality plot of residuals (which is used to assess the normality of errors) and the residuals versus predicted value plot, which is used to assess the assumption of homoskedasticity of error. So you can always find out how to do this. And we get a bunch of options appear on the top, and you can see we have a nice scatter here. And they could monitor when the marketing campaign is sort of reaching its peak, or ready to start a new campaign. But I just want to show you how to do scatter plot, how to get the equation, how to get r squared and how to find r using Excel. Graphing Features. And we're right underneath where it said display the equation on the chart, we can display the r squared value on the chart. It's not as nice a pattern as we saw before. So let's do it again. Popular Baby Names by Surname; Unit Conversions; Biology; Geometry, Trigonometry; Physics; Chemistry; Mathmatics; And once you start typing these in, it'll find it's immediate right? Explore math with our beautiful, free online graphing calculator. I wanted it to find for me an equation of a line that fits the data. So I'll put this guy aside, move this over here, and let's do another one for newspaper and sales. There's a few ways to grab it. And so let me just show you how to. The closer that we are to one, the better the linear correlation is, the stronger you can feel about your prediction. Clearly, there's a stronger linear correlation between TV and sales versus newspaper sales. I won't close this spreadsheet so you can play around with it. Just from a general visual standpoint, the data points seem to be going up into the right. Regressions are now supported! So if you put some money towards a newspaper ad, you will get a positive increase in sales. Have fun, make some pretty charts and interpret your numbers correctly. So I'm going to turn off radio and newspaper and we're just going to work with the first and last column. It's like I don't know what that means. The way you do that is always hold Ctrl+Down and highlight these things. It doesn't carry over the header, so it doesn't call sales and TV but so you have to remember what they were. If I stub for you 0.0473566 it finds B Your intercept. And our second one here, you get to practice writing sideways, this is Sales. supports HTML5 video. And you can play around radio as well, or you can start mixing, matching and making some different graphs. It doesn't, if you give the word sales, so if you come in here and type sales, it'll break, just like I'll show you. And the key here is if you put equals it doesn't know what's going on. Because Excel assumes since you're clicking outside of the chart, you're done working on the chart. Scatter Plot Maker. If you want to show all the rows, you put the show all and it also uses variables for your names. But the variance, the change in y, the spread of y is from r squared. Sometimes the data, it matches what your intuition would say and sometimes it doesn't, so it's best to go through these. And r squared for TV sales was 0.6. The square root is SqrT, squirt. The r value is also similar but it's less, right, so this is 0.05, this is the difference here. But when you highlight the leftmost, it becomes your x axis and the rightmost becomes your y axis. Here's the R value 0.8 versus 0.2. Can someone help me figure out how to make a similar table of values like this for polar coordinates of the form (r, theta)? All right, so let's start with everything. So we have our scatter plot. Great job on this video, I'll see you next time.