Send output to:
Browser Blue - Charts White
Browser Black/White
CSV
Data X:
3423.40 3242.80 3277.20 3833.00 2606.30 3643.80 3686.40 3281.60 3669.30 3191.50 3512.70 3970.70 3601.20 3610.00 4172.10 3956.20 3142.70 3884.30 3892.20 3613.00 3730.50 3481.30 3649.50 4215.20 4066.60 4196.80 4536.60 4441.60 3548.30 4735.90 4130.60 4356.20 4159.60 3988.00 4167.80 4902.20 3909.40 4697.60 4308.90 4420.40 3544.20 4433.00 4479.70 4533.20 4237.50 4207.40 4394.00 5148.40 4202.20 4682.50 4884.30 5288.90 4505.20 4611.50 5081.10 4523.10 4412.80 4647.40 4778.60 4495.30
Data Y:
12300.00 12092.80 12380.80 12196.90 9455.00 13168.00 13427.90 11980.50 11884.80 11691.70 12233.80 14341.40 13130.70 12421.10 14285.80 12864.60 11160.20 14316.20 14388.70 14013.90 13419.00 12769.60 13315.50 15332.90 14243.00 13824.40 14962.90 13202.90 12199.00 15508.90 14199.80 15169.60 14058.00 13786.20 14147.90 16541.70 13587.50 15582.40 15802.80 14130.50 12923.20 15612.20 16033.70 16036.60 14037.80 15330.60 15038.30 17401.80 14992.50 16043.70 16929.60 15921.30 14417.20 15961.00 17851.90 16483.90 14215.50 17429.70 17839.50 17629.20
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