Groups of data (e.g. wells of a plates) are normalized relative to a subset (e.g. some wells within that plate, e.g. negative control). For each group mean and standard deviation (or median and mad) are calculated for the selected subset. Based on these estimates, all data points of a group are normalized by applying this formula:

x.zscore = (x – mean(x[subset]))/sd(x[subset])

or

x.zscore = (x – median(x[subset]))/mad(x[subset])

Literature: Malo et al., Nat. Biotechnol. 24, 167-179 (2006)

Wikipedia: Z-score / Standard score

- Group data by
- Select the column to define the groups (e.g. "barcode" for plate-wise normalization). Select >none< for no grouping (e.g. normalization of the whole screen based on all negative controls available).
- Normalize
- Select the columns with data to be normalized.
- Column with reference label
- Select the column which contains the label defining the reference subset (e.g. treatment)
- Subset / well annotation
- Select a subset label that is used to calculate mean and sd (median and mad) for each group (e.g. "negative control").
- Replace existing values
- If checked the raw values will be replaced by the normalized values. Otherwise columns with the normalized values will be appended - ".zscore"
- Use robust statistics
- Median and mad will be calculated instead of mean and sd.
- Column suffix
- The default column suffix ".zscore" can be changed
- Load a limited number of columns
- If big data tables create memory problems, the number of columns read in memory (subset data) can be restricted. Then, statistic calculation will be done sequential for each set with the given number of columns.

- This node has no views

- 03_Normalization_of_screening_dataKNIME Hub
- AGM_15PlatesKNIME Hub
- HTS_workflowKNIME Hub
- HTS_workflowKNIME Hub
- HTS_workflowKNIME Hub
- Show all 6 workflows

- No links available

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.

To use this node in KNIME, install the extension KNIME HCS Tools from the below update site following our NodePit Product and Node Installation Guide:

v4.7

A zipped version of the software site can be downloaded here.

Do you have feedback, questions, comments about NodePit, want to support this platform, or want your own nodes or workflows listed here as well? Do you think, the search results could be improved or something is missing? Then please get in touch! Alternatively, you can send us an email to mail@nodepit.com, follow @NodePit on Twitter, or chat on Gitter!

**Please note that this is only about NodePit. We do not provide general support for KNIME — please use the KNIME forums instead.**