PiscesLogoSmallerStill Quick guide to running a data set

Top  Previous  Next
1.Prepare the biological data set using a spreadsheet such as Microsoft Excel. The data are arranged with samples (quadrats, or stations) as columns and species (variables) as the rows. Give a title to each sample and species. Values can be real or integer and place 0 (a zero) in all localities where a species was not recorded. This can be automated by searching for blanks in Excel and making them 0. Make sure you use a zero and not a capital '0'!
2.Save this array as a .csv (comma delimited text) file from the Save As menu in Excel. Take care if using Excel that the work sheet does not hold any other data or this will be included in the csv file. ECOM can open Excel (xls) files, but the native format used is a csv file.
3.Prepare and save the environmental (physical) data set in a similar fashion to the biological data. Remember to give it a different name from that used for the biological data set.
4.Close the spreadsheet data file before opening the data in ECOM - otherwise you will get an I/O error 32 - access denied. 
5.Run ECOM from the Start menu or by clicking on the executable file.
6.From the Biological File drop-down menu select Open Biological and choose your biological data file.
7.From the Environmental File drop-down menu select Open Environmental and choose the data file holding the environmental (physical) data. These are the independent variables.
8.The data will now open into the grids that can be seen by clicking on the tabs labeled Sample/Species Data and Environmental Data respectively. Before choosing a method it is wise to check your data for columns that sum to zero (samples with no species) and rows that sum to zero (species not found in any sample). First click on the Working Sample/Species Data tab. To remove zero sum rows or columns, select Handling zeroes - Delete 0 rows or Delete 0 columns in the Type of adjustment panel below the data. Once an adjustment has been made remember to click on the Submit button to create a data set for analysis.
9.Undertake any transformations or relativisations you may wish in the working data tabs for either the biological or environmental data. Note that any changes undertaken on the working data will not change the raw data.
10. From the drop down menus select the method you wish to use and, using the tabbed windows, examine the output.
11. Use File|Print to print output and Edit|Copy to copy a graph to a file or the clipboard.