Kristina: So the goal is to create a bar graph,
which will look like this, of the average Biomulch remaining
in the soil for each of the treatments,
and we want that graph to include standard error bars.
So I have my two treatments, my two biodegradable fabrics,
and I have the mass of Biomulch remaining in the soil
at zero, six and 12 months for all four replicates.
So I'm going to show you, in this first video,
just how to calculate the average standard deviation
and standard error.
So here's one of my treatments and so to get the average.
Let me just delete that.
All I have to do is equals, open parenthesis.
Sorry, equals, AVERAGE, open parenthesis
and then I highlight my four replicates,
and I hit Enter, and I have my average.
To calculate the other two, six and 12 months,
just click and drag over.
So to get the standard deviation, it's equals,
S-T-D-E-V and then open parenthesis
and again, I highlight the mass
for the four replicates, and I hit Enter,
and I'll click and drag
and to get the standard error,
it's going to be equals, open parenthesis,
and then I'm going to highlight my standard deviation,
and then we're going to put
in a forward slash 'cause we're going to divide by,
and then we're going to open parenthesis.
We want the square root function.
So SQRT, another parenthesis, and then we want four
because we have four replicates,
and then we need to close all of our parenthesis,
and we hit Enter, and we have our standard error,
and then we just click and drag over to get our other ones,
and so that is going to wrap up this video
and in the next video, we will create our bar graph.