Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 249.743765932925 -1.05055721843048X[t] -31.0307064944671M1[t] -38.0107916100911M2[t] -30.2152583601200M3[t] -16.6075935557811M4[t] -42.9485044503155M5[t] -78.6002454534487M6[t] + 24.2010437160465M7[t] + 12.2490607972814M8[t] + 32.1316138906316M9[t] + 12.4128437972922M10[t] -9.69543105311223M11[t] -0.393724067173589t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)249.74376593292532.8970487.591700
X-1.050557218430480.345681-3.03910.0039050.001953
M1-31.03070649446718.026298-3.86610.0003450.000173
M2-38.01079161009118.400072-4.52514.2e-052.1e-05
M3-30.21525836012008.108226-3.72650.000530.000265
M4-16.60759355578117.725342-2.14980.0368670.018434
M5-42.94850445031557.565939-5.67661e-060
M6-78.60024545344877.604837-10.335600
M724.20104371604657.7295483.1310.0030250.001513
M812.24906079728147.7435951.58180.120540.06027
M932.13161389063167.6368664.20740.0001185.9e-05
M1012.41284379729227.5472141.64470.1068510.053426
M11-9.695431053112237.527508-1.2880.2041880.102094
t-0.3937240671735890.174624-2.25470.0289560.014478


Multiple Linear Regression - Regression Statistics
Multiple R0.95098585591368
R-squared0.904374098147874
Adjusted R-squared0.877349386754882
F-TEST (value)33.4647088361652
F-TEST (DF numerator)13
F-TEST (DF denominator)46
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation11.8962863267016
Sum Squared Residuals6509.99490487596


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1100113.263613528237-13.2636135282369
294.9798.8195542654022-3.84955426540225
3107.5108.238433307586-0.738433307586283
4124.27130.550199556360-6.28019955635957
5107.06111.894349604382-4.83434960438187
679.7175.84888453407513.86111546592492
7163.41175.220339275133-11.8103392751326
8144.83161.866097359501-17.0360973595007
9166.82182.363461315371-15.5434613153706
10154.26166.295612445815-12.0356124458149
11132.6145.810683387623-13.2106833876234
12157.51154.1038554438693.40614455613121
13104.02111.564529511234-7.54452951123358
14106.03102.1736504690503.85634953095046
15113.23110.5839945815402.64600541845966
16117.64129.859650469050-12.2196504690495
17113.34107.1696607982996.17033920170123
1866.6270.1156607982988-3.49566079829877
19185.99171.51469097092714.4753090290729
20174.57159.16898398498815.4010160150115
21208.19180.67488287055227.5151171294484
22163.81162.5794585694251.23054143057496
23162.46140.07745965184722.3825403481529
24148.16149.379166637786-1.21916663778571
25113.41109.8759510664153.53404893358541
26105.63100.4850720242315.14492797576945
27111.79109.9039510664151.88604893358541
28132.36128.1710720242314.18892797576947
29110.75104.4620418516026.2879581483978
3067.3768.4165767812954-1.04657678129545
31178.29169.8156069539248.47439304607619
32156.38157.469899967985-1.08989996798516
33189.71176.95872899416212.7512710058382
34152.8155.837699903955-3.03769990395546
35150.8137.36984070515013.4301592948495
36160.4151.7247279117408.67527208826026
37127.25119.2917624204067.95823757959424
38108.47114.954063598872-6.4840635988723
39117.09126.390012500443-9.30001250044287
40147.25137.5868833782229.66311662177829
41116.19110.8522484165145.3377515834864
4275.8373.79824841651362.03175158348638
43181.94177.2143484485284.72565155147154
44179.12167.89424625167011.2257537483304
45183.15192.436255498497-9.28625549849678
46197.9175.35987169924822.5401283007522
47155.42155.883477570750-0.463477570749624
48162.54161.1405392657311.39946073426907
49125.9116.5841434737099.3158565262908
50105.5104.1676596424451.33234035755463
51121.11115.6036085440165.50639145598406
52137.51132.8621945721394.64780542786135
5397.2110.161699329204-12.9616993292035
5469.7471.090629469817-1.35062946981707
55152.58168.445014351488-15.8650143514880
56146.59155.090772435856-8.50077243585612
57161.16176.596671321419-15.4366713214193
58152.84161.537357381557-8.6973573815568
59121.95144.088538684629-22.1385386846294
60140.12152.381710740875-12.2617107408748


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.1507184251742480.3014368503484970.849281574825752
180.1530248598321220.3060497196642430.846975140167878
190.4251494837493930.8502989674987870.574850516250607
200.6182495883593080.7635008232813840.381750411640692
210.8684916434809130.2630167130381750.131508356519087
220.8265690076588130.3468619846823730.173430992341187
230.8533639596235090.2932720807529830.146636040376491
240.8744500918251560.2510998163496890.125549908174844
250.8398843541692930.3202312916614140.160115645830707
260.7875315576902690.4249368846194620.212468442309731
270.7324032908384850.535193418323030.267596709161515
280.6765431824209770.6469136351580460.323456817579023
290.6195159482097320.7609681035805360.380484051790268
300.6295096189213760.7409807621572490.370490381078624
310.5383716763795240.9232566472409530.461628323620476
320.5356808953027630.9286382093944740.464319104697237
330.5080378182451710.9839243635096570.491962181754829
340.634464223631520.731071552736960.36553577636848
350.5787465282616720.8425069434766560.421253471738328
360.4817637710343910.9635275420687830.518236228965609
370.4051058556348040.8102117112696090.594894144365196
380.4869284446465570.9738568892931140.513071555353443
390.8585472902197970.2829054195604070.141452709780203
400.8309625834853790.3380748330292430.169037416514621
410.7718751838658420.4562496322683150.228124816134158
420.7409244805303470.5181510389393060.259075519469653
430.5736013011424750.852797397715050.426398698857525


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level00OK
5% type I error level00OK
10% type I error level00OK