this video is going to walk you through the process of making a graph in Excel uh that would represent density so we're going to need to plot these points and determine the slope of a line through these points or the best fit line for these points so what do we do well I got the data from lab and it's all right here I've got volume in this column I have mass in this column and what I want to do is make a plot so I'm going to highlight these and go over here to insert and click on the part right here where it says Scatter Plots and I want this kind of scatter plot right here with just these points and what I can see is I've got my uh volume on this axis my x- Axis and I've got Mass here on my y AIS so that's good what I'm going to do is um well first I want to label these axes like teachers love that stuff right so I'm going to put axes titles in there and when I double click on one of these I can just simply write over it so this one here is vol volum and this one over here is mass in gr and let's give this uh graph a better title instead of just Mass this is mass uh versus volume for an unknown liquid okay so that kind of takes some of care of some of the mechanical things at least uh you know making this look like an actual graph now now let's put a um let's also add a trend line so I'm going to add click on this chart elements button here click a trend line and now a dotted line fills in there cool that's the trend line but that trend line actually represents the density of my liquid so I would like to get the slope of that trend line and one of the easier ways to do that is I can rightclick on the trend line then click on format trend line and I get all these different options and this is linear trend line and down here I can display the equation for the trend line on the chart and here's my trend line and that's the equation so what it means is that this is a slope intercept form of a line and I've got y = mx plus b m is my slope m is 1.38 cool now what if I wanted to do this without making a graph well I can actually just come over here and write the slope of the line and say this cell here is going to equal slope and then a parenthesis and then Excel does a really good job of prompting me for the things I'm going to need so here's my known y's my masses comma my known X's once I have those two things in there end parentheses and hit enter and I get I can hit slope and that tells me what the slope is again just the same things as I see over here but without actually having to make the graph sometimes you actually need that slope and want to do some math with it what if I wanted the intercept so I can make a you know a thing here called intercept and um these are just labels by the way they don't have to be here but if I type in here equals that is now formula is going to go here intercept parentheses it prompts me again for my known y so here's my known y's comma my known x's and parenthesis enter and I get this 01995 and just like that 01199 is my Y intercept over here so this is a kind of powerful way to make a really quick graph especially when things are linear it works out nicely if you're doing this for me in my classes it's a pet PE of mine but I just don't really love these um grid lines so I always delete them so I click and delete outside that it's a beautiful looking graph and we can go ahead and use that for what we need to use it for I hope this was helpful to you and uh I'll see you in class