Create Custom Pre/Post Frequency and Percent tables in SPSS

This tutorial outlines how to create a pre/post table using SPSS. For each variable, summary measures are shown over four rows. The first two rows show measures for pretest responses. The second two rows show measures for posttest responses. Each of these row pairs has a similar pattern: the first row shows counts; the second row displays percentages. By following the steps presented here, you’ll end up with concise tables fit for publication.

Prepare data for analysis

  1. Navigate to the IBM SPSS Statistics Data Editor
    • Click tab Variable View
  2. For each desired variable, change the Measure scale to Ordinal
  3. For each desired variable, make sure values under Values are exactly the same
    • To do this, copy one variable value and paste it into the values of the remaining variables
  4. Arrange your variables so that each pretest variable comes before each post variable

Open the Custom Tables window

  1. Click Analyze
    • Click Tables
      • Click Custom Tables…
      • The Custom Tables window will appear

Create custom table

  1. Navigate to the Custom Tables window
    • Add variables to table
      • Under Variables:, select desired variables
        • Drag selected variables to the Rows bar
          • A table object will appear in the Rows Columns area
    • Reshape custom table
      • Under the Category Position: dropdown menu, select Row Labels in Columns
      • Navigate to the Summary Statistics area (not the button)
        • Under the Position: dropdown menu, select Rows

Specify statistics

  1. Select all variables
  2. Under Define, click Summary Statistics…
    • The Summary Statistics: window will appear
  3. Under Display:, clear the default statistics
    • To clear a statistic, select it and click the left directed arrow
      • The statistic will no longer appear in the Display: area
      • The statistic will now appear in under the Statistics: area
  4. Under Statistics:, select desired statistics
    • Select Count
      • Under Statistics:, click Count then click the right directed arrow
        • The statistic will now appear in the Display: area
        • The statistic will no longer appear in under the Statistics: area
    • Select Row Valid N %
      • Under Statistics:, click Row Valid N %then click the right directed arrow
        • The statistic will now appear in the Display: area
        • The statistic will no longer appear in under the Statistics: area
    • Click Apply to Selection

Specify custom statistic

  1. Select all variables
  2. Under Define, click Categories and Totals…
    • The Categories and Totals window will appear
  3. Under Subtotals and Computed Categories, click Add Category…
    • The Define Computed Category window will appear
  4. Create a statistic
    • Next to Label for Computed Category:, type the word Total
    • Under Expression for Computed Category:, type in the expression [1] + [2] + [3] + [4] + [5]
    • Next to Hide categories used in expression from table, uncheck the box
    • Click Continue
  5. From the Display area, reposition the Total value
    • Under Label, select the Total
    • Click the upward directed arrow until Total is at the top of the list
  6. Click Apply

Produce table

  1. From the Custom Tables window, click OK

SPSS syntax to create table

* Custom Tables.
CTABLES
/VLABELS VARIABLES=V1_pre V1_post DISPLAY=DEFAULT
/PCOMPUTE &cat1 = EXPR([1] + [2] + [3] + [4] + [5])
/PPROPERTIES &cat1 LABEL = "Total" FORMAT=COUNT F40.0, ROWPCT.VALIDN PCT40.1 HIDESOURCECATS=NO
/TABLE V1_pre [COUNT F40.0, ROWPCT.VALIDN PCT40.1] + V1_post [COUNT F40.0, ROWPCT.VALIDN PCT40.1]
/SLABELS POSITION=ROW
/CLABELS ROWLABELS=OPPOSITE
/CATEGORIES VARIABLES=V1_pre V1_post [&cat1, 1, 2, 3, 4, 5, OTHERNM] EMPTY=INCLUDE.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s