Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 8.42354151735435 -0.263310125934268X[t] + 0.456805569775769M1[t] + 0.432604177331831M2[t] + 0.238935189925258M3[t] -0.0400000000000012M4[t] -0.211539367257091M5[t] -0.270474557182349M6[t] + 0.494791645336336M7[t] + 0.563194430224223M8[t] + 0.412662025186853M9[t] + 0.112662025186853M10[t] -0.134733797481316M11[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)8.423541517354350.3609223.339100
X-0.2633101259342680.076988-3.42020.0013040.000652
M10.4568055697757690.4308011.06040.2943980.147199
M20.4326041773318310.4306281.00460.3202390.160119
M30.2389351899252580.4304490.55510.581470.290735
M4-0.04000000000000120.430405-0.09290.926350.463175
M5-0.2115393672570910.43087-0.4910.625740.31287
M6-0.2704745571823490.4312-0.62730.5335240.266762
M70.4947916453363360.4312961.14720.2570970.128549
M80.5631944302242230.4308011.30730.1974640.098732
M90.4126620251868530.430680.95820.3428830.171442
M100.1126620251868530.430680.26160.794780.39739
M11-0.1347337974813160.430407-0.3130.7556370.377818


Multiple Linear Regression - Regression Statistics
Multiple R0.576416949296871
R-squared0.332256499436712
Adjusted R-squared0.161768797165234
F-TEST (value)1.94885903798293
F-TEST (DF numerator)12
F-TEST (DF denominator)47
p-value0.0520596025542661
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation0.68052947892171
Sum Squared Residuals21.7666574690283


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
18.98.511712910822180.388287089177822
28.88.540173543565070.259826456434935
38.38.39916658134535-0.0991665813453451
47.57.9359143032661-0.4359143032661
57.27.58005784785502-0.380057847855022
67.47.62644670830347-0.226446708303470
78.88.365381898228730.434618101771272
89.38.460115695710040.839884304289957
99.38.362245315859530.937754684140474
108.77.825266202518680.874733797481315
118.27.683194430224220.516805569775775
128.37.923252278079250.376747721920754
138.58.353726835261590.14627316473841
148.68.250532405037370.349467594962629
158.57.925208354663660.574791645336336
168.27.751597215112110.448402784887887
178.17.606388860448450.49361113955155
187.97.442129620149480.457870379850517
198.68.207395822668170.392604177331831
208.78.22313658236920.476863417630797
218.78.04627316473840.653726835261594
228.57.956921265485820.543078734514181
238.47.683194430224220.716805569775776
248.57.68627316473840.813726835261594
258.78.143078734514170.556921265485824
268.78.118877342070240.581122657929763
278.68.083194430224220.516805569775775
288.57.698935189925260.801064810074742
298.37.474733797481320.825266202518686
3087.494791645336340.505208354663663
318.28.28638886044845-0.0863888604484498
328.18.38112265792976-0.281122657929764
338.18.3359143032661-0.235914303266100
3488.08857632845295-0.0885763284529536
357.97.76218746800450.137812531995496
367.97.87059025289240.0294097471076069
3788.43271987304187-0.432719873041870
3888.3821874680045-0.382187468004505
397.98.18851848059793-0.288518480597932
4087.909583290672670.090416709327327
417.77.86969898638272-0.169698986382717
427.27.81076379645746-0.610763796457458
437.58.57602999897614-1.07602999897614
447.38.67076379645746-1.37076379645746
4578.46756936623323-1.46756936623323
4677.95692126548582-0.95692126548582
4777.52520835466366-0.525208354663664
487.27.60728012695813-0.407280126958125
497.37.95876164636019-0.658761646360188
507.17.90822924132282-0.808229241322822
516.87.50391215316883-0.703912153168835
526.47.30397000102386-0.903970001023856
536.16.8691205078325-0.769120507832498
546.56.62586822975325-0.125868229753252
557.77.364803419678510.33519658032149
567.97.564861267533530.335138732466469
577.57.387997849902730.112002150097266
586.97.27231493805672-0.372314938056722
596.67.44621531688338-0.846215316883383
606.97.71260417733183-0.812604177331832


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
160.1196862009029950.2393724018059900.880313799097005
170.1617408773648430.3234817547296860.838259122635157
180.09975311271597730.1995062254319550.900246887284023
190.05323670951318980.1064734190263800.94676329048681
200.04557061175585290.09114122351170580.954429388244147
210.03794770846366090.07589541692732180.96205229153634
220.02361324223496850.0472264844699370.976386757765032
230.01537000710234330.03074001420468670.984629992897657
240.01116576878157010.02233153756314020.98883423121843
250.006982389342551740.01396477868510350.993017610657448
260.00479976399289440.00959952798578880.995200236007106
270.003607191798590290.007214383597180580.99639280820141
280.008089445767624980.01617889153525000.991910554232375
290.01918970083473160.03837940166946330.980810299165268
300.02018349802509510.04036699605019010.979816501974905
310.01738344809458550.03476689618917110.982616551905414
320.02851440814249460.05702881628498920.971485591857505
330.04252796163396990.08505592326793980.95747203836603
340.04519029982447860.09038059964895720.954809700175521
350.05356587613933340.1071317522786670.946434123860667
360.0558981576879410.1117963153758820.94410184231206
370.05275301829294850.1055060365858970.947246981707051
380.05621309356495040.1124261871299010.94378690643505
390.06278071889447480.1255614377889500.937219281105525
400.1620690362725370.3241380725450750.837930963727463
410.6432263697190470.7135472605619050.356773630280953
420.9060064469834740.1879871060330530.0939935530165265
430.8613063521191760.2773872957616480.138693647880824
440.79522759271590.4095448145682010.204772407284100


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level20.0689655172413793NOK
5% type I error level100.344827586206897NOK
10% type I error level150.517241379310345NOK