Home » date » 2010 » Nov » 17 »

Decreasing Competence?

*The author of this computation has been verified*
R Software Module: /rwasp_multipleregression.wasp (opens new window with default values)
Title produced by software: Multiple Regression
Date of computation: Wed, 17 Nov 2010 09:04:39 +0000
 
Cite this page as follows:
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL http://www.freestatistics.org/blog/date/2010/Nov/17/t12899849862wg0yilynfjlce6.htm/, Retrieved Wed, 17 Nov 2010 10:09:59 +0100
 
BibTeX entries for LaTeX users:
@Manual{KEY,
    author = {{YOUR NAME}},
    publisher = {Office for Research Development and Education},
    title = {Statistical Computations at FreeStatistics.org, URL http://www.freestatistics.org/blog/date/2010/Nov/17/t12899849862wg0yilynfjlce6.htm/},
    year = {2010},
}
@Manual{R,
    title = {R: A Language and Environment for Statistical Computing},
    author = {{R Development Core Team}},
    organization = {R Foundation for Statistical Computing},
    address = {Vienna, Austria},
    year = {2010},
    note = {{ISBN} 3-900051-07-0},
    url = {http://www.R-project.org},
}
 
Original text written by user:
 
IsPrivate?
No (this computation is public)
 
User-defined keywords:
 
Dataseries X:
» Textbox « » Textfile « » CSV «
9 41 38 13 12 14 12 53 32 9 39 32 16 11 18 11 83 51 9 30 35 19 15 11 14 66 42 9 31 33 15 6 12 12 67 41 9 34 37 14 13 16 21 76 46 9 35 29 13 10 18 12 78 47 9 39 31 19 12 14 22 53 37 9 34 36 15 14 14 11 80 49 9 36 35 14 12 15 10 74 45 9 37 38 15 9 15 13 76 47 9 38 31 16 10 17 10 79 49 9 36 34 16 12 19 8 54 33 9 38 35 16 12 10 15 67 42 9 39 38 16 11 16 14 54 33 9 33 37 17 15 18 10 87 53 9 32 33 15 12 14 14 58 36 9 36 32 15 10 14 14 75 45 9 38 38 20 12 17 11 88 54 9 39 38 18 11 14 10 64 41 9 32 32 16 12 16 13 57 36 9 32 33 16 11 18 9.5 66 41 9 31 31 16 12 11 14 68 44 9 39 38 19 13 14 12 54 33 9 37 39 16 11 12 14 56 37 9 39 32 17 12 17 11 86 52 9 41 32 17 13 9 9 80 47 9 36 35 16 10 16 11 76 43 9 33 37 15 14 14 15 69 44 9 33 33 16 12 15 14 78 45 9 34 33 14 10 11 13 67 44 9 31 31 15 12 16 9 80 49 9 27 32 12 8 13 15 54 33 9 37 31 14 10 17 10 71 43 9 34 37 16 12 15 11 84 54 9 34 30 14 12 14 13 74 42 9 32 33 10 7 16 8 71 44 9 29 31 10 9 9 20 63 37 9 36 33 14 12 15 12 71 43 9 29 31 etc...
 
Output produced by software:

Enter (or paste) a matrix (table) containing all data (time) series. Every column represents a different variable and must be delimited by a space or Tab. Every row represents a period in time (or category) and must be delimited by hard returns. The easiest way to enter data is to copy and paste a block of spreadsheet cells. Please, do not use commas or spaces to seperate groups of digits!


Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time16 seconds
R Server'George Udny Yule' @ 72.249.76.132


Multiple Linear Regression - Estimated Regression Equation
Learning[t] = + 8.35046999717002 -0.40459931201988month[t] + 0.0347834365471902Connected[t] + 0.0433406498517765Separate[t] + 0.576062196352003Software[t] + 0.0796225833189896Happiness[t] -0.0261020091912720Depression[t] + 0.0282902834264182Belonging[t] -0.0326511809003049Belonging_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)8.350469997170022.616983.19090.0015960.000798
month-0.404599312019880.159517-2.53640.0117970.005898
Connected0.03478343654719020.0347561.00080.3178790.15894
Separate0.04334064985177650.035281.22850.2204020.110201
Software0.5760621963520030.05277110.916300
Happiness0.07962258331898960.0578451.37650.1698790.08494
Depression-0.02610200919127200.042437-0.61510.539050.269525
Belonging0.02829028342641820.0377660.74910.4544970.227248
Belonging_Final-0.03265118090030490.056098-0.5820.5610530.280527


Multiple Linear Regression - Regression Statistics
Multiple R0.664098147499979
R-squared0.441026349512904
Adjusted R-squared0.423489921262328
F-TEST (value)25.1491548456242
F-TEST (DF numerator)8
F-TEST (DF denominator)255
p-value0
Multiple Linear Regression - Residual Statistics
Residual Standard Deviation1.86477720145105
Sum Squared Residuals886.735472818163


Multiple Linear Regression - Actuals, Interpolation, and Residuals
Time or IndexActualsInterpolation
Forecast
Residuals
Prediction Error
11315.9509274269776-2.95092742697758
21615.61818286657540.381817133424643
31916.91666437166082.08333562833916
41511.87297480736473.12702519263529
51416.3580519877682-2.35805198776815
61314.7360162717571-1.73601627175708
71915.15370000850733.84629999149269
81517.0077560505479-2.00775605054788
91415.9484454966395-1.94844549663945
101514.29803647116440.701963528835628
111614.86261723779161.13738276220843
121616.1018077007215-0.101807700721472
131615.38931096589850.61068903410149
141615.40797860831350.592021391686455
151718.0043950630554-1.00439506305541
161515.3798159239431-0.379815923943112
171514.51055881772250.489441182277545
182016.38338081660303.61661918339702
191815.37483486550242.62516513449760
201615.49353216649420.506467833505832
211615.30276946513760.697230534862387
221615.04117682479710.958823175202857
231916.45306185276212.54693814723788
241614.98923789504661.01076210495340
251716.16684214898730.833157851012718
261716.22120877420730.778791225792692
271614.97172460671661.02827539328339
281516.7639680138983-1.7639680138983
291615.76616698423490.233833015765089
301414.0778957672031-0.0778957672031147
311515.7460272839639-0.746027283963944
321212.7373771224324-0.737377122432354
331414.7974186192349-0.797418619234864
341615.92850012021880.0714998797812121
351415.6022003060943-1.60220030609430
361012.9219264013097-2.92192640130971
371013.0146729900312-3.01467299003119
381415.7899916900747-1.78999169007471
391614.56264900128851.43735099871148
401614.47211332661551.52788667338445
411614.72718460011861.27281539988142
421415.8283533347221-1.82835333472214
432017.57401211321132.42598788678866
441414.1663108781857-0.166310878185714
451414.4929035444449-0.492903544444942
461115.5799467762799-4.57994677627988
471416.6042289856471-2.60422898564706
481515.1942294341289-0.194229434128941
491615.62909391322530.37090608677469
501415.7309335277757-1.73093352777567
511617.1471512900765-1.14715129007648
521414.2216774089203-0.221677408920321
531215.1453403734528-3.14534037345284
541615.86955240071300.130447599286978
55911.3645521776952-2.36455217769524
561412.40067491876611.59932508123387
571616.0107717121744-0.0107717121744176
581615.58764435886460.412355641135398
591515.2486517151036-0.248651715103637
601614.30096044971811.69903955028191
611211.56804057123740.431959428762605
621615.84809338514080.151906614859215
631616.7320968224482-0.732096822448167
641414.8491657946905-0.849165794690488
651615.45321849883940.546781501160557
661715.7867282952991.2132717047010
671816.06639745499831.93360254500172
681814.22360084200553.7763991579945
691215.7039588645577-3.70395886455774
701615.44783813657970.552161863420335
711013.0291955081803-3.02919550818028
721414.6990097947249-0.699009794724867
731816.82153871734651.17846128265351
741817.04738583689800.952614163101954
751615.06185386664440.93814613335562
761713.26865780022513.73134219977488
771616.2744534843814-0.274453484381412
781614.27409504855741.72590495144259
791315.0334785537398-2.03347855373977
801614.92476976718111.07523023281887
811615.56553475187030.434465248129714
821615.53697520668790.463024793312053
831515.5563789647738-0.556378964773841
841514.70917618789200.290823812108049
851613.97564876045272.02435123954728
861414.0085733239176-0.00857332391764704
871615.22083074899350.77916925100649
881614.70659346891491.29340653108514
891514.35475102652220.645248973477802
901213.7050807374168-1.70508073741682
911716.67826411380120.321735886198799
921615.74302028898820.256979711011831
931515.0195639849035-0.0195639849034504
941314.9635980286721-1.96359802867209
951614.69737266429451.30262733570547
961615.68306295708270.316937042917323
971613.58229891990442.41770108009563
981615.76851057004570.231489429954300
991414.3198580815311-0.319858081531108
1001617.0247038337605-1.02470383376054
1011614.57879733628371.42120266371627
1022017.46876748970402.53123251029596
1031514.05230462593870.947695374061293
1041614.95633327821691.04366672178305
1051314.8011674216603-1.80116742166032
1061715.65821183689391.34178816310611
1071615.71494542313630.285054576863653
1081614.26516952799161.73483047200845
1091212.1445025399444-0.144502539944429
1101615.27003173010800.729968269891974
1111616.0190228965521-0.0190228965520536
1121714.97289912432702.02710087567298
1131314.6235262603592-1.62352626035921
1141214.5611065152376-2.56110651523763
1151816.1825664051971.81743359480300
1161415.8742392027801-1.8742392027801
1171413.06342436139860.93657563860137
1181314.7664152300671-1.7664152300671
1191615.572753804110.427246195889985
1201314.4067456846915-1.40674568469151
1211615.43916476528990.56083523471014
1221315.8911672712233-2.89116727122331
1231616.9042581868609-0.904258186860862
1241515.8921534889468-0.892153488946773
1251616.9022361707383-0.9022361707383
1261514.70363206284200.296367937158032
1271715.61131042759051.38868957240952
1281513.98386079664091.01613920335906
1291214.7440838384905-2.74408383849047
1301613.99364226261572.00635773738434
1311013.7576725915982-3.75767259159823
1321613.51763211448282.48236788551718
1331214.2161631177914-2.21616311779137
1341415.6237963714392-1.62379637143924
1351515.1698667563622-0.169866756362208
1361312.14215570462570.857844295374258
1371514.50094692009940.499053079900579
1381113.4686249246835-2.46862492468351
1391213.0157243738587-1.01572437385866
1401113.4194465342762-2.41944653427621
1411612.88313150544633.11686849455368
1421513.75585057140021.24414942859978
1431717.0097795066055-0.00977950660547738
1441614.27379465830671.7262053416933
1451013.3567315625142-3.35673156251415
1461815.65274620595732.34725379404273
1471315.0228847719538-2.02288477195385
1481614.96201918240161.03798081759843
1491312.87725916249890.122740837501070
1501012.9838669107856-2.98386691078564
1511516.1494801243129-1.14948012431286
1521614.02757313785671.97242686214327
1531611.91105101507544.08894898492458
1541412.88162029650721.11837970349282
1551012.5110772982986-2.51107729829857
1561716.67826411380120.321735886198799
1571311.77484088460681.22515911539322
1581513.98386079664091.01613920335906
1591614.72204775703351.2779522429665
1601212.9024487088536-0.902448708853636
1611312.72341135615090.276588643849055
1621312.35944475142150.640555248578516
1631212.2197140578900-0.219714057889972
1641716.15592569301060.844074306989396
1651513.49271101103111.50728898896895
1661011.3690856488793-1.36908564887931
1671414.1511837465642-0.151183746564210
1681114.0473814027883-3.04738140278826
1691314.6284207569089-1.62842075690888
1701614.32864011010921.67135988989079
1711210.21036951488851.78963048511152
1721615.22941735128720.77058264871285
1731213.6789589162402-1.67895891624021
174911.1422436631215-2.14224366312147
1751214.8132494934299-2.81324949342989
1761514.43672008721820.56327991278181
1771212.0443133302158-0.0443133302158407
1781212.5271258979836-0.527125897983635
1791413.65203802068790.347961979312097
1801213.2423636290015-1.24236362900148
1811614.90287143221651.09712856778351
1821111.2308165908512-0.230816590851180
1831916.63024496677492.36975503322512
1841515.0709573706773-0.0709573706773391
185814.5002572284975-6.50025722849752
1861614.73852227465641.26147772534359
1871714.40111576811242.59888423188756
1881212.2769350009329-0.276935000932892
1891111.3375926910729-0.337592691072856
1901110.23353936827710.766460631722878
1911414.7383473626722-0.738347362672238
1921615.40683587596070.59316412403932
193129.554864139151812.44513586084819
1941613.93110147346472.06889852653535
1951313.5896293614340-0.589629361433967
1961514.93247053755730.0675294624426769
1971612.89708801943293.10291198056707
1981615.01800947072730.981990529272688
1991412.34947855432961.65052144567040
2001614.54136139454021.45863860545978
2011613.94459320357302.05540679642697
2021413.32261846105740.677381538942598
2031113.4275177946162-2.42751779461623
2041214.4367109870216-2.43671098702159
2051512.66992691345482.33007308654517
2061514.45865242543130.541347574568739
2071614.46793724639011.53206275360994
2081614.93164692049001.06835307951003
2091113.5562780239837-2.55627802398369
2101513.97793980179681.02206019820315
2111214.2029022057863-2.20290220578625
2121215.7784438651911-3.77844386519108
2131514.14402017910060.855979820899417
2141512.03070326771532.96929673228469
2151614.56848295895421.43151704104577
2161413.07313463419000.92686536580997
2171714.67461237544132.32538762455872
2181413.94235982251960.0576401774804326
2191311.89050283722281.10949716277721
2201515.2059654363509-0.205965436350911
2211314.6710171706430-1.67101717064297
2221414.1319205655599-0.131920565559859
2231514.30011824651640.699881753483601
2241213.1092937744911-1.10929377449114
2251312.71166640654250.288333593457546
226811.7472131342750-3.74721313427504
2271413.80158017396440.198419826035621
2281413.02026742792360.97973257207643
2291112.2297591833158-1.22975918331585
2301212.8968382776945-0.896838277694458
2311311.24520848195421.75479151804577
2321013.2130657616632-3.21306576166324
2331611.36771740091854.63228259908155
2341815.94741616960612.05258383039394
2351313.8693288638037-0.869328863803698
2361113.3430027385425-2.34300273854246
237410.9726967298314-6.97269672983141
2381314.2678178481433-1.26781784814330
2391614.30690708652381.6930929134762
2401011.6823923405169-1.68239234051694
2411212.2879119795221-0.287911979522077
2421213.5011921116947-1.50119211169469
243108.851422533167461.14857746683254
2441311.10286279022251.89713720977750
2451513.70924810047961.29075189952042
2461211.96850573174150.0314942682585147
2471412.87773198600271.12226801399732
2481012.5358000227952-2.53580002279515
2491210.76241308588411.23758691411588
2501211.73939094400440.260609055995635
2511111.9220624304821-0.922062430482096
2521011.7304631725709-1.73046317257095
2531211.40196619942770.59803380057231
2541612.88255626328213.11744373671786
2551213.3765522827852-1.37655228278524
2561413.90482908535210.0951709146478995
2571614.51987977996511.48012022003486
2581411.66827988484082.33172011515922
2591314.3566901566030-1.35669015660303
26049.3833458059488-5.38334580594881
2611513.84725932840051.15274067159949
2621115.1083609537208-4.1083609537208
2631111.3476291943178-0.347629194317837
2641412.91444947140431.08555052859575


Goldfeld-Quandt test for Heteroskedasticity
p-valuesAlternative Hypothesis
breakpoint indexgreater2-sidedless
120.2492722734171290.4985445468342570.750727726582871
130.1689541093509830.3379082187019650.831045890649017
140.1886524744826960.3773049489653930.811347525517304
150.1138221995709400.2276443991418810.88617780042906
160.07735817854516670.1547163570903330.922641821454833
170.1110899216880140.2221798433760270.888910078311986
180.3502972440081350.700594488016270.649702755991865
190.2730761482175770.5461522964351530.726923851782423
200.200364779799480.400729559598960.79963522020052
210.1473290382449430.2946580764898850.852670961755057
220.1424298221526230.2848596443052450.857570177847377
230.3296136106918740.6592272213837490.670386389308126
240.3961081111703740.7922162223407490.603891888829626
250.3646437826222450.7292875652444890.635356217377755
260.3430137852627020.6860275705254030.656986214737298
270.4195222169011410.8390444338022820.580477783098859
280.4310392695664140.8620785391328270.568960730433586
290.4111782576654860.8223565153309720.588821742334514
300.4445628643832980.8891257287665960.555437135616702
310.3891820533962190.7783641067924380.610817946603781
320.3466207532541680.6932415065083370.653379246745831
330.3166771309296100.6333542618592210.68332286907039
340.2756748983004870.5513497966009740.724325101699513
350.2331395248719940.4662790497439870.766860475128006
360.3636238995606090.7272477991212170.636376100439392
370.4004800180238080.8009600360476160.599519981976192
380.3925184568810720.7850369137621450.607481543118928
390.420646898193910.841293796387820.57935310180609
400.3940366688202010.7880733376404010.6059633311798
410.3526085106959840.7052170213919680.647391489304016
420.3178155607826870.6356311215653750.682184439217313
430.3306029984344080.6612059968688160.669397001565592
440.2841930399770590.5683860799541170.715806960022941
450.2593073538046430.5186147076092860.740692646195357
460.4573731365432830.9147462730865660.542626863456717
470.6130150426948590.7739699146102830.386984957305141
480.564790964894330.8704180702113410.435209035105671
490.5501158312494750.899768337501050.449884168750525
500.5388868721163390.9222262557673230.461113127883661
510.4960291879906010.9920583759812020.503970812009399
520.4489765516673570.8979531033347140.551023448332643
530.4694099708676210.9388199417352420.530590029132379
540.4498338359931050.899667671986210.550166164006895
550.4520661833654640.9041323667309290.547933816634536
560.4207085898279370.8414171796558750.579291410172063
570.3771221469019330.7542442938038660.622877853098067
580.3435042881973320.6870085763946640.656495711802668
590.3053817369161190.6107634738322380.694618263083881
600.3047156648422220.6094313296844440.695284335157778
610.2748853643145120.5497707286290240.725114635685488
620.2433915133210.4867830266420.756608486679
630.2132055555154970.4264111110309940.786794444484503
640.1848502554386160.3697005108772310.815149744561384
650.1596120903137820.3192241806275640.840387909686218
660.1357016826093980.2714033652187960.864298317390602
670.1180785549662390.2361571099324780.881921445033761
680.1474917120339440.2949834240678890.852508287966056
690.3472555386289550.6945110772579090.652744461371045
700.3093835208007310.6187670416014610.69061647919927
710.4660184741956750.932036948391350.533981525804325
720.4276948834687980.8553897669375960.572305116531202
730.4157563143704610.8315126287409230.584243685629539
740.3945458489702340.7890916979404680.605454151029766
750.3594443771041710.7188887542083420.640555622895829
760.407073802696670.814147605393340.59292619730333
770.3743005846908220.7486011693816440.625699415309178
780.3465913445996450.6931826891992890.653408655400355
790.3751240969174830.7502481938349650.624875903082518
800.3445238367559380.6890476735118760.655476163244062
810.3118927695474320.6237855390948640.688107230452568
820.2778009724449010.5556019448898030.722199027555099
830.2541368671141730.5082737342283450.745863132885827
840.2233817956636750.446763591327350.776618204336325
850.2136243035512130.4272486071024260.786375696448787
860.1860951835112320.3721903670224640.813904816488768
870.1627844833256370.3255689666512750.837215516674362
880.1479693140306380.2959386280612750.852030685969362
890.1275367957355450.2550735914710890.872463204264455
900.1293263329675000.2586526659349990.870673667032500
910.1115353318735740.2230706637471470.888464668126426
920.09612839823137280.1922567964627460.903871601768627
930.08255029560782890.1651005912156580.917449704392171
940.08774253876849360.1754850775369870.912257461231506
950.07808798576575520.1561759715315100.921912014234245
960.06582940569368970.1316588113873790.93417059430631
970.0689068074898870.1378136149797740.931093192510113
980.05735795154405050.1147159030881010.94264204845595
990.04759063603325670.09518127206651340.952409363966743
1000.04254385848685640.08508771697371280.957456141513144
1010.03698593102943970.07397186205887950.96301406897056
1020.04200024337560510.08400048675121030.957999756624395
1030.03566538980737500.07133077961474990.964334610192625
1040.03166652007823060.06333304015646130.96833347992177
1050.03880949768818570.07761899537637140.961190502311814
1060.03358010302153150.06716020604306310.966419896978469
1070.02729038597572920.05458077195145840.97270961402427
1080.02601341498369650.05202682996739310.973986585016303
1090.02122212996364220.04244425992728440.978777870036358
1100.01720381846762340.03440763693524690.982796181532377
1110.01363218598249520.02726437196499050.986367814017505
1120.01362275664367580.02724551328735160.986377243356324
1130.01248729596998990.02497459193997980.98751270403001
1140.01914617582040560.03829235164081120.980853824179594
1150.01776171432909890.03552342865819780.982238285670901
1160.0176036460063930.0352072920127860.982396353993607
1170.01436508164379600.02873016328759190.985634918356204
1180.01493331609460580.02986663218921160.985066683905394
1190.01206911619647360.02413823239294720.987930883803526
1200.01101721505049460.02203443010098920.988982784949505
1210.008849279819575040.01769855963915010.991150720180425
1220.01405201699397830.02810403398795660.985947983006022
1230.01204312443743530.02408624887487050.987956875562565
1240.01082304395791380.02164608791582750.989176956042086
1250.009037310821263010.01807462164252600.990962689178737
1260.007284510364863310.01456902072972660.992715489635137
1270.00639914163591080.01279828327182160.99360085836409
1280.005106590993472130.01021318198694430.994893409006528
1290.007833750653358330.01566750130671670.992166249346642
1300.008079630421261350.01615926084252270.991920369578739
1310.01809493309141690.03618986618283370.981905066908583
1320.02036896440071270.04073792880142540.979631035599287
1330.02326176122305140.04652352244610270.976738238776949
1340.02325622382259670.04651244764519350.976743776177403
1350.01903603791347590.03807207582695170.980963962086524
1360.01563724885193670.03127449770387340.984362751148063
1370.01244301443481340.02488602886962680.987556985565187
1380.01657726913473470.03315453826946950.983422730865265
1390.01492406271110170.02984812542220340.985075937288898
1400.01903115525134900.03806231050269790.980968844748651
1410.02611292966167810.05222585932335610.973887070338322
1420.02329661463056040.04659322926112070.97670338536944
1430.01901338794118690.03802677588237370.980986612058813
1440.01807745583239280.03615491166478570.981922544167607
1450.0355026157921140.0710052315842280.964497384207886
1460.03842219667212380.07684439334424760.961577803327876
1470.04319875220066930.08639750440133850.95680124779933
1480.03696458495330850.0739291699066170.963035415046692
1490.03032683018115580.06065366036231170.969673169818844
1500.04572933724844140.09145867449688290.954270662751558
1510.04138110432220660.08276220864441310.958618895677793
1520.0410870915093910.0821741830187820.95891290849061
1530.07170817991153650.1434163598230730.928291820088463
1540.06315971234700180.1263194246940040.936840287652998
1550.07711281200610320.1542256240122060.922887187993897
1560.06481484022680470.1296296804536090.935185159773195
1570.05642129033091110.1128425806618220.943578709669089
1580.04785029547827730.09570059095655470.952149704521723
1590.04545701219412290.09091402438824580.954542987805877
1600.03903553390782290.07807106781564580.960964466092177
1610.0318688113299030.0637376226598060.968131188670097
1620.02618793263043850.05237586526087710.973812067369561
1630.02158134175932780.04316268351865560.978418658240672
1640.01825242230985810.03650484461971620.981747577690142
1650.01613833037455370.03227666074910740.983861669625446
1660.01625166588964480.03250333177928970.983748334110355
1670.01295680055704510.02591360111409020.987043199442955
1680.01847941738628010.03695883477256030.98152058261372
1690.01789425962726920.03578851925453840.98210574037273
1700.01701891816530160.03403783633060320.982981081834698
1710.01656166748192400.03312333496384810.983438332518076
1720.01343604769182140.02687209538364280.986563952308179
1730.01295835550851270.02591671101702540.987041644491487
1740.01387744681416230.02775489362832470.986122553185838
1750.01724076288402770.03448152576805540.982759237115972
1760.01389517376727130.02779034753454260.986104826232729
1770.01105199885551900.02210399771103800.98894800114448
1780.008870743418618270.01774148683723650.991129256581382
1790.006883216021683620.01376643204336720.993116783978316
1800.005774435628497010.01154887125699400.994225564371503
1810.004853935652065480.009707871304130960.995146064347935
1820.003788799163754570.007577598327509140.996211200836245
1830.004241499490367010.008482998980734030.995758500509633
1840.003270547165465220.006541094330930440.996729452834535
1850.07284071054683260.1456814210936650.927159289453167
1860.06383693900914570.1276738780182910.936163060990854
1870.07555137742023540.1511027548404710.924448622579765
1880.06403713870606570.1280742774121310.935962861293934
1890.0536541563999320.1073083127998640.946345843600068
1900.04430833113242790.08861666226485580.955691668867572
1910.03873353446880420.07746706893760830.961266465531196
1920.03248044560637260.06496089121274510.967519554393627
1930.03877701880449930.07755403760899860.96122298119550
1940.04258037207050000.08516074414099990.9574196279295
1950.03554147970651660.07108295941303310.964458520293483
1960.02914301519934010.05828603039868010.97085698480066
1970.03934322123609450.07868644247218890.960656778763906
1980.03217517463612220.06435034927224450.967824825363878
1990.02996916944179330.05993833888358650.970030830558207
2000.02546853602517000.05093707205033990.97453146397483
2010.0242099261925950.048419852385190.975790073807405
2020.02018300708356020.04036601416712050.97981699291644
2030.02552713015082700.05105426030165410.974472869849173
2040.02805986879478570.05611973758957140.971940131205214
2050.03122243404951150.0624448680990230.968777565950488
2060.02457162075482890.04914324150965780.97542837924517
2070.02426991288776360.04853982577552720.975730087112236
2080.01996928815855890.03993857631711780.98003071184144
2090.0216728319632850.043345663926570.978327168036715
2100.01745634679966710.03491269359933420.982543653200333
2110.01892928022771850.03785856045543700.981070719772281
2120.02927031916468960.05854063832937910.97072968083531
2130.02286935442182760.04573870884365520.977130645578172
2140.03302402104082920.06604804208165840.96697597895917
2150.0284568550336940.0569137100673880.971543144966306
2160.02208498411284820.04416996822569640.977915015887152
2170.02435911239073470.04871822478146940.975640887609265
2180.02048958882666260.04097917765332530.979510411173337
2190.01832055050594920.03664110101189830.98167944949405
2200.01375479827737990.02750959655475990.98624520172262
2210.01192723565276560.02385447130553120.988072764347234
2220.008581221005338870.01716244201067770.99141877899466
2230.006346574174097050.01269314834819410.993653425825903
2240.004964716802854890.009929433605709770.995035283197145
2250.004294645822144360.008589291644288720.995705354177856
2260.009946291679482140.01989258335896430.990053708320518
2270.007534383594052540.01506876718810510.992465616405947
2280.005373386330768580.01074677266153720.994626613669231
2290.003807178335165550.00761435667033110.996192821664834
2300.002664712201800940.005329424403601870.9973352877982
2310.002671581709784640.005343163419569290.997328418290215
2320.004943363926681880.009886727853363760.995056636073318
2330.02594673544349790.05189347088699580.974053264556502
2340.03845794067780610.07691588135561220.961542059322194
2350.02771878847402890.05543757694805790.97228121152597
2360.02396181394727590.04792362789455190.976038186052724
2370.1877711753584500.3755423507168990.812228824641550
2380.1470448611769030.2940897223538050.852955138823097
2390.1302161662453900.2604323324907810.86978383375461
2400.09886843392331150.1977368678466230.901131566076689
2410.07660014168752230.1532002833750450.923399858312478
2420.06146341784320180.1229268356864040.938536582156798
2430.05620977614701910.1124195522940380.94379022385298
2440.1035626757643380.2071253515286760.896437324235662
2450.09078377267345660.1815675453469130.909216227326543
2460.06963829302173110.1392765860434620.930361706978269
2470.04652964356737610.09305928713475210.953470356432624
2480.03780599987857170.07561199975714340.962194000121428
2490.03407474496554950.0681494899310990.96592525503445
2500.04144886906803740.08289773813607480.958551130931963
2510.02182244785967240.04364489571934480.978177552140328
2520.05474267636533120.1094853527306620.945257323634669


Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity
Description# significant tests% significant testsOK/NOK
1% type I error level100.0414937759336100NOK
5% type I error level850.352697095435685NOK
10% type I error level1330.551867219917012NOK
 
Charts produced by software:
http://www.freestatistics.org/blog/date/2010/Nov/17/t12899849862wg0yilynfjlce6/104hd41289984662.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/17/t12899849862wg0yilynfjlce6/104hd41289984662.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/17/t12899849862wg0yilynfjlce6/1xggs1289984662.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/17/t12899849862wg0yilynfjlce6/1xggs1289984662.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/17/t12899849862wg0yilynfjlce6/2qqfd1289984662.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/17/t12899849862wg0yilynfjlce6/2qqfd1289984662.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/17/t12899849862wg0yilynfjlce6/3qqfd1289984662.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/17/t12899849862wg0yilynfjlce6/3qqfd1289984662.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/17/t12899849862wg0yilynfjlce6/4qqfd1289984662.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/17/t12899849862wg0yilynfjlce6/4qqfd1289984662.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/17/t12899849862wg0yilynfjlce6/5qqfd1289984662.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/17/t12899849862wg0yilynfjlce6/5qqfd1289984662.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/17/t12899849862wg0yilynfjlce6/6izfg1289984662.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/17/t12899849862wg0yilynfjlce6/6izfg1289984662.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/17/t12899849862wg0yilynfjlce6/7tqe11289984662.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/17/t12899849862wg0yilynfjlce6/7tqe11289984662.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/17/t12899849862wg0yilynfjlce6/8tqe11289984662.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/17/t12899849862wg0yilynfjlce6/8tqe11289984662.ps (open in new window)


http://www.freestatistics.org/blog/date/2010/Nov/17/t12899849862wg0yilynfjlce6/94hd41289984662.png (open in new window)
http://www.freestatistics.org/blog/date/2010/Nov/17/t12899849862wg0yilynfjlce6/94hd41289984662.ps (open in new window)


 
Parameters (Session):
par1 = 4 ; par2 = Do not include Seasonal Dummies ; par3 = No Linear Trend ;
 
Parameters (R input):
par1 = 4 ; par2 = Do not include Seasonal Dummies ; par3 = No Linear Trend ;
 
R code (references can be found in the software module):
library(lattice)
library(lmtest)
n25 <- 25 #minimum number of obs. for Goldfeld-Quandt test
par1 <- as.numeric(par1)
x <- t(y)
k <- length(x[1,])
n <- length(x[,1])
x1 <- cbind(x[,par1], x[,1:k!=par1])
mycolnames <- c(colnames(x)[par1], colnames(x)[1:k!=par1])
colnames(x1) <- mycolnames #colnames(x)[par1]
x <- x1
if (par3 == 'First Differences'){
x2 <- array(0, dim=c(n-1,k), dimnames=list(1:(n-1), paste('(1-B)',colnames(x),sep='')))
for (i in 1:n-1) {
for (j in 1:k) {
x2[i,j] <- x[i+1,j] - x[i,j]
}
}
x <- x2
}
if (par2 == 'Include Monthly Dummies'){
x2 <- array(0, dim=c(n,11), dimnames=list(1:n, paste('M', seq(1:11), sep ='')))
for (i in 1:11){
x2[seq(i,n,12),i] <- 1
}
x <- cbind(x, x2)
}
if (par2 == 'Include Quarterly Dummies'){
x2 <- array(0, dim=c(n,3), dimnames=list(1:n, paste('Q', seq(1:3), sep ='')))
for (i in 1:3){
x2[seq(i,n,4),i] <- 1
}
x <- cbind(x, x2)
}
k <- length(x[1,])
if (par3 == 'Linear Trend'){
x <- cbind(x, c(1:n))
colnames(x)[k+1] <- 't'
}
x
k <- length(x[1,])
df <- as.data.frame(x)
(mylm <- lm(df))
(mysum <- summary(mylm))
if (n > n25) {
kp3 <- k + 3
nmkm3 <- n - k - 3
gqarr <- array(NA, dim=c(nmkm3-kp3+1,3))
numgqtests <- 0
numsignificant1 <- 0
numsignificant5 <- 0
numsignificant10 <- 0
for (mypoint in kp3:nmkm3) {
j <- 0
numgqtests <- numgqtests + 1
for (myalt in c('greater', 'two.sided', 'less')) {
j <- j + 1
gqarr[mypoint-kp3+1,j] <- gqtest(mylm, point=mypoint, alternative=myalt)$p.value
}
if (gqarr[mypoint-kp3+1,2] < 0.01) numsignificant1 <- numsignificant1 + 1
if (gqarr[mypoint-kp3+1,2] < 0.05) numsignificant5 <- numsignificant5 + 1
if (gqarr[mypoint-kp3+1,2] < 0.10) numsignificant10 <- numsignificant10 + 1
}
gqarr
}
bitmap(file='test0.png')
plot(x[,1], type='l', main='Actuals and Interpolation', ylab='value of Actuals and Interpolation (dots)', xlab='time or index')
points(x[,1]-mysum$resid)
grid()
dev.off()
bitmap(file='test1.png')
plot(mysum$resid, type='b', pch=19, main='Residuals', ylab='value of Residuals', xlab='time or index')
grid()
dev.off()
bitmap(file='test2.png')
hist(mysum$resid, main='Residual Histogram', xlab='values of Residuals')
grid()
dev.off()
bitmap(file='test3.png')
densityplot(~mysum$resid,col='black',main='Residual Density Plot', xlab='values of Residuals')
dev.off()
bitmap(file='test4.png')
qqnorm(mysum$resid, main='Residual Normal Q-Q Plot')
qqline(mysum$resid)
grid()
dev.off()
(myerror <- as.ts(mysum$resid))
bitmap(file='test5.png')
dum <- cbind(lag(myerror,k=1),myerror)
dum
dum1 <- dum[2:length(myerror),]
dum1
z <- as.data.frame(dum1)
z
plot(z,main=paste('Residual Lag plot, lowess, and regression line'), ylab='values of Residuals', xlab='lagged values of Residuals')
lines(lowess(z))
abline(lm(z))
grid()
dev.off()
bitmap(file='test6.png')
acf(mysum$resid, lag.max=length(mysum$resid)/2, main='Residual Autocorrelation Function')
grid()
dev.off()
bitmap(file='test7.png')
pacf(mysum$resid, lag.max=length(mysum$resid)/2, main='Residual Partial Autocorrelation Function')
grid()
dev.off()
bitmap(file='test8.png')
opar <- par(mfrow = c(2,2), oma = c(0, 0, 1.1, 0))
plot(mylm, las = 1, sub='Residual Diagnostics')
par(opar)
dev.off()
if (n > n25) {
bitmap(file='test9.png')
plot(kp3:nmkm3,gqarr[,2], main='Goldfeld-Quandt test',ylab='2-sided p-value',xlab='breakpoint')
grid()
dev.off()
}
load(file='createtable')
a<-table.start()
a<-table.row.start(a)
a<-table.element(a, 'Multiple Linear Regression - Estimated Regression Equation', 1, TRUE)
a<-table.row.end(a)
myeq <- colnames(x)[1]
myeq <- paste(myeq, '[t] = ', sep='')
for (i in 1:k){
if (mysum$coefficients[i,1] > 0) myeq <- paste(myeq, '+', '')
myeq <- paste(myeq, mysum$coefficients[i,1], sep=' ')
if (rownames(mysum$coefficients)[i] != '(Intercept)') {
myeq <- paste(myeq, rownames(mysum$coefficients)[i], sep='')
if (rownames(mysum$coefficients)[i] != 't') myeq <- paste(myeq, '[t]', sep='')
}
}
myeq <- paste(myeq, ' + e[t]')
a<-table.row.start(a)
a<-table.element(a, myeq)
a<-table.row.end(a)
a<-table.end(a)
table.save(a,file='mytable1.tab')
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,hyperlink('http://www.xycoon.com/ols1.htm','Multiple Linear Regression - Ordinary Least Squares',''), 6, TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'Variable',header=TRUE)
a<-table.element(a,'Parameter',header=TRUE)
a<-table.element(a,'S.D.',header=TRUE)
a<-table.element(a,'T-STAT<br />H0: parameter = 0',header=TRUE)
a<-table.element(a,'2-tail p-value',header=TRUE)
a<-table.element(a,'1-tail p-value',header=TRUE)
a<-table.row.end(a)
for (i in 1:k){
a<-table.row.start(a)
a<-table.element(a,rownames(mysum$coefficients)[i],header=TRUE)
a<-table.element(a,mysum$coefficients[i,1])
a<-table.element(a, round(mysum$coefficients[i,2],6))
a<-table.element(a, round(mysum$coefficients[i,3],4))
a<-table.element(a, round(mysum$coefficients[i,4],6))
a<-table.element(a, round(mysum$coefficients[i,4]/2,6))
a<-table.row.end(a)
}
a<-table.end(a)
table.save(a,file='mytable2.tab')
a<-table.start()
a<-table.row.start(a)
a<-table.element(a, 'Multiple Linear Regression - Regression Statistics', 2, TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'Multiple R',1,TRUE)
a<-table.element(a, sqrt(mysum$r.squared))
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'R-squared',1,TRUE)
a<-table.element(a, mysum$r.squared)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'Adjusted R-squared',1,TRUE)
a<-table.element(a, mysum$adj.r.squared)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'F-TEST (value)',1,TRUE)
a<-table.element(a, mysum$fstatistic[1])
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'F-TEST (DF numerator)',1,TRUE)
a<-table.element(a, mysum$fstatistic[2])
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'F-TEST (DF denominator)',1,TRUE)
a<-table.element(a, mysum$fstatistic[3])
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'p-value',1,TRUE)
a<-table.element(a, 1-pf(mysum$fstatistic[1],mysum$fstatistic[2],mysum$fstatistic[3]))
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'Multiple Linear Regression - Residual Statistics', 2, TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'Residual Standard Deviation',1,TRUE)
a<-table.element(a, mysum$sigma)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'Sum Squared Residuals',1,TRUE)
a<-table.element(a, sum(myerror*myerror))
a<-table.row.end(a)
a<-table.end(a)
table.save(a,file='mytable3.tab')
a<-table.start()
a<-table.row.start(a)
a<-table.element(a, 'Multiple Linear Regression - Actuals, Interpolation, and Residuals', 4, TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a, 'Time or Index', 1, TRUE)
a<-table.element(a, 'Actuals', 1, TRUE)
a<-table.element(a, 'Interpolation<br />Forecast', 1, TRUE)
a<-table.element(a, 'Residuals<br />Prediction Error', 1, TRUE)
a<-table.row.end(a)
for (i in 1:n) {
a<-table.row.start(a)
a<-table.element(a,i, 1, TRUE)
a<-table.element(a,x[i])
a<-table.element(a,x[i]-mysum$resid[i])
a<-table.element(a,mysum$resid[i])
a<-table.row.end(a)
}
a<-table.end(a)
table.save(a,file='mytable4.tab')
if (n > n25) {
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,'Goldfeld-Quandt test for Heteroskedasticity',4,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'p-values',header=TRUE)
a<-table.element(a,'Alternative Hypothesis',3,header=TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'breakpoint index',header=TRUE)
a<-table.element(a,'greater',header=TRUE)
a<-table.element(a,'2-sided',header=TRUE)
a<-table.element(a,'less',header=TRUE)
a<-table.row.end(a)
for (mypoint in kp3:nmkm3) {
a<-table.row.start(a)
a<-table.element(a,mypoint,header=TRUE)
a<-table.element(a,gqarr[mypoint-kp3+1,1])
a<-table.element(a,gqarr[mypoint-kp3+1,2])
a<-table.element(a,gqarr[mypoint-kp3+1,3])
a<-table.row.end(a)
}
a<-table.end(a)
table.save(a,file='mytable5.tab')
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,'Meta Analysis of Goldfeld-Quandt test for Heteroskedasticity',4,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'Description',header=TRUE)
a<-table.element(a,'# significant tests',header=TRUE)
a<-table.element(a,'% significant tests',header=TRUE)
a<-table.element(a,'OK/NOK',header=TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'1% type I error level',header=TRUE)
a<-table.element(a,numsignificant1)
a<-table.element(a,numsignificant1/numgqtests)
if (numsignificant1/numgqtests < 0.01) dum <- 'OK' else dum <- 'NOK'
a<-table.element(a,dum)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'5% type I error level',header=TRUE)
a<-table.element(a,numsignificant5)
a<-table.element(a,numsignificant5/numgqtests)
if (numsignificant5/numgqtests < 0.05) dum <- 'OK' else dum <- 'NOK'
a<-table.element(a,dum)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'10% type I error level',header=TRUE)
a<-table.element(a,numsignificant10)
a<-table.element(a,numsignificant10/numgqtests)
if (numsignificant10/numgqtests < 0.1) dum <- 'OK' else dum <- 'NOK'
a<-table.element(a,dum)
a<-table.row.end(a)
a<-table.end(a)
table.save(a,file='mytable6.tab')
}
 





Copyright

Creative Commons License

This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 License.

Software written by Ed van Stee & Patrick Wessa


Disclaimer

Information provided on this web site is provided "AS IS" without warranty of any kind, either express or implied, including, without limitation, warranties of merchantability, fitness for a particular purpose, and noninfringement. We use reasonable efforts to include accurate and timely information and periodically update the information, and software without notice. However, we make no warranties or representations as to the accuracy or completeness of such information (or software), and we assume no liability or responsibility for errors or omissions in the content of this web site, or any software bugs in online applications. Your use of this web site is AT YOUR OWN RISK. Under no circumstances and under no legal theory shall we be liable to you or any other person for any direct, indirect, special, incidental, exemplary, or consequential damages arising from your access to, or use of, this web site.


Privacy Policy

We may request personal information to be submitted to our servers in order to be able to:

  • personalize online software applications according to your needs
  • enforce strict security rules with respect to the data that you upload (e.g. statistical data)
  • manage user sessions of online applications
  • alert you about important changes or upgrades in resources or applications

We NEVER allow other companies to directly offer registered users information about their products and services. Banner references and hyperlinks of third parties NEVER contain any personal data of the visitor.

We do NOT sell, nor transmit by any means, personal information, nor statistical data series uploaded by you to third parties.

We carefully protect your data from loss, misuse, alteration, and destruction. However, at any time, and under any circumstance you are solely responsible for managing your passwords, and keeping them secret.

We store a unique ANONYMOUS USER ID in the form of a small 'Cookie' on your computer. This allows us to track your progress when using this website which is necessary to create state-dependent features. The cookie is used for NO OTHER PURPOSE. At any time you may opt to disallow cookies from this website - this will not affect other features of this website.

We examine cookies that are used by third-parties (banner and online ads) very closely: abuse from third-parties automatically results in termination of the advertising contract without refund. We have very good reason to believe that the cookies that are produced by third parties (banner ads) do NOT cause any privacy or security risk.

FreeStatistics.org is safe. There is no need to download any software to use the applications and services contained in this website. Hence, your system's security is not compromised by their use, and your personal data - other than data you submit in the account application form, and the user-agent information that is transmitted by your browser - is never transmitted to our servers.

As a general rule, we do not log on-line behavior of individuals (other than normal logging of webserver 'hits'). However, in cases of abuse, hacking, unauthorized access, Denial of Service attacks, illegal copying, hotlinking, non-compliance with international webstandards (such as robots.txt), or any other harmful behavior, our system engineers are empowered to log, track, identify, publish, and ban misbehaving individuals - even if this leads to ban entire blocks of IP addresses, or disclosing user's identity.


FreeStatistics.org is powered by