Multiple Linear Regression - Estimated Regression Equation
Totaal[t] = + 121.350385460641 + 15.4495309520155crisis[t] + 1.07950932409880`t-1`[t] -0.50927530639777`t-2`[t] + 0.0759563844468494`t-3`[t] + 0.0672167107393819`t-4`[t] + 0.440072107331956`t-12`[t] -0.382095098205888`t-24 `[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)121.35038546064187.2771621.39040.1703290.085165
crisis15.44953095201558.9710251.72220.0909850.045492
`t-1`1.079509324098800.1420877.597500
`t-2`-0.509275306397770.20721-2.45780.017350.008675
`t-3`0.07595638444684940.2052240.37010.71280.3564
`t-4`0.06721671073938190.148430.45290.6525390.326269
`t-12`0.4400721073319560.159092.76620.0078340.003917
`t-24 `-0.3820950982058880.152642-2.50320.0154860.007743


Multiple Linear Regression - Regression Statistics
Multiple R0.92733413415113
R-squared0.859948596361827
Adjusted R-squared0.84109552279515
F-TEST (value)45.6131777834778
F-TEST (DF numerator)7
F-TEST (DF denominator)52
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation16.2044643843294
Sum Squared Residuals13654.402631116


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1591597.775264231122-6.7752642311221
2589591.846377760334-2.84637776033359
3584590.691965683054-6.69196568305394
4573581.617662765862-8.6176627658618
5567571.844913155236-4.84491315523601
6569570.803532292062-1.80353229206206
7621573.60038038119947.3996196188013
8629630.799372241105-1.79937224110505
9628614.34607781674413.6539221832555
10612617.363623516191-5.36362351619113
11595604.100155614093-9.10015561409346
12597591.7419906299315.25800937006879
13593596.841216508233-3.84121650823289
14590588.6398535751581.36014642484243
15580586.539865567352-6.539865567352
16574576.465459028862-2.46545902886191
17573574.618653195398-1.61865319539820
18573574.221155358428-1.22115535842797
19620576.99942482351243.0005751764878
20626624.2820665964281.71793340357167
21620605.55170412584314.4482958741572
22588593.311982890966-5.31198289096582
23566564.452650914481.54734908552033
24557557.445866663248-0.445866663247895
25561555.868526883875.13147311613013
26549560.39204061077-11.39204061077
27532540.748206817415-8.74820681741515
28526529.769340561915-3.76934056191475
29511533.159853537583-22.1598535375827
30499517.160816253607-18.1608162536066
31555526.51138646104828.4886135389518
32565591.11623811456-26.1162381145599
33542569.213849377034-27.2138493770340
34527534.770552995607-7.7705529956065
35510531.628975135344-21.6289751353441
36514515.116777324348-1.11677732434796
37517528.695833537948-11.6958335379481
38508523.4631710946-15.4631710946005
39493507.720627871151-14.7206278711515
40490496.260339708791-6.26033970879102
41469493.959997492884-24.9599974928842
42478465.79296615466212.2070338453380
43528491.65278008638636.3472199136141
44534541.356184812228-7.35618481222837
45518513.8124440920284.18755590797234
46506503.5133742196662.48662578033381
47502503.449107412381-1.44910741238136
48516509.6295162192276.37048378077309
49528524.5846399261813.41536007381878
50533529.9229636716213.07703632837886
51536529.8982642141616.10173578583897
52537533.4152804854223.58471951457841
53524530.643258560551-6.64325856055116
54536525.21010489236510.7898951076353
55587545.66868214845441.3313178515456
56597592.5116193755834.4883806244168
57581579.1183649054591.88163509454067
58564561.8843999766682.11560002333245
59558560.604090701701-2.60409070170147
60575566.8742090319398.1257909680612


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
110.1109486312310290.2218972624620590.88905136876897
120.04823294766597030.09646589533194050.95176705233403
130.01955030496209770.03910060992419540.980449695037902
140.01273864970383090.02547729940766180.98726135029617
150.01573696179544660.03147392359089330.984263038204553
160.01167930073898430.02335860147796860.988320699261016
170.008131131241474310.01626226248294860.991868868758526
180.006030130248794730.01206026049758950.993969869751205
190.009405711752644780.01881142350528960.990594288247355
200.004393252790378480.008786505580756960.995606747209622
210.004333117604534390.008666235209068770.995666882395466
220.004849237066491710.009698474132983420.995150762933508
230.002414770104483750.00482954020896750.997585229895516
240.002075811367882060.004151622735764130.997924188632118
250.002606787920088410.005213575840176820.997393212079912
260.01625000389456770.03250000778913550.983749996105432
270.03400063471372020.06800126942744040.96599936528628
280.03729381717730050.0745876343546010.9627061828227
290.0887273779206560.1774547558413120.911272622079344
300.1103248882362560.2206497764725110.889675111763744
310.1757243429421340.3514486858842670.824275657057866
320.2527786933238340.5055573866476690.747221306676166
330.2554662193704460.5109324387408930.744533780629554
340.2662845822700090.5325691645400190.73371541772999
350.2785883522136230.5571767044272450.721411647786377
360.3020861381671790.6041722763343570.697913861832821
370.2950897481335490.5901794962670990.70491025186645
380.3207009266017630.6414018532035260.679299073398237
390.4073179938728060.8146359877456130.592682006127194
400.4976825663699990.9953651327399970.502317433630001
410.693741499481250.61251700103750.30625850051875
420.7476166175711680.5047667648576640.252383382428832
430.870739091496840.2585218170063210.129260908503161
440.9370823206874970.1258353586250060.0629176793125032
450.930383974486650.1392320510266990.0696160255133496
460.9001778130344720.1996443739310570.0998221869655284
470.8243222913707190.3513554172585620.175677708629281
480.7156824925815680.5686350148368640.284317507418432
490.6243718882591150.7512562234817690.375628111740885


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level60.153846153846154NOK
5% type I error level140.358974358974359NOK
10% type I error level170.435897435897436NOK