User Tools

Site Tools


table

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
table [2019/12/02 13:21]
erik
table [2022/12/29 18:05] (current)
mina [Editing table properties]
Line 13: Line 13:
 by contaminants (rows) and contaminants (columns): by contaminants (rows) and contaminants (columns):
  
-^Time^0.0^5.0^...^100.0^+^Contaminants^0.0^5.0^...^100.0^
 ^Nickel|1|2|...|3| ^Nickel|1|2|...|3|
 ^Lead|2|8|...|9| ^Lead|2|8|...|9|
 ^Silver|3|5|...|5| ^Silver|3|5|...|5|
  
-If the data is probabilistic the dimension increase. With 1000 iterations, the table would then become: +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^ ^Time^Nickel/1^Lead/1^Silver/1^Nickel/2^Lead/2^Silver/2^ ^Nickel/n,^Lead/n^Silver/n^
-^0.0|1|2|3| | | |...| | | | +^0.0|1|2|3|4|3|2|...|5|3|2
-^5.0|2|8|5| | | |...| | | |+^5.0|2|8|5|2|6|1|...|8|6|8|
 ^...|...|...|...|...|...|...|...|...|...|...| ^...|...|...|...|...|...|...|...|...|...|...|
-^100.0|3|9|5| | | |...| | | |+^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:
  
- Depending on which view of the output data you seek there are different tables to choose from:+^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]]
  
-  * [[Time_table|Time table]] - Displays data for each time point. Useful for time dependent simulation outputs, like those from [[Compartment|compartments]]. 
-  * [[Index_table|Index table]] - Displays data for each index. Useful for one or two dimensional outputs. 
-  * [[Compare_table|Compare table]] - Displays the ratio, difference or absolute difference between two outputs. //For probabilistic simulations or sensitivity analysis only// 
-  * [[Statistics_table|Statistics table]] - Displays data with different statistics. 
-  * [[Correlation_table|Correlation table]] - Displays the correlation coefficients for one or more outputs. 
-  * [[Raw_data_table|Raw data table]] - Displays all data from a probabilistic simulation for a given time point. 
  
 ===== See also ===== ===== See also =====
table.1575289307.txt.gz · Last modified: 2019/12/02 13:21 by erik