Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 158.174107787313 + 3.15903440532521X[t] + 7.17135863608437M1[t] + 18.9423684069826M2[t] + 26.7225368914909M3[t] + 31.8935466623894M4[t] + 38.1508183628733M5[t] + 41.8900212527067M6[t] + 50.8017480017109M7[t] + 48.4730063891785M8[t] + 1.00503949795491M9[t] -10.0552603790734M10[t] -14.9796712513701M11[t] + 0.106093445077124t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)158.17410778731320.368037.765800
X3.159034405325210.1374222.988200
M17.171358636084375.2280041.37170.1768040.088402
M218.94236840698265.3172143.56250.0008680.000434
M326.72253689149095.3679044.97829e-065e-06
M431.89354666238945.4878565.81171e-060
M538.15081836287335.7414416.644800
M641.89002125270675.8937957.107500
M750.80174800171096.349088.001400
M848.47300638917856.1871577.834500
M91.005039497954915.0693410.19830.8437160.421858
M10-10.05526037907345.274256-1.90650.0628460.031423
M11-14.97967125137015.199309-2.88110.0060020.003001
t0.1060934450771240.0951911.11450.2708420.135421


Multiple Linear Regression - Regression Statistics
Multiple R0.985469174259445
R-squared0.971149493415593
Adjusted R-squared0.96299608938087
F-TEST (value)119.109698143213
F-TEST (DF numerator)13
F-TEST (DF denominator)46
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation7.92410001262523
Sum Squared Residuals2888.40260646401


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1594604.557342208677-10.5573422086767
2595603.798307803352-8.79830780335244
3591595.889397706312-4.88939770631167
4589591.689397706312-2.68939770631171
5584582.2575908252471.74240917475338
6573570.3077151335312.69228486646883
7567563.5303633009863.46963669901351
8569564.4667495388564.53325046114361
9621630.830114684417-9.83011468441741
10629645.148183495068-16.1481834950678
11628640.329866067848-12.3298660678483
12612623.825286711043-11.8252867110434
13595599.512394738953-4.51239473895285
14597595.5943259283021.40567407169782
15593581.36734702061111.6326529793889
16590580.3263814259369.67361857406367
17580567.73554013954612.2644598604539
18574562.10373325848111.8962667415190
19573561.64445023658711.3555497634133
20573562.58083647445710.4191635255433
21620616.3080639987173.69193600128316
22626624.3080639987171.69193600128316
23620616.3307121661723.66928783382787
24588584.0309607827413.96903921725878
25566556.5590344053259.44096559467457
26557546.32289678402410.6771032159756
27561557.3681931189353.63180688106504
28549543.6910899029595.30891009704066
29532531.1002486165690.899751383430905
30526525.4684417355040.531558264495951
31511512.373021092309-1.37302109230892
32499503.832304114203-4.83230411420321
33555554.4004972331380.599502766861832
34565562.4004972331382.59950276686183
35542538.6279733739673.37202662603257
36527525.2824284224881.71757157751225
37510504.1285708557225.87142914427761
38514512.8466396663731.15336033362744
39517520.732901595958-3.73290159595796
40508513.373867190633-5.37386719063274
41493500.783025904242-7.7830259042425
42490498.310253428503-8.31025342850267
43469478.896763974657-9.89676397465712
44478486.151219023177-8.15121902317745
45528530.401343331462-2.40134333146199
46534532.0832745208121.91672547918841
47518517.7878538776160.212146122383543
48506507.601343331462-1.60134333146200
49502502.242657791323-0.242657791322671
50516520.437829817948-4.43782981794846
51528534.642160558184-6.64216055818427
52533539.91926377416-6.91926377415988
53536543.123594514396-7.12359451439568
54537543.809856443981-6.80985644398105
55524527.555401395461-3.55540139546071
56536537.968890849306-1.96889084930627
57587579.0599807522667.9400192477344
58597587.0599807522669.9400192477344
59581575.9235945143965.07640548560431
60564556.2599807522667.7400192477344


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.06984105058175220.1396821011635040.930158949418248
180.02657732238062660.05315464476125320.973422677619373
190.01653516756983080.03307033513966160.983464832430169
200.007645044672410150.01529008934482030.99235495532759
210.002541748291975770.005083496583951550.997458251708024
220.001605374192408220.003210748384816430.998394625807592
230.002986092515688920.005972185031377840.99701390748431
240.07195220194743920.1439044038948780.92804779805256
250.2463098321641530.4926196643283060.753690167835847
260.421737149410430.843474298820860.57826285058957
270.9416886270463380.1166227459073230.0583113729536615
280.987159708168470.02568058366306110.0128402918315306
290.998595587432320.002808825135361340.00140441256768067
300.99973094334180.0005381133163988720.000269056658199436
310.9998105057501710.0003789884996572030.000189494249828602
320.9997264507067520.0005470985864956090.000273549293247805
330.9995411999081330.0009176001837340920.000458800091867046
340.9998201725540440.0003596548919116930.000179827445955846
350.9996243177438060.0007513645123880640.000375682256194032
360.9999334572500530.0001330854998936506.65427499468252e-05
370.9997705232961140.0004589534077716950.000229476703885848
380.99924286589880.001514268202399660.000757134101199828
390.9983656956750770.003268608649846440.00163430432492322
400.9959189389598850.00816212208022940.0040810610401147
410.9946419829201890.01071603415962230.00535801707981113
420.998841693927750.002316612144500800.00115830607225040
430.9976144610563280.004771077887344140.00238553894367207


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level170.62962962962963NOK
5% type I error level210.777777777777778NOK
10% type I error level220.814814814814815NOK