Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 72515.1331006383 + 0.548453531164433X[t] + 3444.62240244408M1[t] + 5252.44902743883M2[t] + 6444.18114239702M3[t] + 7655.64877227978M4[t] + 9291.3039631184M5[t] + 9145.69561028996M6[t] -3397.38353593821M7[t] -10003.1470243896M8[t] -9464.2835414011M9[t] -5046.2793650683M10[t] -2975.32673037337M11[t] -213.238635508375t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)72515.133100638312756.9332785.684400
X0.5484535311644330.02909618.849600
M13444.622402444082219.6827761.55190.1261370.063069
M25252.449027438832195.9181962.39190.0200230.010011
M36444.181142397022195.1524782.93560.0047650.002382
M47655.648772279782232.3498553.42940.001120.00056
M59291.30396311842311.3396674.01990.000178.5e-05
M69145.695610289962321.1421913.94020.0002210.000111
M7-3397.383535938212302.920102-1.47530.1455530.072777
M8-10003.14702438962472.023054-4.04650.0001567.8e-05
M9-9464.28354140112401.19951-3.94150.000220.00011
M10-5046.27936506832272.792059-2.22030.030320.01516
M11-2975.326730373372179.989875-1.36480.1775760.088788
t-213.23863550837571.089081-2.99960.0039790.001989


Multiple Linear Regression - Regression Statistics
Multiple R0.990415764972113
R-squared0.980923387505297
Adjusted R-squared0.976647595049587
F-TEST (value)229.413236883256
F-TEST (DF numerator)13
F-TEST (DF denominator)58
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation3775.4821923672
Sum Squared Residuals826747415.523148


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1344744346060.066504933-1316.06650493254
2338653341125.863659437-2472.86365943729
3327532331669.480254953-4137.48025495261
4326225329746.097288814-3521.09728881405
5318672323144.090229678-4472.0902296775
6317756321233.668201677-3477.66820167649
7337302335369.1239599941932.87604000558
8349420346311.2409892643108.75901073634
9336923336176.760090376746.239909624273
10330758331350.141333515-592.141333515424
11321002321784.116732078-782.116732078
12320820322338.130910475-1518.13091047498
13327032329335.745075917-2303.74507591685
14324047327109.257313781-3062.25731378062
15316735321461.335229702-4726.33522970174
16315710319650.933690983-3940.93369098307
17313427317354.835305018-3927.83530501847
18310527314385.89796187-3858.89796187012
19330962330525.951376594436.04862340595
20339015337779.1699552511235.83004474867
21341332339889.4625931401442.53740685949
22339092338557.041283329534.958716671184
23323308322948.155675522359.844324478328
24325849325755.76541347393.2345865266907
25330675331719.54467267-1044.54467267022
26332225332522.165763155-297.165763155156
27331735331215.801831774519.198168226073
28328047327174.839781809872.160218190492
29326165325017.5001392301147.49986077049
30327081325153.3582360031927.64176399699
31346764345973.914085684790.085914315782
32344190343731.756679292458.243320708333
33343333342841.46004818491.539951819767
34345777344638.5145871931138.48541280721
35344094341370.3818841172723.61811588344
36348609345777.2821189442831.71788105631
37354846352807.2550427242038.74495727574
38356427353219.9256725513207.07432744872
39353467350317.5619654823149.43803451844
40355996350873.7374137375122.26258626258
41352487347760.4432663384726.5567336622
42355178350754.841167544423.15883245967
43374556372195.6979609692360.30203903149
44375021371075.6764793383945.32352066161
45375787370456.8643461535330.13565384664
46372720367790.604048554929.39595145024
47364431359710.3400630374720.65993696321
48370490366555.116243893934.88375611019
49376974373920.1942752123053.80572478814
50377632374708.0071203552923.99287964465
51378205372657.9402007155547.05979928484
52370861367221.1639139373639.83608606275
53369167364838.958323584328.04167642017
54371551367803.7397340993747.26026590051
55382842382913.248963765-71.2489637654439
56381903385545.746542362-3642.74654236238
57384502386886.010422497-2384.0104224967
58392058390383.819361651674.18063834984
59384359382831.7161266491527.28387335146
60388884386299.6639161222584.33608387784
61386586387014.194428544-428.194428544277
62387495387793.78047072-298.780470720308
63385705386056.880517375-351.880517375007
64378670380842.227910719-2172.22791071870
65377367379169.172736157-1802.17273615689
66376911379672.494698811-2761.49469881056
67389827395275.063652993-5448.06365299336
68387820392925.409354493-5105.40935449257
69387267392893.442499653-5626.44249965347
70380575388259.879385763-7684.87938576305
71372402380951.289518598-8549.28951859844
72376740384666.041397096-7926.04139709605


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.0007152446306067080.001430489261213420.999284755369393
180.0002564466287341830.0005128932574683660.999743553371266
190.001366045661006990.002732091322013990.998633954338993
200.001352595796260210.002705191592520420.99864740420374
210.0007330761013524040.001466152202704810.999266923898648
220.000610543692797360.001221087385594720.999389456307203
230.000351663448615890.000703326897231780.999648336551384
240.0002275664793952570.0004551329587905140.999772433520605
250.0001414150553941370.0002828301107882750.999858584944606
260.0005285929049696620.001057185809939320.99947140709503
270.009259945613971920.01851989122794380.990740054386028
280.02057673214293870.04115346428587740.979423267857061
290.03923266770748980.07846533541497960.96076733229251
300.03235373969249090.06470747938498190.96764626030751
310.3635500137928110.7271000275856230.636449986207189
320.5085635353449780.9828729293100430.491436464655022
330.5325835983100360.9348328033799280.467416401689964
340.4997291166706770.9994582333413530.500270883329323
350.4475678029431030.8951356058862060.552432197056897
360.4078607736702090.8157215473404180.592139226329791
370.3919106588816170.7838213177632330.608089341118383
380.349623223534030.699246447068060.65037677646597
390.3935777434156750.787155486831350.606422256584325
400.3799867707881350.759973541576270.620013229211865
410.3854149095351140.7708298190702290.614585090464886
420.391622535878920.783245071757840.60837746412108
430.7093903123558140.5812193752883730.290609687644186
440.6789772541940790.6420454916118420.321022745805921
450.6420277786941310.7159444426117390.357972221305869
460.568548408962030.862903182075940.43145159103797
470.5481721970617640.9036556058764710.451827802938236
480.4686975273605170.9373950547210350.531302472639483
490.4040391069790940.8080782139581880.595960893020906
500.3582171828047150.716434365609430.641782817195285
510.2799746791037020.5599493582074040.720025320896298
520.2156278740552530.4312557481105060.784372125944747
530.2013749104610550.4027498209221090.798625089538945
540.2568576225842890.5137152451685780.743142377415711
550.9737384576077030.05252308478459440.0262615423922972


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level100.256410256410256NOK
5% type I error level120.307692307692308NOK
10% type I error level150.384615384615385NOK