Send output to:
Browser Blue - Charts White
Browser Black/White
CSV
Data X:
274452 267700 257841 255124 247377 247823 276919 294271 281758 270434 258848 256674 258882 255060 247698 244779 240901 239933 270247 283893 282348 273570 254756 254354 255843 254490 251995 246339 244019 245953 279806 283111 281097 275964 270694 271901 274412 272433 268361 268586 264768 269974 304744 309365 308347 298427 289231 291975 294912 293488 290555 284736 281818 287854 316263 325412 326011 328282 317480 317539 313737 312276 309391 302950 300316 304035 333476 337698 335932 323931 313927 314485 313218 309664 302963 298989 298423 301631 329765 335083 327616 309119 295916 291413 291542 284678 276475 272566 264981 263290 296806 303598 286994 276427 266424 267153 268381 262522 255542 253158 243803 250741 280445 285257
Data Y:
116222 110924 103753 99983 93302 91496 119321 139261 133739 123913 113438 109416 109406 105645 101328 97686 93093 91382 122257 139183 139887 131822 116805 113706 113012 110452 107005 102841 98173 98181 137277 147579 146571 138920 130340 128140 127059 122860 117702 113537 108366 111078 150739 159129 157928 147768 137507 136919 136151 133001 125554 119647 114158 116193 152803 161761 160942 149470 139208 134588 130322 126611 122401 117352 112135 112879 148729 157230 157221 146681 136524 132111 125326 122716 116615 113719 110737 112093 143565 149946 149147 134339 122683 115614 116566 111272 104609 101802 94542 93051 124129 130374 123946 114971 105531 104919 104782 101281 94545 93248 84031 87486 115867 120327
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