Multiple Linear Regression - Estimated Regression Equation
WklBe[t] = + 78.3799061515617 + 14.6195874973145X[t] + 0.898113780807656Y1[t] -20.7234367469645M1[t] -27.0811350164046M2[t] -28.2616920464878M3[t] -11.6422490765710M4[t] -11.2092314050304M5[t] -16.9965909773283M6[t] -21.6360223524573M7[t] -18.3441303358710M8[t] -24.6650706863537M9[t] -12.0177055958290M10[t] + 37.5949348318731M11[t] -0.388490745478934t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)78.379906151561726.4795512.960.004850.002425
X14.61958749731453.2888524.44525.5e-052.8e-05
Y10.8981137808076560.03991522.500900
M1-20.72343674696453.953963-5.24124e-062e-06
M2-27.08113501640464.204585-6.440900
M3-28.26169204648784.32882-6.528700
M4-11.64224907657104.511667-2.58050.0131230.006562
M5-11.20923140503044.428655-2.53110.0148550.007427
M6-16.99659097732834.356003-3.90190.0003090.000155
M7-21.63602235245734.377076-4.9431.1e-055e-06
M8-18.34413033587104.473265-4.10080.0001668.3e-05
M9-24.66507068635374.515308-5.46252e-061e-06
M10-12.01770559582904.67794-2.5690.0135080.006754
M1137.59493483187314.5901838.190300
t-0.3884907454789340.11461-3.38970.0014450.000722


Multiple Linear Regression - Regression Statistics
Multiple R0.991014050333522
R-squared0.982108847958452
Adjusted R-squared0.976663714728416
F-TEST (value)180.364521209686
F-TEST (DF numerator)14
F-TEST (DF denominator)46
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation6.42361458238997
Sum Squared Residuals1898.08991794228


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
1613606.0154987325966.98450126740352
2611601.0655372792929.934462720708
3594597.700261942114-3.70026194211452
4595598.663279892822-3.66327989282235
5591599.605920599692-8.6059205996916
6589589.837615158684-0.837615158684151
7584583.0134654764610.986534523539002
8573581.42629784353-8.42629784353008
9567564.8376151586842.16238484131586
10569571.707806818884-2.70780681888394
11621622.728184062722-1.72818406272239
12629631.446675087369-2.44667508736856
13628617.51965784138610.4803421586136
14612609.875355045662.12464495434040
15595593.9364867771751.06351322282496
16597594.8995047278832.10049527211723
17593596.74025921556-3.74025921555972
18590586.9719537745523.02804622544775
19580579.2496903115210.750309688478562
20574573.1719537745520.828046225447751
21573561.07383999374511.9261600062554
22573572.4346005579830.565399442017315
23620621.658750240206-1.65875024020584
24626625.8866723608140.113327639186318
25620610.1634275532169.83657244678383
26588598.028555853451-10.0285558534512
27566567.719867092044-1.71986709204409
28557564.192316138714-7.19231613871355
29561556.1538190375064.84618096249371
30549553.57042384296-4.57042384296006
31532537.76513635266-5.76513635266034
32526525.4006033500380.599396649962425
33511513.30248956923-2.30248956922991
34499512.089657202161-13.0896572021608
35555550.5364415146924.46355848530787
36565562.8473876625692.15261233743114
37542550.716597978202-8.71659797820196
38527523.3137920047073.68620799529316
39510508.273037517031.72696248297010
40514509.2360554677384.76394453226237
41517512.873037517034.12696248297012
42508509.391528541676-1.39152854167601
43493496.280582393799-3.28058239379926
44490485.7122769527924.2877230472082
45469476.308504514407-7.30850451440711
46478469.7069894624928.2930105375079
47528527.0141631719840.985836828015844
48534533.9364266350150.063573364985062
49518532.832769324732-14.8327693247320
50506511.71675981689-5.71675981689042
51502499.3703466716362.62965332836356
52516512.0088437728443.99115622715631
53528524.6269636302133.37303636978748
54533529.2284786821283.77152131787247
55536528.6911254655587.30887453444203
56537534.2888680790882.71113192091170
57524528.477550763934-4.47755076393423
58536529.060945958486.93905404151954
59587589.062461010396-2.06246101039548
60597596.8828382542340.117161745766061
61581584.752048569867-3.75204856986706


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
180.1843117036626800.3686234073253590.81568829633732
190.1124624041751040.2249248083502080.887537595824896
200.05902823219570960.1180564643914190.94097176780429
210.06655743238509920.1331148647701980.9334425676149
220.03079516553987250.06159033107974490.969204834460128
230.01735724219286650.03471448438573310.982642757807134
240.008904131479337680.01780826295867540.991095868520662
250.03974288525020190.07948577050040390.960257114749798
260.6633421939884670.6733156120230670.336657806011533
270.5670975975441080.8658048049117840.432902402455892
280.5667843076020380.8664313847959250.433215692397962
290.6275461035087960.7449077929824080.372453896491204
300.5872051404395370.8255897191209260.412794859560463
310.5503030743227290.8993938513545430.449696925677271
320.4714885022445880.9429770044891760.528511497755412
330.4988414530659550.997682906131910.501158546934045
340.930639543980190.1387209120396210.0693604560198104
350.944090045787640.1118199084247210.0559099542123607
360.939862460513440.1202750789731220.0601375394865612
370.9538882645955820.09222347080883620.0461117354044181
380.9829394485187590.03412110296248290.0170605514812415
390.966371435457570.06725712908485870.0336285645424294
400.959030410197470.0819391796050610.0409695898025305
410.98054075022950.03891849954100220.0194592497705011
420.9805838917909820.03883221641803560.0194161082090178
430.97103231201470.05793537597060050.0289676879853002


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level00OK
5% type I error level50.192307692307692NOK
10% type I error level110.423076923076923NOK