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
Connected[t] = + 18.2629853555222 + 0.336031993936644Separate[t] + 0.324387357179273Learning[t] -0.139120947054737Software[t] + 0.0353030642697499Happiness[t] -0.022863659926687Depression[t] + 0.0349149616469285Belonging[t] -0.0249943108224562Belonging_Final[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)18.26298535552224.1922484.35642.4e-051.2e-05
Separate0.3360319939366440.070614.7594e-062e-06
Learning0.3243873571792730.1333612.43240.0161450.008073
Software-0.1391209470547370.137233-1.01380.3122890.156145
Happiness0.03530306426974990.1290380.27360.7847680.392384
Depression-0.0228636599266870.095489-0.23940.8110840.405542
Belonging0.03491496164692850.0752030.46430.6431070.321554
Belonging_Final-0.02499431082245620.108077-0.23130.8174170.408708


Multiple Linear Regression - Regression Statistics
Multiple R0.427051855095817
R-squared0.182373286940778
Adjusted R-squared0.145208436347178
F-TEST (value)4.90714435892766
F-TEST (DF numerator)7
F-TEST (DF denominator)154
p-value5.02586788058146e-05
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation3.1204734771678
Sum Squared Residuals1499.55262714299


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
14134.85033940541356.14966059458646
23934.78780820611364.21219179388636
33035.4235196060377-5.42351960603767
43134.8469343695324-3.84693436953244
53435.0175307771655-1.01753077716548
63532.74346499000832.25653500999165
73934.09083143755334.90916856244673
83435.0894725782011-1.08947257820108
93634.65594931879931.34405068120067
103736.77440866198580.225591338014155
113834.38404164500513.61595835499491
123634.75726411308451.24273588691549
133834.84446861311463.15553138688544
143935.99742188351653.00257811648355
153336.2436617446859-3.2436617446859
163233.8478243951801-1.84782439518007
173634.15863984594861.84136015405142
183837.92197257795260.0780274220473926
193936.81624023893192.18375976106812
203233.894734585242-1.89473458524195
213234.766938715043-2.76693871504303
223133.5434337015664-2.54343370156644
233936.66746325225872.33253674774133
243736.16209430037810.837905699621869
253935.33014008231023.66985991768981
264134.45244088401736.54755911598267
273635.71522387654920.284776123450816
283335.074956908427-2.07495690842705
293334.6808652521656-1.68086525216555
303433.83291356747040.167086432529586
313132.7957919692103-1.79579196921028
322732.9722704796078-5.97227047960777
333733.60591310240593.39408689759414
343436.0781251801717-2.07812518017166
353432.94687823753371.05312176246633
363232.4100583759496-0.410058375949616
372932.2244325202422-3.22443252024216
383633.88340174777682.1165982522232
392934.3542796925317-5.35427969253167
403534.74070393508730.259296064912711
413734.59773360538412.40226639461589
423433.98764302795840.0123569720415706
433834.85947751995493.14052248004515
443533.64655458780151.35344541219852
453832.35360252684915.64639747315091
463733.38846579463323.61153420536684
473835.61957397424042.38042602575958
483334.7704826199945-1.77048261999448
493636.483211723396-0.483211723395981
503833.58929851017014.41070148982986
513236.0250455726567-4.02504557265668
523233.0078403618329-1.00784036183287
533232.8268789885384-0.826878988538438
543435.5323613848115-1.53236138481148
553232.7118745470261-0.711874547026152
563734.45669300111342.54330699888661
573934.93540412371094.06459587628908
582934.8221339000868-5.82213390008679
593735.36465408415871.63534591584128
603534.93703521594520.0629647840547789
613031.4665091791093-1.46650917910928
623834.95710347576913.04289652423085
633434.9442874470568-0.944287447056815
643134.2501037571595-3.25010375715953
653433.49363757456210.506362425437858
663536.072187976472-1.07218797647201
673635.16966221613310.83033778386692
683033.3177895120583-3.31778951205828
693935.40963919198493.59036080801507
703535.7857415055571-0.785741505557144
713833.9276112074824.07238879251802
723135.3257835092312-4.32578350923122
733437.1202156484346-3.1202156484346
743837.64184556290450.358154437095548
753432.74717635555551.25282364444446
763934.16414465626054.83585534373955
773735.75001099779311.24998900220693
783433.71948475902750.280515240972458
792832.9735992693893-4.97359926938929
803732.17035810998284.82964189001719
813335.76747286458-2.76747286458002
823737.2341581825003-0.234158182500322
833535.8949067960171-0.894906796017068
843734.31292209251972.68707790748032
853234.6928626967719-2.69286269677192
863334.1897001707668-1.18970017076684
873836.3837641175771.61623588242301
883334.7880697793308-1.78806977933083
892933.7133361201059-4.71333612010591
903333.6618130298843-0.661813029884271
913134.7026753158317-3.7026753158317
923633.6203606361212.37963936387903
933537.332075591116-2.33207559111601
943232.682828115227-0.682828115226969
952932.740297011634-3.740297011634
963936.09093847378372.90906152621628
973734.7979257471442.20207425285596
983534.43445771014430.565542289855667
993735.18585630689521.81414369310482
1003235.3150588193169-3.31505881931685
1013835.50295018481842.4970498151816
1023735.16583886619631.83416113380369
1033637.0556547553594-1.05565475535944
1043232.3988209877631-0.398820987763085
1053336.7753771829888-3.7753771829888
1064032.79636212825977.2036378717403
1073835.66139209632922.33860790367084
1084136.45691378604854.54308621395154
1093634.75464385616131.24535614383867
1104335.95569247317157.04430752682854
1113035.0565798494001-5.05657984940009
1123134.1238819052851-3.12388190528514
1133237.929820867378-5.929820867378
1143233.2418655055724-1.24186550557241
1153734.02940767921842.97059232078156
1163735.0606099361051.939390063895
1173335.6718631343822-2.67186313438222
1183436.6740334968864-2.67403349688644
1193334.3586516285645-1.35865162856446
1203835.79983094131762.20016905868237
1213334.5241519010363-1.5241519010363
1223132.3954250431049-1.39542504310489
1233835.95160190474182.04839809525823
1243736.10014674236070.899853257639345
1253333.4393091316037-0.439309131603674
1263134.2464136022439-3.24641360224392
1273934.67551231479734.32448768520268
1284437.20796075250046.79203924749958
1293335.8965303531806-2.89653035318062
1303533.36080497137081.63919502862923
1313234.7876701984545-2.78767019845446
1322831.8946217313785-3.89462173137853
1334036.61302238336843.38697761663155
1342732.1625541814688-5.16255418146879
1353735.59332366993341.40667633006657
1363232.9873583435175-0.987358343517519
1372829.5437015424129-1.54370154241287
1383434.683618273408-0.683618273407999
1393033.2342788000179-3.23427880001786
1403533.98058467643941.0194153235606
1413132.9360570035502-1.93605700355022
1423235.1268083243711-3.12680832437109
1433035.2046996993037-5.20469969930372
1443035.3497432182333-5.34974321823331
1453131.4454843072378-0.445484307237837
1464032.8569764233777.14302357662296
1473233.1355388950339-1.13553889503385
1483634.14394143139781.85605856860216
1493233.8417438554998-1.84174385549984
1503533.26332822354631.73667177645373
1513835.57181843705542.42818156294455
1524235.40721415536066.59278584463942
1533436.7835819386775-2.7835819386775
1543537.2871055660989-2.28710556609885
1553534.33422360153320.665776398466775
1563332.30693427625460.693065723745405
1573633.6203606361212.37963936387903
1583235.5870077412555-3.58700774125554
1593335.8965303531806-2.89653035318062
1603434.5871902813244-0.587190281324417
1613234.499017982794-2.49901798279399
1623434.8167205366189-0.816720536618932


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
110.18586899795610.3717379959122010.8141310020439
120.8711265198208840.2577469603582320.128873480179116
130.917785607363360.164428785273280.08221439263664
140.8782549710655480.2434900578689040.121745028934452
150.8409748745624550.318050250875090.159025125437545
160.8650212906900450.269957418619910.134978709309955
170.8216938897658050.356612220468390.178306110234195
180.7890062562805160.4219874874389670.210993743719484
190.7427074467205670.5145851065588670.257292553279433
200.7705474341228580.4589051317542830.229452565877142
210.7902548525762630.4194902948474740.209745147423737
220.7492177578348350.5015644843303290.250782242165165
230.7059472602460190.5881054795079610.294052739753981
240.6388008599893820.7223982800212360.361199140010618
250.6332683712805120.7334632574389760.366731628719488
260.7795034963227450.4409930073545090.220496503677255
270.7731025924187260.4537948151625490.226897407581274
280.7293224658350670.5413550683298650.270677534164933
290.7383900771481540.5232198457036920.261609922851846
300.6826102923862940.6347794152274110.317389707613705
310.6451341949604330.7097316100791350.354865805039567
320.8036532056193780.3926935887612450.196346794380622
330.8012536826432250.397492634713550.198746317356775
340.7650746236652680.4698507526694640.234925376334732
350.7175590508924480.5648818982151040.282440949107552
360.6711103240942120.6577793518115750.328889675905787
370.6590730000160920.6818539999678170.340926999983908
380.6262948773022420.7474102453955160.373705122697758
390.7442330541417230.5115338917165550.255766945858277
400.6971112879335660.6057774241328680.302888712066434
410.6672128522335540.6655742955328920.332787147766446
420.6154486431136810.7691027137726380.384551356886319
430.5861251239017570.8277497521964860.413874876098243
440.5375554111245310.9248891777509380.462444588875469
450.6347300884154840.7305398231690310.365269911584516
460.6410405470007980.7179189059984030.358959452999201
470.6237605004674870.7524789990650270.376239499532513
480.5930500522892980.8138998954214040.406949947710702
490.5453454367630920.9093091264738170.454654563236908
500.572387047129630.8552259057407410.42761295287037
510.6188628680546390.7622742638907220.381137131945361
520.5798674180973110.8402651638053780.420132581902689
530.5349780662111870.9300438675776250.465021933788813
540.4862341915947620.9724683831895230.513765808405238
550.4413071656985870.8826143313971740.558692834301413
560.4304866465178290.8609732930356580.569513353482171
570.4579753075115790.9159506150231590.54202469248842
580.5930836817318440.8138326365363130.406916318268156
590.5539529181863720.8920941636272550.446047081813627
600.5055594034015760.9888811931968480.494440596598424
610.4690263593896740.9380527187793470.530973640610326
620.4535232639334230.9070465278668460.546476736066577
630.419810151658760.839620303317520.58018984834124
640.4262472069042050.8524944138084090.573752793095795
650.380744190473870.761488380947740.61925580952613
660.3447150556384670.6894301112769350.655284944361533
670.3042239283740710.6084478567481420.695776071625929
680.3348925450790350.669785090158070.665107454920965
690.345486365289060.690972730578120.65451363471094
700.3060211139377080.6120422278754170.693978886062292
710.339072452269970.678144904539940.66092754773003
720.3779145721855640.7558291443711290.622085427814436
730.3789251460676620.7578502921353230.621074853932338
740.3354068212201790.6708136424403570.664593178779821
750.3007718588262990.6015437176525990.699228141173701
760.3563087178066840.7126174356133680.643691282193316
770.3187674452748230.6375348905496460.681232554725177
780.2782536788275050.5565073576550110.721746321172495
790.3421658677495730.6843317354991460.657834132250427
800.4178073496552030.8356146993104070.582192650344797
810.407568161462480.8151363229249610.59243183853752
820.3629451928759710.7258903857519420.637054807124029
830.3234050647726030.6468101295452060.676594935227397
840.3117946951542010.6235893903084020.688205304845799
850.2988765327212920.5977530654425850.701123467278708
860.2650828659056210.5301657318112420.734917134094379
870.2382934810190310.4765869620380610.76170651898097
880.2130079935830840.4260159871661680.786992006416916
890.2503840176144470.5007680352288940.749615982385553
900.2164345260985040.4328690521970080.783565473901496
910.2306292760226850.461258552045370.769370723977315
920.2160680742553660.4321361485107320.783931925744634
930.2024424479209620.4048848958419250.797557552079038
940.1722363295019230.3444726590038470.827763670498077
950.1795821426805210.3591642853610430.820417857319479
960.1754924614480210.3509849228960430.824507538551979
970.1602890452649620.3205780905299240.839710954735038
980.137048647900380.274097295800760.86295135209962
990.1202701079778690.2405402159557390.879729892022131
1000.1191637999744460.2383275999488920.880836200025554
1010.1099870332887690.2199740665775390.890012966711231
1020.09652946431977570.1930589286395510.903470535680224
1030.07908564216874780.1581712843374960.920914357831252
1040.06490920954573530.1298184190914710.935090790454265
1050.0762720249200880.1525440498401760.923727975079912
1060.1827067294171930.3654134588343860.817293270582807
1070.1698591350137260.3397182700274510.830140864986274
1080.1937948316745150.3875896633490290.806205168325485
1090.180040605893120.360081211786240.81995939410688
1100.3807243372514580.7614486745029150.619275662748543
1110.4567150875552470.9134301751104950.543284912444753
1120.4402094206972770.8804188413945550.559790579302722
1130.5690955350178850.8618089299642310.430904464982115
1140.5222926214597430.9554147570805140.477707378540257
1150.5077196772306980.9845606455386050.492280322769302
1160.4720816983318390.9441633966636790.527918301668161
1170.4423322543281310.8846645086562620.557667745671869
1180.4183084114809520.8366168229619040.581691588519048
1190.3725985470299170.7451970940598350.627401452970083
1200.3364030956608230.6728061913216450.663596904339177
1210.2919728559341250.5839457118682490.708027144065875
1220.2509440689365060.5018881378730120.749055931063494
1230.215645622637920.4312912452758390.78435437736208
1240.1784445227088750.3568890454177510.821555477291125
1250.1437586781576160.2875173563152320.856241321842384
1260.1534414046925940.3068828093851870.846558595307406
1270.1707955489856030.3415910979712070.829204451014397
1280.3496285532832810.6992571065665610.650371446716719
1290.3207509728858020.6415019457716040.679249027114198
1300.2840011166064680.5680022332129350.715998883393532
1310.2523594790834980.5047189581669960.747640520916502
1320.2947143677287810.5894287354575620.705285632271219
1330.3658416073725540.7316832147451080.634158392627446
1340.4761863918852560.9523727837705130.523813608114744
1350.4202245722774830.8404491445549660.579775427722517
1360.3581314217005820.7162628434011640.641868578299418
1370.3143919327905510.6287838655811020.685608067209449
1380.2543868428273950.508773685654790.745613157172605
1390.3035720261943970.6071440523887940.696427973805603
1400.248588645879610.4971772917592210.75141135412039
1410.4765229413846110.9530458827692220.523477058615389
1420.4149872337799910.8299744675599810.585012766220009
1430.4412122143355510.8824244286711020.558787785664449
1440.7027614498989550.5944771002020890.297238550101045
1450.6132553504205340.7734892991589310.386744649579466
1460.9442888645712040.1114222708575920.0557111354287962
1470.9242965620595310.1514068758809370.0757034379404687
1480.9464807511732260.1070384976535470.0535192488267735
1490.9447529667845720.1104940664308570.0552470332154284
1500.8824242881943180.2351514236113640.117575711805682
1510.7693679172047760.4612641655904480.230632082795224


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












Click here to blog (archive) this computation