Tip:
Highlight text to annotate it
X
[ Silence ]
>> Now that we have the standard deviation and averages we can plot this on a histogram.
A histogram helps us put data that are discontinuous into a graphical form.
By discontinuous I mean that we want data for Elodea and Geranium but we don't have an Elodea,
Geranium hybrid which we would like to extrapolate data from.
We need to select two pieces of data.
We need to have the names of the plants we're using, Elodea or Geranium,
and then we also need to get the average.
Notice that those two pieces of data are in different lines and so we have to use a trick
with the Ctrl key to select both of these without selecting all of the raw data
that is the individual trials between them.
So click on Elodea and while holding down the left mouse button, paint the word Geranium
and then let go of the mouse button.
Now we need to select the first average.
But before you click with the left mouse button, hold down the Ctrl key and while holding
down the Ctrl key paint the two averages, 4.1 and 4.82 in this case.
[ Silence ]
And so just like that we get our columns and we can get rid of this word that says series 1
because it doesn't add any information so click on it and hit the delete key.
Let's move this window out of the way.
Excel has decided to show us the split between the two different groups
by shrinking the Y access a little bit.
It's often nice to start these at 0 so if you want to do that you click on the Y access
and then with your right mouse button right click on it so that you can access the menu
and we'll change this value to be a minimum of 0 instead of 3.6.
[ Silence ]
We can fix this at 0.
Let's put in titles for the X and Y axis.
Click on the layup tab.
We can modify both axis from the axis title button.
[ Clicking ]
I need to move the Excel Window over a little bit so you can see the fly out menu.
The next step is for us to put in the standard deviation above
and below the top values in the columns.
Let's choose layout, analysis and error bars.
We have custom values.
[ Clicking ]
Click in the positive error value box and then hit the backspace key
to delete the information in there.
Then drag it from left to right over the standard deviation for Elodea and Geranium.
Click in the negative error value box, hit backspace
and then paint the standard deviation again.
[ Silence ]
Great, now we've got a graph with error bars on it and we can now paste it into Word.
Click anywhere on the graph to select it.
I happen to have Word already open and it's behind the Excel that I've been using
so I'm just going to click on the sheet behind and that will bring Word forward.
Choose where you want to put the graph, right click to bring up a menu and paste it in.
You might choose to add a caption as a figure label.
[ Clicking ]
And save your work.
So there you are, you now have a document with a graph inserted
into it and a proper caption below.