APA Tables in R

Generating decent tables in R is something I have struggled with for some time, particularly when these need to follow APA guidelines. SPSS has proved to be a complete nightmare so in the past I've simply built templates in Word and copied the numbers across manually from the R console.

This is both time-consuming and increases the chances of human error.

Fortunately, David Stanley has written a great library that can quickly generate results and place them in APA tables.

One note of caution - your data frame must be complete (i.e. no missing values) and only include variables you want to appear in the table. Subsetting your main data frame beforehand may be required in the first instance. Otherwise, it is plain sailing:

For example, a data-set with six personality factors calculated from the HEXACO personality inventory across several hundred participants might look like this...




To generate an APA correlation table run the following:

 ##load library

 library("apaTables")

 ##load data frame

 data <- file="data.csv" font="" header="TURE," read.csv="" sep=",">

 ##Creates a correlation table in APA style with means and standard deviations

 apa.cor.table(data, filename = "correlation.doc", table.number = 1,
              show.conf.interval = FALSE, landscape = TRUE)


data - name of data frame
filename - this is optional, but required to save the table as .doc or .rtf to your working directory
table.number - any integer
show.confidence.interval - self explanatory 
landscape - FALSE for portrait 

This generates a word document:

The code can also be subtly modified to produce other tables:

Creates a table of means and standard deviations for a 1-way ANOVA design in APA style

 apa.1way.table(iv, dv, data, filename = NA, table.number = NA,
               show.conf.interval = FALSE, landscape = FALSE)

 Creates a table of means and standard deviations for a 2-way ANOVA design in APA style
apa.2way.table(iv1, iv2, dv, data, filename = NA, table.number = NA,
               show.conf.interval = FALSE, show.marginal.means = FALSE, landscape = FALSE)

 Creates a d-values for all paired comparisons in APA style
apa.d.table(iv, dv, data, filename = NA, table.number = NA,
            show.conf.interval = TRUE, landscape = TRUE)

 Creates a regression table in APA style
apa.reg.table(..., filename = NA, table.number = NA)

... - the regression model has to be entered here. 


The full manual is worth consulting as it provides several more advanced examples on page 6.

Comments

Post a Comment

Popular posts from this blog

A universal skill-set for all psychologists?

A short list of skills for all psychologists aiming to become independent scientists. Compiled quickly following a brief discussion with a colleague.....last edited (16/10/2014) Input Original Thinking Web Development Critical Thinking PsychoPy Superlab Qualtrics Processing Sharing data with others MATLAB Python RStudio  (R) SPSS Excel NVIVO Output Talking Writing Dealing with Rejection (getting back on the horse) Developing detailed strands of work that are simultaneously placed into a wider context Developing Impact Powerpoint Keynote Prezi Adobe Creative Suite Tableau LaTeX Processing Misc Evernote Cloud Outliner Mendeley  (or any referencing software)
Read more

State-Trait Anxiety Inventory (STAI): SPSS Script

The State-Trait Anxiety Inventory (STAI) is a psychological inventory based on a 4-point Likert scale and consists of 40 questions on a self-report basis.  Below is a short script for SPSS which will help speed up the coding process. A version that runs in  R is also in the pipeline.  All items should be labeled as separate numeric variables as stai1 and taiy1 ...etc The script computes and prints the results for all reverse scored items and then calculates and prints state and trait scores. It will also produce  Cronbach's Alpha  coefficients. The original scoring key for the STAI can be found  here . *Part 1 - reverse scoring of specific items COMPUTE stai1r = 5 - stai1. EXECUTE. COMPUTE stai2r = 5 - stai2. EXECUTE. COMPUTE stai5r = 5 - stai5. EXECUTE. COMPUTE stai8r = 5 - stai8. EXECUTE. COMPUTE stai10r = 5 - stai10. EXECUTE. COMPUTE stai11r = 5 - stai11. EXECUTE. COMPUTE stai15r = 5 - stai15. EXE...
Read more

The Hexaco Personality Inventory - SPSS Script

I am currently using the 60-item version of the Hexaco-PI-R personality inventory and decided to write a short script for SPSS to help speed up the coding process. I have posted it below because I couldn't find anyone else who had posted one online. All items should be labeled as separate numeric variables as hexaco1, hexaco2, hexaco3 ...etc The script computes and prints the results for all reverse scored items and then calculates and prints Factor/ Facet scores. It will also produce Cronbach's Alpha coefficients for each factor. The original scoring key for the HEXACO-PI-R can be found here . ******************************************* *Part 1 - reverse scoring of specific items *Honesty-Humility COMPUTE rhexaco30 = 6 - hexaco30. EXECUTE. COMPUTE rhexaco12 = 6 - hexaco12. EXECUTE. COMPUTE rhexaco60 = 6 - hexaco60. EXECUTE. COMPUTE rhexaco42 = 6 - hexaco42. EXECUTE. COMPUTE rhexaco24 = 6 - hexaco24. EXECUTE. COMPUTE rhexaco48 = 6 - hexaco48. EXECU...
Read more