Multiple Linear Regression - Estimated Regression Equation
x[t] = + 29406.7468837864 + 1.28058662621852y[t] + 0.0213665756704032y1[t] -0.109951546684521y2[t] + 0.189129502860375y3[t] -0.583466893077811y4[t] + 645.041944741420M1[t] -7862.50086321254M2[t] -27771.3308989242M3[t] -36054.2742253516M4[t] -28597.9078937059M5[t] -24167.9784519473M6[t] -1856.21403375339M7[t] + 3394.51888208249M8[t] + 1692.51508426616M9[t] + 874.021498903283M10[t] -2481.97169085193M11[t] + 347.710441098343t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)29406.746883786415680.0618151.87540.065860.03293
y1.280586626218520.2401765.33192e-061e-06
y10.02136657567040320.3549190.06020.9522060.476103
y2-0.1099515466845210.357412-0.30760.7594830.379742
y30.1891295028603750.3605950.52450.601970.300985
y4-0.5834668930778110.236417-2.4680.0166140.008307
M1645.0419447414203894.7911030.16560.8690450.434522
M2-7862.500863212544442.824227-1.76970.0821250.041062
M3-27771.33089892429119.007139-3.04540.0035150.001757
M4-36054.27422535169351.733966-3.85540.0002960.000148
M5-28597.90789370598984.909714-3.18290.0023620.001181
M6-24167.97845194738377.212555-2.8850.0055170.002759
M7-1856.214033753394557.770143-0.40730.685340.34267
M83394.518882082494770.9913060.71150.4796820.239841
M91692.515084266165147.3007680.32880.74350.37175
M10874.0214989032834915.031570.17780.859490.429745
M11-2481.971690851933988.729095-0.62220.5362610.268131
t347.71044109834349.2495587.060200


Multiple Linear Regression - Regression Statistics
Multiple R0.93604685848075
R-squared0.87618372127168
Adjusted R-squared0.839256059194813
F-TEST (value)23.727029332316
F-TEST (DF numerator)17
F-TEST (DF denominator)57
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation6717.02322907089
Sum Squared Residuals2571748860.41304


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1236089237104.715982948-1015.71598294806
2236997235889.8465540261107.15344597378
3264579263804.184677969774.81532203129
4270349261103.6741835529245.32581644765
5269645267092.118228422552.88177157981
6267037262175.005677024861.9943229800
7258113253545.0037258844567.99627411648
8262813260662.8747515822150.12524841765
9267413262857.2132517974555.78674820312
10267366264372.6780114672993.32198853329
11264777263139.6138963361637.38610366372
12258863257565.9054816541297.09451834614
13254844253037.0991977451806.90080225508
14254868253460.4881129491407.51188705142
15277267271340.1250668025926.87493319829
16285351277907.6286986527443.37130134816
17286602286394.788244815207.211755185062
18283042294938.666114167-11896.6661141668
19276687288902.541610152-12215.5416101521
20277915288871.187832565-10956.1878325655
21277128283917.077790258-6789.07779025772
22277103278119.604519057-1016.60451905721
23275037278117.416586895-3080.41658689528
24270150272044.341981702-1894.34198170234
25267140271785.640216177-4645.64021617714
26264993269347.034379142-4354.03437914184
27287259288321.859174519-1062.85917451887
28291186289273.3497250571912.65027494299
29292300293909.261129945-1609.26112994523
30288186286214.8804271741971.11957282623
31281477279621.7767965731855.22320342702
32282656284243.164855065-1587.16485506543
33280190281138.905434533-948.905434532673
34280408281138.627643475-730.627643474796
35276836275555.0427731911280.95722680916
36275216272978.0624194372237.93758056337
37274352273964.963617819387.036382180673
38271311271144.391651899166.608348101282
39289802290900.283755638-1098.28375563846
40290726292235.263361159-1509.26336115896
41292300288434.4201375803865.57986241972
42278506272229.9902899546276.0097100456
43269826262998.2036985626827.79630143823
44265861260066.7294028355794.27059716494
45269034261091.5271777357942.47282226516
46264176260623.9758290833552.02417091696
47255198253802.0602985581395.93970144219
48253353254857.115830237-1504.11583023651
49246057245581.577112526475.422887474289
50235372237977.495322387-2605.49532238681
51258556266181.240391493-7625.24039149274
52260993268692.026892898-7699.02689289788
53254663255799.007461843-1136.0074618429
54250643253268.633871999-2625.63387199911
55243422246447.3467803-3025.34678029991
56247105246824.252521854280.747478146419
57248541255847.293933219-7306.29393321932
58245039252093.269465372-7054.26946537164
59237080245860.579538571-8780.5795385706
60237085245939.31423192-8854.31423191995
61225554233844.095506987-8290.09550698674
62226839236729.621921312-9890.62192131193
63247934260005.599671992-12071.5996719923
64248333257726.057138682-9393.05713868196
65246969250849.404797396-3880.40479739647
66245098243684.8236196861413.17638031405
67246263244273.127388531989.87261147028
68255765251446.7906360984318.20936390187
69264319261772.9824124592546.01758754143
70268347266090.8445315472256.15546845338
71273046265499.2869064497546.71309355081
72273963265245.2600550518717.7399449493
73267430256147.90836579811282.0916342019
74271993257824.12205828614168.8779417141
75292710277553.70726158715156.2927384128


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
210.3499233341804280.6998466683608560.650076665819572
220.2360681888160440.4721363776320880.763931811183956
230.1460660080691330.2921320161382670.853933991930867
240.08884114858172690.1776822971634540.911158851418273
250.04683938972601210.09367877945202420.953160610273988
260.0403492271051830.0806984542103660.959650772894817
270.0769318146532970.1538636293065940.923068185346703
280.622299917908060.755400164183880.37770008209194
290.6146165218298310.7707669563403380.385383478170169
300.5573657017384160.8852685965231670.442634298261584
310.4814152396644170.9628304793288340.518584760335583
320.4281732571762850.856346514352570.571826742823715
330.4680558633115850.936111726623170.531944136688415
340.4227588853861860.845517770772370.577241114613815
350.3428995669264690.6857991338529380.657100433073531
360.2828854794094000.5657709588188010.7171145205906
370.2801607072681890.5603214145363780.719839292731811
380.2309355101490740.4618710202981470.769064489850926
390.1816318788966990.3632637577933980.818368121103301
400.2888221248947680.5776442497895360.711177875105232
410.5077008672805050.984598265438990.492299132719495
420.8834009197925760.2331981604148480.116599080207424
430.9199669087466120.1600661825067750.0800330912533877
440.9414974161430070.1170051677139860.0585025838569928
450.9234656947030160.1530686105939680.0765343052969842
460.9035910448917520.1928179102164970.0964089551082483
470.8967357159356050.206528568128790.103264284064395
480.8602567119776250.2794865760447490.139743288022375
490.8376175350986840.3247649298026310.162382464901316
500.9975391016434850.004921796713030870.00246089835651544
510.9973224155555440.0053551688889120.002677584444456
520.9938803747680.01223925046399970.00611962523199985
530.9795132717794690.04097345644106230.0204867282205311
540.9420430559153250.1159138881693500.0579569440846752


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level20.0588235294117647NOK
5% type I error level40.117647058823529NOK
10% type I error level60.176470588235294NOK