Tip:
Highlight text to annotate it
X
[silence]
>> Speaker 1: Welcome to a tutorial that show you how to calculate averages
and standard deviation for Windows Microsoft Office 2007 version.
You can tell it's 2007 because of the round circle,
this so-called pearl, in the top left-hand corner.
What we want to do is calculate the average for 2 different types of plants
for the amount of oxygen that they generate.
So you could pretend that this was a lab that was done and, over several replicates,
we collected the amount of oxygen that's generated by elodea
which is an aquatic plant and geranium.
The first thing we want to do is put the average into a cell so the first step is to click
on the cell in which you want the average to show up.
Now we need to choose a formula to put into that cell.
Choose the fx box that you can see at the top here
that lets us access the different statistical functions that are available in Excel.
Although, you can see that there are several functions and average is one of them,
what we want to do is search for the function to make sure it's exactly the right one.
You can skip this step if you know what you're doing.
So, here I'm just going to type in the word "average" and click highlight box to cut
down the number of choices I have in the menu.
You can see in the list that we now have the word "average" which is what we're looking for.
[silence] I'm just going to move this window out of the way
so you can see the cells that we need to select.
[silence] Now what I want to do is identify the data that I want to calculate the average for.
You, basically, paint or drag the mouse over those cells that contain those data.
[ Silence ]
Notice there's a dot in the corner of the highlighted cell.
That's a handle that lets you pull the cell over to adjacent cells
and it will copy the same formula over to those.
Now, we're going to fill in the standard deviation and we'll use the same technique.
We'll click on the function button
after selecting the box we want that number to go into.
[ Clicking Noises ]
Be careful to just select the data for the column that you want
to get the standard deviation for, and not the average, that's right above it.
[ Silence ]
If you drag this by its handle, you can fill it in for the geranium column.
[ Silence ]
This concludes the demonstration for how to use Excel 2007 to create averages
and standard deviation from a list of data.
In another video, I will demonstrate how to make a histogram using the average
and put in error bars using the standard deviation
and then I can show you how to put it into Word too.