Multiple Linear Regression - Estimated Regression Equation
Werkl[t] = -37913.5795481944 + 0.167921847385156x[t] + 0.983692389278356`y-1`[t] -0.262137203471688`y-2`[t] + 856.237856090604M1[t] + 1422.34146979028M2[t] + 645.643330794933M3[t] + 7996.00756864989M4[t] + 26773.9655269154M5[t] -109.931030073537M6[t] -10226.4147700189M7[t] -153.278421988093M8[t] -1876.05346206772M9[t] + 7808.93801645004M10[t] -1.11551941151744M11[t] -54.7353627623493t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)-37913.579548194424602.591742-1.5410.1294890.064745
x0.1679218473851560.0934631.79670.0783110.039156
`y-1`0.9836923892783560.1551816.33900
`y-2`-0.2621372034716880.14998-1.74780.0865140.043257
M1856.2378560906043091.6764390.27690.7829380.391469
M21422.341469790283123.5607350.45540.6507840.325392
M3645.6433307949333281.6332940.19670.8448090.422405
M47996.007568649893115.8996632.56620.0132620.006631
M526773.96552691545380.7963924.97588e-064e-06
M6-109.9310300735375995.742542-0.01830.9854430.492722
M7-10226.41477001893436.071346-2.97620.0044540.002227
M8-153.2784219880933999.797006-0.03830.9695810.48479
M9-1876.053462067723544.949911-0.52920.598950.299475
M107808.938016450043302.6557462.36440.0219020.010951
M11-1.115519411517443287.674264-3e-040.9997310.499865
t-54.735362762349355.020009-0.99480.3245170.162259


Multiple Linear Regression - Regression Statistics
Multiple R0.988435732988545
R-squared0.977005198248602
Adjusted R-squared0.970242021262897
F-TEST (value)144.45950480279
F-TEST (DF numerator)15
F-TEST (DF denominator)51
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation4996.85437277711
Sum Squared Residuals1273396234.75983


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1209465209561.228590528-96.2285905275284
2204045204741.466955078-696.4669550782
3200237198494.0764008311742.92359916866
4203666204482.194695522-816.194695522485
5241476236108.4901866265367.50981337371
6260307248358.19623077411948.8037692263
7243324247110.136264965-3786.13626496471
8244460235269.7324632649190.26753673597
9233575236180.537605615-2605.53760561483
10237217235021.6296185162195.37038148382
11235243232822.2185037832420.78149621709
12230354229622.554323738731.445676261644
13227184225300.8624991341883.13750086607
14221678222073.295976653-395.295976652897
15217142215708.8762078921433.12379210799
16219452220249.776991623-797.77699162257
17256446251117.1183240515328.88167594948
18265845261332.0608475854512.93915241516
19248624250599.577761978-1975.57776197764
20241114238507.9239654412606.07603455865
21229245231050.670664757-1805.67066475674
22231805231265.812459148539.187540852268
23219277228403.730288793-9126.73028879309
24219313214795.1536687994517.84633120140
25212610217191.062835046-4581.06283504648
26214771210159.9492470534611.05075294656
27211142212971.252431636-1829.25243163623
28211457216158.626077849-4701.62607784869
29240048243972.363821706-3924.36382170613
30240636246124.075956097-5488.07595609693
31230580228046.9397471852533.06025281487
32208795222596.829016315-13801.8290163150
33197922198350.997844826-428.997844825983
34194596201574.263385931-6978.26338593104
35194581193842.409353981738.590646019228
36185686192677.522568489-6991.5225684888
37178106181847.948057314-3741.94805731378
38172608176268.416112548-3660.41611254765
39167302169516.796845914-2214.79684591444
40168053170955.983464945-2902.98346494474
41202300201330.027793155969.972206844983
42202388209432.79481873-7044.79481873001
43182516186519.608191053-4003.60819105272
44173476174517.529954869-1041.52995486892
45166444166164.344960978279.655039021949
46171297171987.867705375-690.86770537542
47169701171187.630588166-1486.63058816635
48164182166719.969429707-2537.96942970671
49161914160002.2601252621911.73987473831
50159612159329.863188347282.136811653336
51151001153321.281279458-2320.28127945761
52158114154130.5961839143983.40381608574
53186530190638.348128768-4108.34812876756
54187069190662.77796118-3593.77796118002
55174330170945.7409801013384.25901989892
56169362166314.9846001113047.01539988933
57166827162266.4489238244560.55107617561
58178037173102.4268310304934.57316897038
59186412178958.0112652777453.98873472312
60189226184945.8000092684280.19999073248
61191563186938.6378927174624.36210728341
62188906189047.008520321-141.008520321151
63186005182816.7168342683188.28316573162
64195309190073.8225861475235.17741385274
65223532227165.651745694-3633.65174569448
66226899227234.094185635-335.094185634512
67214126210277.9970547193848.00294528128


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
190.01830028672406480.03660057344812950.981699713275935
200.01807827836038710.03615655672077410.981921721639613
210.006263339748652080.01252667949730420.993736660251348
220.006601260091285330.01320252018257070.993398739908715
230.1737717370215930.3475434740431860.826228262978407
240.1814705501252430.3629411002504860.818529449874757
250.1611198765504440.3222397531008890.838880123449556
260.5134021384482950.973195723103410.486597861551705
270.4497911801643390.8995823603286790.55020881983566
280.3576738360744250.715347672148850.642326163925575
290.5961152308007520.8077695383984950.403884769199248
300.9612473790203760.07750524195924840.0387526209796242
310.9827311932322790.03453761353544210.0172688067677211
320.971099545410390.057800909179220.02890045458961
330.9875606977738150.024878604452370.012439302226185
340.9889491276875060.02210174462498910.0110508723124945
350.995506831005980.008986337988039140.00449316899401957
360.9921492682608260.01570146347834780.0078507317391739
370.9913571604323640.01728567913527270.00864283956763636
380.9835313962890120.03293720742197530.0164686037109877
390.9915757535747170.01684849285056640.00842424642528322
400.996794378574080.006411242851840150.00320562142592007
410.9996406934475950.0007186131048101730.000359306552405086
420.9989459801622760.002108039675448330.00105401983772417
430.9968209391498830.00635812170023470.00317906085011735
440.991559364723540.01688127055292030.00844063527646015
450.9893539834755440.02129203304891210.0106460165244560
460.9946360367837880.01072792643242350.00536396321621177
470.9819506075004090.03609878499918210.0180493924995911
480.998579164146250.002841671707499370.00142083585374969


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level60.2NOK
5% type I error level210.7NOK
10% type I error level230.766666666666667NOK