{"title":"Crosstab","nodeType":"Manipulator","id":"*pNm03fXRSkMzHV8O","factoryName":"org.knime.base.node.viz.crosstable.CrosstabNodeFactory","factoryId":"org.knime.base.node.viz.crosstable.CrosstabNodeFactory","path":["Analytics","Statistics"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>Creates a cross table (also referred as <a href=\"http://en.wikipedia.org/wiki/Contingency_table\" rel=\"ugc nofollow noopener noreferrer\"> contingency table</a> or cross tab). It can be used to analyze the relation of two columns with categorical data and does display the frequency distribution of the categorical variables in a table.</p>\n             \n            <p>This node provides chi-square test statistics and, in case of a cross tabulation of 2x2 dimension, Fisher&#39;s exact test. Both statistics test the null hypothesis of no association between the row variable and the column variable. The p-values are provided in the view and in the second output port.</p>\n            \n        \n        ","shortDescription":"Creates a cross-tabulation (also referred as contingency table or cross-tab).","keywords":[],"deprecated":false,"streamable":false,"tags":["Analytics","Statistics"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAIAAACQkWg2AAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3BpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6N0FEQ0MyNzg4QTI1MTFFNTkyQzJBQjlCNTFCMUUyMzIiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6N0FEQ0MyNzc4QTI1MTFFNTkyQzJBQjlCNTFCMUUyMzIiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpBOUQ4QUYyNzM3OTkxMUU1QUEwNEEzNDQxMEQ0QjlGNiIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDpBOUQ4QUYyODM3OTkxMUU1QUEwNEEzNDQxMEQ0QjlGNiIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PkTIkzwAAACeSURBVHjaYmRiYhIXF2eAgQ8fPggICMC5z58/Z0AFLNzc3EEr3OD8nclH3edaw7lT7RdmH4yHcxf5rGNiIBGQruHz58/I/H///jFQFzACMbK31kXsevbsGUKakfH////IXDp4Go3/9+9fwn7ABPLy8kDyz58/T58+hbAhAMiltqf5+fmp7Wk0gOwehKclJSXh/Hfv3v38+ROPEQABBgDqjDwZhoejeAAAAABJRU5ErkJggg==","views":[{"name":"Cross tabulation","description":"The following properties are displayed in the cross tabulation view:\n<br />\n<i>Frequency:</i>The cell frequency.\n<br />\n<i>Expected:</i>The expected frequency which is computed as ( <i>column total</i> / <i>total</i> ) * <i>row total</i> .\n<br />\n<i>Deviation:</i>The deviation is computed as <i>Frequency</i> - <i>Expected</i> .\n<br />\n<i>Percent:</i>The percent is the relative frequency computed as <i>Frequency</i> / <i>total</i> .\n<br />\n<i>Row Percent:</i>The row percent is computed as <i>Frequency</i> / <i>row total</i> .\n<br />\n<i>Column Percent:</i>The column percent is computed as <i>Frequency</i> / <i>column total</i> .\n<br />\n<i>Cell Chi-Square:</i>The contribution of this cell to the value of the Chi-Square statistic. The Cell Chi-Square sums up to the value of the Chi-Square statistic.\n<br />\n<br />\nFor some properties the row totals and column totals are displayed beside the table and underneath the table, respectively.\n<br />\nYou can control the size of the displayed table with the <i>Max rows</i> and the <i>Max columns</i> controls.\n<br />\n<br />\nThe statistics table provides chi-square test statistics and, in case of a cross tabulation of 2x2 dimension, Fisher&#39;s exact test. Both statistics test the null hypothesis of no association between the row variable and the column variable. You can reject the null hypothesis when the p-value (Prop) is less than a significance value which is typically 0.01 or 0.05. In this case the result is said to be statistically significant. Please bear in mind that the Chi-Square test is based on <a href=\"http://en.wikipedia.org/wiki/Pearson%27s_chi-square_test#Assumptions\" rel=\"ugc nofollow noopener noreferrer\"> some assumptions</a> ."}],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Input Table","description":"Input table containing columns with categorical data."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Cross-Table","description":"The cross table in list form."},{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Statistics Table","description":"The table with the statistics."}],"dynInPorts":[],"dynOutPorts":[],"additionalSiteInformation":{"url":"https://update.knime.com/analytics-platform/5.12","trusted":true,"enabledByDefault":true,"name":"KNIME Analytics Platform 5.12 Update Site","version":"5.12.0"},"dialog":[{"sectionName":"Options","fields":[{"name":"Row variable","description":"The input column used as the row variable in the cross-tabulation.","optional":false},{"name":"Column variable","description":"The input column used as the column variable in the cross-tabulation.","optional":false},{"name":"Weight column","description":"Applies a numeric weight for each record in the input causing the Crosstab node to treat each record as if it were repeated WEIGHT number of times.","optional":false},{"name":"Enable hiliting","description":"If enabled, the hiliting of a cell in the crosstab will hilite all cells with same categories in attached views. Depending on the number of rows, enabling this feature might consume a lot of memory.","optional":false}]}],"links":[],"kudos":[],"kudosCount":0,"bundleInformation":{"bundleVersion":"5.12.0.v202606261225","bundleName":"KNIME Base Nodes","bundleSymbolicName":"org.knime.base","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.base","featureName":"KNIME Base nodes","featureVersion":"5.12.0.v202606261225","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*bjR3r1yWOznPIEXS"},"frequentSuccessors":[{"id":"*DOkyMaii62U05xZ1","factoryName":"org.knime.base.node.preproc.filter.column.DataColumnSpecFilterNodeFactory","probability":0.081799591002045},{"id":"*5stmXk6zY_ORA4bC","factoryName":"org.knime.base.node.preproc.groupby.GroupByNodeFactory","probability":0.0736196319018405},{"id":"*6jI6GPZYQlWirx9J","factoryName":"org.knime.base.node.viz.table.TableNodeFactory","probability":0.05725971370143149},{"id":"*cB9KE6SSG6RhNZNp","factoryName":"org.knime.base.node.preproc.valcount.ValueCounterNodeFactory","probability":0.05521472392638037},{"id":"*ilWsRtia6tW4uakk","factoryName":"org.knime.base.node.viz.condbox.ConditionalBoxPlotNodeFactory","probability":0.05112474437627812},{"id":"*JiJhJpgkWWuOfG2s","factoryName":"org.knime.ext.poi2.node.write2.XLSWriter2NodeFactory","probability":0.0408997955010225},{"id":"*7N4LxTHoPJrHN5lT","factoryName":"org.knime.base.node.stats.viz.extended.ExtendedStatisticsNodeFactory","probability":0.03885480572597137},{"id":"*Oy714gpoifm4PiOZ","factoryName":"org.knime.base.node.io.csvwriter.CSVWriterNodeFactory","probability":0.026584867075664622},{"id":"*pNm03fXRSkMzHV8O","factoryName":"org.knime.base.node.viz.crosstable.CrosstabNodeFactory","probability":0.026584867075664622},{"id":"*jd2U-FYTI8jCbQls","factoryName":"org.knime.base.node.preproc.filter.row.RowFilterNodeFactory","probability":0.02044989775051125}]}