Output close all. Dataset close all. GET DATA /TYPE=XLS /FILE='D:\Jobs\6217-SamKnowns\Tabulation\New Data\MARCH_ALLOCATIONS_Hansa_V3.xls' /SHEET=name 'All Units' /CELLRANGE=full /READNAMES=on /ASSUMEDSTRWIDTH=32767. /* Drop ISP=15 Wireless select if ISP<>15. exec. SORT CASES BY UNIT_ID (A). Formats Download upload (F8.3). /* Split Verizon to DSL-FIBER IF ISP=14 and TECHNOLOGY=3 ISP=15. exec. Value Labels ISP 1 'AT&T' 2 'Cablevision' 3 'CenturyLink' 4 'Charter' 5 'Clearwire' 6 'Comcast' 7 'Cox' 8 'Frontier' 9 'Hughes' 10 'Insight' 11 'Mediacom' 12 'Qwest' 13 'TimeWarner' 14 'Verizon (DSL)' 15 'Verizon (Fiber)' 16 'Windstream' 17 'Brighthouse' . Value Labels TECHNOLOGY 1 'CABLE' 2 'DSL' 3 'FIBRE' 4 'SAT'/ VALIDATEDBY 1 'ISP' 2 'SK' 3 'ISP/SK'/ State 1 'AK' 2 'AL' 3 'AR' 4 'AZ' 5 'CA' 6 'CO' 7 'CT' 8 'DC' 9 'DE' 10 'FL' 11 'GA' 12 'HI' 13 'IA' 14 'ID' 15 'IL' 16 'IN' 17 'KS' 18 'KY' 19 'LA' 20 'MA' 21 'MD' 22 'ME' 23 'MI' 24 'MN' 25 'MO' 26 'MS' 27 'MT' 28 'NC' 29 'ND' 30 'NE' 31 'NH' 32 'NJ' 33 'NM' 34 'NV' 35 'NY' 36 'OH' 37 'OK' 38 'OR' 39 'PA' 40 'RI' 41 'SC' 42 'SD' 43 'TN' 44 'TX' 45 'UT' 46 'VA' 47 'VT' 48 'WA' 49 'WI' 50 'WV' 51 'WY'/ Region 1 'NORTHEAST' 2 'SOUTH (SE)' 3 'SOUTH' 4 'MIDWEST' 5 'WEST'. /* Create Speedbands Recode download (0 thru 2.999=1) (3.0 thru 5.999=2) (6.0 thru 9.999=3) (10.0 thru 19.999=4) (20.0 thru 29.999=5) (30.0 thru hi=6) (SYSMIS=9) into SpeedBand . Value Lables SpeedBand 1 "0-3 Mbps" 2 "3-6 Mbps" 3 "6-10 Mbps" 4 "10-20 Mbps" 5 "20-30 Mbps" 6 "30+ Mbps" 9 "Unclassified". freq Speedband. Save OUTFILE='D:\Jobs\6217-SamKnowns\Tabulation\New Data\UnitISP_FCC_March.SAV'. Dataset close all. GET File='D:\Jobs\6217-SamKnowns\Tabulation\New Data\UnitISP_FCC_March.SAV'. /*Merge CSVs MATCH FILES /FILE=* /TABLE='D:\Jobs\6217-SamKnowns\Tabulation\New Data\Avail.sav' /BY Unit_ID. EXECUTE. MATCH FILES /FILE=* /TABLE='D:\Jobs\6217-SamKnowns\Tabulation\New Data\dlping.sav' /BY Unit_ID. EXECUTE. MATCH FILES /FILE=* /TABLE='D:\Jobs\6217-SamKnowns\Tabulation\New Data\dns.sav' /BY Unit_ID. EXECUTE. MATCH FILES /FILE=* /TABLE='D:\Jobs\6217-SamKnowns\Tabulation\New Data\httpgetmt.sav' /BY Unit_ID. EXECUTE. MATCH FILES /FILE=* /TABLE='D:\Jobs\6217-SamKnowns\Tabulation\New Data\ping.sav' /BY Unit_ID. EXECUTE. MATCH FILES /FILE=* /TABLE='D:\Jobs\6217-SamKnowns\Tabulation\New Data\udpjitter_down.sav' /BY Unit_ID. EXECUTE. MATCH FILES /FILE=* /TABLE='D:\Jobs\6217-SamKnowns\Tabulation\New Data\udpjitter_up.sav' /BY Unit_ID. EXECUTE. MATCH FILES /FILE=* /TABLE='D:\Jobs\6217-SamKnowns\Tabulation\New Data\udplatency.sav' /BY Unit_ID. EXECUTE. MATCH FILES /FILE=* /TABLE='D:\Jobs\6217-SamKnowns\Tabulation\New Data\ulping.sav' /BY Unit_ID. EXECUTE. MATCH FILES /FILE=* /TABLE='D:\Jobs\6217-SamKnowns\Tabulation\New Data\videostream1_25M.sav' /BY Unit_ID. EXECUTE. MATCH FILES /FILE=* /TABLE='D:\Jobs\6217-SamKnowns\Tabulation\New Data\videostream2_25M.sav' /BY Unit_ID. EXECUTE. MATCH FILES /FILE=* /TABLE='D:\Jobs\6217-SamKnowns\Tabulation\New Data\videostream3_75M.sav' /BY Unit_ID. EXECUTE. MATCH FILES /FILE=* /TABLE='D:\Jobs\6217-SamKnowns\Tabulation\New Data\videostream768K.sav' /BY Unit_ID. EXECUTE. MATCH FILES /FILE=* /TABLE='D:\Jobs\6217-SamKnowns\Tabulation\New Data\webget.sav' /BY Unit_ID. EXECUTE. MATCH FILES /FILE=* /TABLE='D:\Jobs\6217-SamKnowns\Tabulation\New Data\httppostmt.sav' /BY Unit_ID. EXECUTE. /* Drop cases with less than 7 days data Select if Days>6. exec. Select if Upload>0. exec. /*Drop SAT Cases Select if Any(Technology,1,2,3). exec. Save OutFile='D:\Jobs\6217-SamKnowns\Tabulation\New Data\6217-SK-Combined.SAV'. Dataset close all. Get File='D:\Jobs\6217-SamKnowns\Tabulation\New Data\6217-SK-Combined.SAV'. /*Set proper units Compute availability_1=availability_1*100. Compute availability_2=availability_2*100. Compute availability_3=availability_3*100. Compute availability_4=availability_4*100. Compute dlpng_trimmed_mean_1=dlpng_trimmed_mean_1*0.001. Compute dlpng_trimmed_stddev_1=dlpng_trimmed_stddev_1*0.001. Compute dlpng_trimmed_mean_2=dlpng_trimmed_mean_2*0.001. Compute dlpng_trimmed_stddev_2=dlpng_trimmed_stddev_2*0.001. Compute dlpng_trimmed_mean_3=dlpng_trimmed_mean_3*0.001. Compute dlpng_trimmed_stddev_3=dlpng_trimmed_stddev_3*0.001. Compute dlpng_trimmed_mean_4=dlpng_trimmed_mean_4*0.001. Compute dlpng_trimmed_stddev_4=dlpng_trimmed_stddev_4*0.001. Compute dns_trimmed_mean_1=dns_trimmed_mean_1*0.001. Compute dns_trimmed_stddev_1=dns_trimmed_stddev_1*0.001. Compute dns_trimmed_mean_2=dns_trimmed_mean_2*0.001. Compute dns_trimmed_stddev_2=dns_trimmed_stddev_2*0.001. Compute dns_trimmed_mean_3=dns_trimmed_mean_3*0.001. Compute dns_trimmed_stddev_3=dns_trimmed_stddev_3*0.001. Compute dns_trimmed_mean_4=dns_trimmed_mean_4*0.001. Compute dns_trimmed_stddev_4=dns_trimmed_stddev_4*0.001. Compute get_burst_trimmed_mean_1=get_burst_trimmed_mean_1*0.000008. Compute get_burst_trimmed_stddev_1=get_burst_trimmed_stddev_1*0.000008. Compute get_sustained_trimmed_mean_1=get_sustained_trimmed_mean_1*0.000008. Compute get_sustained_trimmed_stddev_1=get_sustained_trimmed_stddev_1*0.000008. Compute get_burst_trimmed_mean_2=get_burst_trimmed_mean_2*0.000008. Compute get_burst_trimmed_stddev_2=get_burst_trimmed_stddev_2*0.000008. Compute get_sustained_trimmed_mean_2=get_sustained_trimmed_mean_2*0.000008. Compute get_sustained_trimmed_stddev_2=get_sustained_trimmed_stddev_2*0.000008. Compute get_burst_trimmed_mean_3=get_burst_trimmed_mean_3*0.000008. Compute get_burst_trimmed_stddev_3=get_burst_trimmed_stddev_3*0.000008. Compute get_sustained_trimmed_mean_3=get_sustained_trimmed_mean_3*0.000008. Compute get_sustained_trimmed_stddev_3=get_sustained_trimmed_stddev_3*0.000008. Compute get_burst_trimmed_mean_4=get_burst_trimmed_mean_4*0.000008. Compute get_burst_trimmed_stddev_4=get_burst_trimmed_stddev_4*0.000008. Compute get_sustained_trimmed_mean_4=get_sustained_trimmed_mean_4*0.000008. Compute get_sustained_trimmed_stddev_4=get_sustained_trimmed_stddev_4*0.000008. Compute get_sustained_trimmed_mean_5=get_sustained_trimmed_mean_5*0.000008. Compute get_sustained_trimmed_stddev_5=get_sustained_trimmed_stddev_5*0.000008. Compute get_sustained_trimmed_mean_6=get_sustained_trimmed_mean_6*0.000008. Compute get_sustained_trimmed_stddev_6=get_sustained_trimmed_stddev_6*0.000008. Compute get_sustained_trimmed_mean_7=get_sustained_trimmed_mean_7*0.000008. Compute get_sustained_trimmed_stddev_7=get_sustained_trimmed_stddev_7*0.000008. Compute get_sustained_trimmed_mean_8=get_sustained_trimmed_mean_8*0.000008. Compute get_sustained_trimmed_stddev_8=get_sustained_trimmed_stddev_8*0.000008. Compute get_sustained_trimmed_mean_9=get_sustained_trimmed_mean_9*0.000008. Compute get_sustained_trimmed_stddev_9=get_sustained_trimmed_stddev_9*0.000008. Compute get_sustained_trimmed_mean_10=get_sustained_trimmed_mean_10*0.000008. Compute get_sustained_trimmed_stddev_10=get_sustained_trimmed_stddev_10*0.000008. Compute get_sustained_trimmed_mean_11=get_sustained_trimmed_mean_11*0.000008. Compute get_sustained_trimmed_stddev_11=get_sustained_trimmed_stddev_11*0.000008. Compute get_sustained_trimmed_mean_12=get_sustained_trimmed_mean_12*0.000008. Compute get_sustained_trimmed_stddev_12=get_sustained_trimmed_stddev_12*0.000008. Compute get_sustained_trimmed_mean_13=get_sustained_trimmed_mean_13*0.000008. Compute get_sustained_trimmed_stddev_13=get_sustained_trimmed_stddev_13*0.000008. Compute get_sustained_trimmed_mean_14=get_sustained_trimmed_mean_14*0.000008. Compute get_sustained_trimmed_stddev_14=get_sustained_trimmed_stddev_14*0.000008. Compute get_sustained_trimmed_mean_15=get_sustained_trimmed_mean_15*0.000008. Compute get_sustained_trimmed_stddev_15=get_sustained_trimmed_stddev_15*0.000008. Compute get_sustained_trimmed_mean_16=get_sustained_trimmed_mean_16*0.000008. Compute get_sustained_trimmed_stddev_16=get_sustained_trimmed_stddev_16*0.000008. Compute png_trimmed_mean_1=png_trimmed_mean_1*0.001. Compute png_trimmed_stddev_1=png_trimmed_stddev_1*0.001. Compute png_trimmed_mean_2=png_trimmed_mean_2*0.001. Compute png_trimmed_stddev_2=png_trimmed_stddev_2*0.001. Compute png_trimmed_mean_3=png_trimmed_mean_3*0.001. Compute png_trimmed_stddev_3=png_trimmed_stddev_3*0.001. Compute png_trimmed_mean_4=png_trimmed_mean_4*0.001. Compute png_trimmed_stddev_4=png_trimmed_stddev_4*0.001. Compute jd_trimmed_mean_1=jd_trimmed_mean_1*0.001. Compute jd_trimmed_stddev_1=jd_trimmed_stddev_1*0.001. Compute jd_trimmed_mean_2=jd_trimmed_mean_2*0.001. Compute jd_trimmed_stddev_2=jd_trimmed_stddev_2*0.001. Compute jd_trimmed_mean_3=jd_trimmed_mean_3*0.001. Compute jd_trimmed_stddev_3=jd_trimmed_stddev_3*0.001. Compute jd_trimmed_mean_4=jd_trimmed_mean_4*0.001. Compute jd_trimmed_stddev_4=jd_trimmed_stddev_4*0.001. Compute ju_trimmed_mean_1=ju_trimmed_mean_1*0.001. Compute ju_trimmed_stddev_1=ju_trimmed_stddev_1*0.001. Compute ju_trimmed_mean_2=ju_trimmed_mean_2*0.001. Compute ju_trimmed_stddev_2=ju_trimmed_stddev_2*0.001. Compute ju_trimmed_mean_3=ju_trimmed_mean_3*0.001. Compute ju_trimmed_stddev_3=ju_trimmed_stddev_3*0.001. Compute ju_trimmed_mean_4=ju_trimmed_mean_4*0.001. Compute ju_trimmed_stddev_4=ju_trimmed_stddev_4*0.001. Compute upng_trimmed_mean_1=upng_trimmed_mean_1*0.001. Compute upng_trimmed_stddev_1=upng_trimmed_stddev_1*0.001. Compute upng_trimmed_mean_2=upng_trimmed_mean_2*0.001. Compute upng_trimmed_stddev_2=upng_trimmed_stddev_2*0.001. Compute upng_trimmed_mean_3=upng_trimmed_mean_3*0.001. Compute upng_trimmed_stddev_3=upng_trimmed_stddev_3*0.001. Compute upng_trimmed_mean_4=upng_trimmed_mean_4*0.001. Compute upng_trimmed_stddev_4=upng_trimmed_stddev_4*0.001. Compute v125_trimmed_mean_1=v125_trimmed_mean_1*0.001. Compute v125_trimmed_stddev_1=v125_trimmed_stddev_1*0.001. Compute v125_trimmed_mean_2=v125_trimmed_mean_2*0.001. Compute v125_trimmed_stddev_2=v125_trimmed_stddev_2*0.001. Compute v125_trimmed_mean_3=v125_trimmed_mean_3*0.001. Compute v125_trimmed_stddev_3=v125_trimmed_stddev_3*0.001. Compute v125_trimmed_mean_4=v125_trimmed_mean_4*0.001. Compute v125_trimmed_stddev_4=v125_trimmed_stddev_4*0.001. Compute v225_trimmed_mean_1=v225_trimmed_mean_1*0.001. Compute v225_trimmed_stddev_1=v225_trimmed_stddev_1*0.001. Compute v225_trimmed_mean_2=v225_trimmed_mean_2*0.001. Compute v225_trimmed_stddev_2=v225_trimmed_stddev_2*0.001. Compute v225_trimmed_mean_3=v225_trimmed_mean_3*0.001. Compute v225_trimmed_stddev_3=v225_trimmed_stddev_3*0.001. Compute v225_trimmed_mean_4=v225_trimmed_mean_4*0.001. Compute v225_trimmed_stddev_4=v225_trimmed_stddev_4*0.001. Compute v375_trimmed_mean_1=v375_trimmed_mean_1*0.001. Compute v375_trimmed_stddev_1=v375_trimmed_stddev_1*0.001. Compute v375_trimmed_mean_2=v375_trimmed_mean_2*0.001. Compute v375_trimmed_stddev_2=v375_trimmed_stddev_2*0.001. Compute v375_trimmed_mean_3=v375_trimmed_mean_3*0.001. Compute v375_trimmed_stddev_3=v375_trimmed_stddev_3*0.001. Compute v375_trimmed_mean_4=v375_trimmed_mean_4*0.001. Compute v375_trimmed_stddev_4=v375_trimmed_stddev_4*0.001. Compute v768_trimmed_mean_1=v768_trimmed_mean_1*0.001. Compute v768_trimmed_stddev_1=v768_trimmed_stddev_1*0.001. Compute v768_trimmed_mean_2=v768_trimmed_mean_2*0.001. Compute v768_trimmed_stddev_2=v768_trimmed_stddev_2*0.001. Compute v768_trimmed_mean_3=v768_trimmed_mean_3*0.001. Compute v768_trimmed_stddev_3=v768_trimmed_stddev_3*0.001. Compute v768_trimmed_mean_4=v768_trimmed_mean_4*0.001. Compute v768_trimmed_stddev_4=v768_trimmed_stddev_4*0.001. exec. Compute ltncy_trimmed_mean_1=ltncy_trimmed_mean_1* 0.001. Compute ltncy_trimmed_mean_2=ltncy_trimmed_mean_2* 0.001. Compute ltncy_trimmed_mean_3=ltncy_trimmed_mean_3* 0.001. exec. Value lables Download 0.256 '0.256 Mbit/s' 0.512 '0.512 Mbit/s' 0.576 '0.576 Mbit/s' 0.768 '0.768 Mbit/s' 0.896 '0.896 Mbit/s' 1 '1 Mbit/s' 1.5 '1.5 Mbit/s' 2 '2 Mbit/s' 3 '3 Mbit/s' 4 '4 Mbit/s' 5 '5 Mbit/s' 6 '6 Mbit/s' 7 '7 Mbit/s' 8 '8 Mbit/s' 9 '9 Mbit/s' 10 '10 Mbit/s' 12 '12 Mbit/s' 15 '15 Mbit/s' 16 '16 Mbit/s' 18 '18 Mbit/s' 20 '20 Mbit/s' 22 '22 Mbit/s' 24 '24 Mbit/s' 25 '25 Mbit/s' 30 '30 Mbit/s' 35 '35 Mbit/s' 40 '40 Mbit/s' 50 '50 Mbit/s' 55 '55 Mbit/s' 60 '60 Mbit/s' 100 '100 Mbit/s'. VARSTOCASES /Make availability from availability_1 availability_2 availability_3 /Make dlpng_trimmed_mean from dlpng_trimmed_mean_1 dlpng_trimmed_mean_2 dlpng_trimmed_mean_3 /Make dlpng_trimmed_stddev from dlpng_trimmed_stddev_1 dlpng_trimmed_stddev_2 dlpng_trimmed_stddev_3 /Make dns_trimmed_mean from dns_trimmed_mean_1 dns_trimmed_mean_2 dns_trimmed_mean_3 /Make dns_trimmed_stddev from dns_trimmed_stddev_1 dns_trimmed_stddev_2 dns_trimmed_stddev_3 /Make get_burst_trimmed_mean from get_burst_trimmed_mean_1 get_burst_trimmed_mean_2 get_burst_trimmed_mean_3 /Make get_burst_trimmed_stddev from get_burst_trimmed_stddev_1 get_burst_trimmed_stddev_2 get_burst_trimmed_stddev_3 /Make get_sustained_trimmed_mean from get_sustained_trimmed_mean_1 get_sustained_trimmed_mean_2 get_sustained_trimmed_mean_3 /Make get_sustained_trimmed_stddev from get_sustained_trimmed_stddev_1 get_sustained_trimmed_stddev_2 get_sustained_trimmed_stddev_3 /Make png_trimmed_mean from png_trimmed_mean_1 png_trimmed_mean_2 png_trimmed_mean_3 /Make png_trimmed_stddev from png_trimmed_stddev_1 png_trimmed_stddev_2 png_trimmed_stddev_3 /Make jd_trimmed_mean from jd_trimmed_mean_1 jd_trimmed_mean_2 jd_trimmed_mean_3 /Make jd_trimmed_stddev from jd_trimmed_stddev_1 jd_trimmed_stddev_2 jd_trimmed_stddev_3 /Make ju_trimmed_mean from ju_trimmed_mean_1 ju_trimmed_mean_2 ju_trimmed_mean_3 /Make ju_trimmed_stddev from ju_trimmed_stddev_1 ju_trimmed_stddev_2 ju_trimmed_stddev_3 /Make ltncy_trimmed_mean from ltncy_trimmed_mean_1 ltncy_trimmed_mean_2 ltncy_trimmed_mean_3 /Make ltncy_trimmed_stddev from ltncy_trimmed_stddev_1 ltncy_trimmed_stddev_2 ltncy_trimmed_stddev_3 /Make upng_trimmed_mean from upng_trimmed_mean_1 upng_trimmed_mean_2 upng_trimmed_mean_3 /Make upng_trimmed_stddev from upng_trimmed_stddev_1 upng_trimmed_stddev_2 upng_trimmed_stddev_3 /Make v125_trimmed_mean from v125_trimmed_mean_1 v125_trimmed_mean_2 v125_trimmed_mean_3 /Make v125_trimmed_stddev from v125_trimmed_stddev_1 v125_trimmed_stddev_2 v125_trimmed_stddev_3 /Make v225_trimmed_mean from v225_trimmed_mean_1 v225_trimmed_mean_2 v225_trimmed_mean_3 /Make v225_trimmed_stddev from v225_trimmed_stddev_1 v225_trimmed_stddev_2 v225_trimmed_stddev_3 /Make v375_trimmed_mean from v375_trimmed_mean_1 v375_trimmed_mean_2 v375_trimmed_mean_3 /Make v375_trimmed_stddev from v375_trimmed_stddev_1 v375_trimmed_stddev_2 v375_trimmed_stddev_3 /Make v768_trimmed_mean from v768_trimmed_mean_1 v768_trimmed_mean_2 v768_trimmed_mean_3 /Make v768_trimmed_stddev from v768_trimmed_stddev_1 v768_trimmed_stddev_2 v768_trimmed_stddev_3 /Make uploadBurst_Trimmed_Mean from uploadBurst_Trimmed_Mean1 uploadBurst_Trimmed_Mean2 uploadBurst_Trimmed_Mean3 /Make uploadSustained_Trimmed_Mean from uploadSustained_Trimmed_Mean1 uploadSustained_Trimmed_Mean2 uploadSustained_Trimmed_Mean3 /Make ltncy_failrate from ltncy_failrate_1 ltncy_failrate_2 ltncy_failrate_3 /Make fetch_time_trimmed_mean from fetch_time_trimmed_mean1 fetch_time_trimmed_mean2 fetch_time_trimmed_mean3 /INDEX = Period(3) /KEEP = unit_id ISP TECHNOLOGY VALIDATEDBY DOWNLOAD UPLOAD state region zip days SpeedBand get_period_5 get_sustained_trimmed_mean_5 get_sustained_trimmed_stddev_5 get_period_6 get_sustained_trimmed_mean_6 get_sustained_trimmed_stddev_6 get_period_7 get_sustained_trimmed_mean_7 get_sustained_trimmed_stddev_7 get_period_8 get_sustained_trimmed_mean_8 get_sustained_trimmed_stddev_8 get_period_9 get_sustained_trimmed_mean_9 get_sustained_trimmed_stddev_9 get_period_10 get_sustained_trimmed_mean_10 get_sustained_trimmed_stddev_10 get_period_11 get_sustained_trimmed_mean_11 get_sustained_trimmed_stddev_11 get_period_12 get_sustained_trimmed_mean_12 get_sustained_trimmed_stddev_12 get_period_13 get_sustained_trimmed_mean_13 get_sustained_trimmed_stddev_13 get_period_14 get_sustained_trimmed_mean_14 get_sustained_trimmed_stddev_14 get_period_15 get_sustained_trimmed_mean_15 get_sustained_trimmed_stddev_15 get_period_16 get_sustained_trimmed_mean_16 get_sustained_trimmed_stddev_16 /NULL = DROP. Value Labels Period 1 "24hr Mon-Sun" 2 "24hr Sat-Sun" 3 "1900-2200 Mon-Fri" . Save OUTFILE='D:\Jobs\6217-SamKnowns\Tabulation\New Data\6217-SK-Combined-Stacked.SAV'. Dataset close all. Get FILE='D:\Jobs\6217-SamKnowns\Tabulation\New Data\6217-SK-Combined-Stacked.SAV'. /*Filter for cases less than N<25 include 'D:\Jobs\6217-SamKnowns\Tabulation\New Data\Base Check.sps'. Compute FilterID=GroupDIT=0. Compute FilterTD=GroupDT=0. Compute FilterIU=GroupUIT=0. Compute FilterTU=GroupUT=0. exec. /*Create Tables /********************************************* TITLE "Download Burst Trimmed Mean". SORT CASES BY Period . SPLIT FILE SEPARATE BY Period . filter by filterID. * Basic Tables. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION get_burst_trimmed_mean /FTOTAL $t 'Total' /TABLES (Download > get_burst_trimmed_mean + $t ) BY (ISP > (STATISTICS) + $t ) /STATISTICS mean( (F8.2)) median( (F8.2)) mode( (F8.2)) stddev( (F8.2)) validn( ( NEQUALS5.0 )). SPLIT FILE off. filter off. SORT CASES BY Period . SPLIT FILE SEPARATE BY Period . filter by filterTD. * Basic Tables. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION get_burst_trimmed_mean /FTOTAL $t 'Total' /TABLES (Download > get_burst_trimmed_mean + $t ) BY (Technology > (STATISTICS) + $t ) /STATISTICS mean( (F8.2)) median( (F8.2)) mode( (F8.2)) stddev( (F8.2)) validn( ( NEQUALS5.0 )). filter off. SPLIT FILE off. /********************************************* TITLE "Download Sustained Trimmed Mean". SORT CASES BY Period . SPLIT FILE SEPARATE BY Period . filter by filterID. * Basic Tables. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION get_sustained_trimmed_mean /FTOTAL $t 'Total' /TABLES (Download > get_sustained_trimmed_mean + $t ) BY (ISP > (STATISTICS) + $t ) /STATISTICS mean( (F8.2)) median( (F8.2)) mode( (F8.2)) stddev( (F8.2)) validn( ( NEQUALS5.0 )). filter off. SPLIT FILE off. SORT CASES BY Period . SPLIT FILE SEPARATE BY Period . filter by filterTD. * Basic Tables. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION get_sustained_trimmed_mean /FTOTAL $t 'Total' /TABLES (Download > get_sustained_trimmed_mean + $t ) BY (Technology > (STATISTICS) + $t ) /STATISTICS mean( (F8.2)) median( (F8.2)) mode( (F8.2)) stddev( (F8.2)) validn( ( NEQUALS5.0 )). filter off. SPLIT FILE off. /********************************************* TITLE "ICMP round trip latency". SORT CASES BY Period . SPLIT FILE SEPARATE BY Period . filter by filterID. * Basic Tables. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION png_trimmed_mean /FTOTAL $t 'Total' /TABLES (Download > png_trimmed_mean + $t ) BY (ISP > (STATISTICS) + $t ) /STATISTICS mean( (F8.2)) median( (F8.2)) mode( (F8.2)) stddev( (F8.2)) validn( ( NEQUALS5.0 )). filter off. SPLIT FILE off. SORT CASES BY Period . SPLIT FILE SEPARATE BY Period . filter by filterTD. * Basic Tables. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION png_trimmed_mean /FTOTAL $t 'Total' /TABLES (Download > png_trimmed_mean + $t ) BY (Technology > (STATISTICS) + $t ) /STATISTICS mean( (F8.2)) median( (F8.2)) mode( (F8.2)) stddev( (F8.2)) validn( ( NEQUALS5.0 )). filter off. SPLIT FILE off. /********************************************* TITLE "ICMP round trip latency under downstream load". SORT CASES BY Period . SPLIT FILE SEPARATE BY Period . filter by filterID. * Basic Tables. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION dlpng_trimmed_mean /FTOTAL $t 'Total' /TABLES (Download > dlpng_trimmed_mean + $t ) BY (ISP > (STATISTICS) + $t ) /STATISTICS mean( (F8.2)) median( (F8.2)) mode( (F8.2)) stddev( (F8.2)) validn( ( NEQUALS5.0 )). filter off. SPLIT FILE off. SORT CASES BY Period . SPLIT FILE SEPARATE BY Period . filter by filterTD. * Basic Tables. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION dlpng_trimmed_mean /FTOTAL $t 'Total' /TABLES (Download > dlpng_trimmed_mean + $t ) BY (Technology > (STATISTICS) + $t ) /STATISTICS mean( (F8.2)) median( (F8.2)) mode( (F8.2)) stddev( (F8.2)) validn( ( NEQUALS5.0 )). filter off. SPLIT FILE off. /********************************************* TITLE "ICMP round trip latency under upstream load". SORT CASES BY Period . SPLIT FILE SEPARATE BY Period . filter by filterID. * Basic Tables. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION upng_trimmed_mean /FTOTAL $t 'Total' /TABLES (Download > upng_trimmed_mean + $t ) BY (ISP > (STATISTICS) + $t ) /STATISTICS mean( (F8.2)) median( (F8.2)) mode( (F8.2)) stddev( (F8.2)) validn( ( NEQUALS5.0 )). filter off. SPLIT FILE off. SORT CASES BY Period . SPLIT FILE SEPARATE BY Period . filter by filterTD. * Basic Tables. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION upng_trimmed_mean /FTOTAL $t 'Total' /TABLES (Download > upng_trimmed_mean + $t ) BY (Technology > (STATISTICS) + $t ) /STATISTICS mean( (F8.2)) median( (F8.2)) mode( (F8.2)) stddev( (F8.2)) validn( ( NEQUALS5.0 )). filter off. SPLIT FILE off. /********************************************* TITLE "Downstream jitter". SORT CASES BY Period . SPLIT FILE SEPARATE BY Period . filter by filterID. * Basic Tables. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION jd_trimmed_mean /FTOTAL $t 'Total' /TABLES (Download > jd_trimmed_mean + $t ) BY (ISP > (STATISTICS) + $t ) /STATISTICS mean( (F8.2)) median( (F8.2)) mode( (F8.2)) stddev( (F8.2)) validn( ( NEQUALS5.0 )). filter off. SPLIT FILE off. SORT CASES BY Period . SPLIT FILE SEPARATE BY Period . filter by filterTD. * Basic Tables. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION jd_trimmed_mean /FTOTAL $t 'Total' /TABLES (Download > jd_trimmed_mean + $t ) BY (Technology > (STATISTICS) + $t ) /STATISTICS mean( (F8.2)) median( (F8.2)) mode( (F8.2)) stddev( (F8.2)) validn( ( NEQUALS5.0 )). filter off. SPLIT FILE off. /********************************************* TITLE "Upstream jitter". SORT CASES BY Period . SPLIT FILE SEPARATE BY Period . filter by filterID. * Basic Tables. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION ju_trimmed_mean /FTOTAL $t 'Total' /TABLES (Download > ju_trimmed_mean + $t ) BY (ISP > (STATISTICS) + $t ) /STATISTICS mean( (F8.2)) median( (F8.2)) mode( (F8.2)) stddev( (F8.2)) validn( ( NEQUALS5.0 )). filter off. SPLIT FILE off. SORT CASES BY Period . SPLIT FILE SEPARATE BY Period . filter by filterTD. * Basic Tables. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION ju_trimmed_mean /FTOTAL $t 'Total' /TABLES (Download > ju_trimmed_mean + $t ) BY (Technology > (STATISTICS) + $t ) /STATISTICS mean( (F8.2)) median( (F8.2)) mode( (F8.2)) stddev( (F8.2)) validn( ( NEQUALS5.0 )). filter off. SPLIT FILE off. /********************************************* TITLE "Network Availabilty Percentage". SORT CASES BY Period . SPLIT FILE SEPARATE BY Period . filter by filterID. * Basic Tables. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION availability /FTOTAL $t 'Total' /TABLES (Download > availability + $t ) BY (ISP > (STATISTICS) + $t ) /STATISTICS mean( (F8.2)) median( (F8.2)) mode( (F8.2)) stddev( (F8.2)) validn( ( NEQUALS5.0 )). filter off. SPLIT FILE off. SORT CASES BY Period . SPLIT FILE SEPARATE BY Period . filter by filterTD. * Basic Tables. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION availability /FTOTAL $t 'Total' /TABLES (Download > availability + $t ) BY (Technology > (STATISTICS) + $t ) /STATISTICS mean( (F8.2)) median( (F8.2)) mode( (F8.2)) stddev( (F8.2)) validn( ( NEQUALS5.0 )). filter off. SPLIT FILE off. /********************************************* TITLE "786kbps Video Streaming". SORT CASES BY Period . SPLIT FILE SEPARATE BY Period . filter by filterID. * Basic Tables. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION v768_trimmed_mean /FTOTAL $t 'Total' /TABLES (Download > v768_trimmed_mean + $t ) BY (ISP > (STATISTICS) + $t ) /STATISTICS mean( (F8.2)) median( (F8.2)) mode( (F8.2)) stddev( (F8.2)) validn( ( NEQUALS5.0 )). filter off. SPLIT FILE off. SORT CASES BY Period . SPLIT FILE SEPARATE BY Period . filter by filterTD. * Basic Tables. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION v768_trimmed_mean /FTOTAL $t 'Total' /TABLES (Download > v768_trimmed_mean + $t ) BY (Technology > (STATISTICS) + $t ) /STATISTICS mean( (F8.2)) median( (F8.2)) mode( (F8.2)) stddev( (F8.2)) validn( ( NEQUALS5.0 )). filter off. SPLIT FILE off. /********************************************* TITLE "1.25Mbps Video Streaming". SORT CASES BY Period . SPLIT FILE SEPARATE BY Period . filter by filterID. * Basic Tables. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION v125_trimmed_mean /FTOTAL $t 'Total' /TABLES (Download > v125_trimmed_mean + $t ) BY (ISP > (STATISTICS) + $t ) /STATISTICS mean( (F8.2)) median( (F8.2)) mode( (F8.2)) stddev( (F8.2)) validn( ( NEQUALS5.0 )). filter off. SPLIT FILE off. SORT CASES BY Period . SPLIT FILE SEPARATE BY Period . filter by filterTD. * Basic Tables. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION v125_trimmed_mean /FTOTAL $t 'Total' /TABLES (Download > v125_trimmed_mean + $t ) BY (Technology > (STATISTICS) + $t ) /STATISTICS mean( (F8.2)) median( (F8.2)) mode( (F8.2)) stddev( (F8.2)) validn( ( NEQUALS5.0 )). filter off. SPLIT FILE off. /********************************************* TITLE "2.25Mbps Video Streaming". SORT CASES BY Period . SPLIT FILE SEPARATE BY Period . filter by filterID. * Basic Tables. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION v225_trimmed_mean /FTOTAL $t 'Total' /TABLES (Download > v225_trimmed_mean + $t ) BY (ISP > (STATISTICS) + $t ) /STATISTICS mean( (F8.2)) median( (F8.2)) mode( (F8.2)) stddev( (F8.2)) validn( ( NEQUALS5.0 )). filter off. SPLIT FILE off. SORT CASES BY Period . SPLIT FILE SEPARATE BY Period . filter by filterTD. * Basic Tables. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION v225_trimmed_mean /FTOTAL $t 'Total' /TABLES (Download > v225_trimmed_mean + $t ) BY (Technology > (STATISTICS) + $t ) /STATISTICS mean( (F8.2)) median( (F8.2)) mode( (F8.2)) stddev( (F8.2)) validn( ( NEQUALS5.0 )). filter off. SPLIT FILE off. /********************************************* TITLE "3.75Mbps Video Streaming". SORT CASES BY Period . SPLIT FILE SEPARATE BY Period . filter by filterID. * Basic Tables. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION v375_trimmed_mean /FTOTAL $t 'Total' /TABLES (Download > v375_trimmed_mean + $t ) BY (ISP > (STATISTICS) + $t ) /STATISTICS mean( (F8.2)) median( (F8.2)) mode( (F8.2)) stddev( (F8.2)) validn( ( NEQUALS5.0 )). filter off. SPLIT FILE off. SORT CASES BY Period . SPLIT FILE SEPARATE BY Period . filter by filterTD. * Basic Tables. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION v375_trimmed_mean /FTOTAL $t 'Total' /TABLES (Download > v375_trimmed_mean + $t ) BY (Technology > (STATISTICS) + $t ) /STATISTICS mean( (F8.2)) median( (F8.2)) mode( (F8.2)) stddev( (F8.2)) validn( ( NEQUALS5.0 )). filter off. SPLIT FILE off. /********************************************* TITLE "Latency". SORT CASES BY Period . SPLIT FILE SEPARATE BY Period . filter by filterID. * Basic Tables. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION ltncy_trimmed_mean /FTOTAL $t 'Total' /TABLES (Download > ltncy_trimmed_mean + $t ) BY (ISP > (STATISTICS) + $t ) /STATISTICS mean( (F8.2)) median( (F8.2)) mode( (F8.2)) stddev( (F8.2)) validn( ( NEQUALS5.0 )). filter off. SPLIT FILE off. SORT CASES BY Period . SPLIT FILE SEPARATE BY Period . filter by filterTD. * Basic Tables. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION ltncy_trimmed_mean /FTOTAL $t 'Total' /TABLES (Download > ltncy_trimmed_mean + $t ) BY (Technology > (STATISTICS) + $t ) /STATISTICS mean( (F8.2)) median( (F8.2)) mode( (F8.2)) stddev( (F8.2)) validn( ( NEQUALS5.0 )). filter off. SPLIT FILE off. /************************************************************** TITLE "Burst Upload Speed". SORT CASES BY Period . SPLIT FILE SEPARATE BY Period . filter by filterIU. * Basic Tables. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION uploadBurst_Trimmed_Mean /FTOTAL $t 'Total' /TABLES (Upload > uploadBurst_Trimmed_Mean + $t ) BY (ISP > (STATISTICS) + $t ) /STATISTICS mean( (F8.2)) median( (F8.2)) mode( (F8.2)) stddev( (F8.2)) validn( ( NEQUALS5.0 )). filter off. SPLIT FILE off. SORT CASES BY Period . SPLIT FILE SEPARATE BY Period . filter by filterTU. * Basic Tables. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION uploadBurst_Trimmed_Mean /FTOTAL $t 'Total' /TABLES (Upload > uploadBurst_Trimmed_Mean + $t ) BY (Technology > (STATISTICS) + $t ) /STATISTICS mean( (F8.2)) median( (F8.2)) mode( (F8.2)) stddev( (F8.2)) validn( ( NEQUALS5.0 )). filter off. SPLIT FILE off. /************************************************************** TITLE "Sustained Upload Speed". SORT CASES BY Period . SPLIT FILE SEPARATE BY Period . filter by filterIU. * Basic Tables. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION uploadSustained_Trimmed_Mean /FTOTAL $t 'Total' /TABLES (Upload > uploadSustained_Trimmed_Mean + $t ) BY (ISP > (STATISTICS) + $t ) /STATISTICS mean( (F8.2)) median( (F8.2)) mode( (F8.2)) stddev( (F8.2)) validn( ( NEQUALS5.0 )). filter off. SPLIT FILE off. SORT CASES BY Period . SPLIT FILE SEPARATE BY Period . filter by filterTU. * Basic Tables. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION uploadSustained_Trimmed_Mean /FTOTAL $t 'Total' /TABLES (Upload > uploadSustained_Trimmed_Mean + $t ) BY (Technology > (STATISTICS) + $t ) /STATISTICS mean( (F8.2)) median( (F8.2)) mode( (F8.2)) stddev( (F8.2)) validn( ( NEQUALS5.0 )). filter off. SPLIT FILE off. /********************************************* TITLE "Packet Loss". SORT CASES BY Period . SPLIT FILE SEPARATE BY Period . filter by filterID. * Basic Tables. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION ltncy_failrate /FTOTAL $t 'Total' /TABLES (Download > ltncy_failrate + $t ) BY (ISP > (STATISTICS) + $t ) /STATISTICS mean( (F8.2)) median( (F8.2)) mode( (F8.2)) stddev( (F8.2)) validn( ( NEQUALS5.0 )). filter off. SPLIT FILE off. SORT CASES BY Period . SPLIT FILE SEPARATE BY Period . filter by filterTD. * Basic Tables. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION ltncy_failrate /FTOTAL $t 'Total' /TABLES (Download > ltncy_failrate + $t ) BY (Technology > (STATISTICS) + $t ) /STATISTICS mean( (F8.2)) median( (F8.2)) mode( (F8.2)) stddev( (F8.2)) validn( ( NEQUALS5.0 )). filter off. SPLIT FILE off. /********************************************* TITLE "Web page load time". SORT CASES BY Period . SPLIT FILE SEPARATE BY Period . filter by filterID. * Basic Tables. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION fetch_time_trimmed_mean /FTOTAL $t 'Total' /TABLES (Download > fetch_time_trimmed_mean + $t ) BY (ISP > (STATISTICS) + $t ) /STATISTICS mean( (F8.2)) median( (F8.2)) mode( (F8.2)) stddev( (F8.2)) validn( ( NEQUALS5.0 )). filter off. SPLIT FILE off. SORT CASES BY Period . SPLIT FILE SEPARATE BY Period . filter by filterTD. * Basic Tables. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION fetch_time_trimmed_mean /FTOTAL $t 'Total' /TABLES (Download > fetch_time_trimmed_mean + $t ) BY (Technology > (STATISTICS) + $t ) /STATISTICS mean( (F8.2)) median( (F8.2)) mode( (F8.2)) stddev( (F8.2)) validn( ( NEQUALS5.0 )). filter off. SPLIT FILE off. /* 2 hr Timeband charts Compute filter$=Period=1. exec. Compute Avg_24hr=Mean(get_sustained_trimmed_mean_5, get_sustained_trimmed_mean_6, get_sustained_trimmed_mean_7, get_sustained_trimmed_mean_8, get_sustained_trimmed_mean_9, get_sustained_trimmed_mean_10, get_sustained_trimmed_mean_11, get_sustained_trimmed_mean_12, get_sustained_trimmed_mean_13, get_sustained_trimmed_mean_14, get_sustained_trimmed_mean_15, get_sustained_trimmed_mean_16). exec. Compute Avg_24HrRatio=Avg_24Hr/download. exec. Filter by filter$. Compute HR_1=get_sustained_trimmed_mean_5. Compute HR_2=get_sustained_trimmed_mean_6. Compute HR_3=get_sustained_trimmed_mean_7. Compute HR_4=get_sustained_trimmed_mean_8. Compute HR_5=get_sustained_trimmed_mean_9. Compute HR_6=get_sustained_trimmed_mean_10. Compute HR_7=get_sustained_trimmed_mean_11. Compute HR_8=get_sustained_trimmed_mean_12. Compute HR_9=get_sustained_trimmed_mean_13. Compute HR_10=get_sustained_trimmed_mean_14. Compute HR_11=get_sustained_trimmed_mean_15. Compute HR_12=get_sustained_trimmed_mean_16. Compute HR_1=get_sustained_trimmed_mean_5/download. Compute HR_2=get_sustained_trimmed_mean_6/download. Compute HR_3=get_sustained_trimmed_mean_7/download. Compute HR_4=get_sustained_trimmed_mean_8/download. Compute HR_5=get_sustained_trimmed_mean_9/download. Compute HR_6=get_sustained_trimmed_mean_10/download. Compute HR_7=get_sustained_trimmed_mean_11/download. Compute HR_8=get_sustained_trimmed_mean_12/download. Compute HR_9=get_sustained_trimmed_mean_13/download. Compute HR_10=get_sustained_trimmed_mean_14/download. Compute HR_11=get_sustained_trimmed_mean_15/download. Compute HR_12=get_sustained_trimmed_mean_16/download. exec. * General Tables. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION= HR_1 HR_2 HR_3 HR_4 HR_5 HR_6 HR_7 HR_8 HR_9 HR_10 HR_11 HR_12 Download Avg_24hr Avg_24HrRatio /GBASE=CASES /TABLE=ISP + TECHNOLOGY BY HR_1 + HR_2 + HR_3 + HR_4 + HR_5 + HR_6 + HR_7 + HR_8 + HR_9 + HR_10 + HR_11 + HR_12 + Download + Avg_24hr + Avg_24HrRatio /STATISTICS mean( HR_1) mean( HR_2) mean( HR_3) mean( HR_4) mean( HR_5) mean( HR_6) mean( HR_7) mean( HR_8) mean( HR_9) mean( HR_10) mean( HR_11) mean( HR_12) mean( Download) mean( Avg_24hr ) mean( Avg_24HrRatio) . Compute HR_1=get_sustained_trimmed_mean_5/Avg_24hr. Compute HR_2=get_sustained_trimmed_mean_6/Avg_24hr. Compute HR_3=get_sustained_trimmed_mean_7/Avg_24hr. Compute HR_4=get_sustained_trimmed_mean_8/Avg_24hr. Compute HR_5=get_sustained_trimmed_mean_9/Avg_24hr. Compute HR_6=get_sustained_trimmed_mean_10/Avg_24hr. Compute HR_7=get_sustained_trimmed_mean_11/Avg_24hr. Compute HR_8=get_sustained_trimmed_mean_12/Avg_24hr. Compute HR_9=get_sustained_trimmed_mean_13/Avg_24hr. Compute HR_10=get_sustained_trimmed_mean_14/Avg_24hr. Compute HR_11=get_sustained_trimmed_mean_15/Avg_24hr. Compute HR_12=get_sustained_trimmed_mean_16/Avg_24hr. exec. *General Tables. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION= HR_1 HR_2 HR_3 HR_4 HR_5 HR_6 HR_7 HR_8 HR_9 HR_10 HR_11 HR_12 Avg_24hr Avg_24HrRatio /GBASE=CASES /TABLE=ISP + TECHNOLOGY BY HR_1 + HR_2 + HR_3 + HR_4 + HR_5 + HR_6 + HR_7 + HR_8 + HR_9 + HR_10 + HR_11 + HR_12 + Avg_24hr + Avg_24HrRatio /STATISTICS mean( HR_1) mean( HR_2) mean( HR_3) mean( HR_4) mean( HR_5) mean( HR_6) mean( HR_7) mean( HR_8) mean( HR_9) mean( HR_10) mean( HR_11) mean( HR_12) mean( Avg_24hr) mean( Avg_24HrRatio) SORT CASE by PERIOD (A). filter off. /*Tables for charts COMPUTE dnloadsustainedratio=get_burst_trimmed_mean/DOWNLOAD. COMPUTE upratio=uploadBurst_Trimmed_Mean/UPLOAD. COMPUTE upratioburst=uploadBurst_Trimmed_Mean/upload. COMPUTE dnratioburst=get_burst_trimmed_mean/download. EXECUTE. USE ALL. COMPUTE filter_$=(Period=3 and TECHNOLOGY<>4). FILTER BY filter_$. **************** Means. **************** Chart 1. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION dnloadsustainedratio /TABLES dnloadsustainedratio BY ISP > (STATISTICS) /STATISTICS mean( ). TABLES /FORMAT BLANK MISSING('.') /OBSERVATION upratio /TABLES upratio BY ISP > (STATISTICS) /STATISTICS mean( ). **************** Chart 2. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION dnloadsustainedratio /TABLES dnloadsustainedratio BY TECHNOLOGY > (STATISTICS) /STATISTICS mean( ). TABLES /FORMAT BLANK MISSING('.') /OBSERVATION upratio /TABLES upratio BY TECHNOLOGY > (STATISTICS) /STATISTICS mean( ). **************** Chart 3. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION dnloadsustainedratio /TABLES ISP > dnloadsustainedratio BY Download > (STATISTICS) /STATISTICS mean( ). **************** Chart 4. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION upratio /TABLES ISP > upratio BY UPLOAD > (STATISTICS) /STATISTICS mean( ). **************** Chart 5. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION dnratioburst /TABLES ISP > dnratioburst BY Download > (STATISTICS) /STATISTICS mean( ). **************** Chart 6. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION upratioburst /TABLES ISP > upratioburst BY UPLOAD > (STATISTICS) /STATISTICS mean( ). **************** Chart 7. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION ltncy_trimmed_mean /TABLES Download > ltncy_trimmed_mean BY TECHNOLOGY > (STATISTICS) /STATISTICS mean( ). **************** Counts. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION dnloadsustainedratio /TABLES dnloadsustainedratio BY ISP > (STATISTICS) /STATISTICS validn( ( NEQUALS5.0 )). TABLES /FORMAT BLANK MISSING('.') /OBSERVATION dnloadsustainedratio /TABLES dnloadsustainedratio BY TECHNOLOGY > (STATISTICS) /STATISTICS validn( ( NEQUALS5.0 )). TABLES /FORMAT BLANK MISSING('.') /OBSERVATION dnloadsustainedratio /TABLES ISP > dnloadsustainedratio BY Download > (STATISTICS) /STATISTICS validn( ( NEQUALS5.0 )). TABLES /FORMAT BLANK MISSING('.') /OBSERVATION upratio /TABLES ISP > upratio BY UPLOAD > (STATISTICS) /STATISTICS validn( ( NEQUALS5.0 )). TABLES /FORMAT BLANK MISSING('.') /OBSERVATION dnratioburst /TABLES ISP > dnratioburst BY Download > (STATISTICS) /STATISTICS validn( ( NEQUALS5.0 )). TABLES /FORMAT BLANK MISSING('.') /OBSERVATION upratioburst /TABLES ISP > upratioburst BY UPLOAD > (STATISTICS) /STATISTICS validn( ( NEQUALS5.0 )). TABLES /FORMAT BLANK MISSING('.') /OBSERVATION ltncy_trimmed_mean /TABLES Download > ltncy_trimmed_mean BY TECHNOLOGY > (STATISTICS) /STATISTICS validn( ( NEQUALS5.0 )).