Statistical Testing in Crosstabs

To view the Crosstabs report, click Menu, and under Trend It, click Crosstabs.

In Crosstabs, you can apply a Columns Proportions test and a Chi Square statistical test to report data.

To apply the statistical tests to report data, you must use Measures that are Counts, such as Alert Counts or Survey Counts.

For a description of the tests and examples of test results, see:

 

To apply a Column Proportions or Chi Square test to report data, review the following report example:

  1. From Hidden Fields, click the plus sign next to Measures, click the plus sign next to Survey, then drag Survey count into Data Area.


  2. From Hidden Fields, click the plus sign next to Organization, then drag Organization into Row Area.
    Organization can only be dragged onto Row Area. It includes too much data to be shown as columns.
    Levels 2-9 Are shown


  3. At Level 02, click the blue funnel icon, and then select TME.
  4. Click the at TME.
    The Survey data is shown.


  5. From Hidden Fields, click the plus sign at Model, then drag Model Type-Model into Column Area.
    Model Type and Model columns are now shown at Drop Columns Here. The report looks like this partial graphic.


  6. To apply a Column Proportions test, click the  button.
    A selection window opens.


  7. Select an alpha value. For example, for a confidence level of .95, select 0.05.
    Results will be based on two-sided tests with significance level of 0.05.
    The Significance Testing Results window opens, shown in the following partial graphic.


    For information about the results shown above, see a description of the Significance Testing results window. .
    To close the window, click anywhere outside the window.
  8. To apply a Chi Square test, click the button.
    A selection window opens:


  9. Select an alpha value. For example, for a confidence level of .95, select 0.05.
    The Chi Square Testing Results window opens.  


    For information about the results, see a description of the Chi Square Results window.
    To close the window, click anywhere outside of the window.

 

See also:

Crosstabs Overview

Creating Basic Reports in Crosstabs

Working with Filters in Crosstabs