Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 2798.64582612754 -1.29649455104450X[t] + 126.573614428065M1[t] -101.914798649428M2[t] + 865.440994811826M3[t] + 334.730478464959M4[t] + 338.982766477257M5[t] + 393.997858848719M6[t] + 298.931549040599M7[t] + 440.968744681435M8[t] -190.497565126685M9[t] + 148.998929424360M10[t] + 205.866309808120M11[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)2798.64582612754310.553539.011800
X-1.296494551044500.792395-1.63620.1084840.054242
M1126.573614428065106.0949381.1930.2388490.119424
M2-101.914798649428105.813332-0.96320.3403990.170199
M3865.440994811826105.6850818.188900
M4334.730478464959105.4013083.17580.0026390.001319
M5338.982766477257105.2268583.22140.0023180.001159
M6393.997858848719105.1307453.74770.0004880.000244
M7298.931549040599105.0242612.84630.0065360.003268
M8440.968744681435104.9831214.20040.0001185.9e-05
M9-190.497565126685104.904503-1.81590.0757650.037883
M10148.998929424360104.8691841.42080.1619740.080987
M11205.866309808120104.7915591.96450.0553960.027698


Multiple Linear Regression - Regression Statistics
Multiple R0.880399109517796
R-squared0.775102592039729
Adjusted R-squared0.717681977241361
F-TEST (value)13.4986815233781
F-TEST (DF numerator)12
F-TEST (DF denominator)47
p-value1.89890325685838e-11
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation165.674653926675
Sum Squared Residuals1290060.27482500


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
125292518.1201515276310.8798484723707
221962284.44576024596-88.4457602459581
332023249.20856460512-47.2085646051217
427182714.608564605123.3914353948774
527282716.2678635153311.7321364846685
623542768.68996678470-414.689966784705
726972669.7341733234527.265826676549
826512810.47487441324-159.474874413242
920672177.71207005408-110.712070054078
1026412514.61557550303126.384424496967
1125392571.48295588679-32.4829558867934
1222942365.61664607867-71.6166460786734
1327122485.70778775152226.292212248483
1423142249.4404073677664.5595926322436
1530923215.49970627797-123.499706277965
1626772677.01022262483-0.0102226248318100
1728132677.37302698400135.626973016004
1826682728.49863570232-60.498635702325
1929392629.54284224107309.457157758928
2026172768.98704877982-151.987048779818
2122312136.2242444206594.775755579346
2224812474.424244420656.575755579346
2324212529.99513025337-108.995130253370
2424082318.9428422410789.0571577589282
2525602444.21996211809115.780037881907
2621002215.7315490406-115.731549040599
2733153181.79084795081133.209152049191
2828012649.78383705290151.216162947103
2924032654.03612506519-251.036125065195
3030242707.75472288561316.245277114387
3125072611.39191852645-104.391918526449
3229802753.42911416728226.570885832716
3322112120.6663098081290.33369019188
3424712460.1628043591610.8371956408356
3525942515.7336901918878.2663098081199
3624522309.86738038376142.132619616240
3722322435.14450026078-203.144500260781
3823732205.35959263224167.640407367757
3931273171.41889154245-44.4188915424526
4028022635.52239699141166.477603008592
4126412633.292212248487.70778775151669
4227872687.010810068999.989189931099
4326192590.6480057097428.3519942902633
4428062731.3887067995374.611293200472
4521932098.6259024403694.3740975596365
4623232436.82590244036-113.825902440363
4725292493.6932828241235.3067171758764
4824122286.53047846496125.469521535041
4922622411.80759834198-149.807598341980
5021542182.02269071344-28.0226907134425
5132303148.0819896236581.9180103763483
5222952616.07497872574-321.074978725741
5327152619.0307721869995.9692278130061
5427332674.0458645584658.9541354415439
5523172577.68306019929-260.683060199292
5627302719.7202558401310.2797441598727
5719132081.77147327678-168.771473276785
5823902419.97147327679-29.971473276785
5924842456.0949408438327.9050591561669
6019602245.04265283154-285.042652831535


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
160.2250678004114150.4501356008228290.774932199588585
170.1105709077556430.2211418155112870.889429092244357
180.1998673761754300.3997347523508610.80013262382457
190.1834408122488120.3668816244976240.816559187751188
200.2076089090849040.4152178181698090.792391090915096
210.1328267672585000.2656535345170010.8671732327415
220.1919809661598290.3839619323196580.808019033840171
230.2432108452177720.4864216904355440.756789154782228
240.1687958022507530.3375916045015060.831204197749247
250.1736606324429770.3473212648859530.826339367557023
260.2474397813947090.4948795627894170.752560218605291
270.2089800445801830.4179600891603660.791019955419817
280.1654789690685990.3309579381371970.834521030931401
290.6565441006579890.6869117986840220.343455899342011
300.8667211992158980.2665576015682040.133278800784102
310.892244283968820.215511432062360.10775571603118
320.8928206055467960.2143587889064070.107179394453204
330.838031279931280.3239374401374390.161968720068720
340.7806034919466860.4387930161066280.219396508053314
350.73995308482720.5200938303455990.260046915172799
360.6498453163915980.7003093672168040.350154683608402
370.71858122612570.56283754774860.2814187738743
380.634597674668860.730804650662280.36540232533114
390.655104761379250.68979047724150.34489523862075
400.799224500572030.4015509988559390.200775499427969
410.7597637016520910.4804725966958170.240236298347909
420.6395829459247490.7208341081505010.360417054075251
430.6315302613187270.7369394773625450.368469738681272
440.4551566383302790.9103132766605590.544843361669721


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