Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 126.383760683761 -49.8978632478632X[t] -19.5698836657170M1[t] -24.5135158051825M2[t] + 0.285709198209129M3[t] -48.4007800841134M4[t] -50.5301265092932M5[t] -5.49975579975582M6[t] -10.3552927011260M7[t] -9.92785239451906M8[t] -26.7667226292227M9[t] -20.9555928639262M10[t] -16.0277964319631M11[t] + 0.272203568036901t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)126.3837606837614.92435825.66500
X-49.89786324786324.442725-11.231400
M1-19.56988366571705.841073-3.35040.0013670.000684
M2-24.51351580518255.838375-4.19878.6e-054.3e-05
M30.2857091982091295.8364320.0490.9611120.480556
M4-48.40078008411345.835244-8.294600
M5-50.53012650929325.834812-8.660100
M6-5.499755799755826.084279-0.90390.3694770.184738
M7-10.35529270112606.085009-1.70180.0937290.046864
M8-9.927852394519066.060242-1.63820.1063670.053183
M9-26.76672262922276.057693-4.41864e-052e-05
M10-20.95559286392626.055871-3.46040.0009740.000487
M11-16.02779643196316.054778-2.64710.0102420.005121
t0.2722035680369010.0664344.09730.0001226.1e-05


Multiple Linear Regression - Regression Statistics
Multiple R0.917996846433517
R-squared0.842718210061882
Adjusted R-squared0.81026323753497
F-TEST (value)25.9657656269178
F-TEST (DF numerator)13
F-TEST (DF denominator)63
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation10.4865511345852
Sum Squared Residuals6927.96854599104


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1105.7107.086080586081-1.38608058608068
2105.7102.4146520146523.28534798534793
3111.1127.486080586081-16.3860805860806
482.479.07179487179493.32820512820513
56077.2146520146519-17.2146520146519
6107.3122.517226292226-15.2172262922263
799.3117.933892958893-18.6338929588929
8113.5118.633536833537-5.13353683353683
9108.9102.0668701668706.83312983312984
10100.2108.150203500204-7.95020350020353
11103.9113.350203500203-9.45020350020345
12138.7129.6502035002049.04979649979646
13120.2110.3525234025239.84747659747661
14100.2105.681094831095-5.48109483109483
15143.2130.75252340252312.4474765974766
1670.982.3382376882377-11.4382376882377
1785.280.48109483109494.71890516890516
18133125.7836691086697.2163308913309
19136.6121.20033577533615.3996642246642
20117.9121.899979649980-3.99997964997965
21106.3105.3333129833130.966687016687016
22122.3111.41664631664610.8833536833537
23125.5116.6166463166468.88335368335368
24148.4132.91664631664615.4833536833537
25126.3113.61896621896612.6810337810338
2699.6108.947537647538-9.34753764753764
27140.4134.0189662189666.3810337810338
2880.385.6046805046805-5.30468050468051
2992.683.74753764753778.85246235246234
30138.5129.0501119251129.44988807488808
31110.9124.466778591779-13.5667785917786
32119.6125.166422466422-5.56642246642248
33105108.599755799756-3.5997557997558
34109114.683089133089-5.68308913308913
35129.4119.8830891330899.51691086691087
36148.6136.18308913308912.4169108669108
37101.4116.885409035409-15.485409035409
38134.8112.21398046398022.5860195360196
39143.7137.2854090354096.41459096459096
4081.688.8711233211233-7.27112332112333
4190.387.01398046398053.28601953601952
42141.5132.3165547415559.18344525844527
43140.7127.73322140822112.9667785917786
44140.2128.43286528286511.7671347171347
45100.2111.866198616199-11.6661986161986
46125.7117.9495319495327.75046805046806
47119.6123.149531949532-3.54953194953197
48134.7139.449531949532-4.74953194953197
49109120.151851851852-11.1518518518518
50116.3115.4804232804230.81957671957673
51146.9140.5518518518526.34814814814816
5297.492.13756613756615.26243386243387
5389.490.2804232804233-0.880423280423285
54132.1135.582997557998-3.48299755799756
55139.8130.9996642246648.80033577533578
56129131.699308099308-2.6993080993081
57112.5115.132641432641-2.63264143264143
58121.9121.2159747659750.684025234025239
59121.7126.415974765975-4.71597476597477
60123.1142.715974765975-19.6159747659748
61131.6123.4182946682958.18170533170535
62119.3118.7468660968660.553133903133916
63132.5143.818294668295-11.3182946682947
6498.395.4040089540092.89599104599105
6585.193.5468660968661-8.44686609686611
66131.7138.849440374440-7.14944037444039
67129.3134.266107041107-4.96610704110704
6890.785.06788766788775.63211233211233
6978.668.50122100122110.098778998779
7068.974.5845543345543-5.68455433455433
7179.179.7845543345543-0.684554334554351
7283.596.0845543345543-12.5845543345543
7374.176.7868742368742-2.68687423687422
7459.772.1154456654457-12.4154456654457
7593.397.1868742368742-3.88687423687423
7661.348.772588522588512.5274114774115
7756.646.91544566544579.68455433455432


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.9362055660265840.1275888679468320.063794433973416
180.9092769357316820.1814461285366360.090723064268318
190.9298978833589470.1402042332821060.0701021166410528
200.9081727390034290.1836545219931430.0918272609965713
210.8984991467235340.2030017065529310.101500853276466
220.8571724750967070.2856550498065860.142827524903293
230.8016935699860580.3966128600278840.198306430013942
240.7687374052932720.4625251894134550.231262594706728
250.7394636881464750.5210726237070510.260536311853525
260.8316568950426870.3366862099146270.168343104957313
270.7705449373446070.4589101253107870.229455062655393
280.7637950913897550.472409817220490.236204908610245
290.7009594854603330.5980810290793340.299040514539667
300.6300148750159230.7399702499681540.369985124984077
310.8015869153527530.3968261692944940.198413084647247
320.8046716225566930.3906567548866140.195328377443307
330.801714638095240.3965707238095220.198285361904761
340.8132391544030940.3735216911938120.186760845596906
350.7631689665683060.4736620668633870.236831033431694
360.7908434892283780.4183130215432440.209156510771622
370.9318286703541260.1363426592917480.0681713296458738
380.9757167761798140.04856644764037190.0242832238201859
390.9633190418891110.07336191622177750.0366809581108887
400.9829873311209440.03402533775811170.0170126688790559
410.973670785533150.05265842893370130.0263292144668507
420.9623979883083420.07520402338331550.0376020116916578
430.9515659249918170.09686815001636550.0484340750081828
440.942403297153190.1151934056936220.0575967028468108
450.9756128640347390.04877427193052280.0243871359652614
460.965940263999740.06811947200052170.0340597360002608
470.9529764431415580.09404711371688320.0470235568584416
480.958101155487020.08379768902595920.0418988445129796
490.982325513346490.03534897330701880.0176744866535094
500.9692446736243920.06151065275121660.0307553263756083
510.9672778443783970.06544431124320550.0327221556216028
520.9493106734390720.1013786531218560.0506893265609278
530.9270951797393130.1458096405213730.0729048202606866
540.898748505749420.202502988501160.10125149425058
550.8378819167652280.3242361664695440.162118083234772
560.7636100189738270.4727799620523460.236389981026173
570.7116458943910590.5767082112178830.288354105608941
580.6342500220103070.7314999559793860.365749977989693
590.489833818568050.97966763713610.51016618143195
600.39634268192360.79268536384720.6036573180764


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level00OK
5% type I error level40.090909090909091NOK
10% type I error level130.295454545454545NOK