Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 3580.46697505064 + 0.0879589903051959X[t] -3363.86695716855M1[t] -3052.59898369868M2[t] -2739.25415281523M3[t] -2542.97232292653M4[t] -2291.51219027590M5[t] -2063.65837622777M6[t] -1721.72140851618M7[t] -1390.73302941988M8[t] -1051.99640047540M9[t] -725.289657296368M10[t] -382.029542527825M11[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)3580.4669750506484.02424842.612300
X0.08795899030519590.0260023.38280.0014540.000727
M1-3363.86695716855109.974273-30.587800
M2-3052.59898369868110.289953-27.677900
M3-2739.25415281523110.714779-24.741500
M4-2542.97232292653110.282907-23.058600
M5-2291.51219027590113.531376-20.18400
M6-2063.65837622777119.809846-17.224400
M7-1721.72140851618115.326853-14.929100
M8-1390.73302941988112.778531-12.331500
M9-1051.99640047540111.072832-9.471200
M10-725.289657296368110.471349-6.565400
M11-382.029542527825109.885915-3.47660.0011040.000552


Multiple Linear Regression - Regression Statistics
Multiple R0.989585570274023
R-squared0.979279600894564
Adjusted R-squared0.973989286229346
F-TEST (value)185.108006397625
F-TEST (DF numerator)12
F-TEST (DF denominator)47
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation173.428308377894
Sum Squared Residuals1413636.77290044


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1280327.252427686036-47.2524276860357
2557633.330820727895-76.3308207278947
3831943.069333008828-112.069333008828
410811163.01213128962-82.0121312896247
513181371.1084817198-53.1084817198011
615781579.17152294925-1.17152294925396
718591963.06492903642-104.064929036423
821412276.46151007168-135.461510071683
924282619.33221156051-191.332211560512
1027152965.74176856790-250.741768567903
1130043295.63211681006-291.632116810059
1233093684.17062462047-375.170624620467
13269312.651235295365-43.6512352953646
14537623.919208765239-86.9192087652394
15813936.82424469716-123.824244697159
1610681215.87548446305-147.875484463049
1714111468.30316600704-57.3031660070411
1816751693.60616933631-18.6061693363131
1919581925.0666452245832.9333547754197
2022422256.58277826271-14.5827782627088
2125242591.36125264346-67.3612526434598
2228362930.38225446522-94.3822544652162
2331433283.84561210916-140.845612109162
2435223652.15355214938-130.153552149377
25285297.082494011345-12.0824940113451
26574602.017420179246-28.0174201792459
27865908.149613857665-43.1496138576647
2811471200.92245611117-53.9224561111655
2915161550.01706800057-34.0170680005679
3017891874.01005845227-85.0100584522696
3120872180.76343004178-93.7634300417844
3223722477.27188493845-105.271884938445
3326692779.76940987719-110.769409877189
3429663081.05600485802-115.056004858017
3532703398.45617647683-128.456176476832
3636523755.24148878707-103.241488787066
37329276.67600826054052.3239917394605
38658561.38036665824596.6196333417547
39988847.45791054708140.54208945292
4013031193.35798294492109.642017055082
4116031595.491865988357.50813401164582
4219291972.52412759409-43.5241275940891
4322352252.71388411143-17.7138841114348
4425442522.3948469650121.6051530349895
4528722798.2407978412873.7592021587195
4631983074.10724462391123.892755376094
4735443365.82339107360178.176608926396
4839033697.45243215655205.547567843448
49332281.33783474671550.662165253285
50665570.35218366937594.6478163306251
511001862.498897889269138.501102110731
5213291154.83194519124174.168054808757
5316391502.07941828424136.920581715764
5419751826.68812166807148.311878331926
5523042121.39111158578182.608888414223
5626402406.28897976215233.711020237847
5729922696.29632807756295.703671922442
5833302993.71272748496336.287272515043
5936903307.24270353034382.757296469656
6040633659.98190228654403.018097713461


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
160.0006912374518456480.001382474903691300.999308762548154
170.0005341592911292490.001068318582258500.99946584070887
186.29723796259271e-050.0001259447592518540.999937027620374
190.0008356457354519270.001671291470903850.999164354264548
200.001026460152240990.002052920304481970.99897353984776
210.001239359264329100.002478718528658200.99876064073567
220.002905860070593660.005811720141187330.997094139929406
230.01059381907959290.02118763815918580.989406180920407
240.1027346805656590.2054693611313170.897265319434341
250.0615969106297880.1231938212595760.938403089370212
260.0359829154864020.0719658309728040.964017084513598
270.02113808327051900.04227616654103790.97886191672948
280.01672815911234910.03345631822469820.98327184088765
290.01925565069320930.03851130138641860.98074434930679
300.01861405167273570.03722810334547140.981385948327264
310.01796073692532050.03592147385064100.98203926307468
320.02005891110669340.04011782221338670.979941088893307
330.03133403863819790.06266807727639580.968665961361802
340.07443447263666980.1488689452733400.92556552736333
350.3425731103104030.6851462206208050.657426889689597
360.954246287469620.09150742506075850.0457537125303792
370.9289002694347350.1421994611305300.0710997305652651
380.9165093318133830.1669813363732350.0834906681866174
390.9225671638330260.1548656723339490.0774328361669743
400.9057702969304530.1884594061390950.0942297030695473
410.8538473700260870.2923052599478260.146152629973913
420.8429566096854920.3140867806290170.157043390314508
430.8315639520405140.3368720959189720.168436047959486
440.8069601831010050.386079633797990.193039816898995


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level70.241379310344828NOK
5% type I error level140.482758620689655NOK
10% type I error level170.586206896551724NOK