# Ecolego Wiki

### Site Tools

correlation_table

This is an old revision of the document!

## Overview

Tables allow simulation data to be presented in a tabular form. The correlation table is used after a sensitivity analysis to present correlation coefficients between model inputs and model outputs.

For a correlation table, the following dimensions are available:

• Outputs - The outputs that have been selected for the table.
• Time - If any of the outputs is time dependent, then the time dimension allow you to select which time points to show data for. It is also possible to show the minimum/maximum value across the time vector and the time points for which the minimum or maximum occurs.
• Indices - For each dimension of the selected outputs, a dimension is available for the table data. These dimensions allow you to select all, or only a sub-set of the indices of an index list.
• Correlation type - The coefficients to calculate.
• Inputs - Whether to include all inputs or only inputs that can influence the selected objects. This dimension can also include an R2 value.
• Transformation - How to transform the data before the coefficients are calculated (none, rank or log)

# Correlation table

A correlation table displays correlation coefficients for the selected parameters of a sentitivity or probabilistic analysis towards a selected number of outputs (at a specific time point).

The table is only available after a probabilistic simulation or a sensitivity analysis has been performed.

## Creating a correlation table

From the results window (Recommended)

• Right-click the outputs that you want to include and select Correlation Table from the popup-menu.

From the tables window

• Right-click the tables window and select Create | Correlation Table from the popup-menu.

## Table controls

The controls beneath the table let you change the appearance of the table.

• Format - Select either scientific or decimal format
• Digits - Select the number of digits to show

Highlight

• Highest - Select to highlight the highest value in each column.
• Lowest - Select to highlight the lowest value in each column.
• Condition - Select to enter a condition. The condition is on the form xstart < x < end and will be evaluated for each cell in the table. Cells who’s value fulfills the condition will be highlighted.
• Correlation - Select correlation model.

## Editing a correlation table

To edit a correlation table either right-click the table in the tables window and select Edit, or double-click the table, or click the button in the title bar.

The table editor has two tabs:

### Properties

This screen let you edit properties such as name, that are common to all tables. Please see editing table properties for more information.

### Data

This page lets you choose which outputs to include in the table.

Rows

• Title – Enter a name for the first column. The default name is Input, but you are free to enter any text here.
• Time-point - Enter the time point for which to display correlations for.
• Correlation - Select correlation model.
• Inputs - By default all the parameters that where selected for the analysis are included. Unselect the button Include all to manually select which inputs to include.

Column

To choose outputs for the table, select one of the table data columns. (You can add and remove columns using the Add column and Remove column buttons).

• Title – Enter a name for the column. If you do not enter a name, the name of the output (selected below) will be used.
• Output – A drop-down list with all the available outputs from the simulation.

Table

• Format - Select either scientific or numeric format for the table.
• Digits - Enter the number of digits to show.
• Add column - Click to add a new column
• Remove column - Click to remove the selected column(s).