How to Use Data Relationships


  1. Select Tools > Data Relationships....

    Response: The Data Relationships dialog is displayed and all available columns are listed in the Available columns field.

  2. Type a Comparison name or use the default name Data Relationships.

  3. Select the Comparison method you wish to use, depending on the type of columns that you want to compare.

    Comment: Choose from Linear regression (numerical vs numerical), Spearman R (numerical vs numerical), Anova (numerical vs categorical), Kruskal-Wallis (numerical vs categorical) and Chi-square (categorical vs categorical).

  4. Move the desired columns into the two fields Selected Y-columns and Selected X-columns.

    Comment: Select columns from Available Y-columns and Available X-columns and click on the corresponding Add > button. You must select at least one column for the Y-columns field and one for the X-columns field. Click < Remove to move a column back to the list of available columns.

  5. Click OK.

    Response: A new page with the specified comparison name is created, showing a data relationships table and a scatter plot (for linear regression), a cross table (for chi-square) or a box plot (for Anova and Kruskal-Wallis).

  1. In the data relationships table, click on the column pair you are interested in.

    Response: The visualization under the table is updated to show the currently marked columns on its axes.  

If you filter your data after performing a data relationships calculation, the p-values in the table will no longer reflect the current selection in your other visualizations, and the Refresh calculation icon will turn red.

  1. Click on the Refresh calculation icon to the left of the Data Relationships table, dr_refresh_calculation__icon.png.

    Response: The Data Relationships table is updated to show calculated values for the currently filtered data.

  1. Right-click on the Data Relationships table.

  2. Select Properties from the pop-up menu.

  3. Select the Columns page in the dialog.

  4. Add or remove columns from the Selected columns list by using the Add > or < Remove buttons.

    Comment: Click on a column in the Selected columns list and then click Move Up or Move Down to change the order of the columns.

  5. Click Close.

  1. Click on the column header by which you want to sort the table.

    Response: The table is sorted in ascending order.

    Comment: Click on the column heading again to sort in descending order. Note the small arrow beside the column title, showing the sort order.

  1. Place the mouse pointer on a table header.

  2. Drag the header to the desired position.

  3. To adjust the column width:

  1. Place the mouse pointer on the separator between two column headers.

  2. Click-and-drag the separator to the desired position.

    Comment: You can also right-click on the column header and select Column Width... from the pop-up menu to specify a column width in number of pixels.

See also:

What is the Data Relationships Tool?

Details on Data Relationships