Spreadsheet: 266003d1379461929-slicing-and-dicing-data-need-help-extracting-information-from-a-data-set-dataslicesample_example
Sheet: Sheet1

Revenue Growth Rates
Company | 2000
AAA1 | 0.2488924832486776 | 0.6200967771624007 | 0.2203244351768329 | 0.604224201147019 | 0.4376945886586486 | 0.4116523185331633 | 0.2796720236372892 | 0.2551113531630745 | 0.6681593650864589 | 0.4493425660085725 | 0.3891050685085656 | 0.2855396271235698 | 0.9853816616852207 | 0.5329078785278997
AAA2 | 0.9174887951784727 | 0.06021053354449757 | 0.323904029735821 | 0.4516496789909175 | 0.7987395788814695 | 0.3209599404717968 | 0.3832333313327994 | 0.335677008075101 | 0.6877957877769215 | 0.1181300947863829 | 0.05644851974551612 | 0.8888803277326223 | 0.1578486836813363 | 0.4386809772050153
AAA3 | 0.03165944010361044 | 0.6576177287104558 | 0.4755360707974938 | 0.6207628387301758 | 0.07321450188532996 | 0.858101305435617 | 0.4937865684812623 | 0.3261446522953726 | 0.3101382718717731 | 0.06629799080900511 | 0.4727275053759817 | 0.7578419284504315 | 0.7889780244089847 | 0.1942459129945885
AAA4 | 0.788661048487472 | 0.3273912738986058 | 0.8336349460129935 | 0.09400737037913731 | 0.5462743315652893 | 0.6425088604289483 | 0.7665744862168687 | 0.6760594261073571 | 0.1368038688871813 | 0.424875492981092 | 0.7923659992357159 | 0.6901327138702923 | 0.7388415879075142 | 0.1325220578070062
AAA5 | 0.4537986193513155 | 0.8125522220365384 | 0.8540504126857987 | 0.2003924071624348 | 0.07503858848312694 | 0.9296011035076345 | 0.9219019827591107 | 0.1229649209940925 | 0.02122486398516565 | 0.2407544512970485 | 0.5584326460324085 | 0.3393224131383294 | 0.3343512556007134 | 0.8318023750333607
AAA6 | 0.53046347840004 | 0.8941452237968388 | 0.1565848047642774 | 0.2755854438549962 | 0.1001151607498068 | 0.3499342122667286 | 0.4598142183008809 | 0.4262658802462731 | 0.325249331545808 | 0.003812851437876796 | 0.3662259585569283 | 0.5126451517640975 | 0.9216769053839787 | 0.5395453460562013
AAA7 | 0.3046271872093372 | 0.4859221414928693 | 0.3359092495261202 | 0.9703057888400152 | 0.7566640273696764 | 0.1481446647547379 | 0.251008726339409 | 0.5489528664159458 | 0.7250840559839262 | 0.7561485262502097 | 0.761795061712686 | 0.3327390919922674 | 0.05427079704945481 | 0.7890535137559983
AAA8 | 0.8333727591001098 | 0.07361723349973348 | 0.5571101655166276 | 0.08976133963245114 | 0.2180044965548881 | 0.8100659391275494 | 0.5190854081222117 | 0.8952774876052653 | 0.6374735323764665 | 0.7282536325421726 | 0.5652695742119181 | 0.3855203923824529 | 0.93056908110906 | 0.5188928548380424
AAA9 | 0.9671936630271238 | 0.615153706085336 | 0.3157507864836216 | 0.9272047225395537 | 0.1400527036307387 | 0.1200711045027292 | 0.7152232715477896 | 0.8618997642013573 | 0.4114433623275134 | 0.3361380843250414 | 0.3022002272590361 | 0.2107688115563571 | 0.6633358996382306 | 0.09136620858583577
AAA10 | 0.2371535159797016 | 0.1893392457213465 | 0.8347705645734596 | 0.155607818911831 | 0.3937665213727648 | 0.8419715574060945 | 0.9768069433866646 | 0.1694743454753881 | 0.2684600574942785 | 0.342525572503815 | 0.1071570977107554 | 0.5883436114967204 | 0.509025022078626 | 0.4246527497153701
AAA11 | 0.8720230525362653 | 0.2456352887161927 | 0.3302138139208127 | 0.07691802988300378 | 0.3763811340920337 | 0.4885089191761421 | 0.256326485770371 | 0.1828487288117215 | 0.1868369010254204 | 0.514749146131 | 0.3120487105086466 | 0.3747480983246154 | 0.6077345246733206 | 0.9946528823231586
AAA12 | 0.3977698318329868 | 0.9663769199640332 | 0.2213461806061503 | 0.4759326549123196 | 0.9693875263151928 | 0.5879713499480138 | 0.1774938588248669 | 0.9576461885997206 | 0.3895226183243231 | 0.972463042280361 | 0.08596347184609787 | 0.9361507056017849 | 0.6862165948532937 | 0.8133023933816067
AAA13 | 0.05278193910558171 | 0.27506185941422 | 0.5221284612782803 | 0.3779981983503855 | 0.9432815771886064 | 0.03838046323697319 | 0.2838260175200421 | 0.669555172078207 | 0.829650840483765 | 0.2403046017014556 | 0.2915834039400683 | 0.7208369361217994 | 0.7752303082060278 | 0.174934675851603
AAA14 | 0.865381583319998 | 0.9684938608176676 | 0.6636509243928478 | 0.2818585442197494 | 0.789868001930333 | 0.9158643868184685 | 0.3130836145541072 | 0.08910343587631153 | 0.3953160204449752 | 0.4234336885910495 | 0.165788148610906 | 0.5944105293043898 | 0.07524143665357619 | 0.3894483761422828
AAA15 | 0.8753660895255244 | 0.9399102285185835 | 0.9772013715152988 | 0.8344958569015161 | 0.07667665547446534 | 0.1912708247191838 | 0.998390796382387 | 0.4942701255658939 | 0.3535456924384474 | 0.7921582404965584 | 0.9343972153026291 | 0.6112119894490886 | 0.6668224187866607 | 0.3711402164933499
AAA16 | 0.3709445433523803 | 0.6994764442137474 | 0.8957922654585847 | 0.4876215437987995 | 0.7069200038145167 | 0.1402925313829174 | 0.2016537818803712 | 0.847392387604313 | 0.695042894768313 | 0.09329392417784066 | 0.9909056618444052 | 0.8014752415810564 | 0.695790387260716 | 0.5477614264066891
AAA17 | 0.7887245712744345 | 0.5528998389353702 | 0.6544474134810404 | 0.5511407635717839 | 0.5787880369350116 | 0.6731150966888628 | 0.1695541268306335 | 0.858153574082468 | 0.2144317316566458 | 0.102231887597112 | 0.1850579272055236 | 0.6003304284784922 | 0.06594383324492115 | 0.2949712372779097
AAA18 | 0.4023420775039901 | 0.1566139772409374 | 0.0907054976768219 | 0.004454262991933966 | 0.6869738977895518 | 0.8475472314277808 | 0.6338733016762798 | 0.007594870171118484 | 0.6074773865953851 | 0.9691718126330683 | 0.1911362007952219 | 0.3495477534361731 | 0.9883106242705725 | 0.6519486301974373
AAA19 | 0.02867451842516222 | 0.7233751161630935 | 0.6550490646562698 | 0.1558886370915457 | 0.8702359758250845 | 0.0618202438934381 | 0.7019270449205021 | 0.6789945146726725 | 0.8508690378969875 | 0.1812323534988922 | 0.3560626589210679 | 0.5207135782706194 | 0.2145875654584494 | 0.0008701100973876885
AAA20 | 0.04198213446040489 | 0.2236785582656162 | 0.04383828094955766 | 0.4495243955522062 | 0.7658906463069917 | 0.1213897614275722 | 0.07862022927567136 | 0.1900737973040044 | 0.8881282845522334 | 0.6118071305103818 | 0.2094543806445471 | 0.8193017469004266 | 0.45076866037715 | 0.336590565082232
AAA21 | 0.3138891268460962 | 0.3592067091105154 | 0.8233568360670507 | 0.7722946755927553 | 0.9742066819935832 | 0.2785329718836128 | 0.418848183675069 | 0.25735593708758 | 0.7221798115894501 | 0.0338410239186161 | 0.1449324017688042 | 0.7387254132470067 | 0.9515620310324137 | 0.2647849273008033
AAA22 | 0.9293877054468082 | 0.501966511470837 | 0.9925525096415019 | 0.3975564279031016 | 0.157927973725794 | 0.9849470327010444 | 0.1117552639049854 | 0.9113722307656611 | 0.7729385536877109 | 0.1729735486299092 | 0.9499939656846063 | 0.01443680846927486 | 0.9695170047066033 | 0.5360291844226739
AAA23 | 0.9264714569265105 | 0.9688696627216805 | 0.1786785917843824 | 0.9764190704612616 | 0.6644931193542641 | 0.3726841833327851 | 0.9623995797044516 | 0.3577925379658738 | 0.7261648645208928 | 0.0541991663394098 | 0.4470945501785176 | 0.4981417805335937 | 0.63717231993208 | 0.6440811080293407
AAA24 | 0.8720163948845528 | 0.5202819474246566 | 0.2687965096911038 | 0.3891279915003883 | 0.6625143476597843 | 0.702866658384584 | 0.2299877584441462 | 0.8681463469220947 | 0.7068532254139174 | 0.7523374503712181 | 0.7772191261869634 | 0.2347839647121116 | 0.3098801412693298 | 0.1492490940287109
AAA25 | 0.5874482420268575 | 0.9634254483016638 | 0.580560348332193 | 0.8858593757343003 | 0.907888479498183 | 0.06286711977800585 | 0.6630353452394048 | 0.2029191152676688 | 0.8733632717459183 | 0.4138828384256119 | 0.9366174296914633 | 0.02716640226681233 | 0.2323501523932695 | 0.3467702872270159
AAA26 | 0.5886274626537328 | 0.1993745782248398 | 0.4605728224264363 | 0.8563696867615248 | 0.1932442398020893 | 0.4691633216390867 | 0.2844604749206425 | 0.8771439969714117 | 0.1861723854186637 | 0.2864651672520847 | 0.9461483712572021 | 0.2932420098644432 | 0.3233710239665643 | 0.4727109005484345
AAA27 | 0.1273131070554524 | 0.06977523891689297 | 0.9054976293439573 | 0.3436310755894524 | 0.8503847305873465 | 0.8460163356723613 | 0.1340268214080448 | 0.5685818465377166 | 0.7745287853571934 | 0.7705351124152051 | 0.3386515735761551 | 0.6521768170205262 | 0.5881328342352338 | 0.05938102572959569
AAA28 | 0.6594801892019132 | 0.7036524560781204 | 0.1228728872522747 | 0.560654410616761 | 0.0223669281700003 | 0.7124877210610046 | 0.6164886994224278 | 0.2724896869555054 | 0.6191685550815655 | 0.5953734323821213 | 0.5867417784958481 | 0.7208427928890003 | 0.6624452893621782 | 0.6025971570888203
AAA29 | 0.4493492004385351 | 0.7201659445674237 | 0.280263246679363 | 0.9259357642243373 | 0.03588148777869693 | 0.4608179167844643 | 0.3029950336721783 | 0.2929899046506446 | 0.0798160137407683 | 0.9155214699211345 | 0.7992417428024694 | 0.9953857129158604 | 0.08955580669619279 | 0.5090085741118543
AAA30 | 0.3744157645455011 | 0.4923451326934298 | 0.8616006013735467 | 0.04336220285009318 | 0.163315698124523 | 0.004509693571577933 | 0.6619761617034892 | 0.5788833134738566 | 0.586967505596506 | 0.8367796963783931 | 0.7046566179938792 | 0.9045522216785283 | 0.3224663931961335 | 0.1905128789679311
AAA31 | 0.5306647684814896 | 0.9256393764011189 | 0.9768148705712119 | 0.06852909981665634 | 0.269157146155658 | 0.788298465654999 | 0.6154467617613619 | 0.3984203383380668 | 0.2122462206851208 | 0.8816444214660247 | 0.7548109331587006 | 0.1327759984087239 | 0.8950562277481444 | 0.5958479336648898
AAA32 | 0.9147877092196487 | 0.12611739668093 | 0.6594151192945353 | 0.5092920467897508 | 0.2482102069425667 | 0.08850281729774212 | 0.17078713958889 | 0.03973880305224053 | 0.462415385467155 | 0.5771751701741185 | 0.4607125269853342 | 0.4998766554479097 | 0.3684054020632448 | 0.9802367960533863
AAA33 | 0.5341371714075769 | 0.8022021968283487 | 0.6833214732142555 | 0.7111992908479555 | 0.8096224826404491 | 0.503010815836755 | 0.2579829027903994 | 0.1156341231955617 | 0.9325688222893216 | 0.009461132962913843 | 0.8947540875535156 | 0.2424899324407995 | 0.798256876789352 | 0.3290187790514484
AAA34 | 0.07567854823001818 | 0.4757198832040817 | 0.4371430822795114 | 0.9945903842302877 | 0.9443632340294821 | 0.5847821639618858 | 0.2944569124861766 | 0.18357609177948 | 0.3278659098728188 | 0.6360030389593059 | 0.7201529448535264 | 0.1411908854278928 | 0.4238706091013468 | 0.2263778612899479
AAA35 | 0.2905317610232044 | 0.02105907117285466 | 0.9536356360331624 | 0.01450787491781991 | 0.4114164221133292 | 0.2735515755910585 | 0.8974187864136896 | 0.9607589276137126 | 0.6584821420449605 | 0.2533041534707332 | 0.9884799260627873 | 0.2139120675931585 | 0.6352259781487715 | 0.7209478991885631
AAA36 | 0.7814072386235945 | 0.1768481708799641 | 0.5577207724515908 | 0.06569253319471535 | 0.9983484839419555 | 0.6150268365945895 | 0.6329562753581524 | 0.7853521599382065 | 0.06659189546619337 | 0.3497741178394479 | 0.02089203389556682 | 0.8744117113629964 | 0.3854731130804614 | 0.7099131581360116
AAA37 | 0.05447191956396802 | 0.8878798330699353 | 0.4502566740916641 | 0.6651228420353759 | 0.3890892940647142 | 0.2934728592541158 | 0.3180993678940972 | 0.3745551770910011 | 0.1795232526810366 | 0.07611795670553734 | 0.1352666354675184 | 0.3938974126877299 | 0.3331248466142199 | 0.7347243289154727
AAA38 | 0.7103327244056676 | 0.8224278791668811 | 0.1102199494001075 | 0.8638538324156567 | 0.8731473229301364 | 0.5033318666372274 | 0.1119489318484154 | 0.5573774924988121 | 0.6606077538868076 | 0.9323469145703752 | 0.3137887045761114 | 0.7561312796413292 | 0.2009140228092424 | 0.7676830282628122
AAA39 | 0.2419411923273791 | 0.9461045624801071 | 0.8074864146475874 | 0.41126162986392 | 0.6786484917952322 | 0.9255987642877913 | 0.9735854830865587 | 0.6560242960392287 | 0.4215472426641608 | 0.07107801377692746 | 0.8494610734501409 | 0.9754311517979884 | 0.9926312197022804 | 0.6243682675190567
AAA40 | 0.08623828540281675 | 0.242776078582419 | 0.5446197553338635 | 0.3018198712139842 | 0.8294202582054265 | 0.8288468594351653 | 0.2804983652940322 | 0.3670436211536177 | 0.4792937824503724 | 0.8196539851864743 | 0.5988614537792437 | 0.06296126213547404 | 0.1962093353964167 | 0.8781803116730627
AAA41 | 0.4987819787135536 | 0.7061472636215532 | 0.6516918181886033 | 0.4747925669946826 | 0.8930450915772596 | 0.01715137142145984 | 0.3301058182687815 | 0.7796462052084353 | 0.8224426490273163 | 0.389540119476293 | 0.964497093504568 | 0.3813136645079466 | 0.5495597400576681 | 0.3059024995170704
AAA42 | 0.699301133918603 | 0.2066796573273485 | 0.2506806165424088 | 0.7302873470798554 | 0.2468368419241529 | 0.3949013472744354 | 0.4159623186625444 | 0.4904023464990536 | 0.1764947130481922 | 0.908022518817124 | 0.6152309796266122 | 0.2181276312899763 | 0.5247264978526632 | 0.9896825431685946
AAA43 | 0.2268534076366892 | 0.2383787298860686 | 0.1367496402635952 | 0.4058029925688281 | 0.4973582683572723 | 0.4781163628565361 | 0.1059111694227366 | 0.05989012649380276 | 0.1916303163636615 | 0.2833344663105027 | 0.6430563371919202 | 0.6297429759879936 | 0.5300866464964539 | 0.2062590529536135
AAA44 | 0.6601650851781383 | 0.5919843522687318 | 0.4125761462739178 | 0.9120540127476809 | 0.1030240771615433 | 0.04402135959462516 | 0.9343585896631637 | 0.5766036447003023 | 0.8457579316775837 | 0.4967332925683703 | 0.02659618049795742 | 0.7565209000479386 | 0.4174714823780586 | 0.187931566582588
AAA45 | 0.2196167494498613 | 0.9803763175196675 | 0.9136297882915 | 0.917999553641731 | 0.5690440969039838 | 0.2801824690922514 | 0.9197559466608269 | 0.2675416722746211 | 0.7979087981383225 | 0.9321009953547559 | 0.5082872842837395 | 0.2166714564855934 | 0.08321655469141098 | 0.003526763030048952
AAA46 | 0.2509618700518707 | 0.8769449432981625 | 0.09062566457435484 | 0.5281075771366749 | 0.5737248056092503 | 0.9579195266151215 | 0.5971237451004647 | 0.8650111840071757 | 0.1495532551634146 | 0.6144378238376164 | 0.1765363797579769 | 0.2513680921359887 | 0.6139013210075606 | 0.4738077056058672
AAA47 | 0.3406960731569483 | 0.02019330986420764 | 0.3972780592972714 | 0.04386085702011699 | 0.1479144199579331 | 0.09464136904612741 | 0.3853945822611485 | 0.6308245164758632 | 0.2447420825932184 | 0.08968859714835864 | 0.06126100279997337 | 0.2466348718957418 | 0.02808244063626431 | 0.648469931150851
AAA48 | 0.4549990945132094 | 0.7986103471040154 | 0.2428286476391166 | 0.1614492630288915 | 0.5626630571111978 | 0.0160894941375993 | 0.4316782891859116 | 0.9113363892783719 | 0.08613328002231013 | 0.2656018302489941 | 0.5149527384692985 | 0.536025220408148 | 0.3136931480614118 | 0.7071720619109318
AAA49 | 0.7026148443846669 | 0.1052939442645409 | 0.1219210923078843 | 0.9354174458504294 | 0.7477098198838197 | 0.8610309989818943 | 0.922918620815804 | 0.03983333792362964 | 0.4129555552360109 | 0.6270104139284125 | 0.07827093058677659 | 0.05147840002766513 | 0.05593558461260795 | 0.868286502173763
AAA50 | 0.4195620475324342 | 0.8499396713310879 | 0.4558163162672464 | 0.7731422270757945 | 0.2199218665739358 | 0.415628402339145 | 0.2133959160467187 | 0.5742040264568072 | 0.6870807747148954 | 0.8258799496271894 | 0.2797467937827565 | 0.3284083507371364 | 0.1891504629536787 | 0.07888949004368295
Maximum
Median
Minimum
First Quartile
*Which companies perform at or below the first quartile threshhold?