Send output to:
Browser Blue - Charts White
Browser Black/White
CSV
Data X:
124.06 124.58 122.00 124.02 124.16 124.29 123.93 124.62 121.81 124.14 124.31 125.15 125.35 125.48 124.17 125.33 124.46 123.39 123.14 122.24 119.31 120.87 120.43 119.41 118.85 119.08 117.25 118.51 118.42 118.56 117.97 117.98 115.25 117.23 117.08 116.83 117.17 117.73 115.74 116.99 116.90 116.49 115.84 115.92 113.32 114.84 114.75 114.84 115.03 115.03 112.99 114.15 113.77 113.57 113.38 112.71 110.27 111.73 112.12 112.31 111.73 111.83 109.99 111.15 111.25 110.87 110.27 110.18 108.15 109.60 109.60 109.41 109.80 109.60 107.76 109.02 108.62 109.02 109.22 108.92 106.69 107.76 107.66 107.85 107.95 107.85 106.30 107.37 107.66 107.46 107.37 107.18 105.43 106.39 106.50 106.50 106.69 106.50 105.14 106.50 106.20 105.72 104.76 104.55 102.71 104.36 104.65 104.46 104.65 103.88 102.32 103.39 103.00 102.71 102.51 102.04 100.00
Data Y:
241.66 251.25 230.26 240.91 211.20 188.19 177.01 167.85 174.03 170.09 203.42 254.97 342.84 386.29 440.51 433.58 408.13 370.32 355.51 332.62 314.62 301.73 306.31 282.98 266.48 249.97 259.87 246.24 238.36 238.04 224.19 214.71 203.11 221.00 211.73 209.39 217.48 242.19 244.64 232.07 235.80 230.37 209.82 206.41 209.60 192.24 186.17 193.41 202.36 203.00 190.64 185.43 171.58 179.57 180.42 162.10 157.95 146.66 154.43 163.38 150.92 151.98 144.74 140.37 143.36 135.79 134.73 126.42 124.72 117.90 114.07 112.26 105.44 110.77 107.68 105.76 102.03 100.22 111.62 118.11 111.72 103.42 97.13 103.10 104.91 100.22 98.52 95.32 96.92 96.60 92.55 82.75 80.84 79.13 79.77 85.10 96.39 97.56 96.39 101.18 103.52 100.11 99.26 104.48 101.29 100.33 115.24 113.64 115.35 108.42 105.65 108.64 104.80 95.43 104.48 103.84 100.01
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
1 seconds
R Server
Big Analytics Cloud Computing Center
Click here to blog (archive) this computation