I had to do a contingency table based on the GDP and exports of some contries and after that to group the countries by the X variable( exports in my case) but I do not know how to group them. I really need some guidance.I've attached the table I did.( sheet 3)Thanks!
Sheet1 UE+EECCA+WBGDP/cap(2008)GDP intervalsNo. of countriesMidpointsni*xi Tajikistan16401640-13605,4137622.799095.1 Kyrgyzstan205313605,4-25570,81119588.1215469.1 Republic of Moldova276825570,8-37536,21331553.5410195.5 Armenia561737536,2-49501,6243518.987037.8 Bosnia and Herzegovina663249501,6-61467055484.30 Ukraine676661467-73432,4167449.767449.7 Albania7047879247.2 Azerbaijan8085 The former Yugoslav Republic of Macedonia9172Average for frequency data series Kazakhstan10479 Belarus11356X=917360,7/4022934.017 Romania11580 Bulgaria11991Median Russian Federation14767Loc.Me=20,5 Latvia15498Median interval: [13605,4-25570,8) Poland16459Me=13605,4+11965,4*(20,5-13)/11 Croatia17299Me=21741,872 Lithuania17668 Hungary17901Mode Estonia18938The modal interval: (1640-13605,4)[25570,8-37536,2) Slovakia20433Mo=1640+11965,4*(13/24)Mo=25570,8+11965,4*(2/11) Portugal22037Mo=8101,316Mo=27724,572 Malta23024 Czech Republic24347Variance Greece26113var=203449116,446 Cyprus26319 Slovenia27216St. dev.=14263,56 Spain28330C.V.=62,19% Italy28454 France30379Absolute skweness Finland33443as=22934,017-8101,316as=22934,017-27724,572 Belgium33599as=14832,701as=-4790,555 United Kingdom33715 Germany33825 Denmark34133Cas=14832,701/14263,56Cas=-4790,555/14263,56 Sweden34299Cas=1,04Cas=-0,34 Austria36179 Netherlands38119 Ireland39141n=40 Luxembourg73432N=52 X=22934,017 S=14263,56 Mean21506.325N<20n=>we have a finite pop. Median19685.5σx=σ/n^1/2*[(N-n)/(N-1)]^1/2 ModeERROR:#N/AX-E<>
<><25107,5 variance="" 194942687.301923="" standard="" deviation="" 13962.187="" c.v.="" 64.92%="" rx="71792" r="6" k="11965,4" http://live.unece.org/fileadmin/dam/stats/profiles2009/albania.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/cyprus.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/czech_republic.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/denmark.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/estonia.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/finland.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/france.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/germany.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/greece.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/hungary.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/ireland.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/armenia.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/italy.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/kazakhstan.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/kyrgyzstan.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/latvia.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/lithuania.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/luxembourg.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/malta.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/netherlands.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/poland.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/portugal.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/austria.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/romania.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/russian_federation.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/slovakia.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/slovenia.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/spain.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/sweden.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/tajikistan.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/tfyr_macedonia.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/ukraine.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/united_kingdom.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/azerbaijan.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/belarus.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/belgium.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/bosnia_herzegovina.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/bulgaria.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/croatia.pdf="" sheet2="" ue+eecca+wb="" exports="" of="" goods="" &="" services(2008)="" armenia="" 913="" kyrgyzstan="" 969="" exports="" intervals="" no.="" of="" countries="" midpoints="" tajikistan="" 1040="" 913-22423="" 36="" 11668="" republic="" of="" moldova="" 1406="" 22423-43933="" 3="" 33178="" albania="" 2040="" 43933-65443="" 0="" 54688="" bosnia="" and="" herzegovina="" 2473="" 65443-86953="" 0="" 76198="" ukraine="" 3032="" 86953-108463="" 0="" 97708="" the="" former="" yugoslav="" republic="" of="" macedonia="" 3918="" 108463-129973="" 1="" 119218="" romania="" 4013="" russian="" federation="" 4827="" kazakhstan="" 5276="" average="" for="" frequency="" data="" series="" azerbaijan="" 5924="" x="15970" belarus="" 6067="" greece="" 6342="" median="" bulgaria="" 6650="" loc.me="20,5" poland="" 6854="" median="" interval:[913-22423)="" portugal="" 7038="" me="913+21510*[(20,5-0)/36]" croatia="" 7278="" me="13173,7" spain="" 7541="" latvia="" 7572="" mode="" italy="" 8023="" modal="" interval:[913-22423)="" france="" 8205="" mo="913+21510*(36/69)" united="" kingdom="" 9458="" mo="12098,2" lithuania="" 10727="" cyprus="" 12400="" variance="" estonia="" 14288="" var="305368866" germany="" 16186="" st.="" dev.="17474,8" finland="" 16255="" c.v.="109,42%" hungary="" 16269="" slovakia="" 17525="" absolute="" skewness="" czech="" republic="" 17693="" as="15970-12098,2" sweden="" 18178="" as="3871,8" denmark="" 18569="" slovenia="" 19021="" cas="3871,8/17474,8=0,22" malta="" 20813="" austria="" 21249="" n="40" belgium="" 27959="" n="52" netherlands="" 28250="" s="17474,8" ireland="" 33254="" x="15970" luxembourg="" 129973=""><20n σx="(17474,8/6,3)*(12/51)^1/2=1331,37" e="2*1331,37=2662,74" mean="" 13886.7=""><><18632,74 median7797.5 modeerror:#n/a range absolute129060 relative929.37% variance420995036.112821 standard deviation20518.163 c.v.147.75% rx=129060 r=6 k=21510 http://live.unece.org/fileadmin/dam/stats/profiles2009/albania.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/czech_republic.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/denmark.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/estonia.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/finland.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/greece.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/hungary.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/kazakhstan.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/kyrgyzstan.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/latvia.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/lithuania.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/armenia.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/luxembourg.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/malta.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/poland.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/portugal.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/romania.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/russian_federation.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/slovakia.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/slovenia.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/spain.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/sweden.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/austria.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/tajikistan.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/tfyr_macedonia.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/ukraine.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/united_kingdom.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/azerbaijan.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/belarus.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/belgium.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/bosnia_herzegovina.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/bulgaria.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/cyprus.pdf sheet3 137622.7 1119588.1 1331553.5 243518.9 055484.3 167449.7 for gdp for exports 3611668 333178 054688 076198 097708 1119218 contingency table gdp intervals exports intervals 913-2242322423-4393343933-6544365443-8695386953-108463108463-129973total 1640-13605,49000009 13605,4-25570,8110000011 25570,8-37536,2121000013 37536,2-49501,60200002 49501,6-614670000000 61467-73432,40000011 total323000136 7622.719588.09999999999931553.543518.955484.367449.713111320111668331785468876198977081192183630001 median="" 7797.5="" mode="" error:#n/a="" range="" absolute="" 129060="" relative="" 929.37%="" variance="" 420995036.112821="" standard="" deviation="" 20518.163="" c.v.="" 147.75%="" rx="129060" r="6" k="21510" http://live.unece.org/fileadmin/dam/stats/profiles2009/albania.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/czech_republic.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/denmark.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/estonia.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/finland.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/greece.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/hungary.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/kazakhstan.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/kyrgyzstan.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/latvia.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/lithuania.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/armenia.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/luxembourg.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/malta.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/poland.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/portugal.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/romania.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/russian_federation.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/slovakia.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/slovenia.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/spain.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/sweden.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/austria.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/tajikistan.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/tfyr_macedonia.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/ukraine.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/united_kingdom.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/azerbaijan.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/belarus.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/belgium.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/bosnia_herzegovina.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/bulgaria.pdfhttp://live.unece.org/fileadmin/dam/stats/profiles2009/cyprus.pdf="" sheet3="" 13="" 7622.7="" 11="" 19588.1="" 13="" 31553.5="" 2="" 43518.9="" 0="" 55484.3="" 1="" 67449.7="" for="" gdp="" for="" exports="" 36="" 11668="" 3="" 33178="" 0="" 54688="" 0="" 76198="" 0="" 97708="" 1="" 119218="" contingency="" table="" gdp="" intervals="" exports="" intervals="" 913-22423="" 22423-43933="" 43933-65443="" 65443-86953="" 86953-108463="" 108463-129973="" total="" 1640-13605,4="" 9="" 0="" 0="" 0="" 0="" 0="" 9="" 13605,4-25570,8="" 11="" 0="" 0="" 0="" 0="" 0="" 11="" 25570,8-37536,2="" 12="" 1="" 0="" 0="" 0="" 0="" 13="" 37536,2-49501,6="" 0="" 2="" 0="" 0="" 0="" 0="" 2="" 49501,6-61467="" 0="" 0="" 0="" 0="" 0="" 0="" 0="" 61467-73432,4="" 0="" 0="" 0="" 0="" 0="" 1="" 1="" total="" 32="" 3="" 0="" 0="" 0="" 1="" 36="" 7622.7="" 19588.099999999999="" 31553.5="" 43518.9="" 55484.3="" 67449.7="" 13="" 11="" 13="" 2="" 0="" 1="" 11668="" 33178="" 54688="" 76198="" 97708="" 119218="" 36="" 3="" 0="" 0="" 0="">