Check variable summaries Row LabelsAverage of Check variable StdDev of Check variable Count of Check variable cim01189 XXXXXXXXXX XXXXXXXXXX1000 cim5008 XXXXXXXXXX XXXXXXXXXX1000 cim5020 XXXXXXXXXX...

https://www.youtube.com/watch?v=6ih1q7xGbh0&authuser=0


Check variable summaries Row LabelsAverage of Check variable StdDev of Check variable Count of Check variable cim0118952004.83738342892.87746956551000 cim50082005.03764781262.96842073171000 cim502012004.96791156612.93147361721000 cim505937004.89738713973.02410784131000 cim506339004.96709824892.84376753121000 cim506549005.04101915472.95293031311000 cim507236004.93554185042.90232912241000 cim509843005.05231272982.94373877421000 cim513556004.80277569622.89235336591000 cim514258004.86661378152.83987045141000 cim515233004.98758570492.89222499631000 cim520950004.95363309792.87004947021000 cim524723004.92527253072.80695160361000 cim52675004.97424835372.89386084241000 cim530513004.95786147862.92086721771000 cim530651005.00150860972.88866904681000 cim531231004.88066746992.85858245241000 cim534222004.95634198322.97131276531000 cim535125004.96726104212.89005475791000 cim537848005.0914512342.78954036391000 cim537957004.9720936772.8821144891000 cim53814005.01667427882.96532784681000 cim539019005.09762318392.95241410321000 cim539138005.12958743322.91269852031000 cim53923005.08258835442.88426856661000 cim540117005.035060642.9115941961000 cim541045004.72047459912.83769496561000 cim541742004.92752043562.85925893211000 cim544715005.02213044452.91716222171000 cim545360005.09050909172.93853218411000 cim545818005.00851607912.89457117721000 cim54648005.0521745032.8780974151000 cim546955005.04895135482.84242539331000 cim547429004.74362192772.87330408411000 cim547653005.00575721122.91163900651000 cim548044004.96802168982.85532864681000 cim549241005.04727380742.86807646021000 cim549414005.05717216752.84503823491000 cim549930004.79375029112.877573371000 cim550616004.89334835362.88378749621000 cim550947005.02186871762.84892826711000 cim552126005.01497317022.85322588981000 cim553827004.96043698932.88745048951000 cim554154004.96156315032.87874307181000 cim554435004.84859120092.8422165461000 cim555910005.00151976012.8640875471000 cim556421005.00842912632.80384120931000 cim557246005.09909960412.87333999781000 cim55867004.93777443312.88466154921000 cim55899004.91277939332.9073534281000 cim559128005.12320456452.89054047591000 cim55966004.97145193272.84191014181000 cim559724005.09549978172.90901442981000 cim560634004.93220760632.98185743271000 cim560832004.91708316132.85010350851000 cim560911005.14727048042.78624372581000 cim561040005.10674469762.83463110871000 cim562220004.99663580862.93304018621000 cim562359005.04302449882.90473532221000 Not your ID 1 1004.99713517962.91406603821000 Not your ID 1069004.83428049292.88815784081000 Not your ID 1170005.03902006052.77861145521000 Not your ID 1271005.06361374632.98021057861000 Not your ID 1372004.97986587452.84838993811000 Not your ID 1473005.05437435222.80774870471000 Not your ID 1574005.0724635952.88541243181000 Not your ID 1675005.04902835762.87775941881000 Not your ID 1776004.97549691852.9230462661000 Not your ID 1877004.94209909562.90593061071000 Not your ID 1978005.02391306692.86268125491000 Not your ID 261005.0690822212.91037401681000 Not your ID 2079005.00285649422.90797281891000 Not your ID 2180005.01501522892.86793807791000 Not your ID 2281005.06178314572.93247922331000 Not your ID 2382004.91844606022.84121061371000 Not your ID 2483005.11153029812.92808555431000 Not your ID 2584004.92729579942.83947431261000 Not your ID 2685005.01347746652.89735975011000 Not your ID 2786004.85151220642.82764887091000 Not your ID 2887004.93089155682.86723839561000 Not your ID 2988005.00925147212.86125044991000 Not your ID 362004.84428919122.78767483651000 Not your ID 3089005.06279734662.92065900081000 Not your ID 3190005.1007910312.90697341571000 Not your ID 3291004.95689788892.88353019531000 Not your ID 3392005.03910218192.8376845881000 Not your ID 3493005.17730882192.8820790451000 Not your ID 3594004.94655544912.87911903811000 Not your ID 3695005.07286051642.89733343361000 Not your ID 3796005.07881388082.93393576491000 Not your ID 3897005.01377513832.94609510221000 Not your ID 3998004.87630691322.98911456781000 Not your ID 463004.99587030912.95287295981000 Not your ID 4099004.87654126222.9299985551000 Not your ID 41100004.9864140672.90685285891000 Not your ID 564004.99829656762.88176214981000 Not your ID 665004.98548150322.89381059591000 Not your ID 766004.95662883132.94140191141000 Not your ID 867004.86656681062.90887946531000 Not your ID 968004.90956667782.83894787811000 Grand Total50504.98601827628866.2163509137100000 Dataset Select your student number using the filter and paste you dataset into a new variable, to check you have done this properly use the check variable summary instructions are available from Dataset 1 ( 1000 rows) Dataset 2( 500 rows) Dataset 3 (100 rows) Student ID Sample Sample rowCheck variable _Drugs Present? Test result ?_Drugs Present? Test result ?_Location ?Number of tests ?Number of positive results ? Not your ID 1 sample 1sample row 11004.7769672157absentnegativeabsentnegativeDarwin15022 Not your ID 1 sample 1sample row 21009.5400925215absentnegativeabsentnegativeDarwin18543Which sample student ID Not your ID 1 sample 1sample row 31003.9912024892presentpositiveabsentnegativeDarwin125341Not your ID 1 Not your ID 1 sample 1sample row 41000.8651933027absentnegativeabsentnegativeDarwin141302cim5008 Not your ID 1 sample 1sample row 51009.749009743presentpositiveabsentnegativeDarwin156403cim5392 Not your ID 1 sample 1sample row 61003.0091148932absentnegativeabsentnegativeDarwin199444cim5381 Not your ID 1 sample 1sample row 71007.8815789565absentnegativeabsentnegativeDarwin105215cim5267 Not your ID 1 sample 1sample row 81007.3223627267absentnegativeabsentnegativeDarwin146316cim5596 Not your ID 1 sample 1sample row 91000.3797255058absentnegativeabsentnegativeDarwin163277cim5586 Not your ID 1 sample 1sample row 101002.137154713absentnegativeabsentnegativeDarwin131198cim5464 Not your ID 1 sample 1sample row 111000.4955597023absentnegativeabsentnegativeDarwin171379cim5589 Not your ID 1 sample 1sample row 121009.5570948722absentnegativeabsentnegativeDarwin1282510cim5559 Not your ID 1 sample 1sample row 131003.2651231743absentnegativeabsentnegativeDarwin1173111cim5609 Not your ID 1 sample 1sample row 141006.343691509absentnegativeabsentnegativeDarwin1223412cim5020 Not your ID 1 sample 1sample row 151008.9263550349absentnegativeabsentnegativeDarwin1213313cim5305 Not your ID 1 sample 1sample row 161009.8112929155absentnegativeabsentnegativeDarwin1413214cim5494 Not your ID 1 sample 1sample row 171005.8499363513absentnegativeabsentnegativeDarwin1282315cim5447 Not your ID 1 sample 1sample row 181009.5806436222absentnegativepresentpositiveDarwin1963416cim5506 Not your ID 1 sample 1sample row 191005.919484644presentpositiveabsentnegativeDarwin1292117cim5401 Not your ID 1 sample 1sample row 201005.1002661694absentnegativeabsentnegativeDarwin1263418cim5458 Not your ID 1 sample 1sample row 211001.1416619888absentnegativepresentpositiveDarwin1963819cim5390 Not your ID 1 sample 1sample row 221002.7957992866absentnegativeabsentnegativeDarwin1232220cim5622 Not your ID 1 sample 1sample row 231000.0769311999presentpositivepresentpositiveDarwin1572421cim5564 Not your ID 1 sample 1sample row 241008.2419494274presentpositivepresentpositiveDarwin1051822cim5342 Not your ID 1 sample 1sample row 251002.093146451absentnegativepresentpositiveDarwin1873623cim5247 Not your ID 1 sample 1sample row 261003.0089289958absentnegativeabsentnegativeDarwin1483924cim5597 Not your ID 1 sample 1sample row 271004.7580725718absentnegativeabsentnegativeDarwin1734525cim5351 Not your ID 1 sample 1sample row 281003.438342253absentnegativeabsentnegativeDarwin1413426cim5521 Not your ID 1 sample 1sample row 291002.680713574presentpositivepresentpositiveDarwin1032727cim5538 Not your ID 1 sample 1sample row 301008.1256975923absentnegativeabsentnegativeDarwin1983828cim5591 Not your ID 1 sample 1sample row 311004.9131702858absentnegativeabsentnegativeDarwin1111329cim5474 Not your ID 1 sample 1sample row 321005.8129808782absentnegativeabsentnegativeDarwin1944730cim5499 Not your ID 1 sample 1sample row 331000.5993535712presentpositiveabsentnegativeDarwin1502831cim5312 Not your ID 1 sample 1sample row 341001.9349135828absentnegativeabsentnegativeDarwin1352732cim5608 Not your ID 1 sample 1sample row 351006.4341193549absentnegativeabsentnegativeDarwin1473133cim5152 Not your ID 1 sample 1sample row 361005.1852278973absentnegativeabsentnegativeDarwin1461934cim5606 Not your ID 1 sample 1sample row 371004.4992508441absentnegativeabsentnegativeDarwin1733735cim5544 Not your ID 1 sample 1sample row 381008.8396314027absentnegativeabsentnegativeDarwin1393436cim5072 Not your ID 1 sample 1sample row 391006.7971797194absentnegativepresentpositiveDarwin1772637cim5059 Not your ID 1 sample 1sample row 401001.6634385371absentnegativeabsentnegativeDarwin1653138cim5391 Not your ID 1 sample 1sample row 411000.0773248404absentnegativeabsentnegativeDarwin1864039cim5063 Not your ID 1 sample 1sample row 421006.1142955562presentpositiveabsentnegativeDarwin2003640cim5610 Not your ID 1 sample 1sample row 431007.1137822647presentpositiveabsentnegativeDarwin1553141cim5492 Not your ID 1 sample 1sample row 441000.1100050964presentpositivepresentpositiveDarwin1442142cim5417 Not your ID 1 sample 1sample row 451000.0323196345presentpositiveabsentnegativeDarwin1233243cim5098 Not your ID 1 sample 1sample row 461008.8591663284absentnegativeabsentnegativeDarwin1613044cim5480 Not your ID 1 sample 1sample row 471006.1904818899absentnegativeabsentnegativeDarwin1413445cim5410 Not your ID 1 sample 1sample row 481009.7963340056absentnegativeabsentnegativeSydney83517346cim5572 Not your ID 1 sample 1sample row 491005.9290525602absentnegativeabsentnegativeSydney77115847cim5509 Not your ID 1 sample 1sample row 501004.2558588908absentnegativeabsentnegativeSydney50710048cim5378 Not your ID 1 sample 1sample row 511002.9422108561absentnegativeabsentnegativeSydney54511549cim5065 Not your ID 1 sample 1sample row 521007.5135618145presentpositiveabsentnegativeSydney93118450cim5209 Not your ID 1 sample 1sample row 531000.926780832presentpositiveabsentnegativeSydney98420751cim5306 Not your ID 1 sample 1sample row 541005.2630239731absentnegativepresentpositiveSydney57311852cim01189 Not your ID 1 sample 1sample row 551006.7599961536absentnegativeabsentnegativeSydney88317853cim5476 Not your ID 1 sample 1sample row 561006.7300115361absentnegativeabsentnegativeSydney71213754cim5541 Not your ID 1 sample 1sample row 571003.746234097absentnegativeabsentnegativeSydney59611655cim5469 Not your ID 1 sample 1sample row 581009.4084200202absentnegativeabsentnegativeSydney64113156cim5135 Not your ID 1 sample 1sample row 591006.9174625441absentnegativeabsentnegativeSydney53010957cim5379 Not your ID 1 sample 1sample row 601006.7784622033absentnegativeabsentnegativeSydney801058cim5142 Not your ID 1 sample 1sample row 611002.9912839561absentnegativepresentpositiveSydney87818559cim5623 Not your ID 1 sample 1sample row 621003.8706698001absentnegativeabsentnegativeSydney58811960cim5453 Not your ID 1 sample 1sample row 631000.1436883948presentpositiveabsentnegativeSydney83017561Not your ID 2 Not your ID 1 sample 1sample row 641000.9086572984absentnegativepresentpositiveSydney69714962Not your ID 3 Not your ID 1 sample 1sample row 651002.0121742072presentpositiveabsentnegativeSydney53710563Not your ID 4 Not your ID 1 sample 1sample row 661009.390722728presentpositiveabsentnegativeSydney65613964Not your ID 5 Not your ID 1 sample 1sample row 671009.9080532372presentpositiveabsentnegativeSydney54011765Not your ID 6 Not your ID 1 sample 1sample row 681002.2283201682absentnegativepresentpositiveSydney56511666Not your ID 7 Not your ID 1 sample 1sample row 691007.5737049688absentnegativeabsentnegativeSydney52311367Not your ID 8 Not your ID 1 sample 1sample row 701001.2835274542absentnegativeabsentnegativeSydney77715768Not your ID 9 Not your ID 1 sample 1sample row 711000.3898931852absentnegativeabsentnegativeSydney93818369Not your ID 10 Not your ID 1 sample 1sample row 721005.1172524032absentnegativeabsentnegativeSydney58311370Not your ID 11 Not your ID 1 sample 1sample row 731007.4345467689absentnegativepresentpositiveSydney83117271Not your ID 12 Not your ID 1 sample 1sample row 741002.2600742003absentnegativeabsentnegativeSydney75514772Not your ID 13 Not your ID 1 sample 1sample row 751002.9064714125absentnegativeabsentnegativeSydney78916073Not your ID 14 Not your ID 1 sample 1sample row 761000.0076340513absentnegativeabsentnegativeSydney88117974Not your ID 15 Not your ID 1 sample 1sample row 771007.1198351118absentnegativeabsentnegativeSydney91217475Not your ID 16 Not your ID 1 sample 1sample row 781006.4713774589absentnegativeabsentnegativeSydney66013176Not your ID 17 Not your ID 1 sample 1sample row 791005.786309934absentnegativeabsentnegativeSydney63612777Not your ID 18 Not your ID 1 sample 1sample row 801005.0731448415absentnegativepresentpositiveSydney76715178Not your ID 19 Not your ID 1 sample 1sample row 811007.4708411827absentnegativeabsentnegativeSydney61112579Not your ID 20 Not your ID 1 sample 1sample row 821003.9066707951presentpositiveabsentnegativeSydney67213480Not your ID 21 Not your ID 1 sample 1sample row 831008.0407438834absentnegativeabsentnegativeSydney50311081Not your ID 22 Not your ID 1 sample 1sample row 841008.8511018493presentpositiveabsentnegativeSydney85916582Not your ID 23 Not your ID 1 sample 1sample row 851008.6905915653absentnegativeabsentnegativeSydney87316783Not your ID 24 Not your ID 1 sample 1sample row 861006.5738305815absentnegativepresentpositiveSydney5049984Not your ID 25 Not your ID 1 sample 1sample row 871003.9646507336absentnegativeabsentnegativeSydney64113285Not your ID 26 Not your ID 1 sample 1sample row 881009.067189684absentnegativeabsentnegativeSydney53611386Not your ID 27 Not your ID 1 sample 1sample row 891001.6510929713absentnegativeabsentnegativeSydney69814587Not your ID 28 Not your ID 1 sample 1sample row 901000.0619732063absentnegativepresentpositiveSydney62912888Not your ID 29 Not your ID 1 sample 1sample row 911006.189674743absentnegativeabsentnegativeSydney87017989Not your ID 30 Not your ID 1 sample 1sample row 921007.3682145067presentpositiveabsentnegativeSydney94418190Not your ID 31 Not your ID 1 sample 1sample row 931005.2130523545absentnegativepresentpositiveSydney65313791Not your ID 32 Not your ID 1 sample 1sample row 941005.5306616605presentpositiveabsentpositiveSydney97919892Not your ID 33 Not your ID 1 sample 1sample row 951002.2393576956absentnegativeabsentpositiveSydney81917393Not your ID 34 Not your ID 1 sample 1sample row 961006.9346018051presentpositiveabsentnegativeSydney80616894Not your ID 35 Not your ID 1 sample 1sample row 971008.8027409149absentnegativeabsentnegativeSydney72713895Not your ID 36 Not your ID 1 sample 1sample row 981004.5100449521presentpositiveabsentnegativeSydney86918296Not your ID 37 Not your ID 1 sample 1sample row 991002.0074942659absentnegativeabsentnegativeSydney93018597Not your ID 38 Not your ID 1 sample 1sample row 1001008.4533559933absentnegativeabsentnegativeSydney97418698Not your ID 39 Not your ID 1 sample 1sample row 1011001.5460950461absentnegativeabsentnegative99Not your ID 40 Not your ID 1 sample 1sample row 1021003.1742867956absentnegativeabsentnegative100Not your ID 41 Not your ID 1 sample 1sample row 1031003.5332904648absentnegativepresentpositive101Not your ID 42 Not your ID 1 sample 1sample row 1041007.0006484173absentnegativeabsentpositive102Not your ID 43 Not your ID 1 sample 1sample row 1051009.5291051319presentpositiveabsentnegative103Not your ID 44 Not your ID 1 sample 1sample row 1061000.2426985517absentnegativeabsentnegative104Not your ID 45 Not your ID 1 sample 1sample row 1071001.6748837702absentnegativeabsentnegative105Not your ID 46 Not your ID 1 sample 1sample row 1081008.4887402329absentnegativeabsentnegative106Not your ID 47 Not your ID 1 sample 1sample row 1091003.7918263796absentnegativeabsentpositive107Not your ID 48 Not your ID 1 sample 1sample row 1101005.3023843321absentnegativeabsentnegative108Not your ID 49 Not your ID 1 sample 1sample row 1111002.2617990734absentnegativepresentpositive109Not your ID 50 Not your ID 1 sample 1sample row 1121001.6857299403absentnegativepresentpositive110Not your ID 51 Not your ID 1 sample 1sample row 1131008.4519518945absentnegativeabsentnegative111Not your ID 52 Not your ID 1 sample 1sample row 1141009.5021171127absentnegativeabsentnegative112Not your ID 53 Not your ID 1 sample 1sample row 1151007.0442876668absentnegativeabsentnegative113Not your ID 54 Not your ID 1 sample 1sample row 1161000.7571733005presentpositiveabsentnegative114Not your ID 55 Not your ID 1 sample 1sample row 1171003.5424537663presentpositiveabsentnegative115Not your ID 56 Not your ID 1 sample 1sample row 1181003.0090633307absentnegativeabsentnegative116Not your ID 57 Not your ID 1 sample 1sample row 1191001.2192569902absentnegativeabsentnegative117Not your ID 58 Not your ID 1 sample 1sample row 1201004.0796285103absentnegativeabsentnegative118Not your ID 59 Not your ID 1 sample 1sample row 1211005.5900220338absentnegativepresentpositive119Not your ID 60 Not your ID 1 sample 1sample row 1221003.2489430188absentnegativeabsentnegative120Not your ID 61 Not your ID 1 sample 1sample row 1231008.778443761absentnegativeabsentnegative121Not your ID 62 Not your ID 1 sample 1sample row 1241009.2083173458absentnegativepresentpositive122Not your ID 63 Not your ID 1 sample 1sample row 1251009.1979079149absentnegativeabsentnegative123Not your ID 64 Not your ID 1 sample 1sample row 1261009.9024321333absentnegativeabsentnegative124Not your ID 65 Not your ID 1 sample 1sample row 1271006.7932960673presentpositivepresentpositive125Not your ID 66 Not your ID 1 sample 1sample row