Multiple Linear Regression - Estimated Regression Equation
Totaal[t] = + 0.00491514014106615 + 0.999983239776429InbrengInContanten[t] + 1.00005149645888InbrengInNatura[t] + 0.999970165231271TeStortenBedrag[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)0.004915140141066150.0638070.0770.938730.469365
InbrengInContanten0.9999832397764290.0002533948.400500
InbrengInNatura1.000051496458883.8e-0526319.551900
TeStortenBedrag0.9999701652312710.0003972521.321800


Multiple Linear Regression - Regression Statistics
Multiple R0.999999927363938
R-squared0.999999854727882
Adjusted R-squared0.999999851002955
F-TEST (value)268461661.658462
F-TEST (DF numerator)3
F-TEST (DF denominator)117
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation0.586834386097299
Sum Squared Residuals40.2918278146247


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1337337.014697184225-0.0146971842250384
2430430.023937652523-0.0239376525231721
3169169.00874412943-0.0087441294296469
4133133.005869290629-0.00586929062917818
57676.0045794594835-0.00457945948346171
6328328.010222530333-0.0102225303328232
7175175.008968892997-0.00896889299739897
8169170.003632728393-1.00363272839307
9165165.006597923437-0.00659792343735183
10141142.008062440954-1.00806244095353
119292.0049938627308-0.00499386273082084
12233233.015005511907-0.0150055119071485
13110110.006330339085-0.00633033908523825
14170170.004980558302-0.00498055830209302
159494.0045406116005-0.00454061160047947
16125125.003994895579-0.00399489557948544
17100100.004489464483-0.0044894644830544
1884348433.430614814130.569385185865635
19126126.008064884433-0.00806488443269254
20381382.014570358852-1.01457035885168
21799799.03084514503-0.030845145029819
22150150.00353224368-0.00353224367952425
23190189.0071643461710.992835653828913
24165165.007186084489-0.00718608448914515
25162162.004831422772-0.00483142277234335
26137138.005861052825-1.00586105282522
27131131.005227550883-0.00522755088341177
28162163.005733916424-1.00573391642428
29141142.004001840967-1.00400184096706
30247247.005616973217-0.00561697321704674
31175175.008107705216-0.00810770521592634
32357356.010618854530.989381145470473
33107107.004892047287-0.00489204728732144
34310311.014662459893-1.01466245989281
35116115.0038690899080.996130910091609
36376375.0174150637580.982584936242078
37230230.006876526511-0.00687652651081953
385454.0043048412131-0.00430484121311104
39194194.010682190721-0.0106821907211339
40171172.007081837469-1.00708183746919
41311311.016408100589-0.0164081005894571
42290289.0124795384710.987520461529447
4344354434.95531453540.0446854645993039
44440440.018077057836-0.0180770578357414
4514301430.05194496729-0.051944967286954
46820820.02335103253-0.023351032530128
47223223.003602740369-0.0036027403686093
48426426.005658065623-0.00565806562279841
4916931693.00462220596-0.00462220595743484
5020682067.107297720650.892702279349616
51832831.0058788869530.994121113046785
52416415.0136759880620.986324011938373
53372372.016158276874-0.0161582768736484
5452665266.17717462468-0.177174624685369
55633633.025143325823-0.0251433258226496
56191190.003492103380.99650789661952
57337336.0083631890250.991636810975383
58280280.007869716451-0.0078697164512766
59619619.010354956979-0.010354956979416
6024232422.980172392280.0198276077210771
61538538.008118776494-0.00811877649389344
62294293.0120291065720.987970893428138
63430430.005351453721-0.00535145372089477
64737738.013253632056-1.01325363205629
65541541.019124733141-0.0191247331414276
6612141213.042866963450.957133036552564
67929929.040710063842-0.0407100638416653
6812881288.0650427569-0.0650427568967676
69321321.009362531928-0.0093625319284415
7019121911.074807999570.925192000427203
71146146.006168428135-0.00616842813502884
72357357.013831884796-0.0138318847960448
73473473.015641816396-0.0156418163963484
74153153.008145337311-0.00814533731073693
75681682.002928700215-1.00292870021483
76337337.013202843843-0.0132028438432513
77433433.019913871007-0.0199138710070881
78751752.033608090134-1.03360809013386
79655656.025623257657-1.02562325765679
80233232.0028825797630.997117420236714
81118118.00397570378-0.00397570377951059
82146146.005060362714-0.00506036271401843
83365366.009014978006-1.00901497800574
84653653.029108292345-0.0291082923453749
85434433.0078568551050.992143144894659
86231230.0115514366390.988448563360611
87123123.006535070819-0.00653507081867514
88259259.007123806314-0.00712380631392022
899897.00489987102440.995100128975577
9021072107.09452395902-0.0945239590188296
91715714.0349986860930.965001313906838
92136136.004333321446-0.00433332144603624
93180181.004626226756-1.00462622675576
94172173.007002588477-1.00700258847656
95170170.007026720057-0.00702672005696018
96380381.01193376033-1.01193376032985
97813813.036914920537-0.0369149205371478
98708708.013001579542-0.0130015795420971
99193194.007723888242-1.00772388824222
100248248.010628135841-0.0106281358412364
101725725.028308212386-0.0283082123862632
1021300713007.6495499781-0.649549978063922
103976975.0445297885020.955470211498316
104185185.008189864576-0.00818986457630694
105234235.004637351121-1.00463735112126
106185185.007575554434-0.00757555443431168
107217217.009850825805-0.00985082580546123
108802802.018526158739-0.0185261587390211
109705704.031345259350.96865474065004
110304303.0100925985060.989907401494141
111395396.006599445472-1.00659944547163
112439439.014580810251-0.0145808102508882
113321321.014836141069-0.0148361410693253
11410151015.03751285333-0.0375128533294176
115340340.016337362114-0.0163373621138489
116372371.9995407508320.000459249167639785
11717721772.08859171876-0.0885917187550878
118163163.004463188548-0.00446318854808532
119197197.004159061045-0.00415906104457069
120610610.029065083907-0.0290650839068782
121313313.012804851478-0.0128048514780829


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
71.50040998579927e-403.00081997159854e-401
80.1495184398945260.2990368797890530.850481560105474
90.07288421596020040.1457684319204010.9271157840398
100.2067922920008670.4135845840017350.793207707999133
110.126617621707440.2532352434148810.87338237829256
120.07746255364973820.1549251072994760.922537446350262
130.04453696369123860.08907392738247710.955463036308762
140.03322556166550460.06645112333100920.966774438334495
150.0210015792775110.04200315855502210.978998420722489
160.01195606713343690.02391213426687380.988043932866563
170.005999443454345270.01199888690869050.994000556545655
180.003099587303572080.006199174607144160.996900412696428
190.001456127621685350.002912255243370710.998543872378315
200.007145802177538770.01429160435507750.992854197822461
210.008512293149298250.01702458629859650.991487706850702
220.006508992730624560.01301798546124910.993491007269375
230.03677131430391290.07354262860782580.963228685696087
240.02390843946931590.04781687893863190.976091560530684
250.01508633098376030.03017266196752060.98491366901624
260.04516285338702220.09032570677404430.954837146612978
270.03058547677021950.0611709535404390.969414523229781
280.05842983408614160.1168596681722830.941570165913858
290.08221457598112920.1644291519622580.917785424018871
300.07847845828163040.1569569165632610.92152154171837
310.05773755552987660.1154751110597530.942262444470123
320.09150886021918910.1830177204383780.908491139780811
330.06824125582965760.1364825116593150.931758744170342
340.1183504489715190.2367008979430390.881649551028481
350.2855678808233590.5711357616467180.714432119176641
360.4130183785524020.8260367571048030.586981621447598
370.3561668236242070.7123336472484140.643833176375793
380.3047397431921580.6094794863843160.695260256807842
390.2561371441766160.5122742883532320.743862855823384
400.3456694486345130.6913388972690270.654330551365487
410.2953986498585490.5907972997170980.704601350141451
420.4004323306877320.8008646613754640.599567669312268
430.3561371476094740.7122742952189490.643862852390526
440.3050845380626970.6101690761253950.694915461937303
450.2715009862549120.5430019725098250.728499013745088
460.2281132950908130.4562265901816260.771886704909187
470.1885102434264870.3770204868529740.811489756573513
480.153310789748220.306621579496440.84668921025178
490.1245435382560230.2490870765120460.875456461743977
500.1575056214312060.3150112428624130.842494378568794
510.2048758176218730.4097516352437460.795124182378127
520.2796586021010080.5593172042020160.720341397898992
530.2358528675807750.4717057351615490.764147132419225
540.2157198004102560.4314396008205110.784280199589744
550.1785557782875890.3571115565751790.821444221712411
560.2544748616641020.5089497233282040.745525138335898
570.331612604601630.6632252092032610.66838739539837
580.2843836424394910.5687672848789820.715616357560509
590.2420957984790880.4841915969581770.757904201520912
600.255173025523580.5103460510471610.74482697447642
610.2153272427305660.4306544854611320.784672757269434
620.2908401979470080.5816803958940160.709159802052992
630.249574058014190.4991481160283810.75042594198581
640.3357436161652430.6714872323304860.664256383834757
650.2886985530912490.5773971061824980.711301446908751
660.3498616164412110.6997232328824220.650138383558789
670.3022042673921140.6044085347842270.697795732607886
680.2585989705157650.517197941031530.741401029484235
690.2171922126570350.4343844253140710.782807787342965
700.3252177625664090.6504355251328180.674782237433591
710.2780994849347580.5561989698695150.721900515065242
720.2344830470254710.4689660940509410.765516952974529
730.195451893499910.390903786999820.80454810650009
740.1600406599679980.3200813199359960.839959340032002
750.1835179298678120.3670358597356250.816482070132188
760.1493167365507320.2986334731014640.850683263449268
770.1195870875341960.2391741750683930.880412912465804
780.1818973794281340.3637947588562670.818102620571866
790.263052482150740.5261049643014790.73694751784926
800.3578494554343410.7156989108686830.642150544565659
810.3062698290240140.6125396580480280.693730170975986
820.2579745203823890.5159490407647770.742025479617611
830.3314601565868340.6629203131736670.668539843413166
840.2805989628571720.5611979257143440.719401037142828
850.3943317321100690.7886634642201370.605668267889931
860.4854483332432080.9708966664864160.514551666756792
870.4257870707906290.8515741415812580.574212929209371
880.367375678778330.734751357556660.63262432122167
890.4740721001823840.9481442003647680.525927899817616
900.4157158217830230.8314316435660470.584284178216977
910.5398064954780520.9203870090438950.460193504521948
920.47709902923790.95419805847580.5229009707621
930.575810722462840.8483785550743190.42418927753716
940.6894582053988750.6210835892022490.310541794601125
950.6265630103459130.7468739793081740.373436989654087
960.7415201897198030.5169596205603950.258479810280197
970.6805640839567930.6388718320864140.319435916043207
980.6180933367696960.7638133264606070.381906663230304
990.7764717708030080.4470564583939850.223528229196992
1000.7172477197057970.5655045605884070.282752280294203
1010.6473173450869960.7053653098260080.352682654913004
1020.6608741581201190.6782516837597610.339125841879881
1030.7461878364500950.5076243270998090.253812163549905
1040.6722892079617730.6554215840764550.327710792038227
1050.8455237770945210.3089524458109580.154476222905479
1060.784559873824090.430880252351820.21544012617591
1070.7115780895096220.5768438209807550.288421910490378
1080.7054786817006870.5890426365986270.294521318299313
1090.8032061522618090.3935876954763820.196793847738191
1100.9814181078340290.0371637843319420.018581892165971
11111.49261749887831e-817.46308749439154e-82
11214.89685317493195e-652.44842658746598e-65
11314.2835342588276e-532.1417671294138e-53
11411.76176946960249e-408.80884734801244e-41


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level70.0648148148148148NOK
5% type I error level160.148148148148148NOK
10% type I error level210.194444444444444NOK