Multiple Linear Regression - Estimated Regression Equation
Totaal[t] = + 1346.8859142731 + 0.992690925613808jongerdan25jaar[t] + 0.998856373556063vanaf25jaar[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)1346.8859142731673.3223892.00040.0475940.023797
jongerdan25jaar0.9926909256138080.002759359.773100
vanaf25jaar0.9988563735560630.00165605.317500


Multiple Linear Regression - Regression Statistics
Multiple R0.999913564962049
R-squared0.999827137395114
Adjusted R-squared0.999824415149368
F-TEST (value)367280.264384064
F-TEST (DF numerator)2
F-TEST (DF denominator)127
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation519.272750383693
Sum Squared Residuals34244812.0399627


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1476000476105.824109485-105.824109484742
2475000474126.607706199873.392293801056
3470000470149.678555801-149.678555801459
4461000461184.632985566-184.632985565898
5455000455222.321983941-222.321983940789
6456000455222.321983941777.678016059211
7517000516910.96467466989.0353253312444
8525000525832.852109308-832.852109308517
9523000522842.448436583157.551563417424
10519000518896.346525896103.653474103633
11509000508963.27182181636.7281781839742
12512000511972.17183836927.8281616312749
13519000518970.33190120329.6680987965779
14517000516997.280945862.71905413967782
15510000510036.113570679-36.1135706791569
16509000510060.775362448-1060.77536244817
17501000500109.204314541890.795685458926
18507000507082.702585607-82.7025856067462
19569000569764.036201949-764.036201948517
20580000579703.276353971296.723646028895
21578000577711.729054801288.270945198764
22565000565787.107051551-787.107051551028
23547000547869.346806964-869.346806964445
24555000554867.506869799132.493130200862
25562000561865.666932634134.333067366163
26561000560885.306902905114.693097095464
27555000555934.18317072-934.183170720007
28544000543984.89937570115.1006242992187
29537000537029.897448462-29.8974484618705
30543000543010.704793914-10.7047939137379
31594000593724.25827141275.741728590487
32611000610649.327590382350.672409617707
33613000612653.205785437346.794214563326
34611000610729.478413632270.521586368389
35594000593810.574542601189.425457398917
36595000595832.949081482-832.949081482233
37591000590869.494453413130.505546586813
38589000589889.134423684-889.134423683893
39584000583926.82342205973.176577941209
40573000572970.23055265329.7694473466381
41567000567007.919551028-7.91955102826423
42569000568999.4668501980.53314980186158
43621000620718.042149192281.957850807758
44629000628659.569554103340.430445897296
45628000627660.713180547339.28681945336
46612000611740.665683072259.334316927815
47595000595820.618185598-820.618185597723
48597000596850.301798865149.698201134941
49593000592898.034440237101.965559763408
50590000589913.79621545386.2037845470877
51580000579962.22516754637.7748324541904
52574000573987.58327003612.4167299637999
53573000573007.223240307-7.22324030690167
54573000573001.057792365-1.05779236465231
55620000619750.013015347249.986984652544
56626000625706.15856903293.8414309697
57620000619719.185775636280.814224363822
58588000586849.407167421150.59283258008
59566000565941.24325010758.7567498926044
60557000557993.550397255-993.550397254678
61561000560983.95406998116.0459300193881
62549000549034.670274961-34.6702749613886
63532000532091.104612162-91.1046121618469
64526000526116.462714652-116.462714652237
65511000511176.775246907-176.775246907078
66499000499202.829660119-202.829660118833
67555000554947.65769304852.3423069515468
68565000563900.37236741099.62763260051
69542000541962.5248368237.4751631803632
70527000527035.168264959-35.1682649589871
71510000510110.098945986-110.098945986209
72514000514111.689888153-111.689888152714
73517000517108.259008821-108.259008820903
74508000507144.357065029855.642934970704
75493000493197.360522898-197.360522897945
76490000490213.122298114-213.122298114266
77469000469292.627484917-292.627484917245
78478000477264.982129539735.01787046101
79528000529026.715564129-1026.71556412886
80534000532997.4792665841002.52073341591
81518000518033.13000707-33.1300070699055
82506000506096.177107935-96.1771079351904
83502000502125.41340548-125.413405479959
84516000516097.07173938-97.0717393803321
85528000528071.017326169-71.0173261685767
86533000533065.299193949-65.299193948892
87536000536068.033762559-68.0337625593365
88537000537073.055584058-73.0555840576542
89524000523138.389937811861.610062189185
90536000536098.861002271-98.8610022706095
91587000586867.903511247132.096488753322
92597000595820.6181855981179.38181440228
93581000580850.103478141149.896521858719
94564000564936.221428609-936.221428609082
95558000556982.3631278141017.63687218589
96575000574943.28150799656.7184920035258
97580000580936.419749333-936.419749332857
98575000574961.77785182338.2221481767639
99563000564005.184982418-1005.18498241782
100552000551057.044813843942.955186157468
101537000537116.213719653-116.213719653439
102545000545094.733812217-94.7338122174301
103601000600858.058188974141.941811026182
104604000604816.490995545-816.490995544541
105586000586855.572615362-855.572615362166
106564000563962.02684682237.9731531779625
107549000548029.648453463970.351546536927
108551000551044.713917958-44.7139179580203
109556000556032.830337796-32.830337796082
110548000548066.641141117-66.641141116602
111540000540100.451944437-100.451944437119
112531000531135.406374202-135.406374201571
113521000520184.978952738815.021047261588
114519000518187.266205626812.733794373711
115572000571952.8778352747.1221647294596
116581000581898.283435235-898.283435235386
117563000562938.50868149761.4913185030438
118548000548017.317557579-17.3175575785631
119539000539064.602883228-64.602883227524
120541000541074.646526224-74.646526224163
121562000561020.946757634979.053242365857
122559000559029.399458464-29.3994584642695
123546000546081.259289889-81.2592898889829
124536000537116.213719653-1116.21371965344
125528000527152.311775862847.688224138168
126530000531135.406374202-1135.40637420157
127582000581929.11067494770.8893250533369
128599000598835.683650093164.316349907326
129584000583859.003494694140.996505306018
130571000571922.050595559-922.050595559265


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
60.757665802118190.484668395763620.24233419788181
70.6375510516929010.7248978966141970.362448948307098
80.5071230174077970.9857539651844050.492876982592203
90.6346862127505930.7306275744988140.365313787249407
100.5199351858835830.9601296282328330.480064814116417
110.4222506532890960.8445013065781930.577749346710904
120.3403351255004270.6806702510008540.659664874499573
130.2621376209734670.5242752419469330.737862379026533
140.1937674693350370.3875349386700750.806232530664963
150.1397885225643380.2795770451286760.860211477435662
160.3366513038798770.6733026077597550.663348696120123
170.5402747291539910.9194505416920180.459725270846009
180.461823176418170.9236463528363390.53817682358183
190.4316001676700190.8632003353400380.568399832329981
200.4889423549833580.9778847099667160.511057645016642
210.4795016821493930.9590033642987860.520498317850607
220.5158102373031820.9683795253936360.484189762696818
230.5789668740432430.8420662519135140.421033125956757
240.5415836284876850.916832743024630.458416371512315
250.4990929921927840.9981859843855670.500907007807216
260.4459605076305040.8919210152610080.554039492369496
270.5402106085061180.9195787829877630.459789391493882
280.4843444219891490.9686888439782990.51565557801085
290.4236616126427350.847323225285470.576338387357265
300.3660900527472360.7321801054944730.633909947252764
310.3644714666696410.7289429333392820.635528533330359
320.3673914602295380.7347829204590760.632608539770462
330.3524607695878110.7049215391756210.647539230412189
340.3172313850545970.6344627701091940.682768614945403
350.2723914657043240.5447829314086470.727608534295677
360.346772603696550.69354520739310.65322739630345
370.3020066855191070.6040133710382140.697993314480893
380.3740642121122070.7481284242244140.625935787887793
390.3301931246467560.6603862492935130.669806875353244
400.2841019304772310.5682038609544630.715898069522769
410.2396181012969990.4792362025939980.760381898703001
420.1993732096928760.3987464193857520.800626790307124
430.1798672178787910.3597344357575830.820132782121209
440.1639097413658370.3278194827316740.836090258634163
450.1464626421270590.2929252842541180.853537357872941
460.1245581906414680.2491163812829360.875441809358532
470.1705069451193370.3410138902386740.829493054880663
480.1424266873056490.2848533746112990.857573312694351
490.116278111959370.2325562239187410.88372188804063
500.09332714011739710.1866542802347940.906672859882603
510.07329340897712110.1465868179542420.926706591022879
520.05659156982862480.113183139657250.943408430171375
530.04302555374960010.08605110749920010.9569744462504
540.03225233542380250.06450467084760510.967747664576197
550.02573365723465540.05146731446931080.974266342765345
560.02081970687370670.04163941374741330.979180293126293
570.0165543682994180.03310873659883610.983445631700582
580.05540753648688230.1108150729737650.944592463513118
590.04250063659444160.08500127318888310.957499363405558
600.08355440426957520.167108808539150.916445595730425
610.06551711556637780.1310342311327560.934482884433622
620.05061960388645380.1012392077729080.949380396113546
630.03878775400912540.07757550801825070.961212245990875
640.02946812222150350.0589362444430070.970531877778496
650.02251869413448130.04503738826896260.977481305865519
660.01728635469579880.03457270939159760.982713645304201
670.01255882438879120.02511764877758250.987441175611209
680.03900273518294180.07800547036588360.960997264817058
690.02952027680480870.05904055360961740.970479723195191
700.02190649904961410.04381299809922820.978093500950386
710.01624214988041320.03248429976082630.983757850119587
720.01190378802748630.02380757605497260.988096211972514
730.008606126706013380.01721225341202680.991393873293987
740.01534301056917540.03068602113835080.984656989430825
750.01170758903565130.02341517807130250.988292410964349
760.009025055454774160.01805011090954830.990974944545226
770.00776385132513780.01552770265027560.992236148674862
780.009921762561887520.0198435251237750.990078237438113
790.02562223044847820.05124446089695640.974377769551522
800.05194176479928940.1038835295985790.948058235200711
810.03952930533583650.0790586106716730.960470694664163
820.03019147293463980.06038294586927950.96980852706536
830.02360817962846290.04721635925692580.976391820371537
840.01826844500820940.03653689001641880.981731554991791
850.01378783748379890.02757567496759770.986212162516201
860.01024292156937880.02048584313875750.989757078430621
870.007478517571539050.01495703514307810.992521482428461
880.005386963284049360.01077392656809870.994613036715951
890.007824155737312930.01564831147462590.992175844262687
900.005551929481785990.0111038589635720.994448070518214
910.003957931515813910.007915863031627810.996042068484186
920.02282544038034960.04565088076069930.97717455961965
930.01808542273932680.03617084547865360.981914577260673
940.03283325588685350.06566651177370710.967166744113146
950.06998986396829630.1399797279365930.930010136031704
960.05515195113244510.110303902264890.944848048867555
970.0790247871807810.1580495743615620.920975212819219
980.06104659809787780.1220931961957560.938953401902122
990.1109581645311660.2219163290623320.889041835468834
1000.1744953155353340.3489906310706680.825504684464666
1010.1425423845127620.2850847690255240.857457615487238
1020.1133764841249250.2267529682498510.886623515875075
1030.1007330912843080.2014661825686160.899266908715692
1040.1020910772642830.2041821545285650.897908922735717
1050.1200331928804530.2400663857609070.879966807119547
1060.09105584286764780.1821116857352960.908944157132352
1070.1670969610084850.334193922016970.832903038991515
1080.1280534222263260.2561068444526530.871946577773674
1090.09540541462316440.1908108292463290.904594585376836
1100.06951816239738480.139036324794770.930481837602615
1110.05002662006480120.1000532401296020.949973379935199
1120.03608328441535240.07216656883070480.963916715584648
1130.04456111758411870.08912223516823740.955438882415881
1140.07254722514581220.1450944502916240.927452774854188
1150.04955608127238490.09911216254476990.950443918727615
1160.08216772036022820.1643354407204560.917832279639772
1170.0584672004031340.1169344008062680.941532799596866
1180.04109109562687550.0821821912537510.958908904373124
1190.029798322777810.059596645555620.97020167722219
1200.01937761105281030.03875522210562060.98062238894719
1210.044501932459070.08900386491813990.95549806754093
1220.02415611841668420.04831223683336850.975843881583316
1230.01230310589779530.02460621179559050.987696894102205
1240.01997781151587950.0399556230317590.98002218848412


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level10.00840336134453781OK
5% type I error level290.243697478991597NOK
10% type I error level470.394957983193277NOK