With the multivariate value distributions function, you
can visually explore value distributions and relationships between
the columns of a table. For each field in the table, a chart is displayed
that shows the distribution of the values in the chart. Additionally
to the chart, a table shows simple statistics, for example, the number
of NULL values or the number of different values.
Procedure
To explore the attributes of a table:
- In the Data Source Explorer, right-click a
table and select .
- Accept the default options on the Input Data
Selection dialog by clicking OK.
The
Multivariate Distributions view is displayed. It shows a table that
includes statistics for each field of the database table being explored.
Below the table, the appropriate value distribution charts are displayed.
By
selecting different fields in the table, the value distributions of
the selected fields are displayed in the charts below the table.
- To view the chart of a different field, click another field
name, for example, AGE.
- To view the relationship between several fields, follow
these steps:
- In the statistics table, select the fields, for example,
AGE, SEX, BLOOD_PRESSURE, and HEART_RATE.
A graphical
view of these fields is displayed in the Charts section.
- In the AGE chart, select the column that represents
patients between 50 and 60 years. In the SEX chart, select the column
that represents male patients (m).
Selecting these columns
in these charts shows that male patients in the age between 50 and
60 years have approximately the same blood pressure distribution though
there is a tendency to slightly higher values.
Depending on the data that you are analyzing, relationships
like these can give you deep insight in your data.