Multiple Linear Regression - Estimated Regression Equation
Y[t] = -225475.408018723 + 1.46214500504937X[t] + 16420.7919349884M1[t] + 23028.7163256820M2[t] + 30661.1473651015M3[t] + 31235.5640239155M4[t] + 31993.2453135483M5[t] + 34960.6704055155M6[t] + 37647.041692M7[t] + 39974.3973820299M8[t] + 40611.7071382829M9[t] + 31413.0352303011M10[t] + 7293.95281682754M11[t] + 1278.41807555408t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)-225475.40801872324007.470271-9.391900
X1.462145005049370.06722821.749100
M116420.79193498843124.5517655.25544e-062e-06
M223028.71632568203561.6277516.465800
M330661.14736510153864.5929087.933900
M431235.56402391553803.9634068.211300
M531993.24531354833758.6409788.511900
M634960.67040551553842.6772849.09800
M737647.0416924000.4974499.410600
M839974.39738202994096.5825649.75800
M940611.70713828294279.0178399.490900
M1031413.03523030114047.4140217.761300
M117293.952816827543168.8377572.30180.0258260.012913
t1278.4180755540887.51179614.608500


Multiple Linear Regression - Regression Statistics
Multiple R0.970362601330797
R-squared0.941603578061471
Adjusted R-squared0.925451376248687
F-TEST (value)58.2956793739531
F-TEST (DF numerator)13
F-TEST (DF denominator)47
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation4957.90285228592
Sum Squared Residuals1155297632.55713


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1286602268899.15723296917702.8427670306
2283042280106.0310056852935.968994315
3276687273222.7897761153464.21022388462
4277915275161.8910657812753.10893421868
5277128271638.9151217705489.08487822956
6277103273748.5644369153354.43556308533
7275037273495.0654593861541.93454061418
8270150267683.1632474472466.83675255327
9267140265747.6011359541392.39886404620
10264993263265.0645773051727.93542269529
11287259283471.4113330443787.58866695619
12291186283629.0528030897556.9471969112
13292300298746.114734714-6446.11473471408
14288186289085.254995364-899.254995364174
15281477283368.805479824-1891.80547982388
16282656286037.517127009-3381.51712700947
17280190286221.078770799-6031.07877079874
18280408285270.458590375-4862.45859037459
19276836279437.414273577-2601.41427357734
20275216277232.623789095-2016.62378909508
21274352278320.777548044-3968.77754804426
22271311275091.084891815-3780.08489181489
23289802293386.408125954-3584.40812595447
24290726295146.560521534-4420.56052153358
25292300301927.933779372-9627.9337793724
26278506282768.980087222-4262.98008722176
27269826272375.128700529-2549.12870052852
28265861267643.924477159-1782.92447715923
29269034269868.640547997-834.640547997416
30264176264078.3204008697.6795991401582
31255198256049.134286478-851.134286478446
32253353253939.383227324-586.38322732438
33246057244764.7411958321292.25880416799
34235372234372.000159866999.999840134242
35258556260536.587811181-1980.58781118108
36260993264451.941944203-3458.94194420296
37254663257873.696290906-3210.69629090564
38250643250309.552488797333.447511203453
39243422244594.565118261-1172.56511826129
40247105247513.303561310-408.303561310337
41248541251344.916992698-2803.91699269779
42245039247024.052575635-1985.05257563483
43237080240783.069802429-3703.06980242881
44237085240903.089875975-3818.08987597506
45225554229140.451185545-3586.45118554529
46226839231364.55939815-4525.55939815009
47247934251955.450290217-4021.45029021719
48248333252975.757313241-4642.7573132413
49246969249794.074506674-2825.07450667369
50245098243205.1814229331892.81857706748
51246263244113.7109252712149.28907472906
52255765252945.3637687402819.63623126036
53264319260138.4485667364180.55143326438
54268347264951.6039962163395.39600378393
55273046267432.3161781305613.68382187043
56273963270008.7398601593954.26013984125
57267430262559.4289346254870.57106537536
58271993266415.2909728655577.70902713545
59292710286911.1424396035798.85756039656
60295881290915.6874179334965.31258206665
61293299288892.0234553654406.97654463518


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.04174758449478720.08349516898957450.958252415505213
180.01932127810110570.03864255620221140.980678721898894
190.01858526024489140.03717052048978280.981414739755109
200.009764230464700190.01952846092940040.9902357695353
210.01985911325748780.03971822651497550.980140886742512
220.01354192748729130.02708385497458250.986458072512709
230.00931991265480010.01863982530960020.9906800873452
240.04020919498504020.08041838997008040.95979080501496
250.1219109017024470.2438218034048950.878089098297553
260.678547480696990.6429050386060190.321452519303010
270.8259316574466170.3481366851067650.174068342553383
280.9060511492649260.1878977014701480.0939488507350738
290.9018744627674960.1962510744650080.0981255372325042
300.8638990808571740.2722018382856520.136100919142826
310.869786106972740.2604277860545190.130213893027260
320.840649160304850.3187016793902990.159350839695150
330.8379190477129210.3241619045741580.162080952287079
340.993269102458920.01346179508215910.00673089754107956
350.9965794515974590.006841096805082420.00342054840254121
360.9977469198953840.004506160209232940.00225308010461647
370.9991190488175950.001761902364809890.000880951182404943
380.9978367777886170.004326444422766080.00216322221138304
390.9942002119337120.01159957613257670.00579978806628837
400.9937272158663760.01254556826724850.00627278413362423
410.9861670352305240.02766592953895270.0138329647694764
420.9859861699875990.02802766002480230.0140138300124011
430.9614757926436250.07704841471275090.0385242073563754
440.9374433332725730.1251133334548540.0625566667274269


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level40.142857142857143NOK
5% type I error level150.535714285714286NOK
10% type I error level180.642857142857143NOK