Multiple Linear Regression - Estimated Regression Equation
Y[t] = -19851.0732190765 + 0.927997599540739X[t] + 3488.77411053802M1[t] + 5238.89859350010M2[t] + 5813.70309850114M3[t] + 6726.8417983221M4[t] + 5285.69400486605M5[t] -899.207493524473M6[t] -7657.43328196939M7[t] -13975.7005108038M8[t] -7847.9064228879M9[t] -4738.03673981474M10[t] -1569.55783649424M11[t] + 455.91333933419t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)-19851.073219076524988.342126-0.79440.4304980.215249
X0.9279975995407390.07641112.144800
M13488.774110538024731.1571470.73740.4641290.232064
M25238.898593500104742.2580341.10470.2742680.137134
M35813.703098501144778.2741741.21670.2291110.114555
M46726.84179832214817.9769521.39620.1684760.084238
M55285.694004866054888.6857931.08120.2844990.14225
M6-899.2074935244734797.847171-0.18740.8520480.426024
M7-7657.433281969394937.908632-1.55070.1269140.063457
M8-13975.70051080385248.174096-2.6630.0102350.005117
M9-7847.90642288795087.925466-1.54250.1289130.064456
M10-4738.036739814744961.929918-0.95490.3439750.171987
M11-1569.557836494244926.611899-0.31860.7512910.375646
t455.9133393341985.3762675.342e-061e-06


Multiple Linear Regression - Regression Statistics
Multiple R0.911439378287059
R-squared0.830721740292301
Adjusted R-squared0.789200657722488
F-TEST (value)20.0072273861245
F-TEST (DF numerator)13
F-TEST (DF denominator)53
p-value6.66133814775094e-16
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation7787.83778390367
Sum Squared Residuals3214472119.46507


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1267413257771.2423065549641.75769344596
2267366258655.8115471048710.18845289556
3264777256964.7124319877812.28756801327
4258863252933.7464394145929.25356058568
5254844249240.6149898335603.38501016744
6254868249113.0203416045754.97965839585
7277267269174.1916978468092.80830215374
8285351271802.08784654413548.9121534557
9286602278941.6658359197660.33416408076
10283042284614.931406884-1572.93140688361
11276687278215.093579299-1528.09357929924
12277915280295.316613501-2380.31661350057
13277128280711.757189919-3583.75718991889
14277103281561.990519286-4458.99051928617
15275037279915.435288946-4878.43528894634
16270150275307.254789460-5157.2547894596
17267140271877.674658147-4737.67465814742
18264993269599.909571783-4606.90957178310
19287259290618.774450751-3359.77445075127
20291186288674.4264265122511.57357348796
21292300293619.290092973-1319.29009297319
22288186286048.1739232922137.82607670787
23281477280388.8781801411088.12181985873
24282656282932.172016513-276.172016513435
25280190285701.086507767-5511.08650776752
26280408284609.020861296-4201.02086129601
27276836279421.226791109-2585.22679110875
28275216277102.416369689-1886.41636968901
29274352275591.935274227-1239.93527422708
30271311272839.963414497-1528.96341449744
31289802292645.935430866-2843.93543086586
32290726291718.672775723-992.672775723291
33292300291373.022127203926.977872797318
34278506277773.633550905732.366449095013
35269826269145.673486823680.326513176694
36265861266992.37147192-1131.37147191979
37269034271056.770612133-2022.77061213275
38264176266893.032911181-2717.03291118140
39255198260311.386446484-5113.38644648395
40253353258052.895869034-4699.89586903435
41246057250028.799622396-3971.79962239598
42235372242730.567522516-7358.56752251627
43258556267531.022619613-8975.02261961294
44260993267971.628426193-6978.62842619341
45254663259146.863710669-4483.86371066908
46250643252906.496098729-2263.49609872944
47243422247248.128353178-3826.12835317812
48247105249950.109779072-2845.10977907175
49248541255034.37828118-6493.37828117998
50245039251803.278167767-6764.27816776707
51237080246356.572767308-9276.57276730794
52237085245513.278529158-8428.27852915797
53225554235846.626531332-10292.6265313325
54226839236556.08571789-9717.08571788981
55247934257819.013965537-9885.01396553719
56248333256422.184525027-8089.184525027
57246969249753.158233236-2784.15823323581
58245098244131.76502019966.23497981016
59246263242677.2264005583585.77359944193
60255765249132.0301189946632.96988100556
61264319256349.7651024477969.23489755317
62268347258915.8659933659431.1340066351
63273046259004.66627416614041.3337258337
64273963259720.40800324514242.5919967552
65267430252791.34892406414638.6510759355
66271993254536.45343170917456.5465682908
67292710275739.06183538616970.9381646135


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.007262019070656870.01452403814131370.992737980929343
180.00554633716539110.01109267433078220.994453662834609
190.001750749498270930.003501498996541860.99824925050173
200.007060266742063050.01412053348412610.992939733257937
210.002505557080550280.005011114161100550.99749444291945
220.01754710170578800.03509420341157600.982452898294212
230.008424221765466520.01684844353093300.991575778234533
240.00340802557915130.00681605115830260.996591974420849
250.004353053646896010.008706107293792020.995646946353104
260.002256326529787140.004512653059574280.997743673470213
270.001047447995514910.002094895991029820.998952552004485
280.001480808762571970.002961617525143930.998519191237428
290.007425248342700350.01485049668540070.9925747516573
300.006003240647793670.01200648129558730.993996759352206
310.00418118485394130.00836236970788260.995818815146059
320.03875503033040360.07751006066080730.961244969669596
330.1136759716966360.2273519433932720.886324028303364
340.5525786383050950.8948427233898110.447421361694905
350.7989669726296510.4020660547406980.201033027370349
360.9326906540491040.1346186919017910.0673093459508957
370.942016081515580.1159678369688410.0579839184844206
380.9360262936827790.1279474126344430.0639737063172214
390.9542891556807460.0914216886385080.045710844319254
400.943208973969480.113582052061040.05679102603052
410.9494411814930930.1011176370138140.050558818506907
420.9997228839585280.0005542320829439120.000277116041471956
430.9999515286479249.69427041527627e-054.84713520763814e-05
440.999963656168247.26876635207699e-053.63438317603850e-05
450.999918092037130.0001638159257394548.1907962869727e-05
460.9996516883704770.0006966232590469010.000348311629523451
470.9985045976969790.002990804606042520.00149540230302126
480.9971965325034520.005606934993095450.00280346749654773
490.9964744196692940.007051160661411380.00352558033070569
500.9874336375807120.02513272483857550.0125663624192877


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level160.470588235294118NOK
5% type I error level240.705882352941177NOK
10% type I error level260.764705882352941NOK