Column

Column analysis tool

Overview

The Column analysis tool allows aggregation of area data for a layout and calculation of some associated statistics, notbaly the average and standard deviation (SD).
This tool can be explored using the Infection example. See the [Examples] page.

The tool loads the layout and result files from PlateEditor and exposes the available result plates (1) and area combinations (2) in its menu panel.
All area combinations with concentration data will be computed and each unique combination exposed as a single new area.
Result plates can be browsed using the plate selection control (1a). For each plate visited, the average and SD parameters will be cached and exposed in the Plate Summary panel.
Pairing information for the selected result plate is indicated. Browsing result plate will automatically set the definition plates to their correct values, if defined. Changing the definition plate manually will refresh the pairing information, indicating any broken link with the current result plate. For more details about [Pairing], see the corresponding page.
Clicking the Compute All button (1b) starts the analysis process for all the plates available in the selected result file. Plates are analyzed one at a time, so it may take some time with bigger result files.
Areas to display can be selected or unselected by clicking them on the area tables (2b). Two attached buttons allow quick selection/unselection of all areas at once (2a).

In the main panel, parameters associated with the selected result file will be available for browsing (1) and preceded by the result index (#) from the result table. Parameters from other files are locked but the computed data are kept in cache.
For each parameter, several data tables are computed (2). Each table has a set of controls for data export (2a):

• Export: click to download the table as a text (tab-separated) file.
• Printable version: click to display the table in a new browser window/tab, which facilitates copy/print operations

Available tables in the Control analysis tool:

• Values: this tab shows the aggregated values of each selected area, for the selected plate, along with some statistics: average, SD, total number of values (2b).
• Plate Summary: this tab caches the average and SD values calculated for each visited plate. Data are aggregated by area combination. Statistics are computed for the values found accross plates: average, SD, total number of values. Note that this panel will not be displayed if the selected result file has only one plate defined, but clicking the Compute All button will force it to appear.

Note: CV (%) statistical data can also be displayed by ticking the corresponding option, see [Analysis].

Specific details

Cached data
Even if they are not displayed, some information in the Plate Summary panel are computed and kept in cache. This includes the CV (%) values, as well as the average/SD values for unselected area combinations.
This means there is no need to re-compute the average/SD values for visited plates even if some areas were unselected.

Export all
When exporting all the data using the Export All option (see [Analysis]), only values for the selected areas will be exported. However, both data tables (Values, Z-factors) will be exported, even if they are hidden in the main panel.
The zip file provided will have the following structure:

Result_File\Parameter_Name\Data_table.txt

As in the figure below: