Home » date » 2008 » Nov » 24 »

Q3

*The author of this computation has been verified*
R Software Module: rwasp_multipleregression.wasp (opens new window with default values)
Title produced by software: Multiple Regression
Date of computation: Mon, 24 Nov 2008 07:00:34 -0700
 
Cite this page as follows:
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL http://www.freestatistics.org/blog/date/2008/Nov/24/t1227535282o8yzfy8louhiod0.htm/, Retrieved Mon, 24 Nov 2008 14:01:32 +0000
 
BibTeX entries for LaTeX users:
@Manual{KEY,
    author = {{YOUR NAME}},
    publisher = {Office for Research Development and Education},
    title = {Statistical Computations at FreeStatistics.org, URL http://www.freestatistics.org/blog/date/2008/Nov/24/t1227535282o8yzfy8louhiod0.htm/},
    year = {2008},
}
@Manual{R,
    title = {R: A Language and Environment for Statistical Computing},
    author = {{R Development Core Team}},
    organization = {R Foundation for Statistical Computing},
    address = {Vienna, Austria},
    year = {2008},
    note = {{ISBN} 3-900051-07-0},
    url = {http://www.R-project.org},
}
 
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
 
Feedback Forum:

Post a new message
 
Original text written by user:
 
IsPrivate?
No (this computation is public)
 
User-defined keywords:
 
Dataseries X:
» Textbox « » Textfile « » CSV «
1,3322 133,52 7,4545 0 1,4369 153,2 7,4583 0 1,4975 163,63 7,4595 0 1,577 168,45 7,4599 0 1,5553 166,26 7,4586 0 1,5557 162,31 7,4609 0 1,575 161,56 7,4603 0 1,5527 156,59 7,4561 0 1,4748 157,97 7,454 0 1,4718 158,68 7,4505 0 1,457 163,55 7,4599 0 1,4684 162,89 7,4543 0 1,4227 164,95 7,4534 0 1,3896 159,82 7,4506 0 1,3622 159,05 7,4429 0 1,3716 166,76 7,441 0 1,3419 164,55 7,4452 0 1,3511 163,22 7,4519 0 1,3516 160,68 7,453 0 1,3242 155,24 7,4494 0 1,3074 157,6 7,4541 0 1,2999 156,56 7,4539 0 1,3213 154,82 7,4549 0 1,2881 151,11 7,4564 0 1,2611 149,65 7,4555 0 1,2727 148,99 7,4601 0 1,2811 148,53 7,4609 0 1,2684 146,7 7,4602 0 1,265 145,11 7,4566 0 1,277 142,7 7,4565 0 1,2271 143,59 7,4618 0 1,202 140,96 7,4612 0 1,1938 140,77 7,4641 0 1,2103 139,81 7,4613 0 1,1856 140,58 7,4541 0 1,1786 139,59 7,4596 0 1,2015 138,05 7,462 0 1,2256 136,06 7,4584 0 1,2292 135,98 7,4596 0 1,2037 134,75 7,4584 0 1,2165 132,22 7,4448 0 1,2694 135,37 7,4443 1 1,2938 138,84 7,4499 1 1,3201 138,83 7,4466 1 1,3014 136,55 7,4427 1 1,3119 135,63 7,4405 1 1,3408 139,14 7,4338 1 1,2991 136,09 7,4313 1 1,249 135,97 7,4379 1 1,2218 134,51 7,4381 1 1,2176 134,54 7,4365 1 1,2266 134,08 7,4355 1 1,2138 132,86 7,4342 1 1,2007 134,48 7,4405 1 1,1985 129,08 7,4436 1 1,2262 133,13 7,4493 1 1,2646 134,78 7,4511 1 1,2613 134,13 7,4481 1 1,2286 132,43 7,4419 1 1,1702 127,84 7,437 1 1,1692 128,12 7,4301 1 1,1222 128,94 7,4273 1 1,1139 132,38 7,4322 1 1,1372 134,99 7,4332 1 1,1663 138,05 7,425 1 1,1582 135,83 7,4246 1 1,0848 130,12 7,4255 1 1,0807 128,16 7,4274 1 1,0773 128,6 7,4317 1 1,0622 126,12 7,4324 1 1,0183 124,2 7,4264 1 1,0014 121,65 7,428 1 0,9811 121,57 7,4297 1 0,9808 118,38 7,4271 1
 
Output produced by software:

Enter (or paste) a matrix (table) containing all data (time) series. Every column represents a different variable and must be delimited by a space or Tab. Every row represents a period in time (or category) and must be delimited by hard returns. The easiest way to enter data is to copy and paste a block of spreadsheet cells. Please, do not use commas or spaces to seperate groups of digits!


Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time9 seconds
R Server'George Udny Yule' @ 72.249.76.132
R Framework
error message
Warning: there are blank lines in the 'Data X' field.
Please, use NA for missing data - blank lines are simply
 deleted and are NOT treated as missing values.


Multiple Linear Regression - Estimated Regression Equation
Dollar[t] = -38.7020016944876 + 0.0103197910467146Yen[t] + 5.1604990419276DeenseKroon[t] + 0.148107290491013`(Y/N)`[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)-38.70200169448767.879726-4.91166e-063e-06
Yen0.01031979104671460.00079412.999900
DeenseKroon5.16049904192761.0563794.88516e-063e-06
`(Y/N)`0.1481072904910130.0300594.92725e-063e-06


Multiple Linear Regression - Regression Statistics
Multiple R0.906281906334077
R-squared0.821346893748529
Adjusted R-squared0.813690332052037
F-TEST (value)107.273594376558
F-TEST (DF numerator)3
F-TEST (DF denominator)70
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation0.0597122498843697
Sum Squared Residuals0.249588695037739


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
11.33221.144836914119010.187363085880990
21.43691.367540298277700.0693597017223019
31.49751.481368317745240.0161316822547573
41.5771.533173910207180.0438260897928225
51.55531.503864919060360.0514350809396357
61.55571.474970892222280.080729107777725
71.5751.464134749512090.110865250487915
81.55271.391171292033820.161528707966182
91.47481.394575555690230.0802244443097662
101.47181.383840860686660.0879591393133444
111.4571.48260693407828-0.0256069340782764
121.46841.446897077352650.0215029226473512
131.42271.46351139777115-0.0408113977711475
141.38961.39612147238410-0.00652147238410165
151.36221.348439390655290.0137606093447100
161.37161.41820003144580-0.0466000314457967
171.34191.41706738920865-0.0751673892086534
181.35111.43791741069744-0.0868174106974398
191.35161.41738169038491-0.0657816903849058
201.32421.34266423053984-0.0184642305398365
211.30741.39127328290715-0.0838732829071457
221.29991.37950860041017-0.0796086004101748
231.32131.36671266303082-0.0454126630308208
241.28811.33616698681040-0.0480669868104015
251.26111.31645564274446-0.0553556427444603
261.27271.33338287624650-0.0606828762464955
271.28111.33276417159855-0.0516641715985484
281.26841.31026660465372-0.0418666046537151
291.2651.27528034033850-0.0102803403384973
301.2771.249893594011720.0271064059882766
311.22711.28642885296552-0.059328852965516
321.2021.25619150308750-0.0541915030874984
331.19381.26919619001021-0.0753961900102144
341.21031.24483979328797-0.0345397932879681
351.18561.21563043929206-0.0300304392920638
361.17861.23379659088642-0.055196590886416
371.20151.2302893103751-0.0287893103751006
381.22561.19117512964120.0344248703587988
391.22921.196542145207780.0326578547922237
401.20371.177656203370010.0260437966299949
411.21651.08136434505160.135135654948399
421.26941.259398727818800.0100012721811981
431.29381.32410719738570-0.0303071973856974
441.32011.306974352636870.0131256473631323
451.30141.263319282786840.0380807172131579
461.31191.242471977131620.0694280228683774
471.34081.244119100124670.096680899875326
481.29911.199742489827380.0993575101726217
491.2491.232563408578490.0164365914215070
501.22181.218528613458680.00327138654132258
511.21761.210581408722990.00701859127700897
521.22661.200673805799580.0259261942004221
531.21381.181375011968080.0324249880319225
541.20071.2306042174279-0.0299042174279008
551.19851.190874892805620.00762510719438257
561.22621.26208489108380-0.0358848910837987
571.26461.28840144458635-0.0238014445863488
581.26131.2662120832802-0.00491208328020069
591.22861.216673344440840.0119266555591636
601.17021.144019058230970.0261809417690294
611.16921.111301156334750.0578988436652494
621.12221.105313987675660.0168860123243438
631.11391.1661005141818-0.0522005141818003
641.13721.19819566785565-0.0609956678556547
651.16631.18745813631479-0.0211581363147929
661.15821.16248400057432-0.0042840005743158
671.08481.10820244283531-0.0234024428353132
681.08071.09778060056341-0.0170806005634104
691.07731.12451145450426-0.0472114545042569
701.06221.10253072203775-0.0403307220377548
711.01831.05175372897650-0.0334537289764961
721.00141.03369506027446-0.0322950602744571
730.98111.041642325362-0.0605423253619993
740.98080.995304894413967-0.0145048944139673


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
70.3474965817998290.6949931635996590.652503418200171
80.5691301332821870.8617397334356260.430869866717813
90.5273558132756240.9452883734487510.472644186724376
100.4675149547215270.9350299094430540.532485045278473
110.7030258592752340.5939482814495320.296974140724766
120.6970867249129410.6058265501741180.302913275087059
130.7953592078248410.4092815843503170.204640792175159
140.7825455062970070.4349089874059870.217454493702993
150.7317655181346240.5364689637307530.268234481865376
160.6527097016194420.6945805967611160.347290298380558
170.6576920231855990.6846159536288020.342307976814401
180.8090424265147840.3819151469704320.190957573485216
190.8785266896985390.2429466206029220.121473310301461
200.8704574875916430.2590850248167140.129542512408357
210.9563127715115070.08737445697698550.0436872284884927
220.9831855154924820.03362896901503590.0168144845075180
230.9875372093033620.02492558139327620.0124627906966381
240.9931085614483080.01378287710338400.00689143855169202
250.995995650186130.008008699627741270.00400434981387064
260.9981524260566430.003695147886713370.00184757394335669
270.9986899333108950.002620133378210420.00131006668910521
280.9986977252146760.002604549570647150.00130227478532358
290.9978965568954820.004206886209035530.00210344310451777
300.9965755877633350.006848824473330650.00342441223666532
310.997288864044380.005422271911241360.00271113595562068
320.9974070784881850.005185843023629960.00259292151181498
330.9985032622678080.002993475464383410.00149673773219170
340.9981279996281970.003744000743606040.00187200037180302
350.9980825097561260.003834980487747540.00191749024387377
360.9991236815361340.001752636927731950.000876318463865974
370.9994191677497170.001161664500565230.000580832250282614
380.9991572533231180.001685493353764430.000842746676882217
390.9988943069349640.002211386130072080.00110569306503604
400.9992878456793090.001424308641382830.000712154320691417
410.999385155346940.001229689306121470.000614844653060737
420.998839493144450.002321013711101450.00116050685555073
430.9985840111857480.0028319776285050.0014159888142525
440.997480303731960.005039392536081870.00251969626804093
450.9960214537504080.007957092499184550.00397854624959227
460.9965105624090670.006978875181866260.00348943759093313
470.9983752619491360.003249476101727620.00162473805086381
480.9998030642085920.0003938715828168470.000196935791408423
490.9996524475359080.0006951049281833650.000347552464091682
500.9993336253133140.001332749373372470.000666374686686234
510.9987852643834610.002429471233077030.00121473561653851
520.9984325514183110.003134897163377820.00156744858168891
530.998508116408840.002983767182318430.00149188359115921
540.9973545809988960.005290838002207870.00264541900110393
550.9955617055814840.008876588837032230.00443829441851611
560.9926208350427430.01475832991451330.00737916495725665
570.987069780143280.02586043971344160.0129302198567208
580.9758000018122290.04839999637554290.0241999981877714
590.9624993291263360.07500134174732730.0375006708736636
600.9777492130676650.04450157386467030.0222507869323352
610.9997410558907960.0005178882184076680.000258944109203834
620.9999744094242275.11811515457472e-052.55905757728736e-05
630.9998797774565860.0002404450868283240.000120222543414162
640.9995188208215780.0009623583568440330.000481179178422016
650.9981627737961420.003674452407715120.00183722620385756
660.9921997286539440.01560054269211130.00780027134605565
670.9689980982875960.0620038034248080.031001901712404


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level360.59016393442623NOK
5% type I error level440.721311475409836NOK
10% type I error level470.770491803278688NOK
 
Charts produced by software:
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Nov/24/t1227535282o8yzfy8louhiod0/108yga1227535224.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Nov/24/t1227535282o8yzfy8louhiod0/108yga1227535224.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Nov/24/t1227535282o8yzfy8louhiod0/177hq1227535224.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Nov/24/t1227535282o8yzfy8louhiod0/177hq1227535224.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Nov/24/t1227535282o8yzfy8louhiod0/2246f1227535224.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Nov/24/t1227535282o8yzfy8louhiod0/2246f1227535224.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Nov/24/t1227535282o8yzfy8louhiod0/3qp9x1227535224.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Nov/24/t1227535282o8yzfy8louhiod0/3qp9x1227535224.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Nov/24/t1227535282o8yzfy8louhiod0/4ipnv1227535224.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Nov/24/t1227535282o8yzfy8louhiod0/4ipnv1227535224.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Nov/24/t1227535282o8yzfy8louhiod0/5xcec1227535224.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Nov/24/t1227535282o8yzfy8louhiod0/5xcec1227535224.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Nov/24/t1227535282o8yzfy8louhiod0/63a5l1227535224.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Nov/24/t1227535282o8yzfy8louhiod0/63a5l1227535224.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Nov/24/t1227535282o8yzfy8louhiod0/7m28j1227535224.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Nov/24/t1227535282o8yzfy8louhiod0/7m28j1227535224.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Nov/24/t1227535282o8yzfy8louhiod0/8udfr1227535224.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Nov/24/t1227535282o8yzfy8louhiod0/8udfr1227535224.ps (open in new window)


http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Nov/24/t1227535282o8yzfy8louhiod0/9ptq01227535224.png (open in new window)
http://127.0.0.1/wessadotnet/public_html/freestatisticsdotorg/blog/date/2008/Nov/24/t1227535282o8yzfy8louhiod0/9ptq01227535224.ps (open in new window)


 
Parameters (Session):
par1 = 1 ; par2 = Do not include Seasonal Dummies ; par3 = No Linear Trend ;
 
Parameters (R input):
par1 = 1 ; par2 = Do not include Seasonal Dummies ; par3 = No Linear Trend ;
 
R code (references can be found in the software module):
library(lattice)
library(lmtest)
n25 <- 25 #minimum number of obs. for Goldfeld-Quandt test
par1 <- as.numeric(par1)
x <- 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'){
x2 <- array(0, dim=c(n-1,k), dimnames=list(1:(n-1), paste('(1-B)',colnames(x),sep='')))
for (i in 1:n-1) {
for (j in 1:k) {
x2[i,j] <- x[i+1,j] - x[i,j]
}
}
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[1,])
if (par3 == 'Linear Trend'){
x <- cbind(x, c(1:n))
colnames(x)[k+1] <- 't'
}
x
k <- length(x[1,])
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')
hist(mysum$resid, main='Residual Histogram', xlab='values of Residuals')
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')
qqnorm(mysum$resid, main='Residual Normal Q-Q Plot')
qqline(mysum$resid)
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)
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, mysum$coefficients[i,1], 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.end(a)
table.save(a,file='mytable1.tab')
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,hyperlink('http://www.xycoon.com/ols1.htm','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<br />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,mysum$coefficients[i,1])
a<-table.element(a, round(mysum$coefficients[i,2],6))
a<-table.element(a, round(mysum$coefficients[i,3],4))
a<-table.element(a, round(mysum$coefficients[i,4],6))
a<-table.element(a, round(mysum$coefficients[i,4]/2,6))
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, sqrt(mysum$r.squared))
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'R-squared',1,TRUE)
a<-table.element(a, mysum$r.squared)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'Adjusted R-squared',1,TRUE)
a<-table.element(a, mysum$adj.r.squared)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'F-TEST (value)',1,TRUE)
a<-table.element(a, mysum$fstatistic[1])
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'F-TEST (DF numerator)',1,TRUE)
a<-table.element(a, mysum$fstatistic[2])
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'F-TEST (DF denominator)',1,TRUE)
a<-table.element(a, mysum$fstatistic[3])
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'p-value',1,TRUE)
a<-table.element(a, 1-pf(mysum$fstatistic[1],mysum$fstatistic[2],mysum$fstatistic[3]))
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, mysum$sigma)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'Sum Squared Residuals',1,TRUE)
a<-table.element(a, sum(myerror*myerror))
a<-table.row.end(a)
a<-table.end(a)
table.save(a,file='mytable3.tab')
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<br />Forecast', 1, TRUE)
a<-table.element(a, 'Residuals<br />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,x[i])
a<-table.element(a,x[i]-mysum$resid[i])
a<-table.element(a,mysum$resid[i])
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,gqarr[mypoint-kp3+1,1])
a<-table.element(a,gqarr[mypoint-kp3+1,2])
a<-table.element(a,gqarr[mypoint-kp3+1,3])
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,numsignificant1)
a<-table.element(a,numsignificant1/numgqtests)
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,numsignificant5)
a<-table.element(a,numsignificant5/numgqtests)
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,numsignificant10)
a<-table.element(a,numsignificant10/numgqtests)
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')
}
 





Copyright

Creative Commons License

This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 License.

Software written by Ed van Stee & Patrick Wessa


Disclaimer

Information provided on this web site is provided "AS IS" without warranty of any kind, either express or implied, including, without limitation, warranties of merchantability, fitness for a particular purpose, and noninfringement. We use reasonable efforts to include accurate and timely information and periodically update the information, and software without notice. However, we make no warranties or representations as to the accuracy or completeness of such information (or software), and we assume no liability or responsibility for errors or omissions in the content of this web site, or any software bugs in online applications. Your use of this web site is AT YOUR OWN RISK. Under no circumstances and under no legal theory shall we be liable to you or any other person for any direct, indirect, special, incidental, exemplary, or consequential damages arising from your access to, or use of, this web site.


Privacy Policy

We may request personal information to be submitted to our servers in order to be able to:

  • personalize online software applications according to your needs
  • enforce strict security rules with respect to the data that you upload (e.g. statistical data)
  • manage user sessions of online applications
  • alert you about important changes or upgrades in resources or applications

We NEVER allow other companies to directly offer registered users information about their products and services. Banner references and hyperlinks of third parties NEVER contain any personal data of the visitor.

We do NOT sell, nor transmit by any means, personal information, nor statistical data series uploaded by you to third parties.

We carefully protect your data from loss, misuse, alteration, and destruction. However, at any time, and under any circumstance you are solely responsible for managing your passwords, and keeping them secret.

We store a unique ANONYMOUS USER ID in the form of a small 'Cookie' on your computer. This allows us to track your progress when using this website which is necessary to create state-dependent features. The cookie is used for NO OTHER PURPOSE. At any time you may opt to disallow cookies from this website - this will not affect other features of this website.

We examine cookies that are used by third-parties (banner and online ads) very closely: abuse from third-parties automatically results in termination of the advertising contract without refund. We have very good reason to believe that the cookies that are produced by third parties (banner ads) do NOT cause any privacy or security risk.

FreeStatistics.org is safe. There is no need to download any software to use the applications and services contained in this website. Hence, your system's security is not compromised by their use, and your personal data - other than data you submit in the account application form, and the user-agent information that is transmitted by your browser - is never transmitted to our servers.

As a general rule, we do not log on-line behavior of individuals (other than normal logging of webserver 'hits'). However, in cases of abuse, hacking, unauthorized access, Denial of Service attacks, illegal copying, hotlinking, non-compliance with international webstandards (such as robots.txt), or any other harmful behavior, our system engineers are empowered to log, track, identify, publish, and ban misbehaving individuals - even if this leads to ban entire blocks of IP addresses, or disclosing user's identity.


FreeStatistics.org is powered by