Send output to:
Browser Blue - Charts White
Browser Black/White
CSV
Data X:
8638.7 11063.7 11855.7 10684.5 11337.4 10478 11123.9 12909.3 11339.9 10462.2 12733.5 10519.2 10414.9 12476.8 12384.6 12266.7 12919.9 11497.3 12142 13919.4 12656.8 12034.1 13199.7 10881.3 11301.2 13643.9 12517 13981.1 14275.7 13435 13565.7 16216.3 12970 14079.9 14235 12213.4 12581 14130.4 14210.8 14378.5 13142.8 13714.7 13621.9 15379.8 13306.3 14391.2 14909.9 14025.4 12951.2 14344.3 16213.3 15544.5 14750.6 17292.7 17568.5 17930.8 18644.7 16694.8 17242.8 16979.9
Data Y:
3219.2 3552.3 3787.7 3392.7 3550 3681.9 3519.1 4283.2 4046.2 3824.9 4793.1 3977.7 3983.4 4152.9 4286.1 4348.1 3949.3 4166.7 4217.9 4528.2 4232.2 4470.9 5121.2 4170.8 4398.6 4491.4 4251.8 4901.9 4745.2 4666.9 4210.4 5273.6 4095.3 4610.1 4718.1 4185.5 4314.7 4422.6 5059.2 5043.6 4436.6 4922.6 4454.8 5058.7 4768.9 5171.8 4989.3 5202.1 4838.4 4876.5 5845.3 5686.3 4753.8 6620.4 5597.2 5643.5 6357.3 5909.1 6165.8 6321.6
Sample Range:
(leave blank to include all observations)
From:
To:
Chart options
Label y-axis:
Label x-axis:
R Code
n <- length(x) c <- array(NA,dim=c(401)) l <- array(NA,dim=c(401)) mx <- 0 mxli <- -999 for (i in 1:401) { l[i] <- (i-201)/100 if (l[i] != 0) { x1 <- (x^l[i] - 1) / l[i] } else { x1 <- log(x) } c[i] <- cor(x1,y) if (mx < abs(c[i])) { mx <- abs(c[i]) mxli <- l[i] } } c mx mxli if (mxli != 0) { x1 <- (x^mxli - 1) / mxli } else { x1 <- log(x) } r<-lm(y~x) se <- sqrt(var(r$residuals)) r1 <- lm(y~x1) se1 <- sqrt(var(r1$residuals)) bitmap(file='test1.png') plot(l,c,main='Box-Cox Linearity Plot',xlab='Lambda',ylab='correlation') grid() dev.off() bitmap(file='test2.png') plot(x,y,main='Linear Fit of Original Data',xlab='x',ylab='y') abline(r) grid() mtext(paste('Residual Standard Deviation = ',se)) dev.off() bitmap(file='test3.png') plot(x1,y,main='Linear Fit of Transformed Data',xlab='x',ylab='y') abline(r1) grid() mtext(paste('Residual Standard Deviation = ',se1)) dev.off() load(file='createtable') a<-table.start() a<-table.row.start(a) a<-table.element(a,'Box-Cox Linearity 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(x)',header=TRUE) a<-table.element(a,mxli) a<-table.row.end(a) a<-table.row.start(a) a<-table.element(a,'Residual SD (orginial)',header=TRUE) a<-table.element(a,se) a<-table.row.end(a) a<-table.row.start(a) a<-table.element(a,'Residual SD (transformed)',header=TRUE) a<-table.element(a,se1) a<-table.row.end(a) a<-table.end(a) table.save(a,file='mytable.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