Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 687.377724284438 + 7.4799967392503X[t] + 461.450680361815M1[t] -869.103821310916M2[t] -758.415790659869M3[t] -542.991819354467M4[t] -94.7998695700121M5[t] -630.807919785557M6[t] -188.159911959758M7[t] -427.815904786109M8[t] -409.999918481258M9[t] + 185.824052824145M10[t] -169.575963479603M11[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)687.3777242844381033.9688890.66480.5093630.254681
X7.47999673925031.8994693.93790.0002650.000133
M1461.450680361815332.2912921.38870.1713370.085668
M2-869.103821310916362.244322-2.39920.0203610.010181
M3-758.415790659869367.77281-2.06220.0446250.022313
M4-542.991819354467362.573452-1.49760.1407840.070392
M5-94.7998695700121355.188404-0.26690.7906890.395345
M6-630.807919785557350.099179-1.80180.0778590.03893
M7-188.159911959758350.736721-0.53650.5941110.297056
M8-427.815904786109351.37208-1.21760.2293440.114672
M9-409.999918481258350.201395-1.17080.2474770.123738
M10185.824052824145348.3287330.53350.5961680.298084
M11-169.575963479603347.618487-0.48780.6278970.313948


Multiple Linear Regression - Regression Statistics
Multiple R0.632309405720561
R-squared0.399815184562689
Adjusted R-squared0.249768980703362
F-TEST (value)2.66461379414521
F-TEST (DF numerator)12
F-TEST (DF denominator)48
p-value0.00800634103013076
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation548.602832503709
Sum Squared Residuals14446323.2558924


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
155605210.46663405917349.53336594083
239224261.3919660882-339.391966088203
337594499.23994130650-740.239941306505
441384729.62390609041-591.62390609041
546345162.85586239636-528.855862396363
639964499.68786761356-503.687867613562
743084949.81587217861-641.815872178612
841434680.23989239526-537.23989239526
944294683.09588522161-254.095885221611
1052195241.51987283076-22.5198728307618
1149294803.83989239526125.160107604740
1257554928.53587543936826.464124560638
1355925404.94654927968187.053450720323
1441634463.35187804796-300.351878047962
1549624633.87988261301328.120117386989
1652084841.82385717916366.176142820837
1747555170.33585913561-415.335859135613
1844914507.16786435281-16.1678643528127
1957324964.77586565711767.224134342887
2057314695.199885873761035.80011412624
2150404690.57588196086349.424118039139
2261025211.59988587376890.40011412624
2349044811.3198891345192.6801108654894
2453694973.41585587486395.584144125136
2555785434.86653623668143.133463763321
2646194455.87188130871163.128118691289
2747314611.43989239526119.56010760474
2850114781.98388326516229.016116734839
2952994990.81593739361308.184062606394
3041464290.24795891455-144.247958914554
3146254665.5759960871-40.5759960871004
3247364455.83999021775280.160009782249
3342194383.8960156516-164.896015651599
3451164852.56004238975263.439957610254
3542054452.2800456505-247.280045650496
3641214509.65605804134-388.656058041345
3751034881.34677753216221.653222467844
3843003969.67209325744330.327906742558
3945784155.16009130099422.839908699009
4038094198.54413760364-389.544137603637
4155264534.53613629934991.463863700663
4242473871.36814151654375.631858483463
4338304343.93613629934-513.936136299337
4443944126.72013369074267.279866309263
4548264077.21614934234748.783850657664
4644094560.84016955898-151.840169558984
4745694183.00016303748385.999836962515
4841064195.49619499283-89.4961949928316
4947944724.266846007969.7331539921005
5039143767.71218129768146.287818702317
5137933923.28019238423-130.280192384232
5244054019.02421586163385.975784138370
5340224377.45620477508-355.456204775081
5441003811.52816760253288.471832397466
5547884358.89612977784429.103870222162
5631634209.00009782249-1046.00009782249
5735854264.21606782359-679.216067823593
5839034882.48002934675-979.480029346747
5941784534.56000978225-356.560009782249
6038634606.8960156516-743.896015651598
6141875158.10665688442-971.106656884417


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
160.5284285824126610.9431428351746780.471571417587339
170.3808550123666660.7617100247333310.619144987633334
180.2959467170270650.591893434054130.704053282972935
190.5577066863465950.884586627306810.442293313653405
200.7943569255655820.4112861488688360.205643074434418
210.7398966224742880.5202067550514240.260103377525712
220.8098569006607880.3802861986784240.190143099339212
230.73072412545230.53855174909540.2692758745477
240.7252881637253190.5494236725493630.274711836274681
250.6741883340611560.6516233318776870.325811665938844
260.5938316934845640.8123366130308710.406168306515436
270.5068897839320270.9862204321359460.493110216067973
280.4622784890147120.9245569780294240.537721510985288
290.5048913061037260.9902173877925470.495108693896274
300.4126872221362590.8253744442725190.58731277786374
310.3300202802464270.6600405604928540.669979719753573
320.3458614078824830.6917228157649660.654138592117517
330.2632568536185080.5265137072370170.736743146381492
340.2924783049372890.5849566098745780.707521695062711
350.217393701037530.434787402075060.78260629896247
360.1873725602863970.3747451205727940.812627439713603
370.1590669164469000.3181338328937990.8409330835531
380.1495099463322590.2990198926645170.850490053667741
390.1829405022779450.365881004555890.817059497722055
400.1307690492898880.2615380985797750.869230950710112
410.5030072614982550.993985477003490.496992738501745
420.4033272540556990.8066545081113980.596672745944301
430.4937034003252260.9874068006504510.506296599674774
440.7034519293874590.5930961412250820.296548070612541
450.9826391954141180.03472160917176410.0173608045858820


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level00OK
5% type I error level10.0333333333333333OK
10% type I error level10.0333333333333333OK