3. Reports and Graphics › 3.3 Statistical Analyses › 3.3.2 Crosstabulation Report

3.3.2 Crosstabulation Report

                      TABLE OF CICSID BY SYSID

           CICSID(CICS SYSTEM )     SYSID(MVS SYSTEM )

           FREQUENCY|
            ROW PCT |MVS1    |MVS2    |MVS3    |  TOTAL
           ---------+--------+--------+--------+
           ACCT     |  10391 |      0 |   2044 |  12435
                    |  83.56 |   0.00 |  16.44 |
           ---------+--------+--------+--------+
           OIL1     |      0 |  35892 |  16599 |  52491
                    |   0.00 |  68.38 |  31.62 |
           ---------+--------+--------+--------+
           OIL2     |    729 |  19808 |   9938 |  30475
                    |   2.39 |  65.00 |  32.61 |
           ---------+--------+--------+--------+
           TOTAL       11120    55700    28581    95401

Figure 3-20.  Sample Crosstabulation Report


The Crosstabulation Report is a combined frequency
distribution analysis of two variables.  Crosstabulation
reports are useful in on demand analysis to identify areas
needing further study (for example, ABEND code frequencies by
cost center).  Support is included to report frequency count,
percentage, and cumulative count/percentage for each
combination of values of the two variables.  Results are
presented in a two-dimensional table or array.

For example, a table for the variables SYSID and COMMAND
would create a table with a separate column for each SYSID
and a separate row for each TSO command contained in the
data.  The cells of the table would show the frequency with
which each command was used on each system.  In addition,
cells can optionally contain the percentage of the
observation represented by this cell, the percentage of the
column total represented by the cell, and the percentage of
the row total represented by the cell.

Figure 3-20 is a sample crosstabulation report.  The report
shows the number of CICS transactions by CICS system (CICSID)
and SYSID.  Observations are weighted by the number of
transactions (CSYTRANS).

To create a crosstabulation report, select the
Crosstabulation Report option from either of the following
menus:

o  Direct Inquiry Statistical Analysis Menu
o  Structured Inquiry Statistical Analysis Menu