Frequency/Crosstabulation Tutorial

Once you have identified which variables you would like to examine in SDA, you can run a frequency or crosstabulation analysis.

Selecting the Type of Analysis

View the Program Selection Screen

Login. If you have not already logged in, selecting the above link will first take you to a MyData login screen. You can log in as a Guest/Anonymously or as a Returning User.

Terms of Use. Use of many SDA features will require you to read and agree to a Terms of Use statement once per login. Once you select the I Agree button, you will be directed to the selected feature.

To view the codebook in a separate browser window, click the Open Extra Codebook Window button in the program selection window. This allows you to browse the codebook and run an analysis at the same time. This also enables you to copy and paste the names of variables that you wish to analyze from the codebook window to the analysis window.

Select the button next to Run Frequency or Crosstabulation, and then click the Start button. The SDA Frequencies / Crosstabulation Program screen will appear.

Explanations for each option are available by clicking on the option name. For example, click on the word Row for an explanation of what a row variable is.


Univariate Tabulations

We will start with a univariate (one variable) tabulation of the variable V9--RACE. To do this, we will specify V9 as the Row variable. (The Row variable categories will be displayed on the left side of the table.)

Enter the name of the variable V9 into the Row box (or you can copy and paste from this tutorial or the codebook). You can enter the name either in upper case (V9) or in lower case (v9).

Now select Run the Table near the bottom of the SDA Frequencies / Crosstabulation Program window. The requested table should appear in a new browser window within a few seconds. (Remember that the program must process over eight thousand cases.)


Standard Univariate Results

The standard display of results for a univariate tabulation includes the following items:


Crosstabulations

Please return to the browser window displaying the SDA Frequencies/Crosstabulation Program.

Next we will run a crosstabulation of the variable V16 'MARITAL STATUS' by the variable V8 'SEX'.

Within the SDA Frequencies / Crosstabulation Program window, put V16 'MARITAL STATUS' as the row variable. In the box next to Column enter the variable name V8 'SEX'.

Now select Run the Table near the bottom of the SDA Frequencies / Crosstabulation Program window. The requested crosstabulation of 'MARITAL STATUS' by 'SEX' should appear within a few seconds.


Standard Crosstabulation Results

The standard display of results for a crosstabulation includes the following items:


Using a Selection Filter

Please return to the browser window displaying the SDA Frequencies / Crosstabulation Program.

A selection filter limits the analysis to a subset of the cases in the data file. One possible use of a selection filter would be to limit the table to RACE = White. The variable for RACE is V9 in this data file, and we know from the codebook that a code of 1 means that the person was White.

To limit the crosstabulation of MARITAL STATUS by Sex to Whites, enter V9(1) into the box next to Selection Filter(s).

Then select Run the Table and wait for the results to appear.

In the frequency distribution results we see that among White females in the data set 31.7% were married. The corresponding percentage for White males in the data set was 26.2%. The bar chart under the table shows the same result graphically.

In the Allocation of cases section, we see that this result was based on 4,650 cases. There were 3,650 cases that were excluded by the filter because they were not White. There were another 8 cases with invalid codes on the MARITAL STATUS or SEX variable, so those cases were excluded from the analysis.


Using a Control Variable

Please return to the browser window displaying the SDA Frequencies / Crosstabulation Program.

A control variable is used to generate a separate crosstabulation for each category of the control variable. For example, instead of limiting the table just to Whites (by using a Selection Filter), we can run a separate table for Whites and another table for each of the other noted races by using 'RACE' as a control variable.

Within the SDA Frequencies / Crosstabulation Program screen, delete V9(1) from the box next to Selection Filter(s) and enter V9 into the box next to Control.

Then select Run the Table and wait for the results to appear.

The results show one table and chart for Whites, one table and chart for Blacks, one table and chart for Asians, etc.


Using a Weight Variable

Please return to the browser window displaying the SDA Frequencies / Crosstabulation Program.

One or more weight variables may be available for use in the analysis for some data sets. However, this is not applicable to the 2004 Capital Punishment data set. Notice that the only drop-down option for Weight on the SDA Frequencies / Crosstabulation Program screen is No Weight.

For other data sets, it may be appropriate to apply a weight when running an analysis. Studies with one or more weight variables will have detailed weighting information available in the downloadable PDF codebook. Most SDA codebooks also have weighting information when applicable.

For data sets with only one weight variable, that weight variable will be the default option for Weight. To turn the weight off (not recommended), you have to select No Weight in the drop-down option for Weight.

For data sets with multiple weight variables, one of the weight variables will have been set up as the default option for Weight. However, you should always review the study documentation to determine which weight variable to select based on the variable(s) you have chosen to analyze. Once you have done this, select the appropriate weight variable from the drop-down list.


Crosstabulation Options

Please return to the browser window displaying the SDA Frequencies / Crosstabulation Program.

At the bottom of the SDA Frequencies / Crosstabulation Program screen there is a section labeled Table Options.

Remember that explanations for each option are displayed when you select the name of that option. For example, click on the word Percentaging for an explanation of what that option does.

For an example of how the options work, do the following:

In addition to the previous output for the crosstabulation of 'MARITAL STATUS' by 'SEX,' we now have:


Chart Options

Please return to the browser window displaying the SDA Frequencies / Crosstabulation Program.

In the bottom part of the SDA Frequencies / Crosstabulation Program screen there is a section labeled Chart Options.

Once again, explanations for each option are displayed when you select the name of that option. For example, click on the words Bar chart options for an explanation of those options.

For an example of how the options work, do the following:

The previous chart for the crosstabulation of 'MARITAL STATUS' by 'SEX' is now changed in the following ways:


Additional Analysis of the Variables

This concludes the SDA tutorial. We plan on developing additional tutorials for other SDA analysis features in the future. In the meantime, there is additional online help in the form of the Users Guide, which provides basic information about all the features available in SDA.