Multiple Linear Regression - Estimated Regression Equation
yt[t] = -36966.1549603009 + 0.22521259944289xt[t] + 0.78008644395922`yt-1`[t] + 0.264724289662743`yt-2`[t] -0.254204822249017`yt-3`[t] -0.203055482260318`yt-4`[t] -347.98479049917M1[t] + 6078.80639576497M2[t] + 23777.7731454625M3[t] -879.960276448189M4[t] -26288.3288224235M5[t] -13027.8366627345M6[t] + 837.100853143718M7[t] + 10420.6488383957M8[t] + 2634.58407307717M9[t] -3258.91930047984M10[t] -2450.69027059630M11[t] -133.111522809557t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)-36966.154960300922937.83424-1.61160.1137490.056875
xt0.225212599442890.0901422.49840.016030.008015
`yt-1`0.780086443959220.1655444.71232.2e-051.1e-05
`yt-2`0.2647242896627430.1949791.35770.1810410.09052
`yt-3`-0.2542048222490170.193207-1.31570.1946520.097326
`yt-4`-0.2030554822603180.148286-1.36930.1773980.088699
M1-347.984790499172866.797343-0.12140.9039040.451952
M26078.806395764972785.1217222.18260.0340960.017048
M323777.77314546255409.3730494.39576.3e-053.1e-05
M4-879.9602764481896192.846762-0.14210.8876140.443807
M5-26288.32882242355194.015973-5.06137e-063e-06
M6-13027.83666273456464.106182-2.01540.04960.0248
M7837.1008531437183603.2299110.23230.8172980.408649
M810420.64883839573475.9141872.9980.0043330.002167
M92634.584073077173462.0620740.7610.4504660.225233
M10-3258.919300479843240.768223-1.00560.3197570.159878
M11-2450.690270596302985.771893-0.82080.415910.207955
t-133.11152280955757.949216-2.2970.0261180.013059


Multiple Linear Regression - Regression Statistics
Multiple R0.991167080004474
R-squared0.982412180484596
Adjusted R-squared0.976050628744981
F-TEST (value)154.429645579548
F-TEST (DF numerator)17
F-TEST (DF denominator)47
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation4551.16421878486
Sum Squared Residuals973515500.07834


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1200237199836.660039697400.339960302505
2203666204675.073366061-1009.07336606120
3241476237565.1615012113910.83849878931
4260307249126.78599501711180.2140049834
5243324248602.549394501-5278.54939450088
6244460242868.6844336721591.31556632780
7233575236662.444655061-3087.44465506060
8237217238705.638293358-1488.63829335779
9235243232872.2268994592370.77310054110
10230354228471.5297652291882.47023477076
11227184224979.6562819232204.34371807677
12221678220741.187876437936.81212356349
13217142215498.2985911591643.70140884093
14219452218948.535951556503.464048444141
15256446250804.0069955415641.99300445873
16265845259589.5470996766255.4529003237
17248624251360.317802748-2736.31780274849
18241114240039.5609884231074.43901157729
19229245229689.036985530-444.036985529751
20231805230752.8850806711052.11491932911
21219277226253.895536446-6976.89553644604
22219313214922.8463270024390.15367299793
23212610211755.273185077854.726814922845
24214771210258.4792706994512.52072930115
25211142211901.376540130-759.376540129599
26211457217670.427118698-6213.42711869812
27240048245833.606853983-5785.60685398271
28240636245319.085028244-4683.08502824393
29230580227134.6639318523445.33606814812
30208795217968.880572155-9173.88057215511
31197922201161.096884328-3239.09688432764
32194596196892.421568183-2296.42156818325
33194581191823.7605516092757.23944839119
34185686189452.561993850-3766.56199384959
35178106182368.769543950-4262.76954394974
36172608175801.872799113-3193.87279911266
37167302167938.060135102-636.060135101805
38168053169582.966918991-1529.96691899087
39202300202036.373041012263.626958988097
40202388208703.653392679-6315.65339267872
41182516188018.312490783-5502.31249078323
42173476173523.687647982-47.6876479823754
43166444164087.4581653502356.54183464975
44171297171686.546509356-389.54650935584
45169701172624.685030377-2923.68503037744
46164182168152.733873489-3970.73387348871
47161914160929.833455853984.166544147243
48159612158901.664660917710.335339083216
49151001153047.657276374-2046.65727637441
50158114155563.7402047672550.25979523312
51186530188885.093622934-2355.09362293394
52187069191974.143242376-4905.14324237641
53174330170792.4359207443537.56407925560
54169362162806.1863577686555.81364223239
55166827162412.9633097324414.03669026824
56178037174914.5085484323122.49145156777
57186412181639.4319821094772.56801789119
58189226187761.3280404301464.67195956961
59191563191343.467533197219.532466802877
60188906191871.795392835-2965.79539283518
61186005184606.9474175381398.05258246237
62195309189610.2564399275698.74356007292
63223532225207.757985319-1675.75798531948
64226899228430.785242008-1531.78524200806
65214126207591.7204593716534.27954062887


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
210.298532864046380.597065728092760.70146713595362
220.2477837252641270.4955674505282530.752216274735873
230.1721493221339610.3442986442679220.827850677866039
240.8172629373368850.3654741253262310.182737062663115
250.7515490662851330.4969018674297330.248450933714867
260.6483692007900140.7032615984199720.351630799209986
270.710183232210650.5796335355787010.289816767789351
280.9662008970020740.06759820599585110.0337991029979256
290.979187868424030.04162426315193910.0208121315759695
300.9627890868598140.07442182628037260.0372109131401863
310.976144841431970.04771031713605810.0238551585680290
320.9878620450344910.02427590993101720.0121379549655086
330.9914931822409340.01701363551813160.00850681775906582
340.9860476305522440.02790473889551170.0139523694477558
350.9763854015471230.04722919690575480.0236145984528774
360.9552034329250470.08959313414990570.0447965670749528
370.9817539836014250.03649203279714990.0182460163985749
380.993043046348290.01391390730341960.00695695365170981
390.9969019880897530.006196023820493880.00309801191024694
400.9924306231976160.01513875360476720.00756937680238358
410.980158606992830.03968278601434060.0198413930071703
420.957785454354070.08442909129185880.0422145456459294
430.9512918119103260.09741637617934880.0487081880896744
440.9724038677376870.05519226452462690.0275961322623135


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level10.0416666666666667NOK
5% type I error level110.458333333333333NOK
10% type I error level170.708333333333333NOK