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
R Framework
error message
The field 'Names of X columns' contains a hard return which cannot be interpreted.
Please, resubmit your request without hard returns in the 'Names of X columns'.


Multiple Linear Regression - Estimated Regression Equation
Connected[t] = + 20.8206973025298 + 0.341980886543588Separate[t] + 0.0382969486948975Software[t] + 0.0567724161221245Happiness[t] -0.0477130006041383Depression[t] + 0.0483024999381058Belonging[t] -0.0435495965731524`Belonging_Final\r`[t] + e[t]


Multiple Linear Regression - Ordinary Least Squares
VariableParameterS.D.T-STAT
H0: parameter = 0
2-tail p-value1-tail p-value
(Intercept)20.82069730252984.1220945.0511e-061e-06
Separate0.3419808865435880.0716784.77114e-062e-06
Software0.03829694869489750.1180740.32430.7461120.373056
Happiness0.05677241612212450.1307610.43420.6647690.332385
Depression-0.04771300060413830.096434-0.49480.6214620.310731
Belonging0.04830249993810580.0761820.6340.5269880.263494
`Belonging_Final\r`-0.04354959657315240.109504-0.39770.6913990.345699


Multiple Linear Regression - Regression Statistics
Multiple R0.38853646818059
R-squared0.150960587106246
Adjusted R-squared0.118094545316811
F-TEST (value)4.59320863989076
F-TEST (DF numerator)6
F-TEST (DF denominator)155
p-value0.000254585517122985
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation3.169577653932
Sum Squared Residuals1557.16448816729


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
14135.66423760036415.33576239963592
23934.61539816056764.38460183943243
33034.6798790707069-4.6798790707069
43133.8952952732073-2.8952952732073
53435.5459446358744-1.54594463587439
63533.29122393842551.70877606157446
73932.57549340565156.42450659434849
83435.6684070818558-1.66840708185579
93635.23870110131260.761298898687352
103735.90122887369151.09877112630848
113833.97504260339074.02495739660933
123634.77578104058151.22421895941845
133834.50880530783413.49119469216595
143935.64881238606983.3511876139302
153336.487406695461-3.48740669546105
163233.9262212798355-1.92622127983547
173633.93684262569152.06315737430848
183836.61476422255861.38523577744137
193935.86074778303793.13925221696206
203233.6971957262022-1.69719572620217
213234.6176770164971-2.61767701649713
223133.2065704851778-2.20657048517776
233935.70728745242363.29271254757638
243735.68611022170851.31388977829151
253934.43848225048254.5615177495175
264134.16084970073056.8391502992695
273635.35487081246340.645129187536644
283335.5059564495294-2.50595644952943
293334.5570973255613-1.55709732556134
303433.81334886154120.186651138458825
313133.0649369255698-2.06493692556982
322733.2640059717531-6.26400597175307
333733.84992018332473.15007981667526
343435.9660285040184-1.96602850401837
353433.45953404037960.540465959620374
363234.4140950988402-2.41409509884022
372932.6403006334608-3.64030063346084
383634.40150502034921.59849497965082
392933.9607838932958-4.96078389329581
403534.25373688862040.746263111379644
413734.18387754489622.81612245510377
423434.5125118384423-0.512511838442302
433834.03639286521273.96360713478731
443533.66401553343861.33598446656144
453832.43934703917625.56065296082385
463734.79640541824892.20359458175114
473836.34501129048941.65498870951061
483334.815463168835-1.81546316883498
493636.2319754311915-0.231975431191531
503834.09980310877163.9001968912284
513236.3449546711523-4.34495467115227
523233.0842088359653-1.08420883596526
533233.7630149321699-1.76301493216992
543435.318591863025-1.31859186302496
553233.5872684216863-1.5872684216863
563733.89705655503413.10294344496587
573934.81035362907884.18964637092123
582934.7369645055259-5.73696450552591
593735.41086448400321.58913551599684
603534.30513325938610.694866740613918
613031.3306054898875-1.33060548988755
623834.83265688113093.16734311886915
633435.13768683282-1.13768683281999
643134.4998190874649-3.49981908746488
653433.28418371344160.715816286558406
663535.745001355216-0.745001355215986
673634.49844312019961.50155687980041
683032.3247096970489-2.3247096970489
693936.57898620891112.42101379108892
703535.6209471620122-0.6209471620122
713834.93301487214853.06698512785148
723135.6010993854657-4.60109938546566
733436.7475482529117-2.74754825291166
743837.34341580113920.656584198860795
753432.60687319263091.39312680736915
763932.92978818204246.07021181795758
773735.82525484692041.17474515307956
783433.18698186685280.813018133147195
792833.7854468599939-5.78544685999389
803731.99356733743955.00643266256046
813335.7309318903695-2.73093189036947
823736.15583802558070.84416197441926
833535.8254683751896-0.825468375189645
843734.55488243634752.44511756365248
853234.7099418615628-2.70994186156283
863333.652080546482-0.652080546481974
873836.3968972995281.603102700472
883334.6336580874676-1.63365808746759
892933.4171937665327-4.41719376653266
903333.4218931853927-0.421893185392697
913135.3443448756921-4.34434487569212
923633.53208461261732.46791538738265
933537.2488053220029-2.24880532200293
943232.8052686861501-0.805268686150105
952933.6179676428328-4.61796764283279
963935.71586331246683.28413668753324
973734.66598949147212.33401050852788
983533.80106169550661.19893830449339
993735.17002075625651.82997924374355
1003235.5571434937695-3.5571434937695
1013835.86742571736652.13257428263351
1023734.69550640068842.30449359931156
1033636.2253804587055-0.225380458705462
1043232.2759640719346-0.275964071934608
1053336.4364630017115-3.4364630017115
1064033.32709032617596.67290967382413
1073835.25726632356052.74273367643946
1084136.26253833719424.73746166280584
1093634.23452222910211.76547777089785
1104335.7900124249057.20998757509496
1113034.9180898255647-4.91808982556474
1123134.2092281546792-3.20922815467923
1133237.3317706724329-5.33177067243285
1143233.9629012461031-1.96290124610313
1153734.90452337126732.09547662873273
1163734.5390610331712.46093896682904
1173336.2958232243025-3.29582322430252
1183436.4458459181372-2.44584591813719
1193335.0804810271287-2.08048102712869
1203835.62268860199162.37731139800841
1213335.0320288344336-2.03202883443357
1223132.3465819424232-1.34658194242322
1233836.89150277679611.10849722320392
1243736.44616946627140.553830533728609
1253333.813059003291-0.813059003290949
1263134.662785648006-3.662785648006
1273934.68247941102284.31752058897722
1284436.72542212760957.27457787239049
1293335.6348885326374-2.63488853263742
1303534.32024797441510.679752025584899
1313234.3026288878924-2.30262888789243
1322833.1880249735738-5.18802497357377
1334035.87083298286144.1291670171386
1342733.0349602003019-6.03496020030193
1353736.1256681631620.874331836838016
1363233.0907594226763-1.09075942267632
1372829.3872452179347-1.38724521793473
1383434.5521010244794-0.552101024479366
1393034.1181855027789-4.11818550277893
1403534.430542402870.569457597129964
1413134.8475253083775-3.84752530837751
1423234.3000775801052-2.30007758010518
1433034.8694772023321-4.86947720233208
1443035.432626756739-5.43262675673899
1453131.1025654161276-0.102565416127582
1464034.01569070921685.98430929078324
1473232.5120031793026-0.512003179302596
1483634.83906549843391.16093450156609
1493233.6575002095327-1.65750020953274
1503533.23596399691591.76403600308406
1513836.55941704566031.44058295433969
1524235.66783729316576.33216270683427
1533436.2835292180633-2.28352921806327
1543536.0580443024399-1.05804430243991
1553533.81906761127531.18093238872475
1563333.1542533435949-0.154253343594859
1573633.53208461261732.46791538738265
1583235.2908434571475-3.29084345714754
1593335.6348885326374-2.63488853263742
1603434.330357081289-0.330357081289019
1613234.7987690698489-2.79876906984887
1623434.7426092609439-0.742609260943886


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
100.3291000607319570.6582001214639130.670899939268043
110.1880822161397470.3761644322794950.811917783860253
120.8040231977086160.3919536045827690.195976802291384
130.8771638996596650.245672200680670.122836100340335
140.8209763647761690.3580472704476630.179023635223831
150.7884943065471720.4230113869056560.211505693452828
160.8104090914869860.3791818170260270.189590908513014
170.7532913921707080.4934172156585840.246708607829292
180.7025134512012840.5949730975974320.297486548798716
190.654212054562570.6915758908748610.34578794543743
200.6888020655447330.6223958689105340.311197934455267
210.7132104758152560.5735790483694880.286789524184744
220.667772726655550.6644545466888990.33222727334445
230.6431618244256570.7136763511486860.356838175574343
240.5747339435311490.8505321129377020.425266056468851
250.5988693599024870.8022612801950260.401130640097513
260.8073972782819170.3852054434361660.192602721718083
270.7752202243114550.4495595513770890.224779775688545
280.7519732088395290.4960535823209410.248026791160471
290.7419179784216830.5161640431566330.258082021578317
300.6918968015322660.6162063969354680.308103198467734
310.6646188182278720.6707623635442560.335381181772128
320.8627693489971690.2744613020056610.137230651002831
330.8498635112210220.3002729775579560.150136488778978
340.8289466312215370.3421067375569250.171053368778463
350.7897839337279890.4204321325440220.210216066272011
360.7823354906109030.4353290187781940.217664509389097
370.7963708365638580.4072583268722850.203629163436142
380.7602606181214670.4794787637570670.239739381878533
390.8172784830854410.3654430338291180.182721516914559
400.7795687268019010.4408625463961970.220431273198099
410.7643514923700740.4712970152598530.235648507629926
420.7232175006698320.5535649986603370.276782499330168
430.7215174268287330.5569651463425340.278482573171267
440.6794082509143310.6411834981713380.320591749085669
450.7515311379755580.4969377240488840.248468862024442
460.7199133386028670.5601733227942650.280086661397133
470.6845875012973280.6308249974053440.315412498702672
480.6574516907770830.6850966184458350.342548309222917
490.6095310597087410.7809378805825180.390468940291259
500.6160012932786710.7679974134426580.383998706721329
510.6723343583373260.6553312833253490.327665641662674
520.635947584407350.72810483118530.36405241559265
530.6075052957118980.7849894085762040.392494704288102
540.5629515672056950.874096865588610.437048432794305
550.5304487271650950.939102545669810.469551272834905
560.5335019810570870.9329960378858260.466498018942913
570.5623567941098820.8752864117802350.437643205890118
580.6776946948927480.6446106102145050.322305305107252
590.6419553590260860.7160892819478270.358044640973914
600.5975503411362790.8048993177274410.402449658863721
610.5589177599931610.8821644800136780.441082240006839
620.5493342592745310.9013314814509380.450665740725469
630.51395285458070.97209429083860.4860471454193
640.5247794226127670.9504411547744660.475220577387233
650.4794744045385510.9589488090771020.520525595461449
660.4362236661313730.8724473322627460.563776333868627
670.3997830519289760.7995661038579510.600216948071024
680.3866134873895780.7732269747791560.613386512610422
690.3667295102257520.7334590204515040.633270489774248
700.3252074677487070.6504149354974140.674792532251293
710.3230915980928240.6461831961856480.676908401907176
720.3653778332181950.7307556664363910.634622166781805
730.3546765513393830.7093531026787660.645323448660617
740.3143028874241540.6286057748483070.685697112575846
750.2816635360484490.5633270720968980.718336463951551
760.3819809346710310.7639618693420620.618019065328969
770.3429373237307630.6858746474615260.657062676269237
780.3031667457250340.6063334914500680.696833254274966
790.4084678088031860.8169356176063730.591532191196814
800.4933474966760230.9866949933520460.506652503323977
810.4796778441316080.9593556882632160.520322155868392
820.4407094034180750.8814188068361490.559290596581925
830.3979640176925950.795928035385190.602035982307405
840.3799154399608970.7598308799217950.620084560039103
850.3656147255857260.7312294511714530.634385274414274
860.325099391069420.6501987821388390.67490060893058
870.2954419885541070.5908839771082150.704558011445893
880.265347479768470.530694959536940.73465252023153
890.295759195473770.591518390947540.70424080452623
900.2576649756602810.5153299513205620.742335024339719
910.2902139515962530.5804279031925070.709786048403747
920.2747633526485750.549526705297150.725236647351425
930.2572299823497420.5144599646994840.742770017650258
940.2236227715759840.4472455431519690.776377228424016
950.254639776123810.509279552247620.74536022387619
960.2569722483831890.5139444967663780.743027751616811
970.2388156477731850.477631295546370.761184352226815
980.2121780098980160.4243560197960310.787821990101985
990.189918388050870.3798367761017390.81008161194913
1000.1911711513900810.3823423027801610.80882884860992
1010.1743501618249160.3487003236498310.825649838175085
1020.1597463370904550.3194926741809110.840253662909545
1030.1323187573096910.2646375146193830.867681242690309
1040.1114480398583780.2228960797167570.888551960141622
1050.1222224959777330.2444449919554670.877777504022267
1060.2337483903126690.4674967806253380.766251609687331
1070.22537238372480.4507447674495990.7746276162752
1080.2585314074306240.5170628148612470.741468592569376
1090.2482121394133620.4964242788267240.751787860586638
1100.4764107038132960.9528214076265910.523589296186704
1110.5496770906967210.9006458186065580.450322909303279
1120.5344946932620010.9310106134759970.465505306737999
1130.6375099189030850.7249801621938310.362490081096915
1140.598576429218890.8028471415622210.40142357078111
1150.5696143056736060.8607713886527880.430385694326394
1160.5428603608809010.9142792782381990.457139639119099
1170.5213750259447940.9572499481104120.478624974055206
1180.4921546523406620.9843093046813240.507845347659338
1190.4524331958610290.9048663917220590.547566804138971
1200.4178340055347050.835668011069410.582165994465295
1210.3736926808641110.7473853617282220.626307319135889
1220.3278666850550610.6557333701101230.672133314944939
1230.2815894811233990.5631789622467970.718410518876601
1240.237373078702530.4747461574050610.76262692129747
1250.196749450531490.393498901062980.80325054946851
1260.213385801827810.4267716036556190.78661419817219
1270.2325373211618010.4650746423236020.767462678838199
1280.4509456527433940.9018913054867870.549054347256606
1290.4162268683634790.8324537367269580.583773131636521
1300.3695963379808060.7391926759616120.630403662019194
1310.3290475455853570.6580950911707150.670952454414643
1320.4011139265317350.802227853063470.598886073468265
1330.4811140216450550.9622280432901090.518885978354945
1340.5826829508431480.8346340983137040.417317049156852
1350.5292627006623550.9414745986752890.470737299337645
1360.4660344411897840.9320688823795670.533965558810216
1370.4190517908521830.8381035817043650.580948209147818
1380.3511829679532010.7023659359064020.648817032046799
1390.3791039568371910.7582079136743830.620896043162809
1400.3292866402599120.6585732805198230.670713359740088
1410.3208334748562320.6416669497124650.679166525143768
1420.2635448727385370.5270897454770740.736455127261463
1430.3345273814691360.6690547629382710.665472618530864
1440.6615820158699940.6768359682600120.338417984130006
1450.5744740214707280.8510519570585450.425525978529272
1460.9747338197992620.05053236040147690.0252661802007385
1470.9644480279953180.07110394400936370.0355519720046818
1480.9548201390244040.09035972195119140.0451798609755957
1490.9423992204355070.1152015591289850.0576007795644926
1500.8878933995849780.2242132008300440.112106600415022
1510.8879202679751880.2241594640496250.112079732024812
1520.965043276265650.06991344746869990.0349567237343499


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 level40.027972027972028OK












Click here to blog (archive) this computation