Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 3363247.36872550 + 0.862675215502543X[t] -1820347.80707848M1[t] -187455.186940559M2[t] -343912.623172632M3[t] -812292.839266948M4[t] -1681766.40358488M5[t] -1375785.78428621M6[t] -621772.351334577M7[t] -437174.629128277M8[t] -736462.116213925M9[t] -445829.754652919M10[t] + 39658.6322933237M11[t] -16183.9076883882t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)3363247.36872550646794.8431935.19994e-062e-06
X0.8626752155025430.03471224.852100
M1-1820347.80707848303545.710237-5.996900
M2-187455.186940559301037.135597-0.62270.5365580.268279
M3-343912.623172632301687.329693-1.140.2602020.130101
M4-812292.839266948299846.518977-2.7090.0094470.004723
M5-1681766.40358488298648.982151-5.63121e-061e-06
M6-1375785.78428621298420.525039-4.61023.2e-051.6e-05
M7-621772.351334577298420.956303-2.08350.0427860.021393
M8-437174.629128277303881.998335-1.43860.1570240.078512
M9-736462.116213925298027.095406-2.47110.0172330.008617
M10-445829.754652919297948.368363-1.49630.1413970.070699
M1139658.6322933237302299.8383590.13120.8961970.448099
t-16183.90768838823591.581556-4.50614.5e-052.3e-05


Multiple Linear Regression - Regression Statistics
Multiple R0.977947644368567
R-squared0.95638159512603
Adjusted R-squared0.944054654618168
F-TEST (value)77.584668678827
F-TEST (DF numerator)13
F-TEST (DF denominator)46
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation470540.281698332
Sum Squared Residuals10184775208234.3


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
113768040.1414235472.9875384-467432.847538398
217487530.6717353030.6112547134500.058745351
316198106.1316095503.0038045102603.126195539
417535166.3817701555.8749018-166389.494901839
516571771.617104893.2456888-533121.64568878
616198892.6716466321.7825869-267429.112586945
716554237.9317033100.4025637-478862.472563677
819554176.3719784039.0840916-229862.714091583
915903762.3316224150.7859289-320388.455928858
1018003781.6517804616.3870943199165.26290569
1118329610.3818493690.7419348-164080.361934776
1216260733.4216272901.7129714-12168.2929714352
1314851949.214852978.2375658-1029.03756583872
1418174068.4417770662.8994049403405.540595129
1518406552.2318015641.8940353390910.335964743
1618466459.4217701880.156063764579.263937019
1716016524.615349160.5770064667364.022993623
1817428458.3216761591.0017982666867.318201772
1917167191.4216902866.2519991264325.168000877
2019629987.619085410.4306657544577.169334302
2117183629.0116711986.5651599471642.444840083
2218344657.8518228647.3012262116010.548773801
2319301440.7118998743.6378353302697.072164704
2418147463.6818332814.3990092-185350.719009240
2516192909.2215294689.7923872898219.427612768
2618374420.618255336.3183380119084.281662049
2720515191.9520083118.223053432073.726946982
2818957217.218952133.04728415084.15271586714
2916471529.5316759185.1538739-287655.623873907
3018746813.2718923081.3221046-176268.052104617
3119009453.5918673388.7484459336064.841554093
3219211178.5519872806.6932722-661628.143272149
3320547653.7520617201.936238-69548.1862380049
3419325754.0319339094.6243122-13340.5943121525
3520605542.5820998523.4875892-392980.907589235
3620056915.0620171710.3073347-114795.247334700
3716141449.7216647913.9524341-506464.232434103
3820359793.2220926697.4446745-566904.224674528
3919711553.2720014631.9575503-303078.687550287
4015638580.716724699.2413541-1086118.54135410
411438448614662690.2970804-278204.297080378
4213855616.1214309822.8123737-454206.692373723
4314308336.4614572577.8383604-264241.378360400
4415290621.4415731057.0649904-440435.624990354
4514423755.5314275210.7479184148544.782081633
4613779681.4914147759.5403470-368078.050347027
4715686348.9415984348.6453855-297999.705385525
4814733828.1714869390.4523193-135562.282319270
4912522497.9412445791.250074476706.6899255716
5016189383.5716279469.226328-90085.6563280014
5116059123.2516681631.7515570-622508.501556977
5216007123.2615524278.6403969482844.619603058
5315806842.3315375224.7863506431617.543649441
5415159951.1314928914.5911365231036.538863513
5515692144.1715549430.3286309142713.841369107
5618908869.1118121519.7969802787349.313019784
5716969881.4217200132.0047549-230250.584754853
5816997477.7816931234.947020366242.8329796886
5919858875.6519306511.7472552552363.902744832
6017681170.1317233293.5883654447876.541634646


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.04936358502890760.09872717005781530.950636414971092
180.03079629379260380.06159258758520760.969203706207396
190.009346967513090370.01869393502618070.99065303248691
200.003573361703953090.007146723407906180.996426638296047
210.001594207995517030.003188415991034060.998405792004483
220.01098244745044710.02196489490089420.989017552549553
230.005103951367299250.01020790273459850.9948960486327
240.002468745478326290.004937490956652590.997531254521674
250.00537392683252060.01074785366504120.99462607316748
260.07287939863717640.1457587972743530.927120601362824
270.1255140893486690.2510281786973370.874485910651332
280.2713258993663750.5426517987327490.728674100633625
290.4177512334663060.8355024669326110.582248766533694
300.3625511671454860.7251023342909730.637448832854514
310.4118685567938350.823737113587670.588131443206165
320.6559942937978860.6880114124042290.344005706202114
330.5895241229758040.8209517540483920.410475877024196
340.6159430251921550.768113949615690.384056974807845
350.5400531221258750.919893755748250.459946877874125
360.4816995055132170.9633990110264330.518300494486783
370.4623464415545670.9246928831091330.537653558445433
380.3899998667570650.779999733514130.610000133242935
390.7042959099076540.5914081801846920.295704090092346
400.8225806866844070.3548386266311860.177419313315593
410.7130361931125620.5739276137748760.286963806887438
420.5765022153534040.8469955692931920.423497784646596
430.4376846079636320.8753692159272640.562315392036368


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level30.111111111111111NOK
5% type I error level70.259259259259259NOK
10% type I error level90.333333333333333NOK