User Tools

Site Tools


table

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):

TimeNickelLeadSilver
0.0123
5.0285
100.0395

by contaminants (rows) and contaminants (columns):

Contaminants0.05.0100.0
Nickel123
Lead289
Silver355

If the data is probabilistic the dimension increases to three. With n=1000 iterations, the table would then become:

TimeNickel/1Lead/1Silver/1Nickel/2Lead/2Silver/2 Nickel/n,Lead/nSilver/n
0.0123432532
5.0285261868
100.0395624965

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:

TimeNickel/meanLead/meanSilver/meanNickel/std devLead/std devSilver/std dev
0.0313794
5.0731263
100.0536185

The same can be done for time: instead of showing all time points, just show the first and last time point:

TimeNickel/meanLead/meanSilver/meanNickel/std devLead/std devSilver/std dev
First313794
Last536185

If only the last time point is shown, the dimension of the data is reduced so that we can use rows for contaminants instead:

Contaminantmean, t=100std dev, t=100
Nickel51
Lead38
Silver65

Order

When a table is created, AFRY Intelligent Scenario Modelling 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

OutputSweden/MaleDenmark/MaleSweden/FemaleDenmark/Female
Weight
Length

Switching the order of the columns would yield

Row: Outputs Columns: Gender, Country

OutputMale/SwedenFemale/SwedenMale/DenmarkFemale/Denmark
Weight
Length

Table types

The base version of AFRY Intelligent Scenario Modelling offers two types of tables:

  1. General table - General purpose table for normal simulation data.
  2. 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

See also

table.txt · Last modified: 2024/06/13 11:08 by 127.0.0.1

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki