Multiple Linear Regression - Estimated Regression Equation
y[t] = + 20183.8908363885 + 4420.45606204759x[t] + 1.07278534683268y1[t] -0.128942160563676y4[t] -431.278490014834M1[t] -4299.96610657626M2[t] -7684.23161222854M3[t] -5830.93324768869M4[t] -8608.0669432388M5[t] -4351.97049942333M6[t] + 18422.3835583305M7[t] -2290.05787685714M8[t] -6937.72173064447M9[t] -11912.1094256655M10[t] -8764.12912603719M11[t] -67.3332347975218t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)20183.89083638859546.4364812.11430.0393050.019652
x4420.456062047591933.2546252.28650.0263250.013163
y11.072785346832680.07385114.526400
y4-0.1289421605636760.078557-1.64140.1067520.053376
M1-431.2784900148342018.035954-0.21370.8316070.415804
M2-4299.966106576262159.582509-1.99110.0517350.025867
M3-7684.231612228542360.116241-3.25590.0019920.000996
M4-5830.933247688692160.531412-2.69880.0093630.004681
M5-8608.06694323882059.70848-4.17930.0001125.6e-05
M6-4351.970499423332020.839733-2.15350.0359330.017967
M718422.38355833052046.6702799.001100
M8-2290.057876857142684.606209-0.8530.3975530.198777
M9-6937.721730644473251.784405-2.13350.037620.01881
M10-11912.10942566553395.39403-3.50830.0009390.00047
M11-8764.129126037192182.651035-4.01540.0001929.6e-05
t-67.333234797521833.724977-1.99650.0511230.025561


Multiple Linear Regression - Regression Statistics
Multiple R0.985621546213983
R-squared0.971449832361242
Adjusted R-squared0.963214207080831
F-TEST (value)117.957021997093
F-TEST (DF numerator)15
F-TEST (DF denominator)52
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation3303.31748786203
Sum Squared Residuals567419134.131984


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1267413266858.605583522554.394416478448
2267366268193.678482343-827.678482342807
3264777265842.338671462-1065.33867146211
4258863264244.834383605-5381.83438360534
5254844254462.780973496381.219026503680
6254868254346.08015514521.919844859791
7277267277412.67908012-145.679080119890
8285351281424.7873314143926.21266858648
9286602285900.405529929701.594470070513
10283042282197.644457145844.35554285488
11276687278571.000232786-1884.00023278576
12277915279407.876818907-1492.87681890696
13277128280065.33885714-2937.33885713999
14277103275744.0700294301358.92997056959
15275037273085.0790856921951.92091430805
16270150272496.328715706-2346.32871570576
17267140264510.6372757502629.36272424957
18264993265473.540144816-480.54014481609
19287259286143.6853318471115.31466815279
20291186289880.6895331131305.31046688680
21292300289766.6364048372533.36359516304
22288186286196.8371701201989.16282987976
23281477281993.019170971-516.019170970558
24282656282986.142305776-330.142305776204
25280190283608.702938012-3418.70293801165
26280408277557.6614699222850.33853007773
27276836275205.0028903041630.99710969631
28275216273006.9559538552209.04404614490
29274352268742.5481295895609.45187041144
30271311271976.31540794-665.315407940186
31289802291881.577388712-2079.57738871178
32290726291147.562867123-421.562867122867
33292300287535.2254657384764.77453426157
34278506284574.181782109-6068.18178210868
35269826270472.558281747-646.558281746506
36265861269738.434806118-3877.43480611765
37269034264783.2742203864250.72577961351
38264176266029.829437343-1853.82943734299
39255198258485.857435673-3287.85743567272
40253353251151.6113881862201.38861181379
41246057245918.722017464138.277982536256
42235372242906.844352009-7534.84435200876
43258556255308.7964615993247.20353840141
44260993259638.3755588221354.62444117772
45254663258478.518363941-3815.51836394125
46250643248023.8131742952619.18682570528
47243422243802.46809435-380.468094349849
48247105244438.4489508172666.55104918297
49248541248707.109534758-166.109534757523
50245039246829.955926916-1790.95592691628
51237080240552.554243289-3472.55424328873
52237085233325.3268202343759.67317976628
53225554230301.062874051-4747.06287405083
54226839222571.0936950354267.9063049649
55247934247682.894344598251.105655402272
56248333253953.337917293-5620.33791729274
57246969251153.214235554-4184.21423555387
58245098244482.523416331615.476583668764
59246263242835.9542201473427.04577985268
60255765252731.0971183823033.90288161785
61264319262601.9688661831717.03113381720
62268347268083.804654045263.19534595475
63273046268803.1676735814242.8323264192
64273963274404.942738414-441.942738413858
65267430271441.24872965-4011.24872965012
66271993268102.1262450603890.87375494034
67292710295098.367393125-2388.3673931248
68295881296425.246792235-544.246792235398


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
190.01709145265085570.03418290530171140.982908547349144
200.07068442240377050.1413688448075410.92931557759623
210.04299045107581820.08598090215163640.957009548924182
220.02079522438275090.04159044876550180.97920477561725
230.008437689527833310.01687537905566660.991562310472167
240.002949485004738890.005898970009477770.997050514995261
250.003337565491164530.006675130982329060.996662434508836
260.001372735977562690.002745471955125390.998627264022437
270.0005403426918157250.001080685383631450.999459657308184
280.000856138796150010.001712277592300020.99914386120385
290.002191494557094730.004382989114189460.997808505442905
300.0009640583878172180.001928116775634440.999035941612183
310.0008160634362171510.001632126872434300.999183936563783
320.002675202035520880.005350404071041760.997324797964479
330.007098514407691930.01419702881538390.992901485592308
340.09380213567359130.1876042713471830.906197864326409
350.05938671155592810.1187734231118560.940613288444072
360.05914109398520050.1182821879704010.9408589060148
370.08501383598672990.1700276719734600.91498616401327
380.0573687825660790.1147375651321580.94263121743392
390.04281961212404150.0856392242480830.957180387875958
400.05143719279094420.1028743855818880.948562807209056
410.07163672054603330.1432734410920670.928363279453967
420.3757749022453280.7515498044906560.624225097754672
430.4902087694558470.9804175389116940.509791230544153
440.6692124215387880.6615751569224240.330787578461212
450.6217423693560110.7565152612879780.378257630643989
460.6875288309315240.6249423381369520.312471169068476
470.5599213349642950.880157330071410.440078665035705
480.5459842993591960.9080314012816080.454015700640804
490.5092960137613240.9814079724773510.490703986238676


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level90.290322580645161NOK
5% type I error level130.419354838709677NOK
10% type I error level150.483870967741935NOK