Multiple Linear Regression - Estimated Regression Equation
Y[t] = + 5545.45096713486 -0.178613936386478X[t] + 43.6242818380755M1[t] -931.523238964048M2[t] -737.34522798693M3[t] -574.60293979709M4[t] -229.603780800123M5[t] -869.626245910535M6[t] -397.169978062677M7[t] -609.621116620415M8[t] -610.078828430576M9[t] + 70.0960717549703M10[t] -371.561402011425M11[t] -12.7493375297899t + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)5545.45096713486299.69681318.503500
X-0.1786139363864780.128893-1.38570.1723640.086182
M143.6242818380755346.624690.12590.9003840.450192
M2-931.523238964048363.852446-2.56020.0137360.006868
M3-737.34522798693363.376425-2.02910.0481280.024064
M4-574.60293979709362.949809-1.58310.1200950.060047
M5-229.603780800123362.564867-0.63330.5296230.264811
M6-869.626245910535362.233019-2.40070.0203730.010186
M7-397.169978062677361.961702-1.09730.2781130.139057
M8-609.621116620415361.752756-1.68520.0985820.049291
M9-610.078828430576361.587572-1.68720.0981870.049094
M1070.0960717549703373.5694040.18760.8519680.425984
M11-371.561402011425373.494856-0.99480.3249170.162458
t-12.74933752978994.337665-2.93920.0050880.002544


Multiple Linear Regression - Regression Statistics
Multiple R0.623840267592213
R-squared0.389176679469524
Adjusted R-squared0.220225548258967
F-TEST (value)2.30348667499899
F-TEST (DF numerator)13
F-TEST (DF denominator)47
p-value0.0186249399858107
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation571.339391925744
Sum Squared Residuals15342148.9360057


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
155605467.1927963110292.8072036889818
239224482.33237489767-560.332374897667
337594663.58243440861-904.582434408608
441384814.2898408142-676.289840814204
546345146.89689015415-512.896890154154
639964495.01815719588-499.018157195885
743084956.6898408142-648.689840814204
841434732.56104834499-589.561048344993
944294718.99677113227-289.996771132271
1052195377.13440909593-158.134409095932
1149294921.298686308657.701313691347
1257555280.28936472668474.710635273324
1355925314.02213201714277.977867982856
1441634329.1617106038-166.161710603801
1549624510.23315617836451.766843821644
1652084660.94056258395547.059437416048
1747554993.72622586029-238.726225860288
1844914342.74056258395148.259437416048
1957324803.51917652034928.480823479661
2057314578.497314369201152.50268563080
2150404565.29026502925474.709734970753
2261025224.32097267484877.679027325162
2349044768.84247776033135.157522239666
2453695128.72622586029240.273774139712
2555785165.31681613294412.683183867059
2646194181.34946440153437.65053559847
2747314364.38566327634366.614336723664
2850114513.66415819084497.33584180916
2952994848.05734689465450.942653105345
3041464198.32198117302-52.3219811730241
3146254659.10059510941-34.1005951094108
3247364436.57932806768299.420671932320
3342194425.51564596437-206.515645964367
3451165082.9388281824833.0611718175198
3542054626.74587752243-421.74587752243
3641214989.66606254095-868.666062540955
3751035023.2202158950479.7797841049627
3843004038.35979448169261.640205518306
3945784219.07401218348358.925987816524
4038094368.53112103437-559.531121034367
4155264702.38846792902823.611532070978
4242474052.29587433462194.704125665382
4338304512.53864646185-682.538646461845
4443944291.08906303843102.910936961568
4548264276.27448827100549.725511728995
4644094934.76935410744-525.769354107436
4745694479.2908591929389.7091408070676
4841064840.96074665675-734.960746656751
4947944873.97905820167-79.9790582016743
5039143886.7966556153127.2033443846928
5137934065.72473395322-272.724733953224
5244054213.57431737664191.425682623363
5340224544.93106916188-522.931069161881
5441003891.62342471252208.376575287479
5547884351.1517410942436.848258905798
5631634128.2732461797-965.273246179697
5735854112.92282960311-527.92282960311
5839034129.83643593931-226.836435939314
5938633673.82209921565189.177900784350
6055604671.35760021533888.64239978467
6139224705.26898144219-783.268981442186


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
170.003523933396206390.007047866792412790.996476066603794
180.2792011085258880.5584022170517750.720798891474112
190.329425242478940.658850484957880.67057475752106
200.2729344008689300.5458688017378590.72706559913107
210.2080339870627360.4160679741254720.791966012937264
220.1767427392488490.3534854784976980.823257260751151
230.1245015514209670.2490031028419340.875498448579033
240.07476545375457070.1495309075091410.92523454624543
250.1002636930785610.2005273861571220.899736306921439
260.1213446193197450.242689238639490.878655380680255
270.09431508693195660.1886301738639130.905684913068043
280.06462690686864420.1292538137372880.935373093131356
290.04960151877719720.09920303755439440.950398481222803
300.03037582449309270.06075164898618550.969624175506907
310.02031433506958380.04062867013916770.979685664930416
320.01360876446628090.02721752893256180.986391235533719
330.007165311175387350.01433062235077470.992834688824613
340.004202816292860020.008405632585720040.99579718370714
350.002660778960859970.005321557921719930.99733922103914
360.004967866639148130.009935733278296250.995032133360852
370.002395523730878410.004791047461756810.997604476269122
380.001608253144553890.003216506289107780.998391746855446
390.0009658850604870310.001931770120974060.999034114939513
400.002026596725657130.004053193451314260.997973403274343
410.006686390662150630.01337278132430130.99331360933785
420.003073491054991550.006146982109983090.996926508945008
430.01018516423498020.02037032846996040.98981483576502
440.008192304296000750.01638460859200150.991807695704


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level90.321428571428571NOK
5% type I error level150.535714285714286NOK
10% type I error level170.607142857142857NOK