How to Make APA Style Correlation Table 2

[Pages:10]TONY E. JUNG

HDFS 503L SPRING 2007

How to Make an APA-Style Correlation Table Using SPSS

First, open the data file called "Anxiety 1" by doing: File ? Open ? Data... (To find the Anxiety 1 data file, follow the instructions I gave you last week.) Run a Bivariate Correlation by going to Analyze ? Correlate ? Bivariate...

Correlations

Subject Anxiety Tension Score Trial

Subject Pearson Correlation

1 .869** .435** .070 .000

Sig. (2-tailed)

. .000

.002 .639 1.000

N

48

48

48

48

48

Anxiety Pearson Correlation

.869**

1

.000 .090 .000

Sig. (2-tailed)

.000

.

1.000 .545 1.000

N

48

48

48

48

48

Tension Pearson Correlation

.435** .000

1 .081 .000

Sig. (2-tailed)

.002 1.000

. .582 1.000

N

48

48

48

48

48

Score Pearson Correlation

.070 .090

.081

1 -.884**

Sig. (2-tailed)

.639 .545

.582

. .000

N

48

48

48

48

48

Trial

Pearson Correlation

.000 .000

.000 -.884** 1

Sig. (2-tailed)

1.000 1.000

1.000 .000

.

N

48

48

48

48

48

**. Correlation is significant at the 0.01 level (2-tailed).

Move your mouse pointer over the table and then Right-Click your mouse button. Go to "SPSS Pivot Table Object" and select "Open".

This new window is called the "SPSS Pivot Table" Editor window. Click on Format ? TableLooks...

1

TONY E. JUNG

HDFS 503L SPRING 2007

In the next window, scroll down and select "Academic", then OK.

You should now see the changes made in the SPSS Pivot Table editor: 2

TONY E. JUNG

HDFS 503L SPRING 2007

Although this looks closer to APA-style, it's not quite there yet. Let's make more changes. Click on Format ? Table Properties... You should now see:

Change "Maximum width" of labels to "120". Then, click on the "Cell Formats" tab. 3

TONY E. JUNG

HDFS 503L SPRING 2007

Now change everything to Times New Roman and 12-Point font and flushed-left. Go to the next "Area" and do the same thing. Keep doing this until you have changed all "areas":

After making the changes, click on the "Borders" tab:

4

TONY E. JUNG In this window, change borderline size:

HDFS 503L SPRING 2007

You need to change the following borders to the smallest line. [It's the one right after (None)]: "Top inner frame" "Bottom inner frame" "Data area top" Click (None) for "Horizontal dimension border" Click OK. You should now see the Pivot Table editor again:

5

TONY E. JUNG

HDFS 503L SPRING 2007

Now, let's permanently save this design as a template... Go to Format ? TableLooks... Click on "Save As" and save it to your personal folder. Name it whatever, e.g. "APA Table".

After saving it, click on OK . 6

TONY E. JUNG

HDFS 503L SPRING 2007

Now, let's make this new APA design the SPSS default output. Go to: Edit ? Options... Then click on the Pivot Tables tab:

Click on Browse... and find the file you saved the template as and open it. Click OK. Now, your default output will be your new APA-style table. Try running the Bivariate Correlation... again.

7

TONY E. JUNG

HDFS 503L SPRING 2007

Exporting Table to Microsoft Word

Before we put the table into a Word document, let's clean it up a bit. Remember, APA-style is supposed to be simple and clean:

Here's the final edit:

Click here to shrink the margins

Go ahead and click on the "X" to close the SPSS Pivot Table window. 8

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download