Home » date » 2010 » Dec » 15 »

Paper: Multiple regression uitgebreide variabelen

*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: Wed, 15 Dec 2010 15:12:47 +0000
 
Cite this page as follows:
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL http://www.freestatistics.org/blog/date/2010/Dec/15/t1292425923t6vq9kqejuu1kf4.htm/, Retrieved Wed, 15 Dec 2010 16:12:06 +0100
 
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/2010/Dec/15/t1292425923t6vq9kqejuu1kf4.htm/},
    year = {2010},
}
@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 = {2010},
    note = {{ISBN} 3-900051-07-0},
    url = {http://www.R-project.org},
}
 
Original text written by user:
 
IsPrivate?
No (this computation is public)
 
User-defined keywords:
 
Dataseries X:
» Textbox « » Textfile « » CSV «
13 13 14 13 3 1 13 6 4 6 4 6 12 12 8 13 5 1 18 6 2 7 2 6 15 10 12 16 6 0 13 5 4 4 4 6 12 9 7 12 6 1 17 4 2 6 5 4 10 10 10 11 5 0 13 4 2 6 5 4 9 12 11 11 4 1 13 3 3 3 2 6 12 12 14 14 4 1 13 6 4 6 4 6 11 6 6 9 4 1 18 3 2 5 5 5 11 5 16 14 6 1 13 6 2 2 5 6 11 12 11 12 6 1 13 6 2 6 3 6 15 11 16 11 5 1 13 4 2 6 5 4 7 14 12 12 4 0 13 5 5 5 4 5 11 14 7 13 6 1 14 4 4 6 3 5 11 12 13 11 4 1 13 6 5 5 2 6 10 12 11 12 6 1 17 6 2 6 2 6 14 11 15 16 6 1 14 6 3 4 5 5 10 11 7 9 4 1 12 4 6 5 2 4 6 7 9 11 4 1 13 5 6 3 3 6 11 9 7 13 2 1 17 2 6 3 3 3 15 11 14 15 7 1 13 6 2 6 2 6 14 12 15 13 6 1 13 6 2 6 2 6 9 11 15 15 7 1 13 5 7 5 3 5 13 8 14 14 5 1 14 4 6 5 2 4 16 12 8 14 4 0 13 6 4 6 4 6 13 10 8 8 4 0 12 4 6 5 2 4 12 10 14 13 7 0 16 6 5 4 6 5 14 12 14 15 7 1 14 6 2 7 2 6 11 8 8 13 4 1 17 6 6 7 5 7 9 12 11 11 4 0 13 6 4 6 4 6 16 11 16 15 6 1 14 6 2 6 2 6 12 12 10 15 6 1 16 6 2 6 2 6 10 7 8 9 5 1 14 6 6 7 2 6 13 11 14 13 6 0 13 1 7 2 5 1 16 11 16 16 7 1 11 6 4 6 4 6 5 15 8 12 3 1 13 6 2 6 2 5 8 11 etc...
 
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 time7 seconds
R Server'RServer@AstonUniversity' @ vre.aston.ac.uk


Multiple Linear Regression - Estimated Regression Equation
Popularity[t] = + 1.42973727530118 + 0.0679559785674146FindingFriends[t] + 0.257687676023935KnowingPeople[t] + 0.366618607059788Liked[t] + 0.675903357645973Celebrity[t] -0.0596577206056682Geslacht[t] -0.128099410571831Happiness[t] -0.647557306757711UsingHands[t] -0.196214101838047Quiet[t] + 0.454124178125426EyeContact[t] + 0.198962264726567CrossArms[t] + 0.194097726936484SmilingTalking[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)1.429737275301182.8800680.49640.6206130.310307
FindingFriends0.06795597856741460.114670.59260.5546860.277343
KnowingPeople0.2576876760239350.0803163.20840.0017610.000881
Liked0.3666186070597880.1139763.21660.0017160.000858
Celebrity0.6759033576459730.1813033.7280.000310.000155
Geslacht-0.05965772060566820.50957-0.11710.907020.45351
Happiness-0.1280994105718310.13393-0.95650.3409940.170497
UsingHands-0.6475573067577110.34204-1.89320.061030.030515
Quiet-0.1962141018380470.136818-1.43410.1544540.077227
EyeContact0.4541241781254260.2099672.16280.032780.01639
CrossArms0.1989622647265670.1665681.19450.234930.117465
SmilingTalking0.1940977269364840.3380960.57410.5671120.283556


Multiple Linear Regression - Regression Statistics
Multiple R0.727346569060866
R-squared0.529033031524613
Adjusted R-squared0.480615866541162
F-TEST (value)10.9265594486054
F-TEST (DF numerator)11
F-TEST (DF denominator)107
p-value2.81441536742477e-13
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation2.05898166248144
Sum Squared Residuals453.616387048529


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
11311.00457460906761.99542539093237
21210.55043008913781.44956991086223
31513.21186388654731.78813611345268
41211.57594041426630.424059585733664
51011.9464928190928-1.94649281909279
6910.4848107042366-1.48481070423656
71211.9791405952060.020859404794037
8118.922153711065782.07784628893422
91112.1455245684748-1.14552456847483
101112.0181130072561-1.01811300725606
111513.50091713319811.49908286680186
12710.7292190066368-3.72921900663677
131112.0703821396859-1.07038213968595
14119.573334288586061.42666571141394
151011.3067531002422-1.30675310024216
161413.41864709487950.581352905120548
17108.06481950813171.9351804918683
1867.94486080504862-1.94486080504862
19117.794809006139573.20519099386043
201514.30001697085920.699983029140782
211413.2165200536850.783479946314983
22913.7749318041153-4.77493180411528
231311.91756287639821.08243712360175
241610.4926722596685.50732774033198
25137.94759031913415.0524096808659
261212.2790439372672-0.279043937267188
271414.6939977169802-0.693997716980227
28119.736930341557971.26306965844204
29910.1658794665605-1.16587946656046
301614.01138955468931.98861044531072
311212.2770206559694-0.277020655969426
32108.471717002996681.52828299700332
331313.0171515912932-0.0171515912932296
341615.44370607688760.556293923112422
3559.02814785028552-4.02814785028552
36810.4823883456822-2.48238834568223
371112.4819376897124-1.48193768971243
381614.58326163540491.41673836459509
391712.89893704513714.10106295486291
4097.860301892766241.13969810723376
41911.9557965105435-2.95579651054349
421314.244930811429-1.24493081142901
43610.0061701161472-4.00617011614722
441212.1396686008041-0.139668600804067
45811.6243632806534-3.62436328065335
461412.16109953182981.83890046817019
471212.2204693672247-0.220469367224733
481110.52116376755920.478836232440766
491614.436813086781.56318691322003
5089.88974947853361-1.88974947853361
511514.91204265500780.0879573449922338
5279.07804701073926-2.07804701073926
531613.96992984476812.03007015523187
541414.0174721880548-0.0174721880547607
55910.2443822917313-1.24438229173134
561412.03073766976821.96926233023179
571113.8863042732833-2.88630427328328
581511.99947131079153.00052868920854
591512.33430013127292.66569986872715
601312.03073766976820.969262330231787
611111.8085286204357-0.808528620435679
621113.686838705269-2.68683870526898
631212.8274550809735-0.827455080973473
641214.1240710013144-2.12407100131443
651211.98426639152270.0157336084772647
661212.2136697216109-0.213669721610937
671410.43301453906243.56698546093765
6867.46048032476614-1.46048032476614
6979.50174736952451-2.50174736952451
701413.73854087002610.261459129973863
711011.0073354277487-1.00733542774869
72138.188078057030874.81192194296913
731212.7978933403962-0.797893340396246
7499.28824111182083-0.288241111820833
751614.84782091793341.15217908206664
76109.88950902239930.110490977600702
771614.54829351768861.45170648231139
781513.34379209835121.65620790164884
7987.711110498228170.288889501771825
801112.7498386456421-1.74983864564207
811312.19126567536630.808734324633683
821615.97448430596330.025515694036669
831415.05650612315-1.05650612315003
84910.0276436452936-1.02764364529357
8589.95083348958265-1.95083348958265
86810.9682434246756-2.96824342467563
871111.8776732775281-0.877673277528131
881213.6802688662808-1.68026886628082
891413.63843538650250.361564613497518
901514.22471253021560.77528746978441
911613.71774729804292.28225270195712
921614.88891465914871.11108534085131
931112.5885162028708-1.58851620287077
941413.58863498652180.411365013478156
951410.65707572469413.34292427530594
961211.09165031032130.908349689678733
971313.1369529315639-0.136952931563935
981210.787008483611.21299151639001
991615.52982200395760.470177996042445
1001213.216520053685-1.21652005368502
1011110.83283130096120.167168699038784
10245.97962920214694-1.97962920214694
1031615.41599123990940.584008760090567
1041010.5781720296904-0.578172029690445
1051312.72901965567160.270980344328352
1061414.0350926946725-0.0350926946724795
10779.93496221807539-2.93496221807539
1081212.5136356699401-0.513635669940068
1091211.35277164500390.647228354996094
1101313.3254509847209-0.325450984720871
1111512.3225832518332.67741674816699
1121210.57627495827341.4237250417266
113811.163079291537-3.16307929153696
1141014.1591215292839-4.15912152928388
1151614.52850095502471.47149904497526
1161313.0569007304688-0.0569007304688109
11799.49971446490676-0.499714464906765
1181413.50103457448740.498965425512618
1191412.52425779203391.47574220796612


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
150.4817838182706710.9635676365413420.518216181729329
160.448354354720380.8967087094407610.55164564527962
170.3131467632976560.6262935265953110.686853236702344
180.4502288487318320.9004576974636640.549771151268168
190.4070970007906260.8141940015812530.592902999209374
200.3520445759176780.7040891518353560.647955424082322
210.2569887979699830.5139775959399660.743011202030017
220.4606333577347870.9212667154695740.539366642265213
230.3760603551619370.7521207103238740.623939644838063
240.5688259183005190.8623481633989630.431174081699481
250.8356425691315070.3287148617369860.164357430868493
260.8846969713461130.2306060573077740.115303028653887
270.8455982970737650.3088034058524710.154401702926235
280.807133631626290.3857327367474180.192866368373709
290.8211403654607810.3577192690784380.178859634539219
300.795357237495630.409285525008740.20464276250437
310.7596328192578560.4807343614842880.240367180742144
320.7302373400453080.5395253199093840.269762659954692
330.6932363519590750.613527296081850.306763648040925
340.6641942329592590.6716115340814820.335805767040741
350.885893914972570.228212170054860.11410608502743
360.8899504245382610.2200991509234770.110049575461739
370.8628413347219060.2743173305561890.137158665278094
380.8437821299766910.3124357400466180.156217870023309
390.8813640143756280.2372719712487440.118635985624372
400.9109939680009050.1780120639981890.0890060319990945
410.9389296755158280.1221406489683430.0610703244841716
420.9346696607121870.1306606785756260.0653303392878131
430.9604860704034270.0790278591931450.0395139295965725
440.946290204164750.1074195916704990.0537097958352495
450.9801672237235320.03966555255293510.0198327762764676
460.9778031287234930.04439374255301430.0221968712765072
470.9688127574422120.06237448511557530.0311872425577877
480.9588812166258860.08223756674822780.0411187833741139
490.9580224426542510.08395511469149770.0419775573457488
500.9598665858108920.08026682837821620.0401334141891081
510.945601461628080.1087970767438390.0543985383719195
520.9397020314806330.1205959370387340.060297968519367
530.949526919028540.1009461619429210.0504730809714605
540.9338677622447410.1322644755105170.0661322377552587
550.9225930836131560.1548138327736890.0774069163868445
560.9210484410190650.1579031179618690.0789515589809345
570.942511004379340.1149779912413180.0574889956206589
580.965788710395410.06842257920918040.0342112896045902
590.9823025304005470.03539493919890610.017697469599453
600.9766684192607340.04666316147853290.0233315807392664
610.9691946293864450.06161074122711020.0308053706135551
620.9748071552930250.05038568941395040.0251928447069752
630.9684993528038230.06300129439235420.0315006471961771
640.9706570811616480.05868583767670510.0293429188383525
650.959703731216060.08059253756788250.0402962687839413
660.9460063322671040.1079873354657910.0539936677328956
670.9742457231194820.05150855376103670.0257542768805184
680.9690433720098270.06191325598034580.0309566279901729
690.9673861595604180.06522768087916330.0326138404395817
700.9548783671145640.09024326577087280.0451216328854364
710.9437377680009550.112524463998090.0562622319990448
720.9910794378559650.01784112428806960.00892056214403479
730.9877350127527990.02452997449440260.0122649872472013
740.9818625684924060.03627486301518860.0181374315075943
750.9753380526768350.04932389464633030.0246619473231652
760.9659518391120720.06809632177585640.0340481608879282
770.9631379705992010.07372405880159690.0368620294007985
780.9596730715166480.0806538569667040.040326928483352
790.9435202188660270.1129595622679460.0564797811339731
800.932203897091330.1355922058173380.0677961029086692
810.9158278420885730.1683443158228530.0841721579114266
820.917592154686350.1648156906273010.0824078453136506
830.889458755619020.221082488761960.11054124438098
840.8557424907288310.2885150185423370.144257509271169
850.8403083749490210.3193832501019580.159691625050979
860.9372310395072120.1255379209855770.0627689604927883
870.913042799365020.1739144012699610.0869572006349803
880.9434050262581430.1131899474837140.0565949737418568
890.9199211413286260.1601577173427480.0800788586713739
900.8916376308136830.2167247383726330.108362369186317
910.8888827858705380.2222344282589230.111117214129462
920.84567904045110.30864191909780.1543209595489
930.7956264284452810.4087471431094380.204373571554719
940.7349381876441090.5301236247117820.265061812355891
950.8089198209293890.3821603581412230.191080179070611
960.7563919593231860.4872160813536280.243608040676814
970.6731705548356990.6536588903286020.326829445164301
980.6705649098149130.6588701803701750.329435090185087
990.7148186590806860.5703626818386280.285181340919314
1000.6741456034341910.6517087931316180.325854396565809
1010.6674175349563490.6651649300873010.332582465043651
1020.5441428814449770.9117142371100460.455857118555023
1030.4332238013343560.8664476026687120.566776198665644
1040.282017433956290.564034867912580.71798256604371


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level00OK
5% type I error level80.0888888888888889NOK
10% type I error level260.288888888888889NOK
 
Charts produced by software:
http://www.freestatistics.org/blog/date/2010/Dec/15/t1292425923t6vq9kqejuu1kf4/10tjba1292425956.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Dec/15/t1292425923t6vq9kqejuu1kf4/10tjba1292425956.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Dec/15/t1292425923t6vq9kqejuu1kf4/1n0xh1292425956.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Dec/15/t1292425923t6vq9kqejuu1kf4/1n0xh1292425956.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Dec/15/t1292425923t6vq9kqejuu1kf4/2xsek1292425956.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Dec/15/t1292425923t6vq9kqejuu1kf4/2xsek1292425956.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Dec/15/t1292425923t6vq9kqejuu1kf4/3xsek1292425956.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Dec/15/t1292425923t6vq9kqejuu1kf4/3xsek1292425956.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Dec/15/t1292425923t6vq9kqejuu1kf4/4xsek1292425956.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Dec/15/t1292425923t6vq9kqejuu1kf4/4xsek1292425956.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Dec/15/t1292425923t6vq9kqejuu1kf4/5qjv51292425956.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Dec/15/t1292425923t6vq9kqejuu1kf4/5qjv51292425956.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Dec/15/t1292425923t6vq9kqejuu1kf4/6qjv51292425956.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Dec/15/t1292425923t6vq9kqejuu1kf4/6qjv51292425956.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Dec/15/t1292425923t6vq9kqejuu1kf4/71su71292425956.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Dec/15/t1292425923t6vq9kqejuu1kf4/71su71292425956.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Dec/15/t1292425923t6vq9kqejuu1kf4/81su71292425956.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Dec/15/t1292425923t6vq9kqejuu1kf4/81su71292425956.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Dec/15/t1292425923t6vq9kqejuu1kf4/9tjba1292425956.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Dec/15/t1292425923t6vq9kqejuu1kf4/9tjba1292425956.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