Regardless of how you arranged your data when you collected them, you must make sure they follow the appropriate format for use with the Ecoplexity data analysis tools. Species composition datasets are slightly different from standard datasets.
If your data include:
Use the format for Standard Datasets
To the right is dataset that could be created in the Excel template. It describes soil temperatures at six sites, measured during each of three months.
To prepare the dataset for a test combining the three groups (e.g., a comparison of means with date as the factor) or to make a single graph containing all of the data (e.g., a bar graph), place all of the temperature data in a single column, and place values to designate sites in a separate column (as shown at right).
In this case, the column containing data for the main variable would be 1 and the column containing grouping data would be 2. The numbers 1 and 2 would be placed in the corresponding fields in the tool.
Left: Unstacked data, with data from each group next to each other.
Datasets containing counts of species (or another level of taxa) at one or more sites differ slightly in their structure from standard datasets. The differences are as follows:
The following is a dataset that could be created in Excel. These specific data describe arthropod species collected in pitfall traps at several sites.
Home | Participants & Sponsorship | Contact us | © 2010