Send output to:
Browser Blue - Charts White
Browser Black/White
CSV
Data:
26 51 57 37 67 43 52 52 43 84 67 49 70 52 58 68 62 43 56 56 74 65 63 58 57 63 53 57 51 64 53 29 54 51 58 43 51 53 54 56 61 47 39 48 50 35 30 68 49 61 67 47 56 50 43 67 62 57 41 54 45 48 61 56 41 43 53 44 66 58 46 37 51 51 56 66 45 37 59 42 38 66 34 53 49 55 49 59 40 58 60 63 56 54 52 34 69 32 48 67 58 57 42 64 58 66 26 61 52 51 55 50 60 56 63 61 52 16 46 56 52 55 50 59 60 52 44 67 52 55 37 54 72 51 48 60 50 63 33 67 46 54 59 61 33 47 69 52 55 55 41 73 51 52 50 51 60 56 56 29 66 66 73 55 64 40 46 58 43 61 51 50 52 54 66 61 80 51 56 56 56 53 47 25 47 46 50 39 51 58 35 58 60 62 63 53 46 67 59 64 38 50 48 48 47 66 47 63 58 44 51 43 55 38 56 45 50 54 57 60 55 56 49 37 43 59 46 51 58 64 53 48 51 47 59 62 62 51 64 52 67 50 54 58 56 63 31 65 71 50 57 47 54 47 57 43 41 63 63 56 51 50 22 41 59 56 66 53 42 52 54 44 62 53 50 36 76 66 62 59 47 55 58 60 44 57 45 58 51 57 30 46 51 56 58 44 14 53 42 49 44 62 30 46 56 50 54 48 55 35 55 41 59 54 66 55 45 51 47 42 53 53 41 55 55 46 63 43 65 59 39 44 60 57 67 52 52 69 46 46 53 40 70 54 77 45 60 47 50 66 60 41 53 34 51 69 60 45 58 39 51 52 49 63 44 51 52 60 53 53 52 31 51 65 51 49 61 58 62 54 52 72 50 65 53 56 63 62 66 50 45 58 52 53 68 59 58 52 45 58 70 69 71 46 58 39 46 64 67 44 54 41 68 63 57 61 39 69 64 38 59 51 59 51 65 47 50 57 21 47 51 37 67 43 58 51 40 41 58 64 64 58 50 59 55 59 58 41 56 63 77 60 58 64 47 46 62 60 50 46 44 58 56 43 54 54 56 65 66 62 58 67 25 56 53 56 59 46 49 56 76 33 49 53 58 72 51 42 69 51 54 52 59 51 67 64 58 53
Type of transformation
Full Box-Cox transform
Full Box-Cox transform
Simple Box-Cox transform
Minimum lambda
-2
-2
-8
-7
-6
-5
-4
-3
-2
-1
Maximum lambda
2
2
1
2
3
4
5
6
7
8
Constant term to be added before analysis is performed
(?)
Display table with original and transformed data?
No
No
Yes
Chart options
R Code
par2 <- abs(as.numeric(par2)*100) par3 <- as.numeric(par3)*100 if(par4=='') par4 <- 0 par4 <- as.numeric(par4) numlam <- par2 + par3 + 1 x <- x + par4 n <- length(x) c <- array(NA,dim=c(numlam)) l <- array(NA,dim=c(numlam)) mx <- -1 mxli <- -999 for (i in 1:numlam) { l[i] <- (i-par2-1)/100 if (l[i] != 0) { if (par1 == 'Full Box-Cox transform') x1 <- (x^l[i] - 1) / l[i] if (par1 == 'Simple Box-Cox transform') x1 <- x^l[i] } else { x1 <- log(x) } c[i] <- cor(qnorm(ppoints(x), mean=0, sd=1),x1) if (mx < c[i]) { mx <- c[i] mxli <- l[i] x1.best <- x1 } } c mx mxli x1.best if (mxli != 0) { if (par1 == 'Full Box-Cox transform') x1 <- (x^mxli - 1) / mxli if (par1 == 'Simple Box-Cox transform') x1 <- x^mxli } else { x1 <- log(x) } bitmap(file='test1.png') plot(l,c,main='Box-Cox Normality Plot', xlab='Lambda',ylab='correlation') mtext(paste('Optimal Lambda =',mxli)) grid() dev.off() bitmap(file='test2.png') hist(x,main='Histogram of Original Data',xlab='X',ylab='frequency') grid() dev.off() bitmap(file='test3.png') hist(x1,main='Histogram of Transformed Data', xlab='X',ylab='frequency') grid() dev.off() bitmap(file='test4.png') qqnorm(x) qqline(x) grid() mtext('Original Data') dev.off() bitmap(file='test5.png') qqnorm(x1) qqline(x1) grid() mtext('Transformed Data') dev.off() load(file='createtable') a<-table.start() a<-table.row.start(a) a<-table.element(a,'Box-Cox Normality Plot',2,TRUE) a<-table.row.end(a) a<-table.row.start(a) a<-table.element(a,'# observations x',header=TRUE) a<-table.element(a,n) a<-table.row.end(a) a<-table.row.start(a) a<-table.element(a,'maximum correlation',header=TRUE) a<-table.element(a,mx) a<-table.row.end(a) a<-table.row.start(a) a<-table.element(a,'optimal lambda',header=TRUE) a<-table.element(a,mxli) a<-table.row.end(a) if(mx<0) { a<-table.row.start(a) a<-table.element(a,'Warning: maximum correlation is negative! The Box-Cox transformation must not be used.',2) a<-table.row.end(a) } a<-table.end(a) table.save(a,file='mytable.tab') if(par5=='Yes') { a<-table.start() a<-table.row.start(a) a<-table.element(a,'Obs.',header=T) a<-table.element(a,'Original',header=T) a<-table.element(a,'Transformed',header=T) a<-table.row.end(a) for (i in 1:n) { a<-table.row.start(a) a<-table.element(a,i) a<-table.element(a,x[i]) a<-table.element(a,x1.best[i]) a<-table.row.end(a) } a<-table.end(a) table.save(a,file='mytable1.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