Tip:
Highlight text to annotate it
X
>> I showed how to calculate the average in standard deviation
for these data, which will go into a line graph.
I'm going to call it a line graph, but I'm going to show you that's a bad name
for it if we're in the Excel world.
Now, what we want to plot is temperature and the average amount
of absorbance change per minute for a particular reaction.
So because we only want to deal with these process data, the temperature we recorded on,
which is absolute, and the average, which is the part of raw data that we processed
from these parts, let's hide these.
I'm going to left click and paint all of the columns, B through E, which have the raw data.
I'm going to right click or two-finger click, if you're using the control pad,
and then I'm going to hide them, don't delete.
Hide them.
They're still there.
We go from A to F, but we've got these two data series side by side.
So I'm going to highlight the data I want to plot.
We'll get to the standard deviation in a little bit.
So from here, I want to insert, and remember we call these figures charts when we're in Excel.
And it gives us a choice.
And there is a line graph that you can do, but it turns out these don't work very well,
because the numbers aren't continuous in their spacing.
So we don't have a 10-unit space here and another 10-unit space, we have 0 to 10
and 10 to 25, which is 15, and it gets worse as we move down.
So we want to plot so that these are spaced properly,
and that is done with a scatter plot just like this.
Choose one with lines, left click, and we get a graph that's a bit shocking.
It's not what we're looking for.
But the reason is because we want to swap the axes on here,
and we go through the toolbox to do this.
And if you take a look here for chart data, we can sort by, you know, rows or we can sort
by columns, and that's how we want to do it.
If you click on columns, this makes sense.
We've got temperature down here, so we've got 100 degrees plotted on the far right,
80 degrees over here, and a big space between that and the 50 degrees, which is beside it.
Let's get rid of series five.
It doesn't mean anything for us.
And let's process this graph a little bit by adding proper titles.
So let's do, we've got a horizontal axis ready to go, so we're going to call
that the temperature, Celsius, and let's do the vertical.
And we'll call this change in absorbance.
And I'm going to call units per minute, if that's what you measured.
You could put in delta A for change in absorbance, but it is kind of tricky to do.
So we've got those two parts.
Now we need to put in the error bars, so let's get rid of this guy right there.
And we'll click on the data series.
Click on the line connecting all these dots, and notice all the dots light up.
We have six values there, six values we want to add the values to, very good.
And left click on format the data series, and choose error bars.
Now these are going left and right, so we want to change that to Y error bars.
We want them up and down showing the variation in the absorbance for each temperature.
We would like to choose both, and put caps on it and make a custom value,
and I'm going to specify the value as the standard deviation here.
So I'm going to highlight it there.
That's for the positive value, and remember to delete the data here
and put in your negative value, as well.
And say okay.
And okay. Now, generally pretty good.
We have a Y axis value that goes below zero.
So let's fix that quickly.
I'll click with my left mouse button to select that part, the right mouse button there,
and let's format the axis so that it's going to be scaled only to zero as the smallest amount.
And say okay.
And that looks a little cleaner and nicer.
Well, we've got everything we need on here.
We just need to put it into Word.
So I'm going to left click on the boundary, right click on the boundary to bring up a menu.
I'm going to copy it and get this out of the way.
Let's open up our document that we wanted to go in,
and we look for where we start referring to the graph.
Figure 1, shown right here, so let's put the graph right after that.
So I've just added a -- I clicked on there, hit enter to open some space,
right click to bring up a menu, and paste it.
There we go.
What we're missing is the caption, and so it should be labeled figure 1,
figure 2, figure 3, whatever it is.
So just left -- pardon me, right click anywhere on the background and insert caption.
It'll automatically come up with a figure.
Make sure it's the right figure number, and this is the first one in this document.
So I'll put in a colon and I'll write a proper caption.
Caption: graph of enzyme activity under a variety of temperature conditions.
Now, you might want to say what enzyme it is, it's a real quick --
it's hard to think and type and make a tutorial at the same time.
You should say that data points represent the average of five replicates,
and the error bars show standard deviation for each temperature tested.
And we'll hit okay, and this appears underneath it.
That's really nice.
That's the way it's supposed to be with figure.
Remember, tables go on the top.
And notice that the error bars are consistent with the data we have.
They're not all the same length.
So it looks like this is going to work out.
And hopefully, you have created yourself an A paper.