Multiple Linear Regression - Estimated Regression Equation
Y(t)[t] = + 22.2014493267714 + 1.47305280975136`Y(t-1)`[t] -0.609958903931009`Y(t-2)`[t] -0.311570948737318`Y(t-3)`[t] + 0.266930877605454`Y(t-4)`[t] + 1.67219763575734X[t] -2.25507346474391M1[t] + 0.6140703509069M2[t] -2.28209966022831M3[t] + 6.09052972606484M4[t] -0.631935182812322M5[t] + 4.54801419086582M6[t] -6.35229584801417M7[t] + 1.40352294946333M8[t] + 0.884830647112344M9[t] + 4.65001216934383M10[t] + 0.985345882304379M11[t] + 0.0152649517802632t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)22.201449326771411.5328711.92510.0617320.030866
`Y(t-1)`1.473052809751360.1581749.312900
`Y(t-2)`-0.6099589039310090.280548-2.17420.0359880.017994
`Y(t-3)`-0.3115709487373180.286298-1.08830.2833280.141664
`Y(t-4)`0.2669308776054540.1632441.63520.1102720.055136
X1.672197635757341.5986981.0460.3021810.15109
M1-2.255073464743912.113838-1.06680.2927870.146393
M20.61407035090692.2641390.27120.7876930.393846
M3-2.282099660228312.440303-0.93520.3556060.177803
M46.090529726064842.2510472.70560.010150.005075
M5-0.6319351828123222.482619-0.25450.8004480.400224
M64.548014190865821.9408732.34330.0244490.012225
M7-6.352295848014172.327005-2.72980.009550.004775
M81.403522949463332.3329680.60160.551010.275505
M90.8848306471123442.9756980.29740.7678170.383909
M104.650012169343832.1397822.17310.0360730.018036
M110.9853458823043792.3246370.42390.674050.337025
t0.01526495178026320.033590.45440.6520910.326046


Multiple Linear Regression - Regression Statistics
Multiple R0.965438204984186
R-squared0.932070927643088
Adjusted R-squared0.901681605799206
F-TEST (value)30.6710012296883
F-TEST (DF numerator)17
F-TEST (DF denominator)38
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation2.77038156067033
Sum Squared Residuals291.650531684682


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1132.92132.983760318567-0.0637603185665924
2129.61126.8862353264892.72376467351121
3122.96123.241262021469-0.281262021469456
4124.04125.855966646979-1.81596664697931
5121.29124.460504182536-3.17050418253571
6124.56126.134473269161-1.57447326916149
7118.53119.632110895046-1.10211089504641
8113.14117.671226042491-4.53122604249057
9114.15111.1531993222782.99680067772204
10122.17122.460744416983-0.290744416982594
11129.23130.078942344692-0.848942344692285
12131.19132.863299752968-1.67329975296797
13129.12126.9751660628722.14483393712770
14128.28125.5559308027242.72406919727643
15126.83123.9741292506842.85587074931597
16138.13131.9065988779136.22340112208706
17140.52142.438508762002-1.91850876200246
18146.83144.4893396268272.34066037317325
19135.14137.533654495603-2.39365449560344
20131.84126.5075745645225.33242543547753
21125.7126.945444639670-1.24544463967037
22128.98129.020809473211-0.0408094732107547
23133.25131.8559311956981.39406880430221
24136.76136.2072942870670.552705712932555
25133.24133.872468316190-0.632468316189744
26128.54128.975900767936-0.435900767935761
27121.08121.364883661894-0.284883661893834
28120.23123.664268007648-3.43426800764833
29119.08120.780053355482-1.70005335548232
30125.75125.869466170903-0.119466170902747
31126.89123.7846670238553.10533297614469
32126.6129.298020432093-2.69802043209308
33121.89125.286905878889-3.39690587888891
34123.44123.731399773180-0.291399773179585
35126.46125.6327935061540.827206493845888
36129.49129.555984974033-0.0659849740332081
37127.78128.19727118068-0.417271180680044
38125.29126.187382759627-0.897382759627055
39119.02120.543677205408-1.52367720540766
40119.96122.555914978614-2.59591497861357
41122.86121.3771868519811.48281314801903
42131.89131.5597849193690.330215080631395
43132.73130.2409925885242.48900741147555
44135.01133.0888710690871.92112893091275
45136.71135.0644501591631.64554984083724
46142.73142.1070463366270.622953663372934
47144.43145.802332953456-1.37233295345582
48144.93143.7434209859311.18657901406863
49138.75139.781334121691-1.03133412169131
50130.22134.334550343225-4.11455034322483
51122.19122.956047860545-0.766047860545026
52128.4126.7772514888461.62274851115415
53140.43135.1237468479995.30625315200145
54153.5154.476936013740-0.976936013740409
55149.33151.428574996970-2.09857499697038
56142.97142.994307891807-0.0243078918066325


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
210.9578407738503880.08431845229922450.0421592261496122
220.9861150198740890.02776996025182280.0138849801259114
230.9725035327060710.05499293458785720.0274964672939286
240.9622077163951790.07558456720964220.0377922836048211
250.9609339159420920.07813216811581570.0390660840579078
260.9893743122151970.02125137556960550.0106256877848027
270.9917963955727880.01640720885442380.0082036044272119
280.9949475441986040.01010491160279120.00505245580139561
290.9880491987978820.02390160240423540.0119508012021177
300.9890219770976480.02195604580470320.0109780229023516
310.9962490170707320.007501965858536040.00375098292926802
320.9893608764574390.02127824708512270.0106391235425614
330.9836536171081730.03269276578365440.0163463828918272
340.9552356260640560.08952874787188770.0447643739359439
350.8774235592710520.2451528814578970.122576440728948


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level10.0666666666666667NOK
5% type I error level90.6NOK
10% type I error level140.933333333333333NOK