Send output to:
Browser Blue - Charts White
Browser Black/White
CSV
Data X:
19 7 10 19 15 10 24 21 13 18 13 13 20 8 10 24 16 12 16 13 14 11 8 7 21 10 12 19 16 12 17 14 10 20 18 12 6 4 4 16 12 9 20 20 20 23 22 19 25 15 15 23 20 16 16 16 12 13 9 7 26 21 19 27 16 12 24 11 8 25 23 12 20 16 12 19 16 18 23 17 18 19 17 11 17 24 10 22 20 16 21 19 13 23 20 16 21 17 13 20 18 14 24 17 8 21 18 17 16 16 10 22 21 17 20 19 14 22 19 14 20 15 16 17 14 8 23 22 21 21 22 13 18 17 11 16 14 7 19 19 13 21 16 16 20 15 14 11 7 7 21 24 18 24 23 17 20 20 6 23 20 16 22 19 13 19 16 16 20 20 16 18 18 15 22 19 15 22 18 20 19 18 14 25 17 22 21 8 14 20 20 20 20 20 16 20 20 18 25 16 11 25 21 18 23 21 19 22 21 15 20 19 12 22 21 17 15 19 15 20 19 15 18 11 12 21 19 16 22 20 17 25 22 8 15 18 18 4 11 7 19 21 9 22 23 17 20 20 19 21 15 15 21 18 11 11 14 6 13 11 10 20 14 11 21 14 16 20 18 13 19 16 15 22 19 19 18 18 11 19 20 14 13 13 8 15 18 7 22 20 17 19 16 17 19 12 9 26 24 19 20 18 14 19 20 10 22 19 17 21 19 14 21 20 17 21 20 9 16 17 15 22 19 21 19 22 14 20 21 11 24 15 8 20 19 13 23 22 19 24 22 22 23 20 15 16 21 9 11 16 5 22 23 18 20 20 17 19 21 5 19 21 21 10 14 6 16 18 7 15 20 9 19 21 10 18 19 16 23 22 18 24 23 17 22 18 15 16 20 8 19 18 16 13 18 11 16 18 13 19 14 13 20 20 16 22 21 21 23 19 15 22 22 22 22 21 12 21 17 17 24 22 16 21 15 10 22 20 14 25 25 18 8 15 6 16 19 16 20 23 8 15 17 7 16 18 11 26 24 19 22 23 21 19 15 11 22 24 13 24 25 11 20 10 11 20 20 13 14 27 5 24 26 16 22 18 13 17 24 17 18 21 12 23 19 16 24 22 12 23 19 12 22 23 22 23 20 13 27 21 16 19 21 16 19 21 16 22 20 20 20 13 12 20 18 16 20 18 9 22 24 19 21 22 16 25 23 17 15 16 10 23 19 14 21 20 17 13 11 11 23 20 19 23 19 12 13 20 8 20 18 14 21 18 13 22 18 18 25 22 11 22 18 14 20 21 12 21 20 12 18 14 5 22 22 11 22 22 11 18 20 15 27 24 17 27 26 21 22 25 16 24 21 16 27 24 6 27 26 18 25 21 17 23 20 18 25 22 20 20 21 23 19 18 11 22 20 18 27 21 28 19 25 22 26 24 16 22 27 4 26 23 20 19 18 10 17 21 17 23 26 17 24 18 18 19 18 13 24 28 25
Names of X columns:
AMS.I1 AMS.I2 AMS.I3
Scale (list separated by spaces)
R Code
docor <- function(x,y,method) { r <- cor.test(x,y,method=method) paste(round(r$estimate,3),' (',round(r$p.value,3),')',sep='') } x <- t(x) nx <- length(x[,1]) cx <- length(x[1,]) mymedian <- median(as.numeric(strsplit(par1,' ')[[1]])) myresult <- array(NA, dim = c(cx,7)) rownames(myresult) <- paste('Q',1:cx,sep='') colnames(myresult) <- c('mean','Sum of<br />positives (Ps)','Sum of<br />negatives (Ns)', '(Ps-Ns)/(Ps+Ns)', 'Count of<br />positives (Pc)', 'Count of<br />negatives (Nc)', '(Pc-Nc)/(Pc+Nc)') for (i in 1:cx) { spos <- 0 sneg <- 0 cpos <- 0 cneg <- 0 for (j in 1:nx) { if (!is.na(x[j,i])) { myx <- as.numeric(x[j,i]) - mymedian if (myx > 0) { spos = spos + myx cpos = cpos + 1 } if (myx < 0) { sneg = sneg + abs(myx) cneg = cneg + 1 } } } myresult[i,1] <- round(mean(as.numeric(x[,i]),na.rm=T)-mymedian,2) myresult[i,2] <- spos myresult[i,3] <- sneg myresult[i,4] <- round((spos - sneg) / (spos + sneg),2) myresult[i,5] <- cpos myresult[i,6] <- cneg myresult[i,7] <- round((cpos - cneg) / (cpos + cneg),2) } myresult load(file='createtable') a<-table.start() a<-table.row.start(a) a<-table.element(a,'Summary of survey scores (median of Likert score was subtracted)',8,TRUE) a<-table.row.end(a) a<-table.row.start(a) a<-table.element(a,'Question',header=TRUE) for (i in 1:7) { a<-table.element(a,colnames(myresult)[i],header=TRUE) } a<-table.row.end(a) for (i in 1:cx) { a<-table.row.start(a) a<-table.element(a,i,header=TRUE) for (j in 1:7) { a<-table.element(a,myresult[i,j],align='right') } a<-table.row.end(a) } a<-table.end(a) table.save(a,file='mytable.tab') a<-table.start() a<-table.row.start(a) a<-table.element(a,'Pearson correlations of survey scores (and p-values)',4,TRUE) a<-table.row.end(a) a<-table.row.start(a) a<-table.element(a,'',header=TRUE) a<-table.element(a,'mean',header=TRUE) a<-table.element(a,'(Ps-Ns)/(Ps+Ns)',header=TRUE) a<-table.element(a,'(Pc-Nc)/(Pc+Nc)',header=TRUE) a<-table.row.end(a) a<-table.row.start(a) a<-table.element(a,'mean',header=TRUE) a<-table.element(a,docor(myresult[,1],myresult[,1],method='pearson'),align='right') a<-table.element(a,docor(myresult[,1],myresult[,4],method='pearson'),align='right') a<-table.element(a,docor(myresult[,1],myresult[,7],method='pearson'),align='right') a<-table.row.end(a) a<-table.row.start(a) a<-table.element(a,'(Ps-Ns)/(Ps+Ns)',header=TRUE) a<-table.element(a,docor(myresult[,4],myresult[,1],method='pearson'),align='right') a<-table.element(a,docor(myresult[,4],myresult[,4],method='pearson'),align='right') a<-table.element(a,docor(myresult[,4],myresult[,7],method='pearson'),align='right') a<-table.row.end(a) a<-table.row.start(a) a<-table.element(a,'(Pc-Nc)/(Pc+Nc)',header=TRUE) a<-table.element(a,docor(myresult[,7],myresult[,1],method='pearson'),align='right') a<-table.element(a,docor(myresult[,7],myresult[,4],method='pearson'),align='right') a<-table.element(a,docor(myresult[,7],myresult[,7],method='pearson'),align='right') a<-table.row.end(a) a<-table.end(a) table.save(a,file='mytable1.tab') a<-table.start() a<-table.row.start(a) a<-table.element(a,'Kendall tau rank correlations of survey scores (and p-values)',4,TRUE) a<-table.row.end(a) a<-table.row.start(a) a<-table.element(a,'',header=TRUE) a<-table.element(a,'mean',header=TRUE) a<-table.element(a,'(Ps-Ns)/(Ps+Ns)',header=TRUE) a<-table.element(a,'(Pc-Nc)/(Pc+Nc)',header=TRUE) a<-table.row.end(a) a<-table.row.start(a) a<-table.element(a,'mean',header=TRUE) a<-table.element(a,docor(myresult[,1],myresult[,1],method='kendall'),align='right') a<-table.element(a,docor(myresult[,1],myresult[,4],method='kendall'),align='right') a<-table.element(a,docor(myresult[,1],myresult[,7],method='kendall'),align='right') a<-table.row.end(a) a<-table.row.start(a) a<-table.element(a,'(Ps-Ns)/(Ps+Ns)',header=TRUE) a<-table.element(a,docor(myresult[,4],myresult[,1],method='kendall'),align='right') a<-table.element(a,docor(myresult[,4],myresult[,4],method='kendall'),align='right') a<-table.element(a,docor(myresult[,4],myresult[,7],method='kendall'),align='right') a<-table.row.end(a) a<-table.row.start(a) a<-table.element(a,'(Pc-Nc)/(Pc+Nc)',header=TRUE) a<-table.element(a,docor(myresult[,7],myresult[,1],method='kendall'),align='right') a<-table.element(a,docor(myresult[,7],myresult[,4],method='kendall'),align='right') a<-table.element(a,docor(myresult[,7],myresult[,7],method='kendall'),align='right') a<-table.row.end(a) a<-table.end(a) table.save(a,file='mytable2.tab')
Compute
Summary of computational transaction
Raw Input
view raw input (R code)
Raw Output
view raw output of R engine
Computing time
0 seconds
R Server
Big Analytics Cloud Computing Center
Click here to blog (archive) this computation