Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 2563937.55483184 + 0.87548284030003X[t] -1626909.38512229M1[t] -36997.8580407108M2[t] -213108.916594054M3[t] -692140.797373351M4[t] -1569112.80964333M5[t] -1281363.69594057M6[t] -536563.73776368M7[t] -394936.994381191M8[t] -692625.977911235M9[t] -418327.260387958M10[t] + 36178.4923909261M11[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)2563937.55483184738771.4063533.47050.0011240.000562
X0.875482840300030.04109121.30600
M1-1626909.38512229356911.097022-4.55833.7e-051.8e-05
M2-36997.8580407108355349.001374-0.10410.917520.45876
M3-213108.916594054356664.866431-0.59750.5530390.276519
M4-692140.797373351354730.075748-1.95120.0570110.028506
M5-1569112.80964333353473.634092-4.43915.4e-052.7e-05
M6-1281363.69594057353572.455378-3.6240.000710.000355
M7-536563.73776368353735.540929-1.51680.1360020.068001
M8-394936.994381191360762.429133-1.09470.2792140.139607
M9-692625.977911235353791.414673-1.95770.0562140.028107
M10-418327.260387958353812.283514-1.18230.2430170.121509
M1136178.4923909261359053.8049050.10080.9201690.460085


Multiple Linear Regression - Regression Statistics
Multiple R0.968053822102862
R-squared0.93712820248796
Adjusted R-squared0.921075828655098
F-TEST (value)58.3794155459752
F-TEST (DF numerator)12
F-TEST (DF denominator)47
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation558881.641490906
Sum Squared Residuals14680388392191.8


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
113768040.1413834464.8494045-66424.7094044972
217487530.6716947507.49708540023.17292
316198106.1315670403.5152001527702.614799876
417535166.3817313026.7738824222139.606117558
516571771.616729340.1386049-157568.538604919
616198892.6716074938.1485836123954.521416399
716554237.9316646147.7106241-91909.7806241096
819554176.3719408640.5286141145535.841385858
915903762.3315818366.717500485395.6124995842
1018003781.6517418072.2405576585709.409442432
1118329610.3818095610.6612860233999.718714040
1216260733.4215862344.0096310398389.410369032
1314851949.214658227.9981144193721.201885555
1418174068.4417568430.2891657605638.150834313
1518406552.2317816139.7294412590412.500558827
1618466459.4217510446.0357016956013.384298375
1716016524.615144631.3196005871893.280399501
1817428458.3216571681.2201703856777.099829678
1917167191.4216711070.2174905456121.20250955
2019629987.618896729.9181803733257.681819725
2117183629.0116510535.2700600673093.739940038
2218344657.8518045488.6552115299169.194788506
2319301440.7118805251.9427853496188.767214697
2418147463.6818149929.1579246-2465.47792462261
2516192909.2215303587.5473931889321.67260691
2618374420.618257389.5317486117031.068251425
2720515191.9520111400.8136144403791.136385585
2818957217.218976350.8527366-19133.6527365521
2916471529.5316772679.8572797-301150.327279737
3018746813.2718962352.0653315-215538.795331496
3119009453.5918704968.7725156304484.817484395
3219211178.5519892906.3500833-681727.800083336
3320547653.7520670819.2126168-123165.462616793
3419325754.0319369512.2941608-43758.2641608061
3520605542.5821031811.4984120-426268.918412049
3620056915.0620213216.2241262-156301.164126229
3716141449.7216873992.3863144-732542.666314381
3820359793.2221165500.9309302-805707.710930232
3919711553.2720238987.9395923-527434.66959231
4015638580.716912937.8308187-1274357.13081872
411438448614842149.7570408-457663.757040767
4213855616.1214477693.4221113-622077.302111349
4314308336.4614740365.7330503-432029.273050255
4415290621.4415886756.7996708-596135.359670817
4514423755.5314431762.4269988-8006.89699876563
4613779681.4914298194.7183241-518513.228324083
4715686348.9416140284.3568643-453935.416864285
4814733828.1715029266.1524868-295437.982486823
4912522497.9412806573.4387736-284075.498773586
5016189383.5716646368.2510755-456984.681075505
5116059123.2517053594.8321520-994471.582151978
5216007123.2615891785.4668607115337.793139335
5315806842.3315762352.987474144489.3425259217
5415159951.1315303066.6538032-143115.523803232
5515692144.1715928811.1363196-236666.966319581
5618908869.1118509799.4734514399069.63654857
5716969881.4217597198.4128241-627316.992824064
5816997477.7817320084.8917461-322607.111746049
5919858875.6519708859.8006524150015.849347598
6017681170.1317625354.915831455815.2141686426


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
160.1674452562315280.3348905124630550.832554743768472
170.3549108235169490.7098216470338980.645089176483051
180.4219785373952400.8439570747904810.57802146260476
190.3714403550316180.7428807100632350.628559644968382
200.3642250064906830.7284500129813660.635774993509317
210.3960417846411980.7920835692823970.603958215358802
220.3192736143514370.6385472287028740.680726385648563
230.2793287177707980.5586574355415960.720671282229202
240.2015828898298330.4031657796596670.798417110170167
250.4446873144789790.8893746289579570.555312685521022
260.4536014996565580.9072029993131160.546398500343442
270.5315284492247560.9369431015504880.468471550775244
280.5290562860345730.9418874279308550.470943713965427
290.5028960176192240.9942079647615520.497103982380776
300.4362499381724120.8724998763448240.563750061827588
310.4252855927962580.8505711855925150.574714407203742
320.5773840188128440.8452319623743130.422615981187156
330.4803659134080430.9607318268160860.519634086591957
340.4143432148858430.8286864297716870.585656785114157
350.3602603396165860.7205206792331720.639739660383414
360.2716404703497250.5432809406994490.728359529650275
370.2932073288985010.5864146577970020.706792671101499
380.3029305686125540.6058611372251080.697069431387446
390.245785704151170.491571408302340.75421429584883
400.8401445627036910.3197108745926180.159855437296309
410.8076768307679380.3846463384641240.192323169232062
420.78991104167150.4201779166570.2100889583285
430.6868889053357470.6262221893285060.313111094664253
440.7488359455442770.5023281089114460.251164054455723


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 level00OK