Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 562.196907216495 -43.9845360824743X[t] + 0.80051546391773M1[t] + 3.8005154639175M2[t] + 0.133848797250830M3[t] -8.1994845360825M4[t] -6.86872852233679M5[t] -17.3687285223368M6[t] -14.5353951890034M7[t] + 36.6312714776632M8[t] + 46.1312714776632M9[t] + 36.1312714776632M10[t] + 15.4000000000000M11[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)562.19690721649514.45417238.895100
X-43.98453608247438.918478-4.93187e-064e-06
M10.8005154639177319.4237260.04120.967270.483635
M23.800515463917519.4237260.19570.8455690.422785
M30.13384879725083019.4237260.00690.9945260.497263
M4-8.199484536082519.423726-0.42210.6745130.337256
M5-6.8687285223367919.457821-0.3530.7253860.362693
M6-17.368728522336819.457821-0.89260.3758060.187903
M7-14.535395189003419.457821-0.7470.4581220.229061
M836.631271477663219.4578211.88260.0648620.032431
M946.131271477663219.4578212.37080.0211520.010576
M1036.131271477663219.4578211.85690.0684950.034247
M1115.400000000000020.2850440.75920.4508730.225437


Multiple Linear Regression - Regression Statistics
Multiple R0.687111170448407
R-squared0.47212176055498
Adjusted R-squared0.360989499619186
F-TEST (value)4.24828719023134
F-TEST (DF numerator)12
F-TEST (DF denominator)57
p-value9.1030585401386e-05
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation32.0734710949691
Sum Squared Residuals58636.3302405498


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1555562.997422680411-7.99742268041122
2562565.997422680412-3.99742268041233
3561562.330756013746-1.33075601374569
4555553.9974226804121.00257731958763
5544555.328178694158-11.3281786941581
6537544.828178694158-7.82817869415804
7543547.661512027491-4.66151202749142
8594598.828178694158-4.82817869415803
9611608.3281786941582.67182130584191
10613598.32817869415814.6718213058419
11611577.59690721649533.4030927835052
12594562.19690721649531.8030927835052
13595562.99742268041332.0025773195874
14591565.99742268041225.0025773195876
15589562.33075601374626.6692439862543
16584553.99742268041230.0025773195876
17573555.32817869415817.6718213058419
18567544.82817869415822.1718213058419
19569547.66151202749121.3384879725086
20621598.82817869415822.1718213058419
21629608.32817869415820.6718213058419
22628598.32817869415829.6718213058419
23612577.59690721649534.4030927835052
24595562.19690721649532.8030927835051
25597562.99742268041334.0025773195874
26593565.99742268041227.0025773195876
27590562.33075601374627.6692439862543
28580553.99742268041226.0025773195876
29574555.32817869415818.6718213058419
30573544.82817869415828.1718213058419
31573547.66151202749125.3384879725086
32620598.82817869415821.1718213058419
33626608.32817869415817.6718213058419
34620598.32817869415821.6718213058419
35588577.59690721649510.4030927835052
36566562.1969072164953.80309278350514
37557562.997422680413-5.9974226804126
38561565.997422680412-4.99742268041238
39549562.330756013746-13.3307560137457
40532553.997422680412-21.9974226804124
41526555.328178694158-29.3281786941581
42511544.828178694158-33.8281786941581
43499547.661512027491-48.6615120274914
44555598.828178694158-43.8281786941581
45565608.328178694158-43.3281786941581
46542598.328178694158-56.3281786941581
47527577.596907216495-50.5969072164948
48510562.196907216495-52.1969072164949
49514562.997422680413-48.9974226804126
50517565.997422680412-48.9974226804124
51508562.330756013746-54.3307560137457
52493553.997422680412-60.9974226804124
53490511.343642611684-21.3436426116838
54469500.843642611684-31.8436426116838
55478503.676975945017-25.6769759450172
56528554.843642611684-26.8436426116838
57534564.343642611684-30.3436426116838
58518554.343642611684-36.3436426116838
59506533.612371134021-27.6123711340206
60502518.212371134021-16.2123711340206
61516519.012886597938-3.01288659793836
62528522.0128865979385.98711340206187
63533518.34621993127114.6537800687285
64536510.01288659793825.9871134020619
65537511.34364261168425.6563573883162
66524500.84364261168423.1563573883162
67536503.67697594501732.3230240549828
68587554.84364261168432.1563573883162
69597564.34364261168432.6563573883162
70581554.34364261168426.6563573883162


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
160.3433811649727070.6867623299454140.656618835027293
170.2508546478468010.5017092956936010.7491453521532
180.189297868061020.378595736122040.81070213193898
190.1343000199237980.2686000398475970.865699980076202
200.09721483178099890.1944296635619980.902785168219001
210.06107542999035430.1221508599807090.938924570009646
220.03852651796645070.07705303593290140.96147348203355
230.02394460109547620.04788920219095250.976055398904524
240.01478679340005260.02957358680010520.985213206599947
250.01297140666464770.02594281332929540.987028593335352
260.009365496589973990.01873099317994800.990634503410026
270.006879172772300950.01375834554460190.9931208272277
280.004789334155815970.009578668311631950.995210665844184
290.003329621101645430.006659242203290850.996670378898355
300.003453974267409920.006907948534819830.99654602573259
310.00334195426972510.00668390853945020.996658045730275
320.002935834921616760.005871669843233520.997064165078383
330.002462892239254130.004925784478508250.997537107760746
340.003203694838549500.006407389677098990.99679630516145
350.007095683951008480.01419136790201700.992904316048992
360.01521142662602290.03042285325204580.984788573373977
370.02065536605649640.04131073211299280.979344633943504
380.02384685457069860.04769370914139730.976153145429301
390.03062962602927630.06125925205855260.969370373970724
400.04446497327561120.08892994655122250.955535026724389
410.05141019926737150.1028203985347430.948589800732629
420.07520635466110280.1504127093222060.924793645338897
430.1232433267407490.2464866534814990.87675667325925
440.1470886615382420.2941773230764840.852911338461758
450.1620433340785060.3240866681570110.837956665921494
460.2186329507797870.4372659015595740.781367049220213
470.2795121060733640.5590242121467280.720487893926636
480.3035363935721190.6070727871442370.696463606427881
490.2823654547224670.5647309094449350.717634545277533
500.2454409699776290.4908819399552580.754559030022371
510.2030337255342590.4060674510685180.796966274465741
520.1584598420991670.3169196841983350.841540157900833
530.1234278302214580.2468556604429160.876572169778542
540.1036390471752790.2072780943505580.896360952824721


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level70.179487179487179NOK
5% type I error level160.41025641025641NOK
10% type I error level190.487179487179487NOK