Send output to:
Browser Blue - Charts White
Browser Black/White
CSV
Data X:
23 20 19 22 25 24 19 15 20 25 20 20 16 15 21 28 28 28 21 11 10 22 22 22 24 22 19 24 27 27 20 21 25 21 19 21 27 16 28 23 24 22 24 22 26 22 25 21 21 23 26 25 20 23 21 22 24 27 27 23 27 21 24 25 19 25 23 25 23 25 16 21 19 24 21 22 18 18 19 15 18 21 17 21 27 18 23 25 26 25 25 18 22 17 19 23 28 17 24 20 21 22 25 26 24 21 21 21 24 12 24 28 20 25 20 20 23 19 24 27 21 22 23 23 20 20 18 23 23 20 21 20 23 17 22 24 20 17 27 19 20 23 17 16 22 20 24 24 15 14 19 17 23 23 22 26 26 21 24 23 20 21 26 18 22 22 20 20 20 21 24 27 20 21 22 15 23 21 22 22 24 21 23 26 17 21 24 23 27 24 22 23 25 16 27 27 18 27 19 25 23 23 21 22 22 14 15 24 5 27 19 25 23 25 21 23 18 20 18 24 9 22 23 23 21 27 24 25 24 16 24 26 20 22 21 15 28 25 18 22 28 22 21 19 21 23 20 21 19 27 20 25 23 24 23 18 15 28 23 24 14 21 18 23 23 24 24 21 15 15 14 19 23 24 20 26 26 26 21 24 26 26 20 16 16 25 11 21 23 18 19 20 19 21 27 8 27 24 15 20 23 21 17 26 18 25 18 24 17 23 20 23 21 22 24 24 26 25 24 23 22 23 19 16 21 21 18 24 23 27 19 19 17 23 16 24 18 23 27 20 23 19 27 20 25 19 19 24 25 26 24 25 9 24 17 13 17 5 6 8 19 17 14 28 23 28 27 20 24 16 17 15 23 18 25 26 20 28 24 18 24 23 23 25 19 12 22 19 16 25 24 24 22 20 23 26 19 19 21 23 28 21 25 23 23 25 23 26 27 28 25 26 21 26 23 25 19 22 18 21 22 28 24 17 9 6 25 22 22 22 18 24 21 22 17 24 15 20 26 24 28 24 12 24 22 25 21 23 24 26 23 18 26 20 22 23 25 25 24 21 14 20 17 16 16 20 13 20 22 19 23 23 16 18 21 23 23 24 20 26 25 26 24 21 21 23 16 25 24 23 23 23 16 16 16 15 25 28 25 23 26 22 24 21 19 26 20 24 24 26 23 25 21 22 19 22 23 21 24 27 21 22 28 23 27 23 25 26 23 19 20 22 24 23 27 14 24 24 20 23 20 12 20 23 18 12 26 24 26 21 19 23 22 9 10 24 24 24 19 17 16 23 19 23 25 17 21 18 19 19 14 15 27 25 22 17 24 27 24 17 23 25 20 22 19 23 25 23 22 25 25 20 19 23 22 21 23 21 18 24 24 25 22 21 19 24 25 26 27 25 13 22 23 21 24 24 23 21 21 16 23 23 24 18 21 18 25 24 21 24 28 22 24 25 26 25 26 23 24 24 24 28 18 14 23 23 21 18 26 25 27 23 20 24 24 25 26 20 20 19 27 22 21 21 16 22 19 21 23 25 22 20 23 15 20 25 21 25 18 16 19 20 19 25 22 23 22 23 28 21 21 16 20 21 19 22 28 19 27 19 12 23 23 15 28 22 17 25 27 23 24 23 21 27 21 20 22 26 23 21 23 22 21 28 24 26 26 23 23 28 26 18 21 16 21 28 28 28 21 24 22 24 16 23 21 18 16 22 18 18 25 22 22 20 13 21 19 20 19 23 24 20 26 24 27 28 25 27 24 23 20 24 22 25 28 24 27 23 25 28 19 27 26 27 27 27 15 14 23 27 21 28 21 17 22 25 25 27 26 20 18 24 21 22 27 27 25 14 12 14 24 26 21 25 22 26 24 24 22 22 20 24 26 22 26 19 21 18 19 13 19 28 21 26 20 18 12 26 25 26 24 24 23
Names of X columns:
AMS.IE AMS.E2 AMS.E3
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