Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 2996.21858257135 -397.434462871071X[t] + 177.028669075707M1[t] + 114.595914455059M2[t] + 334.238409008073M3[t] + 204.342364556124M4[t] + 178.748941589334M5[t] + 453.032484736411M6[t] + 22.3364402844630M7[t] -44.4569826823279M8[t] -31.3734395352507M9[t] + 164.561302458348M10[t] -197.155266290631M11[t] + 13.7164568529229t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)2996.21858257135185.86885216.120100
X-397.434462871071100.09187-3.97070.0002440.000122
M1177.028669075707149.5764821.18350.242550.121275
M2114.595914455059156.9506540.73010.4689290.234464
M3334.238409008073156.6474872.13370.0381160.019058
M4204.342364556124156.5391621.30540.1981190.09906
M5178.748941589334156.3252181.14340.2586460.129323
M6453.032484736411156.1299052.90160.0056330.002817
M722.3364402844630156.0242560.14320.8867760.443388
M8-44.4569826823279155.91773-0.28510.7767960.388398
M9-31.3734395352507155.908904-0.20120.8413880.420694
M10164.561302458348155.8278151.0560.2963460.148173
M11-197.155266290631155.758956-1.26580.2118330.105917
t13.71645685292295.0392112.72190.0090750.004537


Multiple Linear Regression - Regression Statistics
Multiple R0.729466690504987
R-squared0.532121652556298
Adjusted R-squared0.402708492625061
F-TEST (value)4.11180480284261
F-TEST (DF numerator)13
F-TEST (DF denominator)47
p-value0.000165474103349661
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation246.259297428538
Sum Squared Residuals2850251.15378987


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
123602392.09478275783-32.0947827578258
222142343.37848499011-129.378484990108
328252576.73743639605248.262563603954
423552460.55784879702-105.557848797021
523332448.68088268315-115.680882683153
630162736.68088268315279.319117316848
721552319.70129508413-164.701295084128
821722266.62432897026-94.62432897026
921502293.42432897026-143.42432897026
1025332503.0755278167829.9244721832179
1120582155.07541592073-97.0754159207257
1221602365.94713906428-205.947139064279
1322602556.69226499291-296.692264992910
1424982507.97596722518-9.97596722518373
1526952741.33491863112-46.334918631121
1627992625.15533103210173.844668967904
1729472613.27836491823333.721635081772
1829302901.2783649182328.7216350817717
1923182484.29877731920-166.298777319203
2025402431.22181120534108.778188794665
2125702458.02181120534111.978188794665
2226692667.673010051861.32698994814249
2324502319.6728981558130.327101844199
2428422530.54462129935311.455378700645
2534402721.28974722798718.710252772015
2626782672.573449460265.42655053974068
2729812905.932400866275.0675991338036
2822602706.29157606425-446.291576064246
2928442678.51723143554165.482768564464
3025462966.51723143554-420.517231435536
3124562470.05075126230-14.0507512622963
3222952397.10206200487-102.102062004875
3323792423.90206200488-44.9020620048750
3424792577.91243604945-98.912436049447
3520572186.19453323757-129.194533237573
3622802325.52805306433-45.5280530643336
3723512488.45276659199-137.452766591988
3822762372.17261013618-96.172610136181
3925482573.73680451243-25.7368045124324
4023112401.91639211146-90.9163921114575
4122012346.32163508177-145.321635081772
4227252634.3216350817790.6783649182282
4324082157.72687805209250.273121947914
4421392064.9064656511174.093534348889
4518982091.70646565111-193.706465651111
4625372241.74249506697295.257504933028
4720691853.99893688381215.001063116191
4820632064.87066002736-1.87066002736259
4925242255.61578595599268.384214044008
5024372206.89948818827230.100511811733
5121892440.25843959420-251.258439594204
5227932324.07885199518468.921148004821
5320742312.20188588131-238.201885881311
5426222600.2018858813121.7981141186885
5522782183.2222982822994.7777017177136
5621442130.1453321684213.8546678315815
5724272156.94533216842270.054667831581
5821392366.59653101494-227.596531014941
5918281947.05821580209-119.058215802092
6020722130.10952654467-58.10952654467
6118002320.8546524733-520.8546524733


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.6135027390504810.7729945218990380.386497260949519
180.5214767088833480.9570465822333050.478523291116652
190.39509878124970.79019756249940.6049012187503
200.2937857550944650.5875715101889290.706214244905535
210.2200187489016690.4400374978033390.77998125109833
220.1404092188170580.2808184376341150.859590781182942
230.09426554549939970.1885310909987990.9057344545006
240.1297178232186690.2594356464373380.87028217678133
250.6058750593361170.7882498813277650.394124940663883
260.5385837050245010.9228325899509970.461416294975499
270.5820571315533420.8358857368933160.417942868446658
280.5756517623177180.8486964753645630.424348237682282
290.7791264714802110.4417470570395780.220873528519789
300.7654567113050480.4690865773899040.234543288694952
310.8307467083535780.3385065832928440.169253291646422
320.7668646734982320.4662706530035370.233135326501768
330.6990383637427380.6019232725145250.300961636257263
340.6102639752145370.7794720495709260.389736024785463
350.5118158613495890.9763682773008230.488184138650411
360.4348110432223440.8696220864446890.565188956777656
370.3610294660584700.7220589321169410.63897053394153
380.2837126201049400.5674252402098790.71628737989506
390.3348155971746280.6696311943492560.665184402825372
400.3340597364328560.6681194728657120.665940263567144
410.2352093379363390.4704186758726770.764790662063661
420.1818641124725540.3637282249451080.818135887527446
430.1592529608202540.3185059216405080.840747039179746
440.08607578028914910.1721515605782980.91392421971085


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