Bivariate

../../_images/bivariateNode1.png

The Clario Bivariate node allows you to create three types of bivariate tables to examine the relationships between attributes on an input data stream:

Configuration

The Bivariate node has four configuration tabs: Two-Way Frequency Table, Means Table, Correlation Matrix, and Weight.

Two-Way Frequency Table Tab

../../_images/bivariate_twoWayFrequencyTableTab.png

Begin by adding at least one Base Attribute by clicking the [+] on the bottom left. This attribute name will be used as the Table name in results. Then select one or more attributes as the Compare Attribute by dragging an attribute from the Available Attributes box into the Compare Attributes box. Click [Save] to save Table configuration or [Cancel] to exit without saving. To erase a previously defined table, click on the table name (in Base Attributes) and click the [-] on the bottom left.

Means Table Tab

../../_images/bivariate_meansTableTab.png

Begin by adding at least one Base Attribute by clicking the [+] on the bottom left. This attribute name will be used as the Table name in results. Then select one or more attributes as the Compare Attribute by dragging an attribute from the Available Attributes box into the Compare Attributes box. Click [Save] to save Table configuration or [Cancel] to exit without saving. To erase a previously defined table, click on the table name (in Base Attributes) and click the [-] on the bottom left.

Correlation Matrix Tab

../../_images/bivariate_correlationMatrixTab.png

To create the Correlation Matrix, select one or more attributes as the Selected Attribute by dragging that attribute from the Available Attributes box into the Selected Attributes box. All numeric attributes will be available in the matrix results.

Settings

In the Settings, select whether or not there are invalid values. Invalid values include +/- infinity, NaN and Null values. Select “None Present” if no invalid values are present for faster run time. “Exclude Pairwise” excludes the case where there is an invalid value in one or both of the attributes in the pairing. If there are invalid values and “None Present” is selected, the run will fail.

Weight Tab

../../_images/bivariate_weightTab.png

To utilize the Weight Attribute, select the attribute from the Available Attributes list box and drag and drop it into the Weight Attribute box. The Weight Attribute must be an integer. This optional setting, whose default value is Null, provides a way to emphasize or de-emphasize certain observations. Once an attribute is selected for the Weight Attribute, it is no longer available in the Available Attribute list boxes for any of the three tables. To remove the Weight Attribute, click the [-] on the right of the box.

Results

The Bivariate Node results set has up to three tabs. Views will be populated based on the tables requested in the node configuration.

Two-Way Frequency Table Tab

../../_images/bivariate_resultsTwoWayFrequencyTableTab.png

Select a Base Attribute (table name) and a Compare Attribute in the Comparisons box. The count in each cell will appear, along with the overall % in the table below. Summary statistics also appear in the upper right corner. To export this table to a spreadsheet, click on the Export to Spreadsheet button on the Toolbar. Note that only the counts (not the % values) export to the spreadsheet.

Means Table Tab

../../_images/bivariate_resultsMeansTableTab.png

Select a Base Attribute (table name) and a Compare Attribute in the Comparisons box. The means table will appear, with the Base Attribute defining the rows and the values of the Compare Attribute summarized across the columns. Statistic measurements displayed include: N, Mean, Minimum, Maximum, Standard Deviation, and Sum. To export this table to a spreadsheet, click on the Export to Spreadsheet button on the Toolbar.

Correlation Matrix Tab

../../_images/bivariate_resultsCorrelationMatrixTab.png

Click the [Attributes...] button, then drag the attribute names from the Available Attributes list to the Selected Attributes list. To view a symmetrical matrix, where the diagonal values will all be 1, check the Symmetrical Matrix box. If this box is not checked, Bivariate shows the correlations of the selected attributes with all numeric attributes on the incoming data stream. Click [Save] to view the matrix. The Highlight Cells slider in the upper right corner allows highlighting of cells over a certain absolute value. To export this correlation matrix to a spreadsheet, click the Export to Spreadsheet button on the Toolbar.

Weight

../../_images/bivariate_resultsWeight.png

If a weight attribute is selected, in the results section for the Bivariate node there will be a line of text above whichever table is being viewed that will list the weight attribute, the total row count, and the weighted row count. If there is not a weight attribute being used, this area will appear blank.