Multiple Linear Regression - Estimated Regression Equation
Totaal[t] = + 1347.68074713005 -1.43242186513971Maanden[t] + 0.992798185983571jongerdan25jaar[t] + 0.998845974898212vanaf25jaar[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)1347.68074713005676.0094291.99360.0483570.024179
Maanden-1.4324218651397114.373044-0.09970.9207720.460386
jongerdan25jaar0.9927981859835710.002972334.076500
vanaf25jaar0.9988459748982120.00166601.754700


Multiple Linear Regression - Regression Statistics
Multiple R0.999913571775203
R-squared0.999827151020244
Adjusted R-squared0.999823035568345
F-TEST (value)242944.681549068
F-TEST (DF numerator)3
F-TEST (DF denominator)126
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation521.308738033867
Sum Squared Residuals34242112.8441584


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1476000476113.53222946-113.532229459931
2475000474132.551224542867.448775458159
3470000470153.878269828-153.878269827748
4461000461187.023229537-187.023229537265
5455000455222.753902856-222.753902856063
6456000455221.321480991778.678519009065
7517000516912.47573514487.5242648560498
8525000525834.131409302-834.131409301663
9523000522842.208851657157.791148343476
10519000518893.774841516106.225158484323
11509000508958.312770941.6872290998307
12512000511965.51385155934.4861484410496
13519000518979.24010527820.7598947223696
14517000517004.306889275-4.30688927462231
15510000510041.191587695-41.1915876952033
16509000510063.950321489-1063.95032148863
17501000500110.344884129889.655115870785
18507000507082.690919808-82.6909198076233
19569000569766.643359944-766.643359944207
20580000579705.288375744294.711624255923
21578000577712.211792997287.788207002852
22565000565785.1055615-785.105561499872
23547000547864.923480613-864.923480613324
24555000554861.46067195138.539328049691
25562000561875.186925669124.813074331019
26561000560893.05189565106.948104350451
27555000555939.724121696-939.724121695836
28544000543988.4267345411.5732654600033
29537000537031.359221875-31.3592218752192
30543000543010.90707157-10.90707157007
31594000593726.851179672273.148820327974
32611000610651.370230845348.629769155266
33613000612653.677547691346.322452309343
34611000610727.126643005272.873356995202
35594000593805.790537016194.209462983553
36595000595826.241220606-826.241220606296
37591000590878.006931205121.99306879502
38589000589895.871901186-895.871901185555
39584000583931.60257450468.3974254956526
40573000572973.10337333226.8966266679246
41567000567008.834046651-8.83404665086795
42569000568999.0457856670.954214332485697
43621000620719.883657582280.116342417662
44629000628660.836723586339.163276414246
45628000627660.558326822339.441673177595
46612000611738.068195732261.93180426771
47595000595815.578064642-815.578064642157
48597000596843.230562248156.76943775157
49593000592905.93782557594.0621744253929
50590000589920.06305684479.9369431558771
51580000579966.45761948533.5423805152911
52574000573990.0927149749.9072850257942
53573000573007.957684955-7.95768495478473
54573000573000.477474175-0.477474175010752
55620000619751.276627257248.723372742667
56626000625706.633321294293.36667870639
57620000619718.172838954281.827161046157
58588000586845.5400791671154.4599208327
59566000565934.86786250165.1321374992416
60557000557985.002163852-985.002163852409
61561000560991.2489401498.75105985105
62549000549039.951552993-39.951552993107
63532000532094.424291346-94.4242913462088
64526000526118.059386836-118.059386835721
65511000511176.2718639-176.271863899885
66499000499200.783321086-200.783321085474
67555000554947.24403716652.755962833654
68565000563899.1386558971100.86134410273
69542000541959.38151975940.6184802406926
70527000527029.689574653-29.6895746527567
71510000510102.30567975-102.305679749774
72514000514102.304946392-102.304946392125
73517000517114.599511603-114.599511603304
74508000507148.898496415851.101503585394
75493000493199.909159462-199.909159462343
76490000490214.034390732-214.034390731844
77469000469291.266596236-291.266596236028
78478000477262.458606813737.54139318733
79528000529025.63100113-1025.63100112996
80534000532995.3913231991004.6086768009
81518000518029.412644605-29.4126446046986
82506000506090.210835278-90.2108352781367
83502000502117.585669479-117.585669478714
84516000516087.901318359-87.9013183592683
85528000528077.714079825-77.7140798250737
86533000533070.511532451-70.511532450995
87536000536071.664824195-71.664824195132
88537000537075.126166143-75.1261661428465
89524000523138.23240702861.767592980135
90536000536097.606503173-97.6065031729217
91587000586867.980711507132.019288493353
92597000595819.8753302381180.12466976242
93581000580847.848862729152.15113727147
94564000564931.406520553-931.406520553048
95558000556975.493032991024.50696700994
96575000574935.14479254964.8552074511854
97580000580943.977282455-943.977282454627
98575000574967.61237794432.3876220558672
99563000564009.113176772-1009.11317677187
100552000551058.969814718941.030185282183
101537000537116.02826668-116.028266680196
102545000545093.268066171-93.268066171474
103601000600857.872148996142.127851003739
104604000604815.536893236-815.53689323613
105586000586853.020289947-853.020289947085
106564000563956.75170131343.2482986865999
107549000548022.165992394977.834007606004
108551000551035.414861967-35.4148619674113
109556000556039.35358806-39.3535880603753
110548000548071.344522668-71.3445226680975
111540000540103.335457276-103.335457275831
112531000531136.480416985-136.480416985346
113521000520184.029004728815.970995272278
114519000518184.904633066815.095366933845
115572000571951.81676609548.1832339054785
116581000581896.509570809-896.50957080901
117563000562935.14699262264.8530073782343
118548000548011.50283643-11.5028364298513
119539000539056.743373969-56.7433739686518
120541000541065.098479729-65.0984797292191
121562000561027.535673637972.464326363205
122559000559034.45909089-34.4590908898687
123546000546084.315728836-84.315728835817
124536000537117.460688545-1117.46068854534
125528000527151.759673357848.240326643359
126530000531133.615573255-1133.61557325507
127582000581928.18093724771.8190627526435
128599000598834.556621676165.443378323864
129584000583856.482365252143.517634747552
130571000571917.280555926-917.280555925892


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
70.762914144935270.4741717101294610.23708585506473
80.6351564356678530.7296871286642940.364843564332147
90.7328401867529660.5343196264940680.267159813247034
100.6199909919701870.7600180160596250.380009008029813
110.5215755756473750.9568488487052510.478424424352625
120.4304021968368940.8608043936737880.569597803163106
130.3341970659350650.668394131870130.665802934064935
140.250139646612110.500279293224220.74986035338789
150.1838701421374070.3677402842748150.816129857862593
160.4052547951877850.810509590375570.594745204812215
170.5907697452770120.8184605094459760.409230254722988
180.5137005844354730.9725988311290540.486299415564527
190.479037101919750.95807420383950.52096289808025
200.5361975967337740.9276048065324530.463802403266226
210.5216512565568710.9566974868862590.478348743443129
220.5647054994844830.8705890010310330.435294500515517
230.6224164211745750.7551671576508490.377583578825425
240.5871387985304840.8257224029390320.412861201469516
250.5409315360662570.9181369278674860.459068463933743
260.4831141351932760.9662282703865520.516885864806724
270.5799997072621090.8400005854757830.420000292737891
280.5242274581909590.9515450836180820.475772541809041
290.4630781737899790.9261563475799580.536921826210021
300.4042160033253460.8084320066506930.595783996674654
310.400202548790870.8004050975817410.59979745120913
320.4008372487507860.8016744975015710.599162751249214
330.3848147011204490.7696294022408990.615185298879551
340.3488054817099560.6976109634199120.651194518290044
350.301396619488550.6027932389770990.69860338051145
360.3679332685398240.7358665370796480.632066731460176
370.3175472106186980.6350944212373960.682452789381302
380.3996798907569360.7993597815138730.600320109243064
390.3533861611466720.7067723222933430.646613838853328
400.3054495538397710.6108991076795420.694550446160229
410.2591640791394940.5183281582789870.740835920860506
420.2170389486990130.4340778973980260.782961051300987
430.1954253309964780.3908506619929560.804574669003522
440.1775520037801480.3551040075602960.822447996219852
450.1587737216345180.3175474432690370.841226278365482
460.1359224502108650.271844900421730.864077549789135
470.1769038308862190.3538076617724370.823096169113781
480.1506109340905260.3012218681810510.849389065909474
490.1221391541964040.2442783083928080.877860845803596
500.09758267182194130.1951653436438830.902417328178059
510.07655201229471040.1531040245894210.92344798770529
520.05912025961517340.1182405192303470.940879740384827
530.04498717543222240.08997435086444480.955012824567778
540.03377547537792460.06755095075584920.966224524622075
550.02685247104245980.05370494208491970.97314752895754
560.02166872210754580.04333744421509160.978331277892454
570.01728253711090940.03456507422181870.982717462889091
580.05875001069899160.1175000213979830.941249989301008
590.04516912276122090.09033824552244180.954830877238779
600.08240719581780180.1648143916356040.917592804182198
610.06444101576372520.128882031527450.935558984236275
620.04964927941569840.09929855883139670.950350720584302
630.03789472422607350.0757894484521470.962105275773926
640.02864201384982850.0572840276996570.971357986150172
650.02171838627601930.04343677255203850.978281613723981
660.016511587487030.033023174974060.98348841251297
670.01196705777467580.02393411554935150.988032942225324
680.03858746830171340.07717493660342670.961412531698287
690.02921645926856220.05843291853712430.970783540731438
700.0216515557164030.0433031114328060.978348444283597
710.01604691198831180.03209382397662360.983953088011688
720.01182129744409180.02364259488818370.988178702555908
730.008471621104072440.01694324220814490.991528378895928
740.01545643274074930.03091286548149850.984543567259251
750.01157568815802580.02315137631605150.988424311841974
760.008746566148751640.01749313229750330.991253433851248
770.007348524815169530.01469704963033910.99265147518483
780.009733381245958810.01946676249191760.990266618754041
790.02384329315812130.04768658631624260.976156706841879
800.05072468000929040.1014493600185810.94927531999071
810.03842678800984970.07685357601969940.96157321199015
820.02906345544395490.05812691088790980.970936544556045
830.02256800579144370.04513601158288740.977431994208556
840.01763521994948610.03527043989897220.982364780050514
850.01288452948751420.02576905897502840.987115470512486
860.009314526555796010.0186290531115920.990685473444204
870.006676862120788010.0133537242415760.993323137879212
880.004755224759531140.009510449519062290.995244775240469
890.006996436004849990.01399287200970.99300356399515
900.004907106811737250.009814213623474490.995092893188263
910.003485006318068670.006970012636137350.996514993681931
920.0212674697510180.04253493950203610.978732530248982
930.01773097957851450.03546195915702910.982269020421485
940.02997920552960630.05995841105921270.970020794470394
950.06462199855306550.1292439971061310.935378001446935
960.04929758453189270.09859516906378540.950702415468107
970.06989284763590830.1397856952718170.930107152364092
980.05339326183256410.1067865236651280.946606738167436
990.09826242388196540.1965248477639310.901737576118035
1000.1547384299076840.3094768598153690.845261570092316
1010.1248385719115250.249677143823050.875161428088475
1020.09786505437414640.1957301087482930.902134945625854
1030.08704000348530740.1740800069706150.912959996514693
1040.0868003937618460.1736007875236920.913199606238154
1050.1025842659790570.2051685319581130.897415734020943
1060.0765790520097970.1531581040195940.923420947990203
1070.1495187529518380.2990375059036750.850481247048162
1080.1151097170394910.2302194340789830.884890282960509
1090.08630560275493520.172611205509870.913694397245065
1100.06418222926290190.1283644585258040.935817770737098
1110.04752932201074880.09505864402149750.952470677989251
1120.03555943930628620.07111887861257240.964440560693714
1130.04286548624501920.08573097249003830.957134513754981
1140.07124921898707840.1424984379741570.928750781012922
1150.04863518052685850.0972703610537170.951364819473141
1160.07598601910806040.1519720382161210.92401398089194
1170.0490213020487240.09804260409744790.950978697951276
1180.03186865667917530.06373731335835060.968131343320825
1190.02346139295383110.04692278590766220.976538607046169
1200.03692683598018730.07385367196037460.963073164019813
1210.03304864095819190.06609728191638390.966951359041808
1220.01749588507217580.03499177014435160.982504114927824
1230.007573143856475270.01514628771295050.992426856143525


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level30.0256410256410256NOK
5% type I error level290.247863247863248NOK
10% type I error level500.427350427350427NOK