====== Table ====== Tables present simulation output data in tabular form. Data can be organized in different ways depending on the dimension of the data. For instance, a table might display concentrations of three contaminants, for ten time-points. This data can be arranged by time (rows) and contaminants (columns): ^Time^Nickel^Lead^Silver^ ^0.0|1|2|3| ^5.0|2|8|5| ^...|...|...|...| ^100.0|3|9|5| by contaminants (rows) and contaminants (columns): ^Contaminants^0.0^5.0^...^100.0^ ^Nickel|1|2|...|3| ^Lead|2|8|...|9| ^Silver|3|5|...|5| If the data is probabilistic the dimension increases to three. With n=1000 iterations, the table would then become: ^Time^Nickel/1^Lead/1^Silver/1^Nickel/2^Lead/2^Silver/2^ ^Nickel/n,^Lead/n^Silver/n^ ^0.0|1|2|3|4|3|2|...|5|3|2| ^5.0|2|8|5|2|6|1|...|8|6|8| ^...|...|...|...|...|...|...|...|...|...|...| ^100.0|3|9|5|6|2|4|...|9|6|5| === Reduction === For probabilistic data, it is more common to display statistics rather than data for each iteration. For example, by showing the mean and standard deviation the probabilistic dimension is reduced from thousands of items to just two: ^Time^Nickel/mean^Lead/mean^Silver/mean^Nickel/std dev^Lead/std dev^Silver/std dev^ ^0.0|3|1|3|7|9|4| ^5.0|7|3|1|2|6|3| ^...|...|...|...|...|...|...| ^100.0|5|3|6|1|8|5| The same can be done for time: instead of showing all time points, just show the first and last time point: ^Time^Nickel/mean^Lead/mean^Silver/mean^Nickel/std dev^Lead/std dev^Silver/std dev^ ^First|3|1|3|7|9|4| ^Last|5|3|6|1|8|5| If only the last time point is shown, the dimension of the data is reduced so that we can use rows for contaminants instead: ^Contaminant^mean, t=100^std dev, t=100^ ^Nickel|5|1| ^Lead|3|8| ^Silver|6|5| ==== Order ==== When a table is created, Ecolego will automatically determine which dimensions it will have. The user can reduce dimensions or even "collapse" dimensions. The user can also select the order in which the dimensions of the data are displayed. First, one dimension is selected for rows, then the priority of the column dimensions can be selected. The following table shows data for the two outputs Weight and Length, where both Weight and Length depend on Country and Gender with the following order: Row: Outputs Columns: Country, Gender ^Output^Sweden/Male^Denmark/Male^Sweden/Female^Denmark/Female^ ^Weight| | | | | ^Length| | | | | Switching the order of the columns would yield Row: Outputs Columns: Gender, Country ^Output^Male/Sweden^Female/Sweden^Male/Denmark^Female/Denmark^ ^Weight| | | | | ^Length| | | | | ==== Table types ==== The base version of Ecolego offers two types of tables: - [[General table]] - General purpose table for normal simulation data. - [[Correlation table]] - Table for displaying correlation coefficients ===== Editing table properties ===== This page includes general information about the table. * **Name** – Enter a name for the table. * **Comment** – A comment for the table, such as a summary of its contents. ===== See also ===== * [[Tables_window|Tables window]] ===== See also ===== * [[Tables_window|Tables window]] * [[Results_window|Results window]]