• QR Code (size=2)
• QR Code (size=3)
• QR Code (size=4)
• QR Code (size=5)
• QR Code (size=6)

14	0	0	7	17	22	0
21	0	1	8	19	39	0
20	0	1	8	18	40	0
20	0	1	10	17	34	0
20	0	1	8	17	38	0
18	1	1	9	19	39	1
18	0	1	8	19	39	0
17	0	0	10	12	38	0
15	0	0	7	15	31	0
18	0	1	10	16	34	0
16	1	1	8	16	32	1
17	1	0	8	14	37	0
19	1	1	6	15	36	1
21	0	0	7	16	38	0
15	0	0	9	14	29	0
21	1	1	9	18	33	1
16	0	0	8	15	35	0
18	1	1	8	18	34	1
18	1	1	10	19	45	1
17	0	0	7	15	30	0
18	0	1	7	17	33	0
16	0	0	7	9	30	0
15	0	0	6	18	40	0
15	0	1	9	17	34	0
19	1	0	7	15	31	0
14	1	1	8	13	27	1
19	0	1	10	17	33	0
19	0	0	9	14	42	0
15	0	0	8	15	36	0
17	0	0	8	14	33	0
21	1	1	10	17	42	1
13	0	0	8	14	33	0
12	0	1	4	13	21	0
15	0	1	6	19	43	0
19	0	1	7	15	34	0
19	1	1	7	14	32	1
14	1	0	3	11	34	0
18	1	1	8	16	28	1
11	1	0	8	13	30	0
17	1	1	6	15	27	1
18	1	0	10	17	29	0
13	0	0	8	15	40	0
12	1	1	4	12	29	1
17	0	0	8	15	41	0
20	0	0	7	15	33	0
16	0	1	6	8	42	0
22	0	1	9	16	39	0
16	0	1	10	12	35	0
23	0	1	9	13	33	0
20	0	1	7	16	33	0
23	0	1	10	16	44	0
13	1	0	7	8	34	0
18	0	0	10	14	30	0
18	1	0	9	15	30	0
17	1	1	7	16	35	1
17	1	1	10	16	39	1
18	0	0	8	17	34	0
21	1	1	8	18	39	1
13	0	0	6	9	25	0
19	0	0	9	19	39	0
16	0	1	7	14	33	0
17	0	1	8	14	34	0
18	0	1	8	15	36	0
18	0	1	9	19	34	0
12	1	0	5	12	31	0
19	0	1	9	17	35	0
16	0	1	6	16	34	0
20	0	1	8	17	36	0
21	0	1	10	15	40	0
18	0	1	7	11	31	0
13	1	1	5	8	33	1
17	0	0	4	16	28	0
20	1	1	9	20	42	1
21	0	1	10	20	38	0
19	0	0	8	13	35	0
15	0	1	6	11	34	0
14	0	0	6	15	28	0
15	0	1	9	15	35	0
16	0	1	3	14	25	0
19	0	0	7	16	39	0
17	0	0	9	15	25	0
17	0	1	7	15	32	0
15	0	0	8	16	35	0
19	1	0	9	19	41	0
21	0	1	9	20	34	0
19	1	1	8	14	33	1
18	0	0	9	16	32	0
18	0	0	6	14	34	0
15	0	0	7	11	25	0
19	0	1	8	16	38	0
19	0	1	7	16	37	0
18	0	1	9	15	38	0
20	0	1	9	16	36	0
18	1	0	5	12	39	0
12	0	0	6	13	31	0
15	0	0	8	11	40	0
17	1	0	10	20	34	0
15	1	0	5	11	33	0
17	0	0	8	14	32	0
20	0	1	8	16	33	0
11	0	1	10	15	32	0
14	0	0	7	13	28	0
14	0	0	9	15	32	0
12	0	0	8	13	34	0
19	0	1	8	17	36	0
22	0	1	10	18	38	0
16	0	0	9	14	31	0
15	0	1	9	13	36	0
15	0	1	6	12	27	0
18	0	0	8	17	31	0
12	1	1	5	6	28	1
17	1	1	3	9	30	1
10	1	1	6	15	29	1
10	1	1	6	15	29	1
18	0	1	10	17	31	0
16	1	1	9	19	35	1
22	0	1	9	20	42	0
12	0	0	5	10	28	0
10	0	1	6	9	38	0
20	0	1	7	15	34	0
20	0	1	8	16	28	0
19	0	1	9	16	30	0
10	1	0	3	9	26	0
13	1	0	5	10	27	0
15	1	0	5	9	31	0
19	0	0	9	17	35	0
17	1	1	10	17	33	1
15	1	1	7	19	34	1
12	0	0	8	10	30	0
14	0	1	6	12	28	0
13	1	0	5	9	30	0
15	1	1	8	11	29	1
20	1	1	7	17	32	1
12	1	1	5	9	34	1
16	1	0	6	14	34	0
15	1	1	10	19	35	1
17	1	1	10	17	40	1
15	1	1	6	13	34	1
12	1	1	4	11	28	1
17	1	0	8	14	35	0
11	1	1	5	7	31	1
16	1	1	7	17	33	1
16	1	1	10	16	36	1
15	1	1	8	12	30	1
17	0	0	7	10	27	0
7	0	1	2	10	30	0
14	0	1	7	8	25	0
21	0	1	9	18	39	0
20	1	1	8	15	36	1
15	0	0	5	18	31	0
13	1	0	8	14	33	0
20	0	0	6	16	30	0
15	1	0	7	11	31	0
16	1	1	10	16	32	1
19	0	0	8	17	33	0
16	1	1	10	20	43	1
19	1	0	9	14	35	0
17	1	1	8	16	36	1
19	1	1	10	17	42	1
14	0	0	4	11	31	0
16	0	1	6	13	26	0
16	0	0	9	11	38	0
14	1	0	4	8	27	0
11	1	1	6	9	27	1
17	0	0	7	9	31	0
20	0	1	9	12	32	0
20	1	1	8	15	36	1
17	0	0	6	18	36	0
13	1	1	4	10	25	1
20	1	0	8	15	33	0
17	0	0	8	16	32	0
16	0	1	9	18	40	0
19	0	0	6	15	36	0
20	1	0	5	17	36	0
17	0	1	5	17	35	0
14	1	1	8	14	31	1
20	1	1	8	17	31	1
19	1	1	9	13	36	1
18	1	0	7	16	36	0
17	1	1	9	12	37	1
17	1	0	8	17	31	0
10	0	0	6	10	31	0
12	0	1	7	9	26	0
19	0	1	8	15	35	0
19	1	0	8	14	32	0
21	1	0	7	16	36	0
21	0	0	7	17	37	0
17	0	0	8	18	34	0
19	1	1	8	14	33	1
21	1	0	9	17	35	0
15	1	1	9	14	31	1
14	0	1	9	15	38	0
15	1	0	8	14	36	0
13	1	1	2	10	32	1
14	0	1	8	9	28	0
14	0	1	8	12	33	0
19	1	1	8	13	31	1
17	0	1	7	14	34	0
19	1	1	10	18	33	1
18	1	1	8	15	36	1
21	1	1	10	14	36	1
12	0	1	5	10	29	0
15	1	0	4	9	31	0
19	1	1	10	17	35	1
16	1	1	8	12	31	1
19	1	0	7	16	35	0
16	1	0	5	11	36	0
18	1	1	7	13	35	1
18	1	0	9	12	38	0
15	1	0	8	15	28	0
15	1	0	8	15	28	0
11	1	1	2	10	28	1
18	1	1	9	16	34	1
13	1	1	8	11	31	1
9	1	1	5	14	44	1
21	1	0	7	17	36	0
19	1	1	8	16	36	1
13	1	1	7	16	34	1
15	0	0	5	11	32	0
18	1	1	10	16	36	1
16	1	0	6	13	38	0
10	1	1	6	7	28	1
12	1	0	5	13	37	0
18	1	1	7	14	32	1
17	1	1	8	14	36	1
15	1	0	8	9	30	0
16	1	1	4	15	38	1
19	0	0	9	16	37	0
15	1	0	4	11	33	0
24	1	1	10	20	43	1
15	1	1	6	14	26	1
14	1	0	6	9	33	0
16	1	0	8	16	34	0
16	1	0	8	13	36	0
20	1	0	8	15	36	0
20	1	0	8	15	36	0
20	1	0	8	15	36	0
20	1	0	8	15	39	0
14	1	1	7	14	33	1
22	1	1	7	15	35	1
16	1	1	8	13	25	1
9	0	1	10	12	26	0
14	1	0	10	17	35	0
11	1	1	3	8	16	1
23	0	0	8	17	40	0
10	0	1	2	10	14	0
10	0	0	4	9	22	0
8	0	0	4	9	21	0
21	1	0	9	15	38	0
18	1	1	10	14	38	1
15	1	1	6	12	27	1
20	1	1	10	16	40	1
17	0	1	10	19	40	0
5	1	0	3	6	19	0
14	1	1	9	11	29	1
19	1	0	9	16	37	0
15	1	1	6	12	27	1
12	1	1	5	12	26	1
10	0	0	4	8	24	0
11	1	1	4	11	29	1
15	1	1	6	8	26	1
15	1	1	6	12	27	1
20	0	1	8	16	35	0
20	1	1	8	18	39	1
20	1	1	5	16	38	1
19	0	1	7	15	36	0
16	1	1	6	20	37	1
21	1	0	10	10	36	0
22	1	1	8	15	32	1
17	1	1	8	14	33	1
21	1	1	9	14	39	1
19	1	0	5	8	34	0
23	1	1	10	19	39	1
21	1	1	8	17	36	1
22	1	1	9	18	33	1
11	1	0	8	10	30	0
20	1	0	7	15	39	0
18	1	0	10	16	37	0
16	1	0	10	12	37	0
18	1	1	9	13	35	1
13	1	0	4	10	32	0
17	1	1	4	14	36	1
20	1	1	8	15	36	1
20	1	1	9	20	41	1
15	1	1	10	9	36	1
18	1	0	8	12	37	0
15	1	0	5	13	29	0
19	1	1	10	16	39	1
19	1	0	8	12	37	0
19	1	1	7	14	32	1
20	1	1	8	15	36	1
20	1	1	8	19	43	1
16	1	0	9	16	30	0
18	1	0	8	16	33	0
17	1	1	6	14	28	1
18	1	1	8	14	30	1
13	1	0	8	14	28	0
20	0	1	5	13	39	0
21	1	1	9	18	34	1
17	1	0	8	15	34	0
19	1	0	8	15	29	0
20	1	0	8	15	32	0
15	1	0	6	13	33	0
15	1	0	6	14	27	0
19	1	1	9	15	35	1
18	1	1	8	14	38	1
22	1	1	9	19	40	1
20	1	1	10	16	34	1
18	0	0	8	16	34	0
14	1	0	8	12	26	0
15	1	0	7	10	39	0
17	1	1	7	11	34	1
16	1	1	10	13	39	1
17	1	1	8	14	26	1
15	1	1	7	11	30	1
17	1	1	10	11	34	1
18	1	1	7	16	34	1
16	1	0	7	9	29	0
18	1	0	9	16	41	0
22	1	0	9	19	43	0
16	1	0	8	13	31	0
16	1	0	6	15	33	0
20	1	0	8	14	34	0
18	1	1	9	15	30	1
16	0	0	2	11	23	0
16	1	0	6	14	29	0
20	1	1	8	15	35	1
21	0	1	8	17	40	0
18	0	0	7	16	27	0
15	1	0	8	13	30	0
18	1	0	6	15	27	0
18	1	0	10	14	29	0
20	1	0	10	15	33	0
18	1	0	10	14	32	0
16	1	0	8	12	33	0
19	1	1	8	12	36	1
20	1	1	7	15	34	1
22	1	1	10	17	45	1
18	0	0	5	13	30	0
8	0	1	3	5	22	0
13	0	1	2	7	24	0
13	0	1	3	10	25	0
18	0	1	4	15	26	0
12	0	0	2	9	27	0
16	0	0	6	9	27	0
21	1	0	8	15	35	0
20	1	0	8	14	36	0
18	0	0	5	11	32	0
22	1	1	10	18	35	1
23	1	1	9	20	35	1
23	1	1	8	20	36	1
21	1	1	9	16	37	1
16	1	1	8	15	33	1
14	1	0	5	14	25	0
18	1	1	7	13	35	1
22	1	1	9	18	37	1
20	1	0	8	14	36	0
18	1	1	4	12	35	1
12	1	1	7	9	29	1
17	1	1	8	19	35	1
15	1	0	7	13	31	0
18	1	1	7	12	30	1
18	1	0	9	14	37	0
15	1	1	6	6	36	1
16	1	0	7	14	35	0
15	1	0	4	11	32	0
16	1	1	6	11	34	1
19	1	0	10	14	37	0
19	1	1	9	12	36	1
23	1	1	10	19	39	1
20	1	0	8	13	37	0
18	0	0	4	14	31	0
21	1	1	8	17	40	1
19	1	0	5	12	38	0
18	0	1	8	16	35	0
19	0	1	9	15	38	0
17	1	0	8	15	32	0
21	1	1	4	15	41	1
19	1	0	8	16	28	0
24	1	1	10	15	40	1
12	1	0	6	12	25	0
15	1	0	7	13	28	0
18	1	1	10	14	37	1
19	1	1	9	17	37	1
22	1	1	8	14	40	1
19	0	0	3	14	26	0
16	1	0	8	14	30	0
19	1	0	7	15	32	0
18	1	0	7	11	31	0
18	1	0	8	11	28	0
19	1	1	8	16	34	1
21	1	0	7	12	39	0
19	0	1	7	12	33	0
22	1	0	9	19	43	0
23	0	1	9	18	37	0
17	1	0	9	16	31	0
18	0	1	4	16	31	0
19	1	0	6	13	34	0
15	1	1	6	11	32	1
14	0	0	6	10	27	0
18	1	0	8	14	34	0
17	0	0	3	14	28	0
19	0	0	8	14	32	0
16	0	1	8	16	39	0
14	0	1	6	10	28	0
20	1	0	10	16	39	0
16	0	0	2	7	32	0
18	0	1	9	16	36	0
16	0	1	6	15	31	0
21	0	0	6	17	39	0
16	0	0	5	11	23	0
14	0	0	4	11	25	0
16	1	0	7	10	32	0
19	0	1	5	13	32	0
19	0	1	8	14	36	0
19	0	0	6	13	39	0
18	0	1	9	13	31	0
16	1	0	6	12	32	0
14	0	1	4	10	28	0
19	0	0	7	15	34	0
11	0	1	2	6	28	0
18	1	1	8	15	38	1
18	1	1	9	15	35	1
16	1	0	6	11	32	0
20	0	1	5	14	26	0
18	0	1	7	14	32	0
20	1	1	8	16	28	1
16	1	0	4	12	31	0
18	0	1	9	15	33	0
19	1	0	9	20	38	0
19	0	1	9	12	38	0
15	0	0	7	9	36	0
17	1	1	5	13	31	1
21	0	0	7	15	36	0
24	1	1	9	19	43	1
16	1	1	8	11	37	1
13	0	1	6	11	28	0
21	0	1	9	17	35	0
16	1	1	8	15	34	1
17	1	1	7	14	40	1
17	1	0	7	15	31	0
18	0	0	7	11	41	0
18	1	0	8	12	35	0
23	1	1	10	15	38	1
20	0	0	6	16	37	0
20	0	0	6	16	31	0

par6 <- '12'
par5 <- ''
par4 <- ''
par3 <- 'TRUE'
par2 <- 'Do not include Seasonal Dummies'
par1 <- '1'
library(lattice)
library(lmtest)
library(car)
library(MASS)
n25 <- 25 #minimum number of obs. for Goldfeld-Quandt test
mywarning <- ''
par6 <- as.numeric(par6)
if(is.na(par6)) {
par6 <- 12
mywarning = 'Warning: you did not specify the seasonality. The seasonal period was set to s = 12.'
}
par1 <- as.numeric(par1)
if(is.na(par1)) {
par1 <- 1
mywarning = 'Warning: you did not specify the column number of the endogenous series! The first column was selected by default.'
}
if (par4=='') par4 <- 0
par4 <- as.numeric(par4)
if (!is.numeric(par4)) par4 <- 0
if (par5=='') par5 <- 0
par5 <- as.numeric(par5)
if (!is.numeric(par5)) par5 <- 0
x <- na.omit(t(y))
k <- length(x[1,])
n <- length(x[,1])
x1 <- cbind(x[,par1], x[,1:k!=par1])
mycolnames <- c(colnames(x)[par1], colnames(x)[1:k!=par1])
colnames(x1) <- mycolnames #colnames(x)[par1]
x <- x1
if (par3 == 'First Differences'){
(n <- n -1)
x2 <- array(0, dim=c(n,k), dimnames=list(1:n, paste('(1-B)',colnames(x),sep='')))
for (i in 1:n) {
for (j in 1:k) {
x2[i,j] <- x[i+1,j] - x[i,j]
}
}
x <- x2
}
if (par3 == 'Seasonal Differences (s)'){
(n <- n - par6)
x2 <- array(0, dim=c(n,k), dimnames=list(1:n, paste('(1-Bs)',colnames(x),sep='')))
for (i in 1:n) {
for (j in 1:k) {
x2[i,j] <- x[i+par6,j] - x[i,j]
}
}
x <- x2
}
if (par3 == 'First and Seasonal Differences (s)'){
(n <- n -1)
x2 <- array(0, dim=c(n,k), dimnames=list(1:n, paste('(1-B)',colnames(x),sep='')))
for (i in 1:n) {
for (j in 1:k) {
x2[i,j] <- x[i+1,j] - x[i,j]
}
}
x <- x2
(n <- n - par6)
x2 <- array(0, dim=c(n,k), dimnames=list(1:n, paste('(1-Bs)',colnames(x),sep='')))
for (i in 1:n) {
for (j in 1:k) {
x2[i,j] <- x[i+par6,j] - x[i,j]
}
}
x <- x2
}
if(par4 > 0) {
x2 <- array(0, dim=c(n-par4,par4), dimnames=list(1:(n-par4), paste(colnames(x)[par1],'(t-',1:par4,')',sep='')))
for (i in 1:(n-par4)) {
for (j in 1:par4) {
x2[i,j] <- x[i+par4-j,par1]
}
}
x <- cbind(x[(par4+1):n,], x2)
n <- n - par4
}
if(par5 > 0) {
x2 <- array(0, dim=c(n-par5*par6,par5), dimnames=list(1:(n-par5*par6), paste(colnames(x)[par1],'(t-',1:par5,'s)',sep='')))
for (i in 1:(n-par5*par6)) {
for (j in 1:par5) {
x2[i,j] <- x[i+par5*par6-j*par6,par1]
}
}
x <- cbind(x[(par5*par6+1):n,], x2)
n <- n - par5*par6
}
if (par2 == 'Include Seasonal Dummies'){
x2 <- array(0, dim=c(n,par6-1), dimnames=list(1:n, paste('M', seq(1:(par6-1)), sep ='')))
for (i in 1:(par6-1)){
x2[seq(i,n,par6),i] <- 1
}
x <- cbind(x, x2)
}
if (par2 == 'Include Monthly Dummies'){
x2 <- array(0, dim=c(n,11), dimnames=list(1:n, paste('M', seq(1:11), sep ='')))
for (i in 1:11){
x2[seq(i,n,12),i] <- 1
}
x <- cbind(x, x2)
}
if (par2 == 'Include Quarterly Dummies'){
x2 <- array(0, dim=c(n,3), dimnames=list(1:n, paste('Q', seq(1:3), sep ='')))
for (i in 1:3){
x2[seq(i,n,4),i] <- 1
}
x <- cbind(x, x2)
}
(k <- length(x[n,]))
if (par3 == 'Linear Trend'){
x <- cbind(x, c(1:n))
colnames(x)[k+1] <- 't'
}
print(x)
(k <- length(x[n,]))
head(x)
df <- as.data.frame(x)
(mylm <- lm(df))
(mysum <- summary(mylm))
if (n > n25) {
kp3 <- k + 3
nmkm3 <- n - k - 3
gqarr <- array(NA, dim=c(nmkm3-kp3+1,3))
numgqtests <- 0
numsignificant1 <- 0
numsignificant5 <- 0
numsignificant10 <- 0
for (mypoint in kp3:nmkm3) {
j <- 0
numgqtests <- numgqtests + 1
for (myalt in c('greater', 'two.sided', 'less')) {
j <- j + 1
gqarr[mypoint-kp3+1,j] <- gqtest(mylm, point=mypoint, alternative=myalt)$p.value
}
if (gqarr[mypoint-kp3+1,2] < 0.01) numsignificant1 <- numsignificant1 + 1
if (gqarr[mypoint-kp3+1,2] < 0.05) numsignificant5 <- numsignificant5 + 1
if (gqarr[mypoint-kp3+1,2] < 0.10) numsignificant10 <- numsignificant10 + 1
}
gqarr
}
bitmap(file='test0.png')
plot(x[,1], type='l', main='Actuals and Interpolation', ylab='value of Actuals and Interpolation (dots)', xlab='time or index')
points(x[,1]-mysum$resid)
grid()
dev.off()
bitmap(file='test1.png')
plot(mysum$resid, type='b', pch=19, main='Residuals', ylab='value of Residuals', xlab='time or index')
grid()
dev.off()
bitmap(file='test2.png')
sresid <- studres(mylm)
hist(sresid, freq=FALSE, main='Distribution of Studentized Residuals')
xfit<-seq(min(sresid),max(sresid),length=40)
yfit<-dnorm(xfit)
lines(xfit, yfit)
grid()
dev.off()
bitmap(file='test3.png')
densityplot(~mysum$resid,col='black',main='Residual Density Plot', xlab='values of Residuals')
dev.off()
bitmap(file='test4.png')
qqPlot(mylm, main='QQ Plot')
grid()
dev.off()
(myerror <- as.ts(mysum$resid))
bitmap(file='test5.png')
dum <- cbind(lag(myerror,k=1),myerror)
dum
dum1 <- dum[2:length(myerror),]
dum1
z <- as.data.frame(dum1)
print(z)
plot(z,main=paste('Residual Lag plot, lowess, and regression line'), ylab='values of Residuals', xlab='lagged values of Residuals')
lines(lowess(z))
abline(lm(z))
grid()
dev.off()
bitmap(file='test6.png')
acf(mysum$resid, lag.max=length(mysum$resid)/2, main='Residual Autocorrelation Function')
grid()
dev.off()
bitmap(file='test7.png')
pacf(mysum$resid, lag.max=length(mysum$resid)/2, main='Residual Partial Autocorrelation Function')
grid()
dev.off()
bitmap(file='test8.png')
opar <- par(mfrow = c(2,2), oma = c(0, 0, 1.1, 0))
plot(mylm, las = 1, sub='Residual Diagnostics')
par(opar)
dev.off()
if (n > n25) {
bitmap(file='test9.png')
plot(kp3:nmkm3,gqarr[,2], main='Goldfeld-Quandt test',ylab='2-sided p-value',xlab='breakpoint')
grid()
dev.off()
}
load(file='createtable')
a<-table.start()
a<-table.row.start(a)
a<-table.element(a, 'Multiple Linear Regression - Estimated Regression Equation', 1, TRUE)
a<-table.row.end(a)
myeq <- colnames(x)[1]
myeq <- paste(myeq, '[t] = ', sep='')
for (i in 1:k){
if (mysum$coefficients[i,1] > 0) myeq <- paste(myeq, '+', '')
myeq <- paste(myeq, signif(mysum$coefficients[i,1],6), sep=' ')
if (rownames(mysum$coefficients)[i] != '(Intercept)') {
myeq <- paste(myeq, rownames(mysum$coefficients)[i], sep='')
if (rownames(mysum$coefficients)[i] != 't') myeq <- paste(myeq, '[t]', sep='')
}
}
myeq <- paste(myeq, ' + e[t]')
a<-table.row.start(a)
a<-table.element(a, myeq)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, mywarning)
a<-table.row.end(a)
a<-table.end(a)
table.save(a,file='mytable1.tab')
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,'Multiple Linear Regression - Ordinary Least Squares', 6, TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'Variable',header=TRUE)
a<-table.element(a,'Parameter',header=TRUE)
a<-table.element(a,'S.D.',header=TRUE)
a<-table.element(a,'T-STAT
H0: parameter = 0',header=TRUE)
a<-table.element(a,'2-tail p-value',header=TRUE)
a<-table.element(a,'1-tail p-value',header=TRUE)
a<-table.row.end(a)
for (i in 1:k){
a<-table.row.start(a)
a<-table.element(a,rownames(mysum$coefficients)[i],header=TRUE)
a<-table.element(a,formatC(signif(mysum$coefficients[i,1],5),format='g',flag='+'))
a<-table.element(a,formatC(signif(mysum$coefficients[i,2],5),format='g',flag=' '))
a<-table.element(a,formatC(signif(mysum$coefficients[i,3],4),format='e',flag='+'))
a<-table.element(a,formatC(signif(mysum$coefficients[i,4],4),format='g',flag=' '))
a<-table.element(a,formatC(signif(mysum$coefficients[i,4]/2,4),format='g',flag=' '))
a<-table.row.end(a)
}
a<-table.end(a)
table.save(a,file='mytable2.tab')
a<-table.start()
a<-table.row.start(a)
a<-table.element(a, 'Multiple Linear Regression - Regression Statistics', 2, TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'Multiple R',1,TRUE)
a<-table.element(a,formatC(signif(sqrt(mysum$r.squared),6),format='g',flag=' '))
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'R-squared',1,TRUE)
a<-table.element(a,formatC(signif(mysum$r.squared,6),format='g',flag=' '))
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'Adjusted R-squared',1,TRUE)
a<-table.element(a,formatC(signif(mysum$adj.r.squared,6),format='g',flag=' '))
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'F-TEST (value)',1,TRUE)
a<-table.element(a,formatC(signif(mysum$fstatistic[1],6),format='g',flag=' '))
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'F-TEST (DF numerator)',1,TRUE)
a<-table.element(a, signif(mysum$fstatistic[2],6))
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'F-TEST (DF denominator)',1,TRUE)
a<-table.element(a, signif(mysum$fstatistic[3],6))
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'p-value',1,TRUE)
a<-table.element(a,formatC(signif(1-pf(mysum$fstatistic[1],mysum$fstatistic[2],mysum$fstatistic[3]),6),format='g',flag=' '))
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'Multiple Linear Regression - Residual Statistics', 2, TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'Residual Standard Deviation',1,TRUE)
a<-table.element(a,formatC(signif(mysum$sigma,6),format='g',flag=' '))
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'Sum Squared Residuals',1,TRUE)
a<-table.element(a,formatC(signif(sum(myerror*myerror),6),format='g',flag=' '))
a<-table.row.end(a)
a<-table.end(a)
table.save(a,file='mytable3.tab')
myr <- as.numeric(mysum$resid)
myr
a <-table.start()
a <- table.row.start(a)
a <- table.element(a,'Menu of Residual Diagnostics',2,TRUE)
a <- table.row.end(a)
a <- table.row.start(a)
a <- table.element(a,'Description',1,TRUE)
a <- table.element(a,'Link',1,TRUE)
a <- table.row.end(a)
a <- table.row.start(a)
a <-table.element(a,'Histogram',1,header=TRUE)
a <- table.element(a,hyperlink( paste('https://supernova.wessa.net/rwasp_histogram.wasp?convertgetintopost=1&data=',paste(as.character(mysum$resid),sep='',collapse=' '),sep='') ,'Compute','Click here to examine the Residuals.'),1)
a <- table.row.end(a)
a <- table.row.start(a)
a <-table.element(a,'Central Tendency',1,header=TRUE)
a <- table.element(a,hyperlink( paste('https://supernova.wessa.net/rwasp_centraltendency.wasp?convertgetintopost=1&data=',paste(as.character(mysum$resid),sep='',collapse=' '),sep='') ,'Compute','Click here to examine the Residuals.'),1)
a <- table.row.end(a)
a <- table.row.start(a)
a <-table.element(a,'QQ Plot',1,header=TRUE)
a <- table.element(a,hyperlink( paste('https://supernova.wessa.net/rwasp_fitdistrnorm.wasp?convertgetintopost=1&data=',paste(as.character(mysum$resid),sep='',collapse=' '),sep='') ,'Compute','Click here to examine the Residuals.'),1)
a <- table.row.end(a)
a <- table.row.start(a)
a <-table.element(a,'Kernel Density Plot',1,header=TRUE)
a <- table.element(a,hyperlink( paste('https://supernova.wessa.net/rwasp_density.wasp?convertgetintopost=1&data=',paste(as.character(mysum$resid),sep='',collapse=' '),sep='') ,'Compute','Click here to examine the Residuals.'),1)
a <- table.row.end(a)
a <- table.row.start(a)
a <-table.element(a,'Skewness/Kurtosis Test',1,header=TRUE)
a <- table.element(a,hyperlink( paste('https://supernova.wessa.net/rwasp_skewness_kurtosis.wasp?convertgetintopost=1&data=',paste(as.character(mysum$resid),sep='',collapse=' '),sep='') ,'Compute','Click here to examine the Residuals.'),1)
a <- table.row.end(a)
a <- table.row.start(a)
a <-table.element(a,'Skewness-Kurtosis Plot',1,header=TRUE)
a <- table.element(a,hyperlink( paste('https://supernova.wessa.net/rwasp_skewness_kurtosis_plot.wasp?convertgetintopost=1&data=',paste(as.character(mysum$resid),sep='',collapse=' '),sep='') ,'Compute','Click here to examine the Residuals.'),1)
a <- table.row.end(a)
a <- table.row.start(a)
a <-table.element(a,'Harrell-Davis Plot',1,header=TRUE)
a <- table.element(a,hyperlink( paste('https://supernova.wessa.net/rwasp_harrell_davis.wasp?convertgetintopost=1&data=',paste(as.character(mysum$resid),sep='',collapse=' '),sep='') ,'Compute','Click here to examine the Residuals.'),1)
a <- table.row.end(a)
a <- table.row.start(a)
a <-table.element(a,'Bootstrap Plot -- Central Tendency',1,header=TRUE)
a <- table.element(a,hyperlink( paste('https://supernova.wessa.net/rwasp_bootstrapplot1.wasp?convertgetintopost=1&data=',paste(as.character(mysum$resid),sep='',collapse=' '),sep='') ,'Compute','Click here to examine the Residuals.'),1)
a <- table.row.end(a)
a <- table.row.start(a)
a <-table.element(a,'Blocked Bootstrap Plot -- Central Tendency',1,header=TRUE)
a <- table.element(a,hyperlink( paste('https://supernova.wessa.net/rwasp_bootstrapplot.wasp?convertgetintopost=1&data=',paste(as.character(mysum$resid),sep='',collapse=' '),sep='') ,'Compute','Click here to examine the Residuals.'),1)
a <- table.row.end(a)
a <- table.row.start(a)
a <-table.element(a,'(Partial) Autocorrelation Plot',1,header=TRUE)
a <- table.element(a,hyperlink( paste('https://supernova.wessa.net/rwasp_autocorrelation.wasp?convertgetintopost=1&data=',paste(as.character(mysum$resid),sep='',collapse=' '),sep='') ,'Compute','Click here to examine the Residuals.'),1)
a <- table.row.end(a)
a <- table.row.start(a)
a <-table.element(a,'Spectral Analysis',1,header=TRUE)
a <- table.element(a,hyperlink( paste('https://supernova.wessa.net/rwasp_spectrum.wasp?convertgetintopost=1&data=',paste(as.character(mysum$resid),sep='',collapse=' '),sep='') ,'Compute','Click here to examine the Residuals.'),1)
a <- table.row.end(a)
a <- table.row.start(a)
a <-table.element(a,'Tukey lambda PPCC Plot',1,header=TRUE)
a <- table.element(a,hyperlink( paste('https://supernova.wessa.net/rwasp_tukeylambda.wasp?convertgetintopost=1&data=',paste(as.character(mysum$resid),sep='',collapse=' '),sep='') ,'Compute','Click here to examine the Residuals.'),1)
a <- table.row.end(a)
a <- table.row.start(a)
a <-table.element(a,'Box-Cox Normality Plot',1,header=TRUE)
a <- table.element(a,hyperlink( paste('https://supernova.wessa.net/rwasp_boxcoxnorm.wasp?convertgetintopost=1&data=',paste(as.character(mysum$resid),sep='',collapse=' '),sep='') ,'Compute','Click here to examine the Residuals.'),1)
a <- table.row.end(a)
a <- table.row.start(a)
a <- table.element(a,'Summary Statistics',1,header=TRUE)
a <- table.element(a,hyperlink( paste('https://supernova.wessa.net/rwasp_summary1.wasp?convertgetintopost=1&data=',paste(as.character(mysum$resid),sep='',collapse=' '),sep='') ,'Compute','Click here to examine the Residuals.'),1)
a <- table.row.end(a)
a<-table.end(a)
table.save(a,file='mytable7.tab')
if(n < 200) {
a<-table.start()
a<-table.row.start(a)
a<-table.element(a, 'Multiple Linear Regression - Actuals, Interpolation, and Residuals', 4, TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'Time or Index', 1, TRUE)
a<-table.element(a, 'Actuals', 1, TRUE)
a<-table.element(a, 'Interpolation
Forecast', 1, TRUE)
a<-table.element(a, 'Residuals
Prediction Error', 1, TRUE)
a<-table.row.end(a)
for (i in 1:n) {
a<-table.row.start(a)
a<-table.element(a,i, 1, TRUE)
a<-table.element(a,formatC(signif(x[i],6),format='g',flag=' '))
a<-table.element(a,formatC(signif(x[i]-mysum$resid[i],6),format='g',flag=' '))
a<-table.element(a,formatC(signif(mysum$resid[i],6),format='g',flag=' '))
a<-table.row.end(a)
}
a<-table.end(a)
table.save(a,file='mytable4.tab')
if (n > n25) {
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,'Goldfeld-Quandt test for Heteroskedasticity',4,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'p-values',header=TRUE)
a<-table.element(a,'Alternative Hypothesis',3,header=TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'breakpoint index',header=TRUE)
a<-table.element(a,'greater',header=TRUE)
a<-table.element(a,'2-sided',header=TRUE)
a<-table.element(a,'less',header=TRUE)
a<-table.row.end(a)
for (mypoint in kp3:nmkm3) {
a<-table.row.start(a)
a<-table.element(a,mypoint,header=TRUE)
a<-table.element(a,formatC(signif(gqarr[mypoint-kp3+1,1],6),format='g',flag=' '))
a<-table.element(a,formatC(signif(gqarr[mypoint-kp3+1,2],6),format='g',flag=' '))
a<-table.element(a,formatC(signif(gqarr[mypoint-kp3+1,3],6),format='g',flag=' '))
a<-table.row.end(a)
}
a<-table.end(a)
table.save(a,file='mytable5.tab')
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,'Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity',4,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'Description',header=TRUE)
a<-table.element(a,'# significant tests',header=TRUE)
a<-table.element(a,'% significant tests',header=TRUE)
a<-table.element(a,'OK/NOK',header=TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'1% type I error level',header=TRUE)
a<-table.element(a,signif(numsignificant1,6))
a<-table.element(a,formatC(signif(numsignificant1/numgqtests,6),format='g',flag=' '))
if (numsignificant1/numgqtests < 0.01) dum <- 'OK' else dum <- 'NOK'
a<-table.element(a,dum)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'5% type I error level',header=TRUE)
a<-table.element(a,signif(numsignificant5,6))
a<-table.element(a,signif(numsignificant5/numgqtests,6))
if (numsignificant5/numgqtests < 0.05) dum <- 'OK' else dum <- 'NOK'
a<-table.element(a,dum)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'10% type I error level',header=TRUE)
a<-table.element(a,signif(numsignificant10,6))
a<-table.element(a,signif(numsignificant10/numgqtests,6))
if (numsignificant10/numgqtests < 0.1) dum <- 'OK' else dum <- 'NOK'
a<-table.element(a,dum)
a<-table.row.end(a)
a<-table.end(a)
table.save(a,file='mytable6.tab')
}
}
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,'Ramsey RESET F-Test for powers (2 and 3) of fitted values',1,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
reset_test_fitted <- resettest(mylm,power=2:3,type='fitted')
a<-table.element(a,paste('
',RC.texteval('reset_test_fitted'),'
',sep=''))
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'Ramsey RESET F-Test for powers (2 and 3) of regressors',1,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
reset_test_regressors <- resettest(mylm,power=2:3,type='regressor')
a<-table.element(a,paste('
',RC.texteval('reset_test_regressors'),'
',sep=''))
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'Ramsey RESET F-Test for powers (2 and 3) of principal components',1,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
reset_test_principal_components <- resettest(mylm,power=2:3,type='princomp')
a<-table.element(a,paste('
',RC.texteval('reset_test_principal_components'),'
',sep=''))
a<-table.row.end(a)
a<-table.end(a)
table.save(a,file='mytable8.tab')
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,'Variance Inflation Factors (Multicollinearity)',1,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
vif <- vif(mylm)
a<-table.element(a,paste('
',RC.texteval('vif'),'
',sep=''))
a<-table.row.end(a)
a<-table.end(a)
table.save(a,file='mytable9.tab')