Data Management to Create Comparative Figures

Kristina Alas Author

01/06/2022 Added

52 Plays

Description

Use data management techniques to create mean data and use it assemble into a line graph to compare buffalo grass cultivars.

Searchable Transcript

Search:

[00:00:06.900]So this is part two of lesson two.
[00:00:09.020]And for this lesson or for this presentation,
[00:00:13.260]we're going to learn about the mean or the average,
[00:00:16.970]and so a practice using descriptive statistics
[00:00:19.860]to analyze our data.
[00:00:21.710]And finally, we're just going to create a table
[00:00:24.110]and line graph in Excel using the data from the software.
[00:00:29.450]Now that bad data has been identified and eliminated,
[00:00:33.000]we can learn how to compare more than one genotype
[00:00:35.650]for all three repetitions.
[00:00:37.560]So our goal is to create a line graph,
[00:00:39.980]but instead of just looking at one genotype
[00:00:43.840]and how it did at all three repetitions,
[00:00:46.320]we wanna look at a line graph with three different genotypes
[00:00:50.450]and how they did throughout the 2015 year.
[00:00:55.310]So if I want to compare this genotype
[00:00:58.190]to two other genotypes,
[00:00:59.957]and this genotype meaning Ne-9-3565.
[00:01:03.210]If I wanna compare him to two others,
[00:01:05.710]I need to start by finding the mean, or average score,
[00:01:09.340]at each date of this genotype.
[00:01:14.270]So the mean is the average number found
[00:01:16.360]by adding all the data points and dividing by the number
[00:01:19.410]of data points.
[00:01:20.800]So if we look at the percent greenness scores
[00:01:23.420]for all three repetitions for Ne-9-3565,
[00:01:27.080]let's focus on May 11th and figure out how we can find
[00:01:30.490]the mean or the average.
[00:01:32.710]So our first step is going to be to add each -- all three
[00:01:36.680]of the scores together.
[00:01:38.340]And so then we'll get that sum.
[00:01:40.270]And then we're gonna divide that by three
[00:01:42.810]because there are three repetitions.
[00:01:45.260]And then we will have our mean.
[00:01:47.990]And so we need to do that for each date
[00:01:51.120]to find our mean score, our average score for each date.
[00:01:55.320]And once we do that, we can now make a line graph
[00:02:01.140]and we can represent any 9-3565
[00:02:06.290]with one value at each date.
[00:02:11.140]So now that the average has been calculated
[00:02:13.530]for one of our genotypes,
[00:02:15.700]we can go ahead and calculate the average
[00:02:18.410]for the other two genotypes I would like to compare it to.
[00:02:22.030]So in this nice table,
[00:02:23.860]I have, you can see, the dates for 2015
[00:02:28.380]that greenness scores were given,
[00:02:30.700]and this would be the average scores
[00:02:33.340]for all three of my genotypes.
[00:02:36.360]And so once I create that table,
[00:02:38.160]I can create a nice line graph in Excel.
[00:02:41.840]And this line graph is a nice and organized and easy way
[00:02:45.690]for me to compare these three genotypes.
[00:02:48.200]I can easily tell how fast they greened up in the spring
[00:02:52.070]and how long they stayed green into the fall.
[00:02:55.830]And by looking at this, I can see that Ne-66-36,
[00:03:00.360]which is the orange line,
[00:03:02.240]greened up the fastest in the spring.
[00:03:05.120]And I can see that it stayed green
[00:03:07.160]just as long as Ne-9-3565 into the fall.
[00:03:14.850]So you're going to be given an assignment
[00:03:17.130]and you're going to have to look at data
[00:03:19.120]for three genotypes.
[00:03:21.030]But before you do, I just wanna point out
[00:03:24.030]that the data you've looked at previously,
[00:03:26.410]I rounded to the 10th decimal place.
[00:03:29.220]And so that's one thing you're going to have to do
[00:03:32.270]for the data you will have.
[00:03:34.830]And I also want to point out
[00:03:37.550]that if you see percentages over 100%, it's not bad data.
[00:03:42.840]This has to do with how the program calculated the plot.
[00:03:46.280]So for this, we will just keep the percentages over 100%.
[00:03:54.040]For your assignment, you are going to use Excel
[00:03:56.700]to graph the mean of three different buffalograss varieties
[00:04:00.680]for 2014 and 2015.
[00:04:04.390]So your final product will look like this.
[00:04:07.510]You'll have two line graphs
[00:04:09.630]and you'll have the buffalograss percent greenness scores
[00:04:12.500]in 2014 for all three genotypes
[00:04:15.750]and the buffalograss percent greenness scores in 2015
[00:04:19.970]for all three genotypes.
[00:04:22.560]And so you're going to be given actual data.
[00:04:26.220]And so this is what you are going to be looking at.
[00:04:31.280]And so when you're looking at this,
[00:04:33.680]you'll see we have ID here.
[00:04:36.490]So those are your three genotypes.
[00:04:39.120]So 11-3608,
[00:04:41.198]53-18,
[00:04:42.407]and 11-3622.
[00:04:44.930]And you have all three repetitions
[00:04:47.140]and their greenness scores.
[00:04:49.670]What may be confusing is that 2014 data is not all together,
[00:04:55.360]so you're really gonna have to pay attention.
[00:04:57.790]Here's some of the scores for 2014
[00:05:00.990]and then the other scores are over here.
[00:05:03.800]So that's what you're gonna have to do first
[00:05:05.900]is organize that data.
[00:05:10.600]And then the next thing you should do
[00:05:12.550]once you organize your data, you want to calculate the mean.
[00:05:16.750]So you can organize it and you can see here,
[00:05:20.170]I have one of my genotypes and I have their data,
[00:05:24.750]so I've organized it.
[00:05:25.950]And this is just for 2015.
[00:05:28.560]So one table for all the dates of 2015.
[00:05:31.820]And then I calculated their mean.
[00:05:33.930]Once I calculate the mean for all three of my genotypes,
[00:05:37.680]I can condense that down to an even smaller table
[00:05:41.450]and then I can round my mean to the 10th decimal place.
[00:05:45.440]And then once I do that,
[00:05:47.660]I can then begin to create my line graphs.
[00:05:52.020]Once you create line graphs for both 2014 and 2015,
[00:05:58.440]make sure that you add a caption for them.
[00:06:01.970]So graphs -- bar graphs, line graphs --
[00:06:05.130]we're always gonna refer to them as figures.
[00:06:07.650]So figure one here is the percent greenness
[00:06:10.830]for three buffalograss genotypes in 2014.
[00:06:14.910]The scores are the averages of three repetitions.
[00:06:18.510]And so if I have two graphs,
[00:06:20.240]I'm going to have figure one and figure two.
[00:06:23.470]And so once you do that,
[00:06:25.370]then you are going to rank the genotypes
[00:06:28.260]based on their greenness.
[00:06:30.390]So which variety did best in 2014 by looking at this graph?
[00:06:35.450]Which one do you think?
[00:06:37.110]And the same for 2015, which did best in 2015?
[00:06:42.250]And which variety did best overall?
[00:06:44.460]Did best in 2014?
[00:06:46.860]In 2015?
[00:06:49.860]And so when you create these graphs,
[00:06:52.920]always make sure to omit any bad data
[00:06:56.220]and the bad data that we talked about...
[00:06:58.880]Let me find that slide.
[00:07:03.700]And so the bad data we talked about
[00:07:05.730]would be due to the quality of the photo,
[00:07:08.210]which the only date you will come across with bad quality
[00:07:12.000]is for June 8th in 2015.
[00:07:16.010]And then also make sure you take out any bad data
[00:07:19.600]due to weed and bluegrass infestations,
[00:07:23.100]which will be seen in the spring and in the fall.
[00:07:27.830]And so to help you make your line graphs,
[00:07:30.750]I do have links to two presentations
[00:07:33.970]on how to calculate the mean and how to create a line graph
[00:07:38.530]in Excel.
[00:07:41.420]So which three genotypes are you going to graph and rank
[00:07:46.660]in Excel?
[00:07:47.880]Well, there are two options for you.
[00:07:49.890]So there's option one and there's no difference
[00:07:52.960]between option one or option two,
[00:07:55.070]just simply different genotypes.
[00:07:57.730]And so, say, if you choose option two,
[00:08:00.840]you will look here and these are all in Excel files
[00:08:04.040]for you already.
[00:08:05.440]So you have your three genotypes, your three repetitions,
[00:08:09.310]and the percent greenness for all of the dates.
[00:08:12.400]And then for you to kind of visualize where they are
[00:08:17.050]on the experimental area, I have them plotted here for you.

The screen size you are trying to search captions on is too small!

You can always jump over to MediaHub and check it out there.

Comments

0 Comments

Data Management to Create Comparative Figures

Description

Searchable Transcript

Comments icon comment

Related Channels

Comments