Multiple Linear Regression - Estimated Regression Equation
Totaal[t] = + 1345.88578803392 -1.39254747362196Maanden[t] + 0.992777505331395jongerdan25jaar[t] + 0.998857397647713vanaf25jaar[t] -0.0136449709021623t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)1345.88578803392721.7982111.86460.0645790.032289
Maanden-1.3925474736219615.42784-0.09030.9282240.464112
jongerdan25jaar0.9927775053313950.004113241.402400
vanaf25jaar0.9988573976477130.002285437.135900
t-0.01364497090216231.867455-0.00730.9941820.497091


Multiple Linear Regression - Regression Statistics
Multiple R0.999913571812119
R-squared0.999827151094069
Adjusted R-squared0.999821619929079
F-TEST (value)180762.48908477
F-TEST (DF numerator)4
F-TEST (DF denominator)125
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation523.389707343826
Sum Squared Residuals34242098.219182


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1476000476113.573044157-113.573044157398
2475000474132.691733366867.308266634046
3470000470154.095627279-154.095627279504
4461000461187.292425271-187.292425270836
5455000455223.141308522-223.141308521629
6456000455221.735116077778.264883922883
7517000516912.37177745487.6282225456009
8525000525833.80334836-833.803348359785
9523000522841.904855288158.095144711564
10519000518893.708210784106.291789216381
11509000508958.44707270941.552927291187
12512000511965.7728578434.2271421599318
13519000518979.15891092920.8410890706618
14517000517004.357492455-4.3574924546532
15510000510041.348978058-41.3489780577288
16509000510064.262354878-1064.26235487848
17501000500110.761539855889.238460145266
18507000507083.117453995-83.1174539952341
19569000569766.531620704-766.531620703908
20580000579705.060266206294.939733794014
21578000577712.019170782287.980829217652
22565000565785.123129728-785.123129728447
23547000547865.082702788-865.082702788269
24555000554861.758186194138.241813805945
25562000561875.144239283124.855760716683
26561000560893.12032614106.879673859968
27555000555939.986391671-939.986391671171
28544000543988.77078135211.2292186480025
29537000537031.842159271-31.8421592713922
30543000543011.420568081-11.4205680805106
31594000593726.785639966273.214360034425
32611000610651.236176685348.763823314678
33613000612653.624671853346.37532814746
34611000610727.462391908272.537608091576
35594000593806.279362616193.720637384056
36595000595826.907534732-826.90753473212
37591000590878.324385314121.67561468591
38589000589896.300472171-896.300472170812
39584000583932.14935542267.8506445784001
40573000572973.71125043426.2887495661823
41567000567009.560133685-9.56013368460605
42569000568999.7888442190.211155780807243
43621000620720.091206068279.908793931696
44629000628660.905056275339.094943725075
45628000627660.641466183339.35853381731
46612000611738.315834538261.684165462053
47595000595815.990202893-815.990202893184
48597000596843.840869678156.159130322038
49593000592906.2749025493.725097459719
50590000589920.45630178579.5436982147363
51580000579966.95548676233.0445132384818
52574000573990.644585389.3554146203441
53573000573008.620672236-8.62067223638161
54573000573001.134587476-1.13458747554558
55620000619751.469530351248.530469648641
56626000625706.728369895293.271630104806
57620000619718.257683881281.742316119287
58588000586845.7557538061154.24424619359
59566000565935.22302623964.7769737605905
60557000557985.516898827-985.516898827409
61561000560991.3135766938.68642330682041
62549000549040.097966374-40.0979663740027
63532000532094.595367816-94.5953678162646
64526000526118.284466434-118.284466434418
65511000511176.576555488-176.576555488422
66499000499201.041375904-201.041375903967
67555000554947.17278992552.8272100744815
68565000563899.0038224121100.9961775875
69542000541959.21423561640.7857643838048
70527000527029.666109303-29.6661093028396
71510000510102.403187694-102.40318769405
72514000514102.506478157-102.506478156698
73517000517114.383048339-114.383048338784
74508000507148.722448682851.277551317599
75493000493199.792043068-199.792043067801
76490000490213.973442313-213.973442312769
77469000469291.280930113-291.280930113141
78478000477262.494241901737.505758098624
79528000529025.355849965-1025.35584996469
80534000532995.0596788461004.94032115426
81518000518029.032198634-29.0321986344742
82506000506089.976372948-89.9763729479335
83502000502117.460159178-117.460159177832
84516000516087.897749169-87.897749168663
85528000528077.331113548-77.3311135475318
86533000533070.211909342-70.2119093415747
87536000536071.457802156-71.4578021565082
88537000537074.988899676-74.9888996760168
89524000523138.218278694861.781721305946
90536000536097.638686405-97.6386864045318
91587000586867.722789136132.277210863536
92597000595819.5538216231180.44617837654
93581000580847.446449096152.55355090414
94564000564931.200709767-931.200709767427
95558000556975.4146900391024.58530996089
96575000574935.20197830464.7980216955308
97580000580943.65074143-943.650741429693
98575000574967.33984004832.6601599521607
99563000564008.90173506-1008.90173506006
100552000551058.828727093941.171272906822
101537000537115.978213795-115.978213794898
102545000545093.271417899-93.2714178994465
103601000600857.64250887142.357491130054
104604000604815.186553118-815.18655311837
105586000586852.586879964-852.586879963952
106564000563956.49914173443.5008582658379
107549000548022.013725457977.986274543226
108551000551035.419402904-35.4194029043412
109556000556038.930876066-38.9308760655377
110548000548070.985071705-70.9850717045758
111540000540103.039267344-103.039267343626
112531000531136.236065335-136.236065334955
113521000520183.877852664816.122147336502
114519000518184.756864924815.243135076456
115572000571951.41316059948.5868394013793
116581000581896.021698417-896.021698416994
117563000562934.56462761565.435372385125
118548000548011.096393618-11.0963936178331
119539000539056.452976242-56.4529762418033
120541000541064.921363725-64.9213637253436
121562000561026.974232337973.02576766304
122559000559033.933136913-33.9331369133243
123546000546083.860128946-83.8601289464374
124536000537117.056926938-1117.05692693777
125528000527151.396327281848.60367271861
126530000531133.259940795-1133.25994079508
127582000581927.66361279272.3363872077133
128599000598833.874472563166.125527436928
129584000583855.687207719144.312792280841
130571000571916.631382033-916.631382032624


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
80.7658103797854480.4683792404291050.234189620214553
90.82527322348280.34945355303440.1747267765172
100.7238478568688780.5523042862622440.276152143131122
110.6263000926187270.7473998147625460.373699907381273
120.5301361751406720.9397276497186560.469863824859328
130.418347926004790.836695852009580.58165207399521
140.3197393621739520.6394787243479040.680260637826048
150.2373570443495420.4747140886990840.762642955650458
160.4775540654650470.9551081309300940.522445934534953
170.6544482914446630.6911034171106750.345551708555338
180.5777168151590850.844566369681830.422283184840915
190.5312729914943710.9374540170112570.468727008505629
200.5929891615464120.8140216769071760.407010838453588
210.5763565901616750.8472868196766510.423643409838325
220.6143709772620540.7712580454758920.385629022737946
230.6666717707621160.6666564584757680.333328229237884
240.6279860104271980.7440279791456030.372013989572802
250.5858263975737470.8283472048525060.414173602426253
260.527600956398990.944798087202020.47239904360101
270.6199363985972540.7601272028054930.380063601402746
280.5631915627374940.8736168745250130.436808437262506
290.5005736860929360.9988526278141280.499426313907064
300.4398096669629370.8796193339258730.560190333037063
310.4284085418350420.8568170836700830.571591458164958
320.4277965908521250.855593181704250.572203409147875
330.4136572270111240.8273144540222480.586342772988876
340.3787519642638710.7575039285277420.621248035736129
350.3270875033101610.6541750066203230.672912496689839
360.3941762412360140.7883524824720280.605823758763986
370.3418093967909440.6836187935818890.658190603209056
380.4260881661438270.8521763322876540.573911833856173
390.3780582845073330.7561165690146660.621941715492667
400.3263853704784520.6527707409569040.673614629521548
410.2769210965403390.5538421930806780.723078903459661
420.2315500402167220.4631000804334430.768449959783278
430.2034109319095570.4068218638191140.796589068090443
440.1752229616724890.3504459233449780.824777038327511
450.1462999987385690.2925999974771380.853700001261431
460.1174838017334930.2349676034669870.882516198266507
470.1920449863875490.3840899727750980.807955013612451
480.1605644702763630.3211289405527260.839435529723637
490.129359894386480.2587197887729590.87064010561352
500.1027497419245470.2054994838490940.897250258075453
510.0806887269890940.1613774539781880.919311273010906
520.06263115894583770.1252623178916750.937368841054162
530.04788471118117960.09576942236235910.95211528881882
540.03610503040721940.07221006081443880.963894969592781
550.02724403410542920.05448806821085850.972755965894571
560.02039131986263290.04078263972526570.979608680137367
570.01493355046308420.02986710092616830.985066449536916
580.029039143639910.05807828727982010.97096085636009
590.02522357453932430.05044714907864850.974776425460676
600.07544827368840470.1508965473768090.924551726311595
610.0614523655507480.1229047311014960.938547634449252
620.04888998262044390.09777996524088780.951110017379556
630.03869801219347070.07739602438694130.961301987806529
640.03031076864991490.06062153729982980.969689231350085
650.02421329923980430.04842659847960870.975786700760196
660.01953109009323920.03906218018647840.980468909906761
670.01414209326996440.02828418653992880.985857906730036
680.03347080001110350.0669416000222070.966529199988897
690.02528118951810420.05056237903620840.974718810481896
700.01883132757373830.03766265514747670.981168672426262
710.01420907656783830.02841815313567670.985790923432162
720.01076919568582660.02153839137165320.989230804314173
730.008117913856447010.0162358277128940.991882086143553
740.01168461531609350.02336923063218690.988315384683907
750.009366855221570510.0187337104431410.990633144778429
760.007483996729929270.01496799345985850.992516003270071
770.006656021592171850.01331204318434370.993343978407828
780.007607288210408150.01521457642081630.992392711789592
790.02417940692329820.04835881384659640.975820593076702
800.04438621909809620.08877243819619240.955613780901904
810.03386200022134910.06772400044269810.966137999778651
820.02570529706441220.05141059412882450.974294702935588
830.02008456494584920.04016912989169830.979915435054151
840.01619711197374470.03239422394748940.983802888026255
850.01219656863205880.02439313726411770.987803431367941
860.009102246231842930.01820449246368590.990897753768157
870.006842058214530490.0136841164290610.99315794178547
880.005250168976953930.01050033795390790.994749831023046
890.006290903539404070.01258180707880810.993709096460596
900.004764074592689130.009528149185378270.995235925407311
910.003209693465669420.006419386931338840.996790306534331
920.01445314313737880.02890628627475760.985546856862621
930.01144946019099650.0228989203819930.988550539809004
940.02523749030816080.05047498061632160.974762509691839
950.04688646140963960.09377292281927920.95311353859036
960.03491814793848390.06983629587696780.965081852061516
970.05734418258426340.1146883651685270.942655817415737
980.04280065012093920.08560130024187840.957199349879061
990.09390925660029380.1878185132005880.906090743399706
1000.1314461456714470.2628922913428950.868553854328553
1010.1071376441416270.2142752882832540.892862355858373
1020.08502639661684960.1700527932336990.91497360338315
1030.07124321513193960.1424864302638790.92875678486806
1040.07855421747220840.1571084349444170.921445782527792
1050.1189412617297350.2378825234594690.881058738270265
1060.09061571249820770.1812314249964150.909384287501792
1070.1336689328004040.2673378656008080.866331067199596
1080.09923304032467950.1984660806493590.90076695967532
1090.07580189772687270.1516037954537450.924198102273127
1100.05978426435052450.1195685287010490.940215735649475
1110.04989328392110860.09978656784221720.950106716078891
1120.04539642144639360.09079284289278710.954603578553606
1130.04261155988937520.08522311977875030.957388440110625
1140.05553853473336510.111077069466730.944461465266635
1150.0354177354366770.07083547087335410.964582264563323
1160.1242443086055390.2484886172110790.875755691394461
1170.094540234395580.189080468791160.90545976560442
1180.06580725943744180.1316145188748840.934192740562558
1190.03996036360709320.07992072721418640.960039636392907
1200.0211381463540120.04227629270802390.978861853645988
1210.01725063646982380.03450127293964750.982749363530176
1220.007868273670497370.01573654734099470.992131726329503


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level20.0173913043478261NOK
5% type I error level290.252173913043478NOK
10% type I error level510.443478260869565NOK