Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 586.7804012508 -1.42669564850463X[t] + 12.0494979595140M1[t] + 8.44581355654682M2[t] + 14.6086479566102M3[t] -5.90728858834744M4[t] -14.4134526969954M5[t] -3.74449074871385M6[t] + 13.1997510290256M7[t] + 38.1263347080594M8[t] + 56.1630560508234M9[t] + 42.5115962852315M10[t] + 11.7074756774717M11[t] + 2.38749164561372t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)586.780401250866.4216258.834200
X-1.426695648504630.703358-2.02840.0471190.02356
M112.049497959514010.868771.10860.2721640.136082
M28.4458135565468210.8900230.77560.4411630.220581
M314.608647956610213.9124291.050.2980540.149027
M4-5.9072885883474411.311053-0.52230.603480.30174
M5-14.413452696995411.245576-1.28170.2050480.102524
M6-3.7444907487138513.812299-0.27110.7872780.393639
M713.199751029025613.9045710.94930.3464020.173201
M838.126334708059410.9259843.48950.0009310.000466
M956.163056050823414.0065854.00980.0001768.8e-05
M1042.511596285231514.4645082.9390.004720.00236
M1111.707475677471711.9340920.9810.3306620.165331
t2.387491645613720.12669418.844500


Multiple Linear Regression - Regression Statistics
Multiple R0.952013796598217
R-squared0.906330268913351
Adjusted R-squared0.885335329187034
F-TEST (value)43.1689864666408
F-TEST (DF numerator)13
F-TEST (DF denominator)58
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation18.7094421164429
Sum Squared Residuals20302.5070098946


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1467460.2598607836726.74013921632807
2460456.618285423863.38171457614026
3448451.044324549341-3.04432454934088
4443452.889618729062-9.88961872906187
5436438.924120199252-2.92412019925211
6431445.845782504578-14.8457825045775
7484501.130246270247-17.1302462702472
8510508.8985912103811.10140878961863
9513520.33462161318-7.33462161318013
10503497.0864100457635.91358995423699
11471478.799320188-7.79932018799969
12471486.029005678795-15.0290056787953
13476492.619169217148-16.6191692171476
14475491.545646024645-16.5456460246447
15470485.971685150126-15.9716851501259
16461471.980657631445-10.9806576314454
17455467.431350381766-12.4313503817663
18456476.635725724699-20.6357257246990
19517522.646667775089-5.64666777508872
20525541.257899643858-16.257899643858
21523540.567017034367-17.5670170343673
22519521.170883717913-2.17088371791268
23509508.3052373244670.69476267553299
24512512.824201083104-0.824201083103979
25519519.557034186307-0.557034186306691
26517518.911519688355-1.91151968835504
27510515.477602286593-5.47760228659326
28509501.2012356382127.79876436178816
29501501.645363158299-0.64536315829888
30507505.5709646017651.42903539823544
31569549.29919361454719.7008063854532
32580573.0465298179336.95347018206725
33578565.07949940106812.9205005989315
34565551.10480954893113.8951904510686
35547541.3778935821965.62210641780406
36555534.48329215279620.5167078472041
37562551.48833392523210.5116660747681
38561547.5614194357213.4385805642804
39555533.71262379987421.2873762001260
40544529.56579625587614.4342037441245
41537531.2939498596175.70605014038332
42543524.37666437444718.6233356255528
43594577.94909336191116.0509066380886
44611591.85222959061519.1477704093846
45613587.59460785986325.4053921401368
46611581.75208320420329.2479167957975
47594562.46630639248631.533693607514
48595556.42772235218938.5722776478113
49591580.85158149684910.1484185031512
50589577.78068439643911.2193156035607
51584573.77608873527610.2239112647243
52573558.3583655680914.6416344319094
53567558.9451626530288.05483734697193
54569549.4598250005519.5401749994498
55621615.8725148245565.12748517544391
56629622.0714945513356.92850544866493
57628617.52853369088210.4714663091181
58612616.679443804987-4.67944380498741
59595584.12539746217810.8746025378221
60597584.078935145612.9210648543999
61593603.224020390793-10.2240203907930
62590599.582445030982-9.58244503098164
63580587.01767547879-7.01767547879024
64574590.004326177315-16.0043261773148
65573570.7600537480382.23994625196203
66573577.111037793962-4.11103779396155
67620638.10228415365-18.1022841536498
68626643.873255185877-17.8732551858774
69620643.895720400639-23.8957204006391
70588630.206369678203-42.206369678203
71566606.925845050674-40.9258450506735
72557613.156843587516-56.156843587516


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.01090862221034680.02181724442069350.989091377789653
180.005249112469474330.01049822493894870.994750887530526
190.0046317892734610.0092635785469220.99536821072654
200.001457540884553630.002915081769107260.998542459115446
210.001696515375698750.003393030751397490.998303484624301
220.0005574717039506070.001114943407901210.99944252829605
230.001800923923280630.003601847846561260.99819907607672
240.003923447874533240.007846895749066490.996076552125467
250.004103926400600090.008207852801200190.9958960735994
260.004286113757197370.008572227514394730.995713886242803
270.004826598482395590.009653196964791180.995173401517604
280.006708098834237250.01341619766847450.993291901165763
290.007968157943453210.01593631588690640.992031842056547
300.01830203456435160.03660406912870320.981697965435648
310.03042360751931630.06084721503863250.969576392480684
320.03529108176625050.07058216353250110.96470891823375
330.03492722562297850.0698544512459570.965072774377022
340.02573042274611350.0514608454922270.974269577253887
350.03138007237372060.06276014474744130.96861992762628
360.02968184211744640.05936368423489290.970318157882554
370.02654572254408520.05309144508817040.973454277455915
380.02442504389338340.04885008778676690.975574956106616
390.01945683626785700.03891367253571410.980543163732143
400.01811159496533380.03622318993066760.981888405034666
410.04134721681401530.08269443362803060.958652783185985
420.07615516102372060.1523103220474410.92384483897628
430.1177621109990700.2355242219981390.88223788900093
440.1817382493305190.3634764986610390.81826175066948
450.2842737984927610.5685475969855220.715726201507239
460.2404157617838450.4808315235676910.759584238216155
470.1962038909528770.3924077819057540.803796109047123
480.1421836451802050.284367290360410.857816354819795
490.1120677381772820.2241354763545630.887932261822718
500.0845419156156060.1690838312312120.915458084384394
510.05109949297035970.1021989859407190.94890050702964
520.05010146621251560.1002029324250310.949898533787484
530.0462801261858520.0925602523717040.953719873814148
540.07282433244505730.1456486648901150.927175667554943
550.08969658410792530.1793931682158510.910303415892075


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level90.230769230769231NOK
5% type I error level170.435897435897436NOK
10% type I error level260.666666666666667NOK