Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 49.328366603281 -0.651288616346723X[t] + 0.947192748369779Y1[t] -7.46602476253019M1[t] -12.5116219686066M2[t] -9.5229972894487M3[t] -12.4128790792859M4[t] -1.52744118751515M5[t] + 49.0216445212456M6[t] + 10.1956027171895M7[t] -7.6285553748178M8[t] -15.1264239823416M9[t] -16.2946658166632M10[t] + 0.284989259707416M11[t] -0.205098050841956t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)49.32836660328123.8527122.0680.0444130.022207
X-0.6512886163467230.296327-2.19790.0331450.016572
Y10.9471927483697790.039823.798900
M1-7.466024762530194.301168-1.73580.089440.04472
M2-12.51162196860664.341435-2.88190.0060380.003019
M3-9.52299728944874.431793-2.14880.0370680.018534
M4-12.41287907928594.484485-2.7680.008160.00408
M5-1.527441187515154.623348-0.33040.7426490.371325
M649.02164452124564.60015610.656500
M710.19560271718954.3376392.35050.0231920.011596
M8-7.62855537481784.387332-1.73880.0889140.044457
M9-15.12642398234164.302066-3.51610.0010120.000506
M10-16.29466581666324.218318-3.86280.0003560.000178
M110.2849892597074164.1986950.06790.9461850.473093
t-0.2050980508419560.083122-2.46740.0174780.008739


Multiple Linear Regression - Regression Statistics
Multiple R0.99054160865246
R-squared0.981172678471802
Adjusted R-squared0.975315289551918
F-TEST (value)167.510249343534
F-TEST (DF numerator)14
F-TEST (DF denominator)45
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation6.62519234950304
Sum Squared Residuals1975.19281505611


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1561563.624079373812-2.62407937381185
2555555.928227550926-0.928227550926121
3544552.051664764503-8.05166476450334
4537538.277049245218-1.27704924521792
5543542.4572975708280.542702429172447
6594598.41931285733-4.41931285733032
7611606.001652766794.99834723321046
8613605.377250578927.62274942108004
9611599.89431372546711.1056862745328
10594596.561459481929-2.56145948192933
11595595.791677999017-0.791677999017001
12591596.118525713568-5.11852571356806
13589586.2868534475842.71314655241640
14584580.4443499266193.55565007338085
15573578.036010781643-5.03601078164348
16567564.1311375390892.86886246091123
17569568.5421611350870.457838864913215
18621621.366694044457-0.366694044457154
19629631.784963689692-2.78496368969167
20628621.2029918105316.79700818946873
21612612.683090127065-0.68309012706509
22595595.633635374908-0.633635374907683
23597596.1664311246890.833568875311195
24593595.942507770012-2.94250777001218
25590583.766196485186.23380351482047
26580574.0457014422855.95429855771496
27574568.7250066812315.2749933187687
28573559.94687035033313.0531296496665
29573570.7220792290472.27792077095277
30620620.414778270619-0.414778270619278
31626626.813501651986-0.813501651986298
32620615.1186906157024.88130938429759
33588601.537180882214-13.5371808822140
34566570.114188495756-4.11418849575617
35557567.018211151478-10.0182111514778
36561557.7428736590623.25712634093825
37549554.186166147342-5.18616614734208
38532537.178384740178-5.17838474017835
39526525.2924696021710.707530397829175
40511516.318946686369-5.31894668636903
41499512.140106685404-13.1401066854044
42555550.0105907150964.98940928490363
43565564.2827602154450.717239784555338
44542556.116204726101-14.1162047261012
45527526.6929337168650.307066283134788
46510511.17683146779-1.17683146778963
47514510.9932097395893.00679026041063
48517515.00831090051.99168909949949
49508509.136704546083-1.13670454608293
50493496.403336339991-3.40333633999134
51490482.8948481704517.10515182954894
52469478.325996178991-9.32599617899074
53478468.1383553796349.86164462036595
54528527.7886241124970.211375887503119
55534536.117121676088-2.11712167608783
56518523.184862268745-5.18486226874515
57506503.1924815483892.80751845161147
58502493.5138851796178.4861148203828
59516509.0304699852276.96953001477299
60528525.1877819568582.8122180431425


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
180.007766343283125920.01553268656625180.992233656716874
190.03833887436876020.07667774873752040.96166112563124
200.01486399513887740.02972799027775470.985136004861123
210.02025612209302350.0405122441860470.979743877906976
220.02898158804805470.05796317609610940.971018411951945
230.01880050256603380.03760100513206750.981199497433966
240.008362648872560250.01672529774512050.99163735112744
250.004582215270312710.009164430540625420.995417784729687
260.003215283108374000.006430566216747990.996784716891626
270.003225164988883340.006450329977766680.996774835011117
280.01377587281200990.02755174562401980.98622412718799
290.009799724381599180.01959944876319840.9902002756184
300.005934108639613320.01186821727922660.994065891360387
310.004526871171659170.009053742343318340.99547312882834
320.07342982867070380.1468596573414080.926570171329296
330.3358667062988410.6717334125976820.664133293701159
340.3133595177001080.6267190354002170.686640482299892
350.2406864196979960.4813728393959920.759313580302004
360.4716727849479650.943345569895930.528327215052035
370.4199438804723160.8398877609446330.580056119527684
380.6739892085751940.6520215828496130.326010791424807
390.6095678275224050.780864344955190.390432172477595
400.9434354867509270.1131290264981450.0565645132490726
410.9265028878048660.1469942243902680.0734971121951342
420.8513994579111130.2972010841777730.148600542088887


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level40.16NOK
5% type I error level120.48NOK
10% type I error level140.56NOK