Statistics

This node calculates statistical moments such as minimum, maximum, mean, standard deviation, variance, median, overall sum, number of missing values and row count across all numeric columns, and counts all nominal values together with their occurrences. The dialog offers two options for choosing the median and/or nominal values calculations:

Options

Settings

Compute median values

Select this option if for all numeric columns the medians are computed. Note, this computation might be expensive, since it requires to sort all column independently to find the values that divides the distribution into two halves of the same number of values.

Column filter

Filter columns for counting all possible values.

Nominal values

Adjusts the number of counts for both, top number of frequent and infrequent occurrences of categorical values per column (displayed in the node view!).

Nominal values in output

Adjusts the maximum number of possible values per column in the nominal output table.

Histogram

Histogram format

The histogram cells should be in SVG or PNG format.

Width

The width of the histogram.

Height

The height of the histogram.

Show min/max values

Show or do not show the numeric min/max values on histograms.

Views

Statistics View

Displays all statistic moments (for all numeric columns), nominal values (for all selected categorical columns) and the most frequent/infrequent values from the categorical columns (Top/bottom).

Workflows

• [Latest] Consolidated 3 Mar 1210KNIME Hub
• 00_Topic_Modeling_with_Verified_ComponentsKNIME Hub
• 00_Topic_Modeling_with_Verified_ComponentsKNIME Hub
• 00. Install ExtensionsKNIME Hub
• 01 Dealing with String DataKNIME Hub
• Show all 1085 workflows

Links

• demo how to count missing values in tablesby HansS on 2019-11-04

  forum.knime.com/p/73940
• weighted statisticsby johannes.schweig on 2019-01-30

  forum.knime.com/p/53793
• Frequencyby ipazin on 2018-04-27

  forum.knime.com/p/42108
• Data explorationby ipazin on 2019-01-07

  forum.knime.com/p/52411
• Find out General Information of a columnby HansS on 2022-07-23

  forum.knime.com/p/164183
• Show all 6 links

Developers