Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 279491.46031746 -2239.38095238095x[t] -5371.7301587302M1[t] -10366.2301587301M2[t] -16486.8968253968M3[t] -13765.7301587302M4[t] -11347.3968253968M5[t] -12045.0634920635M6[t] -15455.8968253968M7[t] -17679.8968253968M8[t] -23222.0634920635M9[t] -24888.8968253968M10[t] -3530.23015873016M11[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)279491.460317466995.0428939.955600
x-2239.380952380955127.483019-0.43670.6638940.331947
M1-5371.73015873029630.633168-0.55780.5791080.289554
M2-10366.23015873019630.633168-1.07640.2861390.143069
M3-16486.89682539689630.633168-1.71190.0921630.046082
M4-13765.73015873029630.633168-1.42940.1581720.079086
M5-11347.39682539689630.633168-1.17830.2434230.121712
M6-12045.06349206359630.633168-1.25070.215980.10799
M7-15455.89682539689630.633168-1.60490.1138630.056931
M8-17679.89682539689630.633168-1.83580.0714280.035714
M9-23222.06349206359630.633168-2.41130.0190290.009515
M10-24888.89682539689630.633168-2.58430.0122510.006125
M11-3530.230158730169630.633168-0.36660.7152570.357628


Multiple Linear Regression - Regression Statistics
Multiple R0.429205826126823
R-squared0.184217641181209
Adjusted R-squared0.0182958054892515
F-TEST (value)1.11026761735700
F-TEST (DF numerator)12
F-TEST (DF denominator)59
p-value0.369401606862465
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation16614.9439395809
Sum Squared Residuals16287325364.8095


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1269645274119.730158730-4474.73015873046
2267037269125.23015873-2088.23015873015
3258113263004.563492064-4891.56349206353
4262813265725.73015873-2912.73015873018
5267413268144.063492063-731.063492063484
6267366267446.396825397-80.3968253968389
7264777264035.563492063741.436507936523
8258863261811.563492063-2948.56349206346
9254844256269.396825397-1425.39682539685
10254868254602.563492064265.436507936491
11277267275961.230158731305.76984126984
12285351279491.460317465859.5396825397
13286602274119.7301587312482.2698412699
14283042269125.2301587313916.7698412698
15276687263004.56349206313682.4365079365
16277915265725.7301587312189.2698412698
17277128268144.0634920638983.9365079365
18277103267446.3968253979656.60317460318
19275037264035.56349206311001.4365079365
20270150261811.5634920638338.4365079365
21267140256269.39682539710870.6031746032
22264993254602.56349206310390.4365079365
23287259275961.2301587311297.7698412698
24291186279491.4603174611694.5396825397
25292300274119.7301587318180.2698412699
26288186269125.2301587319060.7698412698
27281477263004.56349206318472.4365079365
28282656265725.7301587316930.2698412699
29280190268144.06349206312045.9365079365
30280408267446.39682539712961.6031746032
31276836264035.56349206312800.4365079365
32275216261811.56349206313404.4365079365
33274352256269.39682539718082.6031746032
34271311254602.56349206316708.4365079365
35289802275961.2301587313840.7698412698
36290726279491.4603174611234.5396825397
37292300274119.7301587318180.2698412699
38278506269125.230158739380.76984126984
39269826263004.5634920636821.43650793652
40265861265725.73015873135.269841269847
41269034268144.063492063889.936507936509
42264176267446.396825397-3270.39682539682
43255198264035.563492063-8837.5634920635
44253353261811.563492063-8458.5634920635
45246057256269.396825397-10212.3968253968
46235372254602.563492063-19230.5634920635
47258556275961.23015873-17405.2301587302
48260993279491.46031746-18498.4603174603
49254663274119.73015873-19456.7301587301
50250643269125.23015873-18482.2301587302
51243422263004.563492063-19582.5634920635
52247105265725.73015873-18620.7301587301
53248541268144.063492063-19603.0634920635
54245039267446.396825397-22407.3968253968
55237080264035.563492063-26955.5634920635
56237085261811.563492063-24726.5634920635
57225554256269.396825397-30715.3968253968
58226839254602.563492063-27763.5634920635
59247934275961.23015873-28027.2301587302
60248333277252.079365079-28919.0793650794
61246969271880.349206349-24911.3492063492
62245098266885.849206349-21787.8492063492
63246263260765.182539683-14502.1825396825
64255765263486.349206349-7721.3492063492
65264319265904.682539683-1585.68253968254
66268347265207.0158730163139.98412698413
67273046261796.18253968311249.8174603175
68273963259572.18253968314390.8174603175
69267430254030.01587301613399.9841269841
70271993252363.18253968319629.8174603175
71292710273721.84920634918988.1507936508
72295881277252.07936507918628.9206349206


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
160.3294000698523220.6588001397046450.670599930147678
170.2039696722599730.4079393445199460.796030327740027
180.1228367784479860.2456735568959710.877163221552014
190.07397850147160220.1479570029432040.926021498528398
200.04503708675605110.09007417351210230.954962913243949
210.02875098937425750.05750197874851510.971249010625743
220.01669619124227910.03339238248455810.98330380875772
230.009628988773514850.01925797754702970.990371011226485
240.004872389115749980.009744778231499950.99512761088425
250.004588278219273840.009176556438547680.995411721780726
260.004254188032623430.008508376065246850.995745811967377
270.004224747458800340.008449494917600670.9957752525412
280.003716459288796640.007432918577593280.996283540711203
290.002394110297720720.004788220595441430.99760588970228
300.001621833309381790.003243666618763580.998378166690618
310.001075279185969120.002150558371938240.998924720814031
320.000847879533390350.00169575906678070.99915212046661
330.001007628420768730.002015256841537450.998992371579231
340.001069123327973730.002138246655947450.998930876672026
350.0009010057719786310.001802011543957260.999098994228021
360.000786109270344780.001572218540689560.999213890729655
370.002482818817906960.004965637635813920.997517181182093
380.004226636886656550.00845327377331310.995773363113343
390.006452309107538610.01290461821507720.993547690892461
400.007427788176541280.01485557635308260.992572211823459
410.007654174631278070.01530834926255610.992345825368722
420.007940933171916460.01588186634383290.992059066828084
430.009349241362197620.01869848272439520.990650758637802
440.008637949542152550.01727589908430510.991362050457848
450.01065676794939820.02131353589879650.989343232050602
460.01961284688888480.03922569377776970.980387153111115
470.02492710069529020.04985420139058040.97507289930471
480.03415018424284610.06830036848569230.965849815757154
490.08702418293478970.1740483658695790.91297581706521
500.1788006050368340.3576012100736680.821199394963166
510.2656481673334350.5312963346668690.734351832666565
520.3288405843979440.6576811687958890.671159415602056
530.3532082084938820.7064164169877650.646791791506118
540.3364532243455780.6729064486911570.663546775654422
550.2637327188662560.5274654377325120.736267281133744
560.1785784118304640.3571568236609280.821421588169536


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level150.365853658536585NOK
5% type I error level260.634146341463415NOK
10% type I error level290.707317073170732NOK