Send output to:
Data X:
Names of X columns:
Sample Range:
(leave blank to include all observations)
From:
To:
Column Number of Endogenous Series (?)
Fixed Seasonal Effects 
Type of Equation 
Degree of Predetermination (lagged endogenous variables) 
Degree of Seasonal Predetermination 
Seasonality 
Chart options
R Code




Summary of computational transaction
Raw Input view raw input (R code)
Raw Outputview raw output of R engine
Computing time3 seconds
R ServerBig Analytics Cloud Computing Center


Multiple Linear Regression - Estimated Regression Equation
IndProd[t] = -1.48358856264544 + 0.618539905255023TotOmzet[t] + 0.0730223253351927Invest[t] + 0.0459292845305722RegWag[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)-1.483588562645440.345152-4.29844.5e-052.2e-05
TotOmzet0.6185399052550230.04821812.827900
Invest0.07302232533519270.0273452.67040.0090410.004521
RegWag0.04592928453057220.022412.04950.0434290.021715


Multiple Linear Regression - Regression Statistics
Multiple R0.875141180691189
R-squared0.765872086141568
Adjusted R-squared0.757798709801622
F-TEST (value)94.8639149090745
F-TEST (DF numerator)3
F-TEST (DF denominator)87
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation1.96123953070687
Sum Squared Residuals334.642063222235


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
12.51.255335053953941.24466494604606
22.3-0.5297736399293072.82977363992931
31.4-0.8631953578892462.26319535788925
40.5-1.683681944040832.18368194404083
5-2.3-2.567420343482560.267420343482558
6-3.7-2.54203843114115-1.15796156885885
7-3.5-1.82721470412759-1.67278529587241
8-0.20.630465587064943-0.830465587064943
90.2-0.08496454733518020.28496454733518
10-0.10.389702132602919-0.489702132602919
11-1-0.363593963287592-0.636406036712408
12-0.9-0.785971178624598-0.114028821375402
132.21.259579931825250.940420068174753
141.91.306399191699770.593600808300233
152.41.995716354558120.404283645441877
162.31.517363760181660.782636239818337
172.31.670611789854590.629388210145413
183.82.113037876702381.68696212329762
1931.781796637273111.21820336272689
202.40.2855991777129632.11440082228704
210.7-0.9506849843955181.65068498439552
221.4-0.9206115836351972.3206115836352
232.5-0.650849898736613.15084989873661
242.90.4567163744845392.44328362551546
253.80.764597263959483.03540273604052
262.91.67384193399131.2261580660087
2730.5802915312399042.4197084687601
285.10.7327571987119364.36724280128806
293.4-0.5529053708200163.95290537082002
303.81.509197831140422.29080216885958
312.73.20000970775731-0.50000970775731
324.74.76471414603635-0.0647141460363465
334.84.709564740269880.0904352597301184
345.54.276014663534591.22398533646541
355.14.119446102240920.980553897759077
367.75.851323279060091.84867672093991
375.45.064633731341920.335366268658084
384.84.422867181123570.377132818876434
394.74.605195256093280.0948047439067165
405.35.57496491611064-0.274964916110641
417.56.28765118853541.2123488114646
425.74.214275978080571.48572402191943
433.62.50115746315061.0988425368494
442.82.82710445266764-0.0271044526676358
453.43.74576695099731-0.345766950997311
463.85.77781397785646-1.97781397785646
471.54.95680309274367-3.45680309274367
480.34.65886944424663-4.35886944424663
490.42.93348673961923-2.53348673961923
500.32.79189707938742-2.49189707938742
511.23.46753007739411-2.26753007739411
520.92.95937513813257-2.05937513813257
532.84.82710100814685-2.02710100814685
542.95.68566454905146-2.78566454905146
554.98.05347721513338-3.15347721513338
562.36.68294018322151-4.38294018322151
5746.73346239620514-2.73346239620514
582.34.27279809916367-1.97279809916367
5955.24808945389641-0.248089453896406
602.63.86382946621449-1.26382946621449
611.74.57499267693056-2.87499267693056
624.34.72368233604533-0.423682336045326
6344.63067120181195-0.63067120181195
643.83.400166797658540.399833202341462
652.53.65042094867829-1.15042094867829
663.23.33880284176446-0.138802841764461
6743.632079266172360.367920733827636
684.12.010888142528222.08911185747178
693.32.112822837404551.18717716259545
704.33.311980856835080.98801914316492
715.84.699969302343811.10003069765619
728.14.863104216816913.23689578318309
736.84.201181181944712.59881881805529
745.34.243080921466931.05691907853307
754.84.166261316080250.633738683919753
765.54.969511714921080.530488285078915
775.24.044531286344221.15546871365578
7865.065287689258930.934712310741072
7943.401728063155370.598271936844633
806.25.819396472221750.380603527778247
813.74.46111575109061-0.761115751090605
825.25.68359532955709-0.483595329557089
832.74.19419707526348-1.49419707526348
840.83.71614586163368-2.91614586163368
852.94.21394938618133-1.31394938618133
860.21.26966846314574-1.06966846314574
87-2.6-1.70375709438784-0.89624290561216
88-6.7-4.82778567314997-1.87221432685003
89-12.5-8.80313532933066-3.69686467066934
90-14.4-11.0806977618253-3.31930223817469
91-16-12.5617874354863-3.43821256451368


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
70.2486581683202580.4973163366405150.751341831679742
80.1230831243021460.2461662486042920.876916875697854
90.1039282499348790.2078564998697580.896071750065121
100.05623809705418560.1124761941083710.943761902945814
110.02793726510692680.05587453021385350.972062734893073
120.01416185726579810.02832371453159630.985838142734202
130.00856513499628880.01713026999257760.991434865003711
140.004075814050923410.008151628101846820.995924185949077
150.006160914830604920.01232182966120980.993839085169395
160.003874866736923630.007749733473847260.996125133263076
170.00250723011247930.005014460224958590.997492769887521
180.001188296300684640.002376592601369280.998811703699315
190.0006019582236359880.001203916447271980.999398041776364
200.0003470924582435070.0006941849164870140.999652907541757
210.0001645015970910060.0003290031941820120.999835498402909
220.0001042579316724780.0002085158633449550.999895742068328
230.0004622238588388480.0009244477176776970.999537776141161
240.0004516024618386990.0009032049236773970.999548397538161
250.0008374219009599670.001674843801919930.99916257809904
260.0004667780743964480.0009335561487928960.999533221925604
270.002517864338510080.005035728677020160.99748213566149
280.05801405896413580.1160281179282720.941985941035864
290.2662258932167720.5324517864335440.733774106783228
300.2879002481506380.5758004963012760.712099751849362
310.3246773869985020.6493547739970050.675322613001498
320.3030837755589480.6061675511178960.696916224441052
330.2666453696099540.5332907392199090.733354630390046
340.261862394990320.523724789980640.73813760500968
350.2358211930845380.4716423861690770.764178806915462
360.2355372962275410.4710745924550830.764462703772459
370.2049409175246810.4098818350493630.795059082475319
380.1762529342850940.3525058685701890.823747065714906
390.150398912429360.3007978248587190.84960108757064
400.1276469682741920.2552939365483840.872353031725808
410.1092173666268010.2184347332536020.890782633373199
420.1038644397430010.2077288794860030.896135560256999
430.1007145681807060.2014291363614120.899285431819294
440.0910726225218010.1821452450436020.908927377478199
450.07963930747597090.1592786149519420.920360692524029
460.1354089723594150.2708179447188290.864591027640585
470.373709180429930.747418360859860.62629081957007
480.8325550891688950.334889821662210.167444910831105
490.8793159327825260.2413681344349490.120684067217474
500.9021768220098720.1956463559802560.0978231779901282
510.9071028027794810.1857943944410370.0928971972205185
520.9066181129118430.1867637741763140.093381887088157
530.8928315836801010.2143368326397990.107168416319899
540.8845265418396620.2309469163206760.115473458160338
550.8986734472701680.2026531054596650.101326552729832
560.9737109015918820.05257819681623560.0262890984081178
570.9843062555658720.03138748886825580.0156937444341279
580.9781155674401140.04376886511977240.0218844325598862
590.9777830705271320.04443385894573690.0222169294728685
600.9895133723522340.02097325529553140.0104866276477657
610.9957981365263750.008403726947248930.00420186347362446
620.9932066517814390.01358669643712240.00679334821856118
630.9890282648739560.02194347025208770.0109717351260438
640.9829206617222170.03415867655556570.0170793382777829
650.9855850750448180.02882984991036390.0144149249551819
660.9834620194154550.03307596116909060.0165379805845453
670.9769671512803530.04606569743929340.0230328487196467
680.9844038478594360.03119230428112860.0155961521405643
690.9905815465894150.01883690682117030.00941845341058517
700.9865497874398960.02690042512020810.0134502125601041
710.9802723341121450.03945533177570950.0197276658878548
720.9931582700327330.0136834599345340.00684172996726699
730.9991663475917230.001667304816554430.000833652408277214
740.9986639016293810.002672196741238730.00133609837061937
750.9974604186411290.005079162717742430.00253958135887122
760.9943165795662730.01136684086745320.00568342043372658
770.9901958574819310.01960828503613850.00980414251806924
780.983351078191920.03329784361616040.0166489218080802
790.9884595565306180.02308088693876310.0115404434693815
800.9912978359940630.01740432801187440.00870216400593721
810.9776084484463040.04478310310739160.0223915515536958
820.9460717298386950.1078565403226090.0539282701613047
830.8957801673602150.208439665279570.104219832639785
840.9848774231003920.03024515379921570.0151225768996079


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level170.217948717948718NOK
5% type I error level420.538461538461538NOK
10% type I error level440.564102564102564NOK












Click here to blog (archive) this computation