APA style tables from SPSS 7.5.1
Melissa Mack
Tuesday 5 May 1997
Hello,
I am having trouble making the tables in the Output Navigator conform to
APA style. I have figured out how to eliminate the lines for the column and
rows but am unable to insert the correct format for a title. APA style
requires the word "Table #", one line above the actual title for the table.
Does any one have any idea how this can be accomplished?
P.S. I don't have the option of exporting the tables from the Output
Navigator to a word processor since I am working in Windows95 not Windows97;
at least this is what I have been told.
Thank you very much for your help.
Melissa Mack
Psychology Lab
Douglas College
New Westminster, British Columbia, Canada
Clay Helberg
Melissa Mack wrote:
> I am having trouble making the tables in the Output Navigator conform to
> APA style. I have figured out how to eliminate the lines for the column and
> rows but am unable to insert the correct format for a title. APA style
> requires the word "Table #", one line above the actual title for the table.
> Does any one have any idea how this can be accomplished?
One way to do this is to edit the existing title, adding "Table #" and a
line-break to the beginning of the title. The line-break is entered by
using Ctrl-Enter. This will give you a title like:
Title 1.
KMO and Bartlett's Test
Let me know if this doesn't give you what you need.
> P.S. I don't have the option of exporting the tables from the Output
> Navigator to a word processor since I am working in Windows95 not Windows97;
> at least this is what I have been told.
You can indeed export the tables into most word processors, as long as
you paste them as metafiles ("Pictures") rather than as pivot tables.
You can edit the pasted tables, too, to a certain extent. It is a bit
more difficult than editing in SPSS, since each element of the table
(each column label, data cell entry, horizontal rule, etc.) is treated
as a separate object after pasting. This means you have to keep track of
things like adjusting the placement of elements after you make your
changes. It's recommended that if you have any editing to do, you should
do it in SPSS before copying.
What you may be thinking of, which you can't do in Word 95 or most other
current WP programs, is pasting tables as active SPSS Pivot Table
objects. So (for now) you can't get the cool OLE effects of having a
table in your document that you can activate and pivot on the fly. This
was supposed to be remedied in Word 97, but unfortunately there is a bug
in Word 97's ActiveX container code which prevents our tables from
working properly. (Please note that this is a Word 97 bug, not an SPSS
bug.) It is expected to be fixed in the near future. As more
applications begin to support ActiveX technology, it will be easier to
paste pivot tables as active objects once again.
One other note, this ability to paste tables as ActiveX objects depends
only on the client application (i.e. the word processor), and should
work just fine under Windows 95. In fact, if you want to see it working
correctly, you can paste a pivot table into WordPad (using Edit->Paste
Special, paste as "SPSS Pivot Table Object"). Now, if you double-click
on the object in Wordpad, you should be able to do pretty much anything
with the table that you can do in the SPSS Output Navigator. Windows 97
is *not* necessary (contrary to what the original poster was told).
--Clay
--
Clay Helberg | Internet: chel...@spss.com
SPSS, Inc. | WWW: http://www.execpc.com/~helberg
444 N. Michigan Ave.|
Chicago, IL 60611 | Speaking only for myself....
Clay Helberg
Clay Helberg wrote:
> One way to do this is to edit the existing title, adding "Table #" and a
> line-break to the beginning of the title. The line-break is entered by
> using Ctrl-Enter. This will give you a title like:
>
> Title 1.
> KMO and Bartlett's Test
Just to clarify this a bit, you have to replace the "#" above with a
number--I don't know of a way to have SPSS automatically number such
things (although I imagine an enterprising soul could write a Sax Basic
script to do it). To get the example output shown above, you'd have to
add "Title 1.<Ctrl-Enter>" to the existing title, rather than "Title #".