Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 575726.747205707 -66470.4227110583X[t] -804.875142026716M1[t] -4823.62574976884M2[t] -13212.7096908442M3[t] -19500.6269652530M4[t] -30145.3775729951M5[t] -16548.5577288942M6[t] + 34425.1916633637M7[t] + 43581.1077222883M8[t] + 33498.1904478795M9[t] + 13192.5678821509M10[t] -2456.51605892456M11[t] + 192.08394107544t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)575726.74720570711286.2791551.011200
X-66470.422711058310150.669975-6.548400
M1-804.87514202671613039.571626-0.06170.9510050.475503
M2-4823.6257497688413029.148789-0.37020.7126420.356321
M3-13212.709690844213023.484952-1.01450.3147730.157386
M4-19500.626965253013022.586324-1.49740.1399950.069997
M5-30145.377572995113026.453891-2.31420.024420.01221
M6-16548.557728894213057.021954-1.26740.210350.105175
M734425.191663363713042.9075152.63940.0107850.005392
M843581.107722288313033.541453.34380.0014930.000746
M933498.190447879513028.9339992.57110.0128740.006437
M1013192.567882150913605.4697650.96970.3364650.168233
M11-2456.5160589245613598.62417-0.18060.8573110.428655
t192.08394107544249.1506990.7710.4440330.222017


Multiple Linear Regression - Regression Statistics
Multiple R0.878227212463633
R-squared0.771283036711643
Adjusted R-squared0.717222663570759
F-TEST (value)14.2670683145608
F-TEST (DF numerator)13
F-TEST (DF denominator)55
p-value3.20965476419133e-13
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation21497.7035540613
Sum Squared Residuals25418319195.4065


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1562325575113.956004756-12788.9560047564
2560854571287.28933809-10433.2893380897
3555332563090.28933809-7758.28933808959
4543599556994.456004756-13395.4560047562
5536662546541.789338090-9879.78933808959
6542722560330.693123266-17608.6931232660
7593530611496.526456599-17966.5264565993
8610763620844.526456599-10081.5264565993
9612613610953.6931232661659.30687673404
10611324590840.15449861320483.8455013873
11594167575383.15449861318783.8455013872
12595454578031.75449861317422.2455013872
13590865577418.96329766213446.0367023385
14589379573592.29663099515786.7033690052
15584428565395.29663099519032.7033690052
16573100559299.46329766213800.5367023385
17567456548846.79663099518609.2033690052
18569028562635.7004161716392.29958382878
19620735613801.5337495056933.46625049545
20628884623149.5337495055734.46625049545
21628232613258.70041617114973.2995838288
22612117593145.16179151818971.8382084820
23595404577688.16179151817715.8382084820
24597141580336.76179151816804.2382084820
25593408579723.97059056713684.0294094333
26590072575897.303923914174.6960760999
27579799567700.303923912098.6960760999
28574205561604.47059056712600.5294094332
29572775551151.803923921623.1960760999
30572942564940.7077090768001.2922909235
31619567616106.541042413460.45895759017
32625809625454.54104241354.458957590171
33619916615563.7077090764352.2922909235
34587625595450.169084423-7825.16908442332
35565742579993.169084423-14251.1690844233
36557274582641.769084423-25367.7690844233
37560576582028.977883472-21452.9778834720
38548854578202.311216805-29348.3112168054
39531673570005.311216805-38332.3112168054
40525919563909.477883472-37990.4778834721
41511038553456.811216805-42418.8112168054
42498662500775.292290923-2113.2922909235
43555362551941.1256242573420.87437574317
44564591561289.1256242573301.87437574316
45541657551398.292290924-9741.2922909235
46527070531284.75366627-4214.75366627031
47509846515827.75366627-5981.75366627032
48514258518476.35366627-4218.35366627032
49516922517863.562465319-941.562465319028
50507561514036.895798652-6475.89579865238
51492622505839.895798652-13217.8957986524
52490243499744.062465319-9501.06246531906
53469357489291.395798652-19934.3957986524
54477580503080.299583829-25500.2995838288
55528379554246.132917162-25867.1329171621
56533590563594.132917162-30004.1329171621
57517945553703.299583829-35758.2995838288
58506174533589.760959176-27415.7609591756
59501866518132.760959176-16266.7609591756
60516141520781.360959176-4640.36095917559
61528222520168.5697582248053.4302417757
62532638516341.90309155816296.0969084423
63536322508144.90309155828177.0969084423
64536535502049.06975822434485.9302417757
65523597491596.40309155832000.5969084423
66536214505385.30687673430828.6931232659
67586570556551.14021006730018.8597899326
68596594565899.14021006730694.8597899326
69580523556008.30687673424514.6931232659


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
174.75383306438665e-059.5076661287733e-050.999952461669356
181.19706509980433e-052.39413019960866e-050.999988029349002
197.67216069366232e-071.53443213873246e-060.99999923278393
201.72037544255747e-053.44075088511493e-050.999982796245574
212.54757208751506e-055.09514417503011e-050.999974524279125
220.0005228036800256490.001045607360051300.999477196319974
230.001007517871593130.002015035743186270.998992482128407
240.001169304845838060.002338609691676120.998830695154162
250.000750593133073770.001501186266147540.999249406866926
260.0005030646093667930.001006129218733590.999496935390633
270.0004568670871112880.0009137341742225770.99954313291289
280.0002574669780914380.0005149339561828750.999742533021909
290.0002184938078743080.0004369876157486160.999781506192126
300.0001155182092662060.0002310364185324120.999884481790734
317.08576702481385e-050.0001417153404962770.999929142329752
327.17790928857272e-050.0001435581857714540.999928220907114
330.0002319222921897480.0004638445843794970.99976807770781
340.006139203465722030.01227840693144410.993860796534278
350.03750523598998740.07501047197997490.962494764010013
360.1197016098992860.2394032197985710.880298390100714
370.1440860450043290.2881720900086590.85591395499567
380.1798706311615770.3597412623231540.820129368838423
390.2279710666625460.4559421333250920.772028933337454
400.2295510748503930.4591021497007860.770448925149607
410.2481993939457090.4963987878914180.751800606054291
420.2006970421463550.4013940842927090.799302957853645
430.184968309535070.369936619070140.81503169046493
440.2012270183940880.4024540367881770.798772981605911
450.243647061636850.48729412327370.75635293836315
460.4229671026814110.8459342053628210.577032897318589
470.6096267787823430.7807464424353150.390373221217657
480.7916929679612560.4166140640774890.208307032038744
490.9374239532842240.1251520934315530.0625760467157764
500.9895938316708160.02081233665836790.0104061683291840
510.9886171564484870.02276568710302670.0113828435515133
520.9934167695151770.01316646096964560.00658323048482278


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level170.472222222222222NOK
5% type I error level210.583333333333333NOK
10% type I error level220.611111111111111NOK