R version 2.15.2 (2012-10-26) -- "Trick or Treat" Copyright (C) 2012 The R Foundation for Statistical Computing ISBN 3-900051-07-0 Platform: i686-pc-linux-gnu (32-bit) R is free software and comes with ABSOLUTELY NO WARRANTY. You are welcome to redistribute it under certain conditions. Type 'license()' or 'licence()' for distribution details. R is a collaborative project with many contributors. Type 'contributors()' for more information and 'citation()' on how to cite R or R packages in publications. Type 'demo()' for some demos, 'help()' for on-line help, or 'help.start()' for an HTML browser interface to help. Type 'q()' to quit R. > x <- array(list(-4 + ,-16 + ,3 + ,0 + ,3 + ,-6 + ,-18 + ,5 + ,-2 + ,0 + ,-3 + ,-14 + ,0 + ,1 + ,-1 + ,-3 + ,-12 + ,-2 + ,-2 + ,-1 + ,-7 + ,-17 + ,6 + ,-2 + ,-4 + ,-9 + ,-23 + ,11 + ,-2 + ,1 + ,-11 + ,-28 + ,9 + ,-6 + ,-1 + ,-13 + ,-31 + ,17 + ,-4 + ,0 + ,-11 + ,-21 + ,21 + ,-2 + ,-1 + ,-9 + ,-19 + ,21 + ,0 + ,6 + ,-17 + ,-22 + ,41 + ,-5 + ,0 + ,-22 + ,-22 + ,57 + ,-4 + ,-3 + ,-25 + ,-25 + ,65 + ,-5 + ,-3 + ,-20 + ,-16 + ,68 + ,-1 + ,4 + ,-24 + ,-22 + ,73 + ,-2 + ,1 + ,-24 + ,-21 + ,71 + ,-4 + ,0 + ,-22 + ,-10 + ,71 + ,-1 + ,-4 + ,-19 + ,-7 + ,70 + ,1 + ,-2 + ,-18 + ,-5 + ,69 + ,1 + ,3 + ,-17 + ,-4 + ,65 + ,-2 + ,2 + ,-11 + ,7 + ,57 + ,1 + ,5 + ,-11 + ,6 + ,57 + ,1 + ,6 + ,-12 + ,3 + ,57 + ,3 + ,6 + ,-10 + ,10 + ,55 + ,3 + ,3 + ,-15 + ,0 + ,65 + ,1 + ,4 + ,-15 + ,-2 + ,65 + ,1 + ,7 + ,-15 + ,-1 + ,64 + ,0 + ,5 + ,-13 + ,2 + ,60 + ,2 + ,6 + ,-8 + ,8 + ,43 + ,2 + ,1 + ,-13 + ,-6 + ,47 + ,-1 + ,3 + ,-9 + ,-4 + ,40 + ,1 + ,6 + ,-7 + ,4 + ,31 + ,0 + ,0 + ,-4 + ,7 + ,27 + ,1 + ,3 + ,-4 + ,3 + ,24 + ,1 + ,4 + ,-2 + ,3 + ,23 + ,3 + ,7 + ,0 + ,8 + ,17 + ,2 + ,6 + ,-2 + ,3 + ,16 + ,0 + ,6 + ,-3 + ,-3 + ,15 + ,0 + ,6 + ,1 + ,4 + ,8 + ,3 + ,6 + ,-2 + ,-5 + ,5 + ,-2 + ,2 + ,-1 + ,-1 + ,6 + ,0 + ,2 + ,1 + ,5 + ,5 + ,1 + ,2 + ,-3 + ,0 + ,12 + ,-1 + ,3 + ,-4 + ,-6 + ,8 + ,-2 + ,-1 + ,-9 + ,-13 + ,17 + ,-1 + ,-4 + ,-9 + ,-15 + ,22 + ,-1 + ,4 + ,-7 + ,-8 + ,24 + ,1 + ,5 + ,-14 + ,-20 + ,36 + ,-2 + ,3 + ,-12 + ,-10 + ,31 + ,-5 + ,-1 + ,-16 + ,-22 + ,34 + ,-5 + ,-4 + ,-20 + ,-25 + ,47 + ,-6 + ,0 + ,-12 + ,-10 + ,33 + ,-4 + ,-1 + ,-12 + ,-8 + ,35 + ,-3 + ,-1 + ,-10 + ,-9 + ,31 + ,-3 + ,3 + ,-10 + ,-5 + ,35 + ,-1 + ,2 + ,-13 + ,-7 + ,39 + ,-2 + ,-4 + ,-16 + ,-11 + ,46 + ,-3 + ,-3 + ,-14 + ,-11 + ,40 + ,-3 + ,-1 + ,-17 + ,-16 + ,50 + ,-3 + ,3 + ,-24 + ,-28 + ,62 + ,-5 + ,-2) + ,dim=c(5 + ,60) + ,dimnames=list(c('Consumer_confidence_indicator' + ,'General_economic_situation' + ,'Unemployment_in_Belgium' + ,'Financial_situation_of_households' + ,'Saving_capacity_of_households ') + ,1:60)) > y <- array(NA,dim=c(5,60),dimnames=list(c('Consumer_confidence_indicator','General_economic_situation','Unemployment_in_Belgium','Financial_situation_of_households','Saving_capacity_of_households '),1:60)) > for (i in 1:dim(x)[1]) + { + for (j in 1:dim(x)[2]) + { + y[i,j] <- as.numeric(x[i,j]) + } + } > par1 = 'pearson' > main = 'Correlation Matrix' > panel.tau <- function(x, y, digits=2, prefix='', cex.cor) + { + usr <- par('usr'); on.exit(par(usr)) + par(usr = c(0, 1, 0, 1)) + rr <- cor.test(x, y, method=par1) + r <- round(rr$p.value,2) + txt <- format(c(r, 0.123456789), digits=digits)[1] + txt <- paste(prefix, txt, sep='') + if(missing(cex.cor)) cex <- 0.5/strwidth(txt) + text(0.5, 0.5, txt, cex = cex) + } > panel.hist <- function(x, ...) + { + usr <- par('usr'); on.exit(par(usr)) + par(usr = c(usr[1:2], 0, 1.5) ) + h <- hist(x, plot = FALSE) + breaks <- h$breaks; nB <- length(breaks) + y <- h$counts; y <- y/max(y) + rect(breaks[-nB], 0, breaks[-1], y, col='grey', ...) + } > postscript(file="/var/wessaorg/rcomp/tmp/1qu0a1355266410.ps",horizontal=F,onefile=F,pagecentre=F,paper="special",width=8.3333333333333,height=5.5555555555556) > pairs(t(y),diag.panel=panel.hist, upper.panel=panel.smooth, lower.panel=panel.tau, main=main) Warning messages: 1: In strwidth(labels, "user") : font width unknown for character 0xd 2: In text.default(x, y, txt, cex = cex, font = font) : font width unknown for character 0xd 3: In text.default(x, y, txt, cex = cex, font = font) : font metrics unknown for character 0xd > dev.off() null device 1 > > #Note: the /var/wessaorg/rcomp/createtable file can be downloaded at http://www.wessa.net/cretab > load(file="/var/wessaorg/rcomp/createtable") > > n <- length(y[,1]) > n [1] 5 > a<-table.start() > a<-table.row.start(a) > a<-table.element(a,paste('Correlations for all pairs of data series (method=',par1,')',sep=''),n+1,TRUE) > a<-table.row.end(a) > a<-table.row.start(a) > a<-table.element(a,' ',header=TRUE) > for (i in 1:n) { + a<-table.element(a,dimnames(t(x))[[2]][i],header=TRUE) + } > a<-table.row.end(a) > for (i in 1:n) { + a<-table.row.start(a) + a<-table.element(a,dimnames(t(x))[[2]][i],header=TRUE) + for (j in 1:n) { + r <- cor.test(y[i,],y[j,],method=par1) + a<-table.element(a,round(r$estimate,3)) + } + a<-table.row.end(a) + } > a<-table.end(a) > table.save(a,file="/var/wessaorg/rcomp/tmp/2524o1355266410.tab") > a<-table.start() > a<-table.row.start(a) > a<-table.element(a,'Correlations for all pairs of data series with p-values',4,TRUE) > a<-table.row.end(a) > a<-table.row.start(a) > a<-table.element(a,'pair',1,TRUE) > a<-table.element(a,'Pearson r',1,TRUE) > a<-table.element(a,'Spearman rho',1,TRUE) > a<-table.element(a,'Kendall tau',1,TRUE) > a<-table.row.end(a) > cor.test(y[1,],y[2,],method=par1) Pearson's product-moment correlation data: y[1, ] and y[2, ] t = 4.6667, df = 58, p-value = 1.851e-05 alternative hypothesis: true correlation is not equal to 0 95 percent confidence interval: 0.3096368 0.6854651 sample estimates: cor 0.5224817 > for (i in 1:(n-1)) + { + for (j in (i+1):n) + { + a<-table.row.start(a) + dum <- paste(dimnames(t(x))[[2]][i],';',dimnames(t(x))[[2]][j],sep='') + a<-table.element(a,dum,header=TRUE) + rp <- cor.test(y[i,],y[j,],method='pearson') + a<-table.element(a,round(rp$estimate,4)) + rs <- cor.test(y[i,],y[j,],method='spearman') + a<-table.element(a,round(rs$estimate,4)) + rk <- cor.test(y[i,],y[j,],method='kendall') + a<-table.element(a,round(rk$estimate,4)) + a<-table.row.end(a) + a<-table.row.start(a) + a<-table.element(a,'p-value',header=T) + a<-table.element(a,paste('(',round(rp$p.value,4),')',sep='')) + a<-table.element(a,paste('(',round(rs$p.value,4),')',sep='')) + a<-table.element(a,paste('(',round(rk$p.value,4),')',sep='')) + a<-table.row.end(a) + } + } Warning messages: 1: In cor.test.default(y[i, ], y[j, ], method = "spearman") : Cannot compute exact p-values with ties 2: In cor.test.default(y[i, ], y[j, ], method = "spearman") : Cannot compute exact p-values with ties 3: In cor.test.default(y[i, ], y[j, ], method = "spearman") : Cannot compute exact p-values with ties 4: In cor.test.default(y[i, ], y[j, ], method = "spearman") : Cannot compute exact p-values with ties 5: In cor.test.default(y[i, ], y[j, ], method = "spearman") : Cannot compute exact p-values with ties 6: In cor.test.default(y[i, ], y[j, ], method = "spearman") : Cannot compute exact p-values with ties 7: In cor.test.default(y[i, ], y[j, ], method = "spearman") : Cannot compute exact p-values with ties 8: In cor.test.default(y[i, ], y[j, ], method = "spearman") : Cannot compute exact p-values with ties 9: In cor.test.default(y[i, ], y[j, ], method = "spearman") : Cannot compute exact p-values with ties 10: In cor.test.default(y[i, ], y[j, ], method = "spearman") : Cannot compute exact p-values with ties > a<-table.end(a) > table.save(a,file="/var/wessaorg/rcomp/tmp/34szk1355266410.tab") > > try(system("convert tmp/1qu0a1355266410.ps tmp/1qu0a1355266410.png",intern=TRUE)) character(0) > > > proc.time() user system elapsed 1.054 0.185 1.219