（办公常用表格）Excel可视化图表模板059（可编辑）.xls

《（办公常用表格）Excel可视化图表模板059（可编辑）.xls》由会员分享，可在线阅读，更多相关《（办公常用表格）Excel可视化图表模板059（可编辑）.xls（231页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、410rank Countrysalaryrecords#1Australia 93k $81#2Canada 90k $58#3Germany 80k $17#4Netherlands 73k $23#5USA 73k $617#6New Zealand 70k $15#7UK 67k $154#8Singapore 52k $13#9South Africa 50k $19#10 Spain 46k $10showing items with 10+ records per itemview byCountryactive filters:USAIndiaUKAustraliaCanada

2、PakistanNetherlandsBrazilUAESouth AfricaUSA 73k $11010010000k25k50k75k100k125k150knumber of Survey Records - logaritmical axisSalary in USDGOOD reliabilityPOOR reliability1stChooseyourView2ndApplyyourFilters3rdSet theThresholdofReliabilityFollow 3 steps to know the truth.SALARY SURVEY 2012 at The su

3、rvey responses are coming from.(Vetko)(Vetko)(Vetko)(Vetko)Country.Job Type.Experience.Hours.Continent.How many records per item are sufficient for a reliable result?Where are all the 1883 survey responses coming from?from people working with Excel dailywith 0 - 40 Years of experience*having 10 vari

4、ous job typesliving in 105 countriesall over the world4 - 6 hours41% 5 years31%Analyst39%USA33%Asia38%8 hours25%5 - 9 years 31%Manager30%India30%North America37%2 - 3 hours24%10-14 years18%Accountant7%UK8%Europe17%1 - 2 hours9%15-19 years 9%Consultant5%Australia4%Oceania5%0 hours0%20-24 years 6%Repo

5、rting4%Canada3%Africa2%25+4%all others15%all others22%South America2%* doesnt include responseswithout info about experience(Vetko)ContinentCountryJob TypeExperienceHours N/A in this Viewinteractivedata visualizationcreated by Lubos PribulaLanguage version(Vetko)Selected Continent(Vetko)1#VALUE!Sele

6、cted Country(Vetko)1Selected Job Type(Vetko)1Selected Experience(Vetko)1Selected Hours(Vetko)1views switchContinentFALSECountryTRUEJob TypeFALSEExperienceFALSEHoursFALSEselected viewCountryscroll ranking0active filterLISTs(Vetko)(Vetko)(Vetko)Accountant 5 years1 or 2 hours a dayAnalyst5 - 9 years2 t

7、o 3 hours per dayConsultant10-14 years4 to 6 hours a dayController15-19 yearsAll the 8 hours baby, all the 8!CXO or Top Mgmt.20-24 yearsExcel ?!? What Excel?Engineer25+ yearsManagerMisc.ReportingSpecialist(Vetko)Continent(Vetko)AlbaniaCountryAfricaarabian GulfJob TypeAsiaArgentinaExperienceEuropeArm

8、eniaHoursNorth AmericaArubaOceaniaAsiaSouth AmericaAustraliaAustriaAzerbaijanBalticBangladeshBelgiumBermudaBhutanBoliviaBrazilBulgariaCambodiaCanadaCEECentral AmericaColombiaCosta RicaCroatiaCzech RepublicDenmarkDominican RepublicDubaiEgyptEstoniaEthiopiaEuropeFinlandFranceGermanyGhanaGreeceGuyanaHo

9、ng KongHungarychinaIcelandIndiaIndonesiairanIrelandIsraelitalyJapanKenyaKuwaitKuwait Latin AmericaLesothoLibyaLithuaniamalaysiaMauritiusMexicoMongoliaMontenegroMoroccomozambiqueMyanmarMYSNetherlandsNew ZealandNigeriaNorwayOmanPakistanPanamaParaguayPeruPhilippinesPolandPortugalQatarRepublic of Georgi

10、aRepublica DominicanaRomaniaRussiaSaudi Arabiaself-employedSingaporeSlovakiaSloveniaSomaliaSouth AfricaSpainSri LankaSwedenSwitzerlandThailandTunisiaTurkeyUAEUgandaUKUkraineUruguayUSAVietnamZambiaZimbabweSurvey Statisticsfrom people working with Excel dailywith 0 - 40 Years of experience*having 10 v

11、arious job typesliving in 105 countries4 - 6 hours41% 5 years31%Analyst39%USA8 hours25%5 - 9 years 31%Manager30%India2 - 3 hours24%10-14 years 18%Accountant7%UK1 - 2 hours9%15-19 years 9%Consultant5%Australia0 hours0%20-24 years 6%Reporting4%Canada25+4%all others15%all others* doesnt include respons

12、eswithout info about experienceall over the world33%Asia38%30%North America37%8%Europe17%4%Oceania5%3%Africa2%22%South America2%living in 105 countriestotal number of records1883the source of recordsdajedajeunique IDs aver.salaryGEO1share of IDs aver.salaryCelkom188349,815Asia38%17,101North America3

13、7%73,428Europe17%63,182Oceania5%89,331Africa2%42,576South America2%32,356N/A0%50,000Celkov set100%49,815countries105job types10dajedajeclean Countryshare of IDs aver.salaryJob Typeshare of IDs aver.salaryUSA33%72,738Analyst39%46,296India30%13,529Manager30%46,488UK8%67,241Accountant7%54,196Australia4

14、%92,858Consultant5%62,951Canada3%89,800Reporting4%19,574Pakistan2%11,874CXO or Top Mgmt.4%97,266Netherlands1%73,006Engineer4%51,715Brazil1%42,672Controller4%65,104UAE1%43,015Specialist3%59,813South Africa1%49,556Misc.0%45,952Germany1%79,637Celkov set100%49,815New Zealand1%70,288Singapore1%52,155Saud

15、i Arabia1%35,832Philippines1%17,479Spain1%46,236Portugal1%32,908Mexico1%32,138Russia0%55,905Indonesia0%28,873Norway0%99,016malaysia0%24,996Romania0%16,450Poland0%34,210italy0%47,259France0%56,953Denmark0%82,526Sri Lanka0%22,921Colombia0%12,362Israel0%66,840Ireland0%61,652Hungary0%24,716Europe0%123,8

16、89Ukraine0%11,650Switzerland0%137,526Dubai0%32,167Belgium0%41,707Qatar0%53,067Croatia0%43,490Nigeria0%13,495Finland0%75,389Greece0%30,066Kuwait0%42,667Japan0%67,565iran0%18,000Zambia0%13,000Vietnam0%10,000Turkey0%48,000Thailand0%73,000CEE0%87,168Bangladesh0%10,299Sweden0%84,477Panama0%44,760china0%1

17、7,046Myanmar0%17,700Zimbabwe0%36,400Lithuania0%15,000Egypt0%19,831Mauritius0%9,376Cambodia0%3,000Mongolia0%7,262Montenegro0%13,500Morocco0%13,746mozambique0%24,000Libya0%24,864MYS0%12,000Armenia0%6,000Iceland0%41,731Lesotho0%177,600Central America0%95,000Oman0%100,800Asia0%12,000Latin America0%4,400

18、Paraguay0%20,000Peru0%15,840Bolivia0%9,600Hong Kong0%20,000Bulgaria0%14,400Guyana0%6,000Republic of Georgia0%5,250Republica Dominicana0%15,404Costa Rica0%28,110Aruba0%5,000Bhutan0%4,800self-employed0%50,000Bermuda0%78,000Slovakia0%13,000Slovenia0%19,056Somalia0%78,000Baltic0%8,400Austria0%50,816Ghan

19、a0%18,000Kuwait 0%15,600arabian Gulf0%21,000Kenya0%51,497Tunisia0%11,000Czech Republic0%36,000Azerbaijan0%36,000Uganda0%100,000Argentina0%24,000Dominican Republic0%6,629Uruguay0%35,000Albania0%20,571Estonia0%12,000Ethiopia0%2,954Celkov set100%49,815Years of ExperiencedajeYears of Experience2share of

20、 IDs aver.salary 5 years0.314606742 28482.11285 - 9 years0.312359551 39133.844310-14 years0.178277154 56704.162315-19 years0.087640449 63951.941120-24 years0.063670412 71265.649425+ years0.043445693 80468.0592Celkov set1 44931.8321Excel hours dailydajeHow many hours of a day you work on Excelshare o

21、f IDs aver.salary4 - 6 hours41%51,4238 hours25%43,5712 - 3 hours24%53,5551 - 2 hours9%49,7260 hours0%57,493Celkov set100%49,815CONTINENT viewJob Type(Vetko)clean Country(Vetko)Years of Experience2(Vetko)How many hours of a day you work on Excel(Vetko)dajeGEO1aver.salaryno. of IDs ReliabilityOceania8

22、9,33196TRUENorth America73,428689TRUEEurope63,182311TRUEN/A50,0001FALSEAfrica42,57637TRUESouth America32,35636TRUEAsia17,101713TRUECOUNTRY viewGEO1(Vetko)Job Type(Vetko)Years of Experience2(Vetko)How many hours of a day you work on Excel(Vetko)dajeclean Countryaver.salaryno. of IDs ReliabilityLesoth

23、o177,6001FALSESwitzerland137,5264FALSEEurope123,8895FALSEOman100,8001FALSEUganda100,0001FALSENorway99,0167FALSECentral America95,0001FALSEAustralia92,85881TRUECanada89,80058TRUECEE87,1682FALSESweden84,4772FALSEDenmark82,5266FALSEGermany79,63717TRUESomalia78,0001FALSEBermuda78,0001FALSEFinland75,3893

24、FALSENetherlands73,00623TRUEThailand73,0002FALSEUSA72,738617TRUENew Zealand70,28815TRUEJapan67,5653FALSEUK67,241154TRUEIsrael66,8405FALSEIreland61,6525FALSEFrance56,9536FALSERussia55,9059FALSEQatar53,0673FALSESingapore52,15513TRUEKenya51,4971FALSEAustria50,8161FALSEself-employed50,0001FALSESouth Afr

25、ica49,55619TRUETurkey48,0002FALSEitaly47,2596FALSESpain46,23610TRUEPanama44,7602FALSECroatia43,4903FALSEUAE43,01519TRUEBrazil42,67220TRUEKuwait42,6673FALSEIceland41,7311FALSEBelgium41,7074FALSEZimbabwe36,4001FALSEAzerbaijan36,0001FALSECzech Republic36,0001FALSESaudi Arabia35,83211TRUEUruguay35,0001F

26、ALSEPoland34,2106FALSEPortugal32,90810TRUEDubai32,1674FALSEMexico32,13810TRUEGreece30,0663FALSEIndonesia28,8738FALSECosta Rica28,1101FALSEmalaysia24,9967FALSELibya24,8641FALSEHungary24,7165FALSEArgentina24,0001FALSEmozambique24,0001FALSESri Lanka22,9215FALSEarabian Gulf21,0001FALSEAlbania20,5711FALS

27、EHong Kong20,0001FALSEParaguay20,0001FALSEEgypt19,8311FALSESlovenia19,0561FALSEiran18,0003FALSEGhana18,0001FALSEMyanmar17,7002FALSEPhilippines17,47911TRUEchina17,0462FALSERomania16,4506FALSEPeru15,8401FALSEKuwait 15,6001FALSERepublica Dominicana15,4041FALSELithuania15,0001FALSEBulgaria14,4001FALSEMo

28、rocco13,7461FALSEIndia13,529565TRUEMontenegro13,5001FALSENigeria13,4953FALSEZambia13,0002FALSESlovakia13,0001FALSEColombia12,3625FALSEEstonia12,0001FALSEMYS12,0001FALSEAsia12,0001FALSEPakistan11,87429TRUEUkraine11,6504FALSETunisia11,0001FALSEBangladesh10,2992FALSEVietnam10,0002FALSEBolivia9,6001FALS

29、EMauritius9,3761FALSEBaltic8,4001FALSEMongolia7,2621FALSEDominican Republic6,6291FALSEArmenia6,0001FALSEGuyana6,0001FALSERepublic of Georgia5,2501FALSEAruba5,0001FALSEBhutan4,8001FALSELatin America4,4001FALSECambodia3,0001FALSEEthiopia2,9541FALSEJOB TYPE viewGEO1(Vetko)clean Country(Vetko)Years of E

30、xperience2(Vetko)How many hours of a day you work on Excel(Vetko)dajeJob Typeaver.salaryno. of IDs ReliabilityCXO or Top Mgmt.97,26675TRUEController65,10467TRUEConsultant62,95190TRUESpecialist59,81351TRUEAccountant54,196135TRUEEngineer51,71574TRUEManager46,488558TRUEAnalyst46,296743TRUEMisc.45,9527F

31、ALSEReporting19,57483TRUEEXPERIENCE viewGEO1(Vetko)Job Type(Vetko)clean Country(Vetko)How many hours of a day you work on Excel(Vetko)dajeYears of Experience2aver.salaryno. of IDs Reliability25+ years80468.0592258TRUE20-24 years71265.6493985TRUE15-19 years63951.94105117TRUE10-14 years56704.1623238TR

32、UE5 - 9 years39133.84433417TRUE 5 years28482.11279420TRUEHOURS viewGEO1(Vetko)Job Type(Vetko)clean Country(Vetko)Years of Experience2(Vetko)dajeHow many hours of a day you work on Excelaver.salaryno. of IDs ReliabilityExcel ?!?57,4937FALSE2 to 3 hours53,555451TRUE4 to 6 hours51,423775TRUE1 or 2 hour

33、s49,726174TRUE8 hours43,571476TRUECONTINENT viewJob Type(Vetko)clean Country(Vetko)Years of Experience2(Vetko)How many hours of a day you work on Excel(Vetko)dajeGEO1no. of IDsaver.salaryGEO1Asia71317,101AsiaNorth America68973,428North AmericaEurope31163,182EuropeOceania9689,331OceaniaAfrica3742,576

34、AfricaSouth America3632,356South AmericaN/A150,000no. of IDs aver.salaryreliableunreliable71317,10117101#N/A68973,42873428#N/A31163,18263182#N/A9689,33189331#N/A3742,57642576#N/A3632,35632356#N/ACOUNTRY viewGEO1(Vetko)Job Type(Vetko)Years of Experience2(Vetko)How many hours of a day you work on Exce

35、l(Vetko)dajeclean Countryno. of IDsaver.salaryUSA61772,738India56513,529UK15467,241Australia8192,858Canada5889,800Pakistan2911,874Netherlands2373,006Brazil2042,672UAE1943,015South Africa1949,556Germany1779,637New Zealand1570,288Singapore1352,155Saudi Arabia1135,832Philippines1117,479Spain1046,236Por

36、tugal1032,908Mexico1032,138Russia955,905Indonesia828,873Norway799,016malaysia724,996Romania616,450Poland634,210italy647,259France656,953Denmark682,526Sri Lanka522,921Colombia512,362Israel566,840Ireland561,652Hungary524,716Europe5123,889Ukraine411,650Switzerland4137,526Dubai432,167Belgium441,707Qatar

37、353,067Croatia343,490Nigeria313,495Finland375,389Greece330,066Kuwait342,667Japan367,565iran318,000Zambia213,000Vietnam210,000Turkey248,000Thailand273,000CEE287,168Bangladesh210,299Sweden284,477Panama244,760china217,046Myanmar217,700Zimbabwe136,400Lithuania115,000Egypt119,831Mauritius19,376Cambodia13

38、,000Mongolia17,262Montenegro113,500Morocco113,746mozambique124,000Libya124,864MYS112,000Armenia16,000Iceland141,731Lesotho1177,600Central America195,000Oman1100,800Asia112,000Latin America14,400Paraguay120,000Peru115,840Bolivia19,600Hong Kong120,000Bulgaria114,400Guyana16,000Republic of Georgia15,25

39、0Republica Dominicana115,404Costa Rica128,110Aruba15,000Bhutan14,800self-employed150,000Bermuda178,000Slovakia113,000Slovenia119,056Somalia178,000Baltic18,400Austria150,816Ghana118,000Kuwait 115,600arabian Gulf121,000Kenya151,497Tunisia111,000Czech Republic136,000Azerbaijan136,000Uganda1100,000Argen

40、tina124,000Dominican Republic16,629Uruguay135,000Albania120,571Estonia112,000Ethiopia12,954CONTINENT viewGEO1(Vetko)Job Type(Vetko)Years of Experience2(Vetko)How many hours of a day you work on Excel(Vetko)dajeclean CountryPoet z Unique ID Priemer z Salary in USDUSA61772,738India56513,529UK15467,241

41、Australia8192,858Canada5889,800Pakistan2911,874Netherlands2373,006Brazil2042,672UAE1943,015South Africa1949,556Germany1779,637New Zealand1570,288Singapore1352,155Saudi Arabia1135,832Philippines1117,479Spain1046,236Portugal1032,908Mexico1032,138Russia955,905Indonesia828,873Norway799,016malaysia724,99

42、6Romania616,450Poland634,210italy647,259France656,953Denmark682,526Sri Lanka522,921Colombia512,362Israel566,840Ireland561,652Hungary524,716Europe5123,889Ukraine411,650Switzerland4137,526Dubai432,167Belgium441,707Qatar353,067Croatia343,490Nigeria313,495Finland375,389Greece330,066Kuwait342,667Japan367

43、,565iran318,000Zambia213,000Vietnam210,000Turkey248,000Thailand273,000CEE287,168Bangladesh210,299Sweden284,477Panama244,760china217,046Myanmar217,700Zimbabwe136,400Lithuania115,000Egypt119,831Mauritius19,376Cambodia13,000Mongolia17,262Montenegro113,500Morocco113,746mozambique124,000Libya124,864MYS11

44、2,000Armenia16,000Iceland141,731Lesotho1177,600Central America195,000Oman1100,800Asia112,000Latin America14,400Paraguay120,000Peru115,840Bolivia19,600Hong Kong120,000Bulgaria114,400Guyana16,000Republic of Georgia15,250Republica Dominicana115,404Costa Rica128,110Aruba15,000Bhutan14,800self-employed15

45、0,000Bermuda178,000Slovakia113,000Slovenia119,056Somalia178,000Baltic18,400Austria150,816Ghana118,000Kuwait 115,600arabian Gulf121,000Kenya151,497Tunisia111,000Czech Republic136,000Azerbaijan136,000Uganda1100,000Argentina124,000Dominican Republic16,629Uruguay135,000Albania120,571Estonia112,000Ethiop

46、ia12,954Celkov set188349,815clean Countryno. of IDs aver.salaryreliableunreliableUSA61772,73872738#N/AIndia56513,52913529#N/AUK15467,24167241#N/AAustralia8192,85892858#N/ACanada5889,80089800#N/APakistan2911,87411874#N/ANetherlands2373,00673006#N/ABrazil2042,67242672#N/AUAE1943,01543015#N/ASouth Afri

47、ca1949,55649556#N/AGermany1779,63779637#N/ANew Zealand1570,28870288#N/ASingapore1352,15552155#N/ASaudi Arabia1135,83235832#N/APhilippines1117,47917479#N/ASpain1046,23646236#N/APortugal1032,90832908#N/AMexico1032,13832138#N/ARussia955,905#N/A55905Indonesia828,873#N/A28873Norway799,016#N/A99016malaysi

48、a724,996#N/A24996Romania616,450#N/A16450Poland634,210#N/A34210italy647,259#N/A47259France656,953#N/A56953Denmark682,526#N/A82526Sri Lanka522,921#N/A22921Colombia512,362#N/A12362Israel566,840#N/A66840Ireland561,652#N/A61652Hungary524,716#N/A24716Europe5123,889#N/A123889Ukraine411,650#N/A11650Switzerl

49、and4137,526#N/A137526Dubai432,167#N/A32167Belgium441,707#N/A41707Qatar353,067#N/A53067Croatia343,490#N/A43490Nigeria313,495#N/A13495Finland375,389#N/A75389Greece330,066#N/A30066Kuwait342,667#N/A42667Japan367,565#N/A67565iran318,000#N/A18000Zambia213,000#N/A13000Vietnam210,000#N/A10000Turkey248,000#N

50、/A48000Thailand273,000#N/A73000CEE287,168#N/A87168Bangladesh210,299#N/A10299Sweden284,477#N/A84477Panama244,760#N/A44760china217,046#N/A17046Myanmar217,700#N/A17700Zimbabwe136,400#N/A36400Lithuania115,000#N/A15000Egypt119,831#N/A19831Mauritius19,376#N/A9376Cambodia13,000#N/A3000Mongolia17,262#N/A726