Watch videos with subtitles in your language, upload your videos, create your own subtitles! Click here to learn more on "how to Dotsub"

BITC / NBD protocol - 5

0 (0 Likes / 0 Dislikes)
Next on our task list is estimate A and B, which are the numbers of species that have been seen once exactly and twice exactly in a particular grid cell. Let's go back to our working file. All the way back to here. Copy it. Paste it into a new sheet. Then, make sure you have unique records. We'll use advanced filter. You can see here, lines 6 and 7, are not unique records; so, those will disappear once this finishes its filter. This can take a little while because the Ghana dataset has a lot of records. Be patient. There we go. Copy this dataset. Paste it into yet another sheet. These are unique combinations of grid ID, species name, and time. We'll do yet another pivot table. But, this one will be different in its format. ID will be on the left. Species names will go on the top across the columns. And, once again, the values will be the sum of the 'Dummy' variable. Already, there are values in the middle which represent the number of days a particular species was recorded. Any one that is a 1 is 'A', and any that are a 2 is 'B'. Now, go all the way to the end of the spreadsheet. We'll use the function "CountIf". In this case, we want to include B5 to FIR5. But, the range will be different for every dataset. We want to scan across all those records to see which fit the criterion "=1". That will be our 'A'. Then, copy it... Oops, I made a mistake. And, now, it's correct. Almost. There we go. Now, we can go look for 'B'. Use the same formula. Don't copy and paste the formula. Just grab the actual text of the formula, and substitute a '2' for the '1'. Of course, I have to fix that same error. Now, it should be working. So, what does this say? Across that full range, how many species have a sum of 1 day seen? In the next column, how many species in that same range have a frequency of 2 times seen? That is 'A' and 'B'. Now, move those formulas down. Just to be sure we don't mess anything up, we're going to go back and grab our row labels as well. Copy and paste those 3 columns into the 'Summary' sheet. Remember to paste "as values". Check that the row labels are the same. Are they the same as the original row labels? Yes. Delete the duplicate row ID column. Now we have N, number of species, number of species seen once, and the number of species seen twice. We now have all the ingredients for calculating an expected number of species.

Video Details

Duration: 5 minutes and 30 seconds
Language: English
License: Dotsub - Standard License
Genre: None
Views: 1
Posted by: townpeterson on Jul 26, 2016

This video gives a step-by-step through the protocol being used in the course on National Biodiversity Diagnoses, an advanced course focused on developing summaries of state of knowledge of particular taxa for countries and regions. The workshop was held in Entebbe, Uganda, during 12-17 January 2015. Workshop organized by the Biodiversity Informatics Training Curriculum, with funding from the JRS Biodiversity Foundation.

Caption and Translate

    Sign In/Register for Dotsub to translate this video.