Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 1908.34256423337 -146.923839541267X[t] + 0.132370309355343Y1[t] + 0.298920931577709Y2[t] + 0.197607377657591Y3[t] + 0.0461259926980141Y4[t] -39.7638045813893M1[t] + 341.294589822638M2[t] -112.553653072054M3[t] -273.955286043913M4[t] -182.808803643698M5[t] + 122.834621812756M6[t] -212.273440315729M7[t] -9.44724396122535M8[t] + 216.52380839182M9[t] -57.7434273672878M10[t] + 97.313934049114M11[t] + 0.83515439869592t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)1908.34256423337640.8782462.97770.0046640.002332
X-146.92383954126775.029451-1.95820.0564210.028211
Y10.1323703093553430.1440590.91890.3630670.181534
Y20.2989209315777090.1432572.08660.042620.02131
Y30.1976073776575910.1437431.37470.1760230.088012
Y40.04612599269801410.1426820.32330.7479830.373991
M1-39.7638045813893162.334696-0.24490.8076090.403805
M2341.294589822638159.343152.14190.0376510.018826
M3-112.553653072054163.535033-0.68830.4948260.247413
M4-273.955286043913173.849323-1.57580.1220720.061036
M5-182.808803643698173.783676-1.05190.2984460.149223
M6122.834621812756182.5225110.6730.5043990.2522
M7-212.273440315729167.680618-1.26590.212050.106025
M8-9.44724396122535177.975635-0.05310.9579020.478951
M9216.52380839182169.4718841.27760.2079290.103965
M10-57.7434273672878170.39645-0.33890.7362790.368139
M1197.313934049114165.8366840.58680.5602670.280133
t0.835154398695923.1492020.26520.792070.396035


Multiple Linear Regression - Regression Statistics
Multiple R0.770206437096738
R-squared0.593217955745252
Adjusted R-squared0.439544739026792
F-TEST (value)3.86025599263707
F-TEST (DF numerator)17
F-TEST (DF denominator)45
p-value0.000144256639657669
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation248.870481174304
Sum Squared Residuals2787143.23799682


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
123332396.56698486062-63.5669848606249
230162749.05926183088266.940738169117
321552359.26350003168-204.263500031677
421722380.40167412762-208.401674127618
521502395.29090306032-245.290903060322
625332521.2259409336511.7740590663476
720582106.56514317468-48.5651431746786
821602299.50455752925-139.504557529245
922602501.87871504757-241.878715047574
1024982372.28495790913125.715042090873
1126952646.5893423145948.4106576854081
1227992627.71913248125171.280867518752
1329472654.31803732812292.68196267188
1429303092.71965659781-162.719656597808
1523182681.94979064592-363.949790645917
1625402484.0264059985155.9735940014934
1725702455.30673075613114.693269243873
1826692710.39700969988-41.3970096998761
1924502413.836120852436.1638791476022
2028422590.19258592928251.807414070723
2134402794.98641219358645.013587806417
2226782723.2563904386-45.2563904385997
2329812950.9360274786730.0639725213271
2422602758.96115081519-498.96115081519
2528442606.86545566779237.134544332205
2625462860.57591850675-314.575918506747
2724562414.1875583606241.8124416393841
2822952249.4675661062145.5324338937941
2923792261.28528045059117.714719549409
3024792484.53410254026-5.53410254026057
3120572137.94907289871-80.9490728987129
3222802324.81498116059-44.8149811605859
3323512463.93807097104-112.938070971041
3422762217.1707031232458.8292968767611
3525482364.88295631540183.117043684596
3623112276.9212832184034.0787167815963
3722012261.68937131074-60.6893713107438
3827252593.77529861685131.224701383151
3924082142.95627125852265.043728741484
4021392093.7790688629245.2209311370826
4118982168.55994778503-270.559947785030
4225372309.56364999331227.436350006685
4320691890.67233324795178.327666752054
4420632163.36358444976-100.363584449756
4525242379.32770740410144.672292595896
4624372204.96575733620232.034242663796
4721892434.98722893784-245.987228937841
4827932355.80235270987437.197647290128
4920742282.68806726173-208.688067261728
5026222682.24363133296-60.2436313329591
5122782209.4533164295268.5466835704769
5221442082.3252849047561.6747150952481
5324272143.55713794793283.44286205207
5421392331.27929683290-192.279296832896
5518281912.97732982626-84.9773298262642
5620722039.1242909311432.8757090688638
5718002234.8690943837-434.869094383699
5817582129.32219119283-371.32219119283
5922462261.60444495349-15.6044449534901
6019872130.59608077529-143.596080775286
6118682064.87208357099-196.872083570988
6225142374.62623311475139.373766885247
6321211928.18956327375192.810436726250


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
210.8252123550215870.3495752899568250.174787644978413
220.8589494417118270.2821011165763460.141050558288173
230.7915959283897690.4168081432204620.208404071610231
240.9574061885769750.08518762284605090.0425938114230255
250.943957168426980.1120856631460380.0560428315730191
260.942169599527760.1156608009444790.0578304004722397
270.9272101913845360.1455796172309280.0727898086154642
280.9138186719172580.1723626561654840.086181328082742
290.8699851797224450.2600296405551110.130014820277555
300.8051101419425650.389779716114870.194889858057435
310.7404171386136880.5191657227726240.259582861386312
320.6565593726401310.6868812547197380.343440627359869
330.6091609998991820.7816780002016370.390839000100818
340.4997089338421180.9994178676842360.500291066157882
350.4177858755734370.8355717511468730.582214124426563
360.3574241818104510.7148483636209020.642575818189549
370.2750193196119410.5500386392238810.72498068038806
380.2023095107504710.4046190215009420.797690489249529
390.1596170825902410.3192341651804820.84038291740976
400.1199568502147050.239913700429410.880043149785295
410.4947083926479410.9894167852958830.505291607352059
420.5426338751650450.914732249669910.457366124834955


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 level10.0454545454545455OK