View Cross Tabulation

Parent Previous Next

(Not fully implemented.)

A cross-tabulation is a way of calculating counts of aggregations sorted by category.

Imagine value (that we set to Var 1) is the value of a colour system that has the entire spectrum of colours encoded as numbers. Numbers that are close to each other represent colours that are close to each other. Imagine that the type field (that we set to Var 2) indicates what material the potsherd is made out of. We can use a cross-tabulation to generate instant categories by splitting up the entire range of entered values into 10 buckets, or deciles. This allows us to see, for example, that the range 100128 ~ 198607 contains the most examples in our database.

To run a simple cross-tabulation

  1. Search for the records you wish to analysis (e.g. use the Database Summary dialog).
  2. Select Database | Analyse | Crosstabs. The Crosstabs dialog displays.
  3. In the Record Type field, select a record type you wish to analysis:

  1. For var 1 (rows) choose your first variable (this will simulate a tabulation by that variable).
  2. For var 2 (cols) choose the second variable (this splits the range of values into 10 'buckets' and counting how many values appear in each 'bucket' by type.
  3. Var3 is an optional variable that breaks the analysis further, into 'pages'.
  4. In the lower box, define how you wish the data to be analysed.
  5. When ready, click the Run button at the bottom of the page

This produces a tabulation of the data in the selected fields.

Note. Save functionality is not yet implemented.

Created with the Personal Edition of HelpNDoc: Produce Kindle eBooks easily