WEBVTT

00:00:06.920 --> 00:00:09.680
We are going to create a line graph in Excel

00:00:09.680 --> 00:00:12.730
of the mean for the percent greenness for all three

00:00:12.730 --> 00:00:15.010
of our buffalograss genotypes.

00:00:15.010 --> 00:00:17.470
So what we eventually are going to come up with

00:00:17.470 --> 00:00:19.810
is this graph right here.

00:00:19.810 --> 00:00:23.510
So the first thing that we have to do is find our mean

00:00:23.510 --> 00:00:26.030
and round it to the 10th decimal place.

00:00:26.030 --> 00:00:27.770
And that'll be this first video.

00:00:27.770 --> 00:00:29.320
So I'm gonna break it into two parts.

00:00:29.320 --> 00:00:33.200
The next video will be how to create our perfect line graph

00:00:33.200 --> 00:00:34.890
for our genotypes.

00:00:34.890 --> 00:00:37.730
So we are going to start right up here

00:00:37.730 --> 00:00:41.420
and I have all three of my buffalograss genotypes.

00:00:41.420 --> 00:00:46.040
And I have all the data collected for each date in 2015.

00:00:47.300 --> 00:00:49.803
And I have all three repetitions.

00:00:50.750 --> 00:00:53.780
So our first step is to calculate the mean.

00:00:53.780 --> 00:00:57.760
So I have created a column for the mean

00:00:57.760 --> 00:01:00.680
and so you'll be able to see it easily.

00:01:00.680 --> 00:01:02.350
I know that these two dates in April

00:01:02.350 --> 00:01:04.590
are both going to be zero.

00:01:04.590 --> 00:01:07.550
So I'm going to start for May 11th.

00:01:07.550 --> 00:01:09.150
And to calculate the mean,

00:01:09.150 --> 00:01:14.150
you would hit equals, average, open parenthesis,

00:01:14.500 --> 00:01:17.140
and then you will highlight the cells

00:01:17.140 --> 00:01:20.330
that you want calculated and you hit enter.

00:01:20.330 --> 00:01:22.660
And there you have your mean.

00:01:22.660 --> 00:01:25.740
And so to get the mean for the other dates,

00:01:25.740 --> 00:01:29.600
all I have to do is click and drag down

00:01:29.600 --> 00:01:32.890
and it'll automatically calculate that for me.

00:01:32.890 --> 00:01:37.790
And so to round our mean, I know those are zero.

00:01:37.790 --> 00:01:42.790
All I do is I hit equals, round, open parenthesis,

00:01:44.260 --> 00:01:48.453
highlight my mean, you're gonna put a comma and a one.

00:01:49.440 --> 00:01:52.460
And so one signals to round one spot to the right

00:01:52.460 --> 00:01:53.960
of the decimal place.

00:01:53.960 --> 00:01:56.340
So if I put a two there instead,

00:01:56.340 --> 00:02:01.040
that would signal it to round two spots

00:02:01.040 --> 00:02:02.560
to the right of the decimal place.

00:02:02.560 --> 00:02:05.280
So we want the 10th, so we only want one.

00:02:05.280 --> 00:02:09.010
Close my parentheses and I hit enter

00:02:09.010 --> 00:02:13.260
and my data is rounded to the 10th decimal place.

00:02:13.260 --> 00:02:16.470
And then all I do is click and drag down again.

00:02:16.470 --> 00:02:18.020
And all of my mean

00:02:18.020 --> 00:02:22.160
for this genotype of buffalograss is rounded.

00:02:22.160 --> 00:02:23.850
And so then you would do that

00:02:23.850 --> 00:02:27.140
for your other two buffalograss genotypes

00:02:27.140 --> 00:02:30.810
and then in the next video, we will take this data

00:02:30.810 --> 00:02:33.413
and we will create a line graph for it.