excel and worksheet

profilefew Emma
Deliverable_Spreadsheet_Del1_Del3_Del41.xlsx

Data

Job Title Salary variance
Accountants and Auditors 71,420 5,100,816,400 source: http://www.bls.gov/
Actuaries 99,870 9,974,016,900
Administrative Law Judges, Adjudicators, and Hearing Officers 112,660 12,692,275,600
Administrative Services Managers 93,150 8,676,922,500
Adult Basic and Secondary Education and Literacy Teachers and Instructors 54,890 3,012,912,100
Advertising and Promotions Managers 136,840 18,725,185,600
Advertising Sales Agents 63,000 3,969,000,000
Aerospace Engineering and Operations Technicians 69,230 4,792,792,900
Aerospace Engineers 109,960 12,091,201,600
Agents and Business Managers of Artists, Performers, and Athletes 85,910 7,380,528,100
Agricultural and Food Science Technicians 42,540 1,809,651,600
Agricultural Inspectors 39,700 1,576,090,000
Agricultural Sciences Teachers, Postsecondary 92,010 8,465,840,100
Air Traffic Controllers 128,980 16,635,840,400
Aircraft Cargo Handling Supervisors 57,690 3,328,136,100
Aircraft Structure, Surfaces, Rigging, and Systems Assemblers 48,860 2,387,299,600
Airfield Operations Specialists 55,190 3,045,936,100
Airline Pilots, Copilots, and Flight Engineers 101,050 10,211,102,500
Anthropologists and Archeologists 56,640 3,208,089,600
Appraisers and Assessors of Real Estate 71,530 5,116,540,900
Arbitrators, Mediators, and Conciliators 91,560 8,383,233,600
Architects, Except Landscape and Naval 85,930 7,383,964,900
Architectural and Civil Drafters 53,290 2,839,824,100
Architecture and Engineering Occupations 80,770 6,523,792,900
Architecture Teachers, Postsecondary 79,040 6,247,321,600
Archivists 49,970 2,497,000,900
Art Directors 85,820 7,365,072,400
Art, Drama, and Music Teachers, Postsecondary 70,390 4,954,752,100
Athletic Trainers 48,990 2,400,020,100
Atmospheric and Space Scientists 99,860 9,972,019,600
Atmospheric, Earth, Marine, and Space Sciences Teachers, Postsecondary 93,990 8,834,120,100
Audiologists 81,010 6,562,620,100
Avionics Technicians 55,680 3,100,262,400
Biomedical Engineers 108,290 11,726,724,100
Boilermakers 71,230 5,073,712,900
Broadcast News Analysts 73,660 5,425,795,600
Brokerage Clerks 48,850 2,386,322,500
Budget Analysts 75,010 5,626,500,100
Business and Financial Operations Occupations 72,420 5,244,656,400
Business Operations Specialists, All Other 69,870 4,881,816,900
Business Teachers, Postsecondary 90,540 8,197,491,600
Buyers and Purchasing Agents, Farm Products 62,290 3,880,044,100
Camera and Photographic Equipment Repairers 41,910 1,756,448,100
Captains, Mates, and Pilots of Water Vessels 67,220 4,518,528,400
Cardiovascular Technologists and Technicians 65,850 4,336,222,500
Career/Technical Education Teachers, Middle School 61,970 3,840,280,900
Career/Technical Education Teachers, Secondary School 64,740 4,191,267,600
Cargo and Freight Agents 45,820 2,099,472,400
Cartographers and Photogrammetrists 69,020 4,763,760,400
Chefs and Head Cooks 48,290 2,331,924,100
Chemical Engineers 86,360 7,458,049,600
Chemical Equipment Operators and Tenders 41,520 1,723,910,400
Chemical Plant and System Operators 48,830 2,384,368,900
Chemical Technicians 53,650 2,878,322,500
Chemistry Teachers, Postsecondary 88,390 7,812,792,100
Chemists 85,030 7,230,100,900
Child, Family, and School Social Workers 54,310 2,949,576,100
Chiropractors 79,250 6,280,562,500
Civil Engineers 87,310 7,623,036,100
Claims Adjusters, Examiners, and Investigators 62,230 3,872,572,900
Clinical, Counseling, and School Psychologists 82,130 6,745,336,900
Coil Winders, Tapers, and Finishers 33,490 1,121,580,100
Commercial and Industrial Designers 63,710 4,058,964,100
Commercial Pilots 83,220 6,925,568,400
Communications Equipment Operators, All Other 40,600 1,648,360,000
Communications Teachers, Postsecondary 66,990 4,487,660,100
Community and Social Service Occupations 47,550 2,261,002,500
Community Health Workers 40,340 1,627,315,600
Compensation and Benefits Managers 144,350 20,836,922,500
Compensation, Benefits, and Job Analysis Specialists 75,350 5,677,622,500
Compliance Officers 74,970 5,620,500,900
Computer and Information Research Scientists 117,200 13,735,840,000
Computer and Information Systems Managers 140,920 19,858,446,400
Computer and Mathematical Occupations 86,710 7,518,624,100
Computer Hardware Engineers 112,250 12,600,062,500
Computer Network Architects 107,860 11,633,779,600
Computer Network Support Specialists 60,200 3,624,040,000
Computer Occupations, All Other 77,570 6,017,104,900
Computer Programmers 89,440 7,999,513,600
Computer Science Teachers, Postsecondary 96,020 9,219,840,400
Computer Systems Analysts 91,230 8,322,912,900
Computer User Support Specialists 55,520 3,082,470,400
Conservation Scientists 65,820 4,332,272,400
Construction and Building Inspectors 69,070 4,770,664,900
Construction Managers 93,290 8,703,024,100
Continuous Mining Machine Operators 42,760 1,828,417,600
Control and Valve Installers and Repairers, Except Mechanical Door 68,400 4,678,560,000
Conveyor Operators and Tenders 35,750 1,278,062,500
Cost Estimators 65,650 4,309,922,500
Crane and Tower Operators 59,680 3,561,702,400
Credit Analysts 82,060 6,733,843,600
Credit Counselors 49,650 2,465,122,500
Criminal Justice and Law Enforcement Teachers, Postsecondary 71,970 5,179,680,900
Curators 54,870 3,010,716,900
Database Administrators 88,410 7,816,328,100
Dental Hygienists 72,850 5,307,122,500
Derrick Operators, Oil and Gas 44,610 1,990,052,100
Detectives and Criminal Investigators 77,660 6,031,075,600
Diagnostic Medical Sonographers 78,560 6,171,673,600
Dietitians and Nutritionists 61,440 3,774,873,600
Directors, Religious Activities and Education 50,210 2,521,044,100
Drafters, All Other 53,330 2,844,088,900
Economics Teachers, Postsecondary 109,480 11,985,870,400
Economists 72,810 5,301,296,100
Editors 55,220 3,049,248,400
Education Administrators, All Other 79,860 6,377,619,600
Education Administrators, Elementary and Secondary School 102,010 10,406,040,100
Education Administrators, Postsecondary 91,970 8,458,480,900
Education Administrators, Preschool and Childcare Center/Program 57,390 3,293,612,100
Education Teachers, Postsecondary 64,880 4,209,414,400
Education, Training, and Library Occupations 55,000 3,025,000,000
Educational, Guidance, School, and Vocational Counselors 56,310 3,170,816,100
Electric Motor, Power Tool, and Related Repairers 40,360 1,628,929,600
Electrical and Electronics Drafters 58,770 3,453,912,900
Electrical and Electronics Engineering Technicians 62,450 3,900,002,500
Electrical and Electronics Installers and Repairers, Transportation Equipment 61,260 3,752,787,600
Electrical and Electronics Repairers, Commercial and Industrial Equipment 63,410 4,020,828,100
Electrical and Electronics Repairers, Powerhouse, Substation, and Relay 78,680 6,190,542,400
Electrical Engineers 94,390 8,909,472,100
Electrical Power-Line Installers and Repairers 79,120 6,259,974,400
Electricians 67,500 4,556,250,000
Electro-Mechanical Technicians 56,450 3,186,602,500
Electronics Engineers, Except Computer 99,490 9,898,260,100
Elementary School Teachers, Except Special Education 63,490 4,030,980,100
Elevator Installers and Repairers 83,900 7,039,210,000
Embalmers 46,100 2,125,210,000
Emergency Management Directors 87,050 7,577,702,500
Engineering Technicians, Except Drafters, All Other 57,360 3,290,169,600
English Language and Literature Teachers, Postsecondary 66,090 4,367,888,100
Environmental Engineering Technicians 42,190 1,779,996,100
Environmental Engineers 87,360 7,631,769,600
Environmental Science and Protection Technicians, Including Health 49,460 2,446,291,600
Environmental Science Teachers, Postsecondary 90,710 8,228,304,100
Environmental Scientists and Specialists, Including Health 74,110 5,492,292,100
Epidemiologists 77,440 5,996,953,600
Executive Secretaries and Executive Administrative Assistants 56,010 3,137,120,100
Exercise Physiologists 58,990 3,479,820,100
Explosives Workers, Ordnance Handling Experts, and Blasters 58,320 3,401,222,400
Extruding, Forming, Pressing, and Compacting Machine Setters, Operators, and Tenders 38,740 1,500,787,600
Farm and Home Management Advisors 74,190 5,504,156,100
Film and Video Editors 50,190 2,519,036,100
Financial Analysts 91,420 8,357,616,400
Financial Clerks, All Other 38,860 1,510,099,600
Financial Examiners 89,040 7,928,121,600
Financial Managers 133,980 17,950,640,400
Financial Specialists, All Other 70,440 4,961,793,600
Fire Inspectors and Investigators 65,710 4,317,804,100
Firefighters 35,750 1,278,062,500
First-Line Supervisors of Construction Trades and Extraction Workers 73,810 5,447,916,100
First-Line Supervisors of Correctional Officers 76,370 5,832,376,900
First-Line Supervisors of Farming, Fishing, and Forestry Workers 60,690 3,683,276,100
First-Line Supervisors of Fire Fighting and Prevention Workers 71,570 5,122,264,900
First-Line Supervisors of Helpers, Laborers, and Material Movers, Hand 49,590 2,459,168,100
First-Line Supervisors of Landscaping, Lawn Service, and Groundskeeping Workers 51,310 2,632,716,100
First-Line Supervisors of Mechanics, Installers, and Repairers 66,430 4,412,944,900
First-Line Supervisors of Non-Retail Sales Workers 77,900 6,068,410,000
First-Line Supervisors of Office and Administrative Support Workers 60,960 3,716,121,600
First-Line Supervisors of Police and Detectives 87,970 7,738,720,900
First-Line Supervisors of Production and Operating Workers 62,830 3,947,608,900
First-Line Supervisors of Protective Service Workers, All Other 52,470 2,753,100,900
First-Line Supervisors of Transportation and Material-Moving Machine and Vehicle Operators 58,250 3,393,062,500
Fish and Game Wardens 46,110 2,126,132,100
Food Service Managers 56,800 3,226,240,000
Foreign Language and Literature Teachers, Postsecondary 68,890 4,745,832,100
Forensic Science Technicians 59,640 3,556,929,600
Forest and Conservation Technicians 42,970 1,846,420,900
Foresters 63,990 4,094,720,100
Forestry and Conservation Science Teachers, Postsecondary 90,080 8,114,406,400
Fundraisers 59,900 3,588,010,000
Funeral Service Managers 98,920 9,785,166,400
Gaming Supervisors 32,220 1,038,128,400
Gas Compressor and Gas Pumping Station Operators 56,220 3,160,688,400
Gas Plant Operators 67,370 4,538,716,900
General and Operations Managers 109,490 11,988,060,100
Geography Teachers, Postsecondary 80,130 6,420,816,900
Geological and Petroleum Technicians 54,390 2,958,272,100
Geoscientists, Except Hydrologists and Geographers 72,210 5,214,284,100
Health and Safety Engineers, Except Mining Safety Engineers and Inspectors 88,300 7,796,890,000
Health Diagnosing and Treating Practitioners, All Other 82,600 6,822,760,000
Health Educators 56,120 3,149,454,400
Health Specialties Teachers, Postsecondary 82,450 6,798,002,500
Health Technologists and Technicians, All Other 54,160 2,933,305,600
Healthcare Practitioners and Technical Occupations 86,270 7,442,512,900
Healthcare Social Workers 58,530 3,425,760,900
Hearing Aid Specialists 55,690 3,101,376,100
Historians 62,210 3,870,084,100
History Teachers, Postsecondary 85,040 7,231,801,600
Hoist and Winch Operators 80,660 6,506,035,600
Home Economics Teachers, Postsecondary 71,420 5,100,816,400
Human Resources Managers 121,530 14,769,540,900
Human Resources Specialists 64,140 4,113,939,600
Industrial Engineering Technicians 53,110 2,820,672,100
Industrial Engineers 90,580 8,204,736,400
Industrial Machinery Mechanics 54,180 2,935,472,400
Industrial Production Managers 110,490 12,208,040,100
Information and Record Clerks, All Other 43,110 1,858,472,100
Information Security Analysts 95,930 9,202,564,900
Installation, Maintenance, and Repair Occupations 49,750 2,475,062,500
Instructional Coordinators 65,320 4,266,702,400
Insurance Appraisers, Auto Damage 62,970 3,965,220,900
Insurance Sales Agents 82,760 6,849,217,600
Insurance Underwriters 66,930 4,479,624,900
Interior Designers 61,130 3,736,876,900
Judges, Magistrate Judges, and Magistrates 135,740 18,425,347,600
Kindergarten Teachers, Except Special Education 58,790 3,456,264,100
Labor Relations Specialists 69,170 4,784,488,900
Landscape Architects 69,200 4,788,640,000
Lawyers 124,230 15,433,092,900
Layout Workers, Metal and Plastic 49,700 2,470,090,000
Legal Occupations 97,570 9,519,904,900
Legal Support Workers, All Other 57,980 3,361,680,400
Librarians 62,790 3,942,584,100
Library Science Teachers, Postsecondary 72,520 5,259,150,400
Life Scientists, All Other 71,130 5,059,476,900
Life, Physical, and Social Science Occupations 71,500 5,112,250,000
Loading Machine Operators, Underground Mining 41,270 1,703,212,900
Loan Officers 78,040 6,090,241,600
Locomotive Engineers 66,150 4,375,822,500
Logging Workers, All Other 41,940 1,758,963,600
Logisticians 74,280 5,517,518,400
Magnetic Resonance Imaging Technologists 76,530 5,856,840,900
Management Analysts 83,560 6,982,273,600
Managers, All Other 126,600 16,027,560,000
Marine Engineers and Naval Architects 57,230 3,275,272,900
Market Research Analysts and Marketing Specialists 70,940 5,032,483,600
Marketing Managers 140,350 19,698,122,500
Marriage and Family Therapists 52,070 2,711,284,900
Materials Engineers 98,090 9,621,648,100
Mathematical Science Teachers, Postsecondary 71,370 5,093,676,900
Mechanical Drafters 58,680 3,443,342,400
Mechanical Engineering Technicians 56,050 3,141,602,500
Mechanical Engineers 83,940 7,045,923,600
Media and Communication Equipment Workers, All Other 47,300 2,237,290,000
Medical and Clinical Laboratory Technologists 65,770 4,325,692,900
Medical and Health Services Managers 108,280 11,724,558,400
Medical Equipment Repairers 63,230 3,998,032,900
Meeting, Convention, and Event Planners 54,500 2,970,250,000
Mental Health Counselors 46,580 2,169,696,400
Metal-Refining Furnace Operators and Tenders 43,310 1,875,756,100
Middle School Teachers, Except Special and Career/Technical Education 64,780 4,196,448,400
Millwrights 49,300 2,430,490,000
Mine Cutting and Channeling Machine Operators 46,410 2,153,888,100
Mine Shuttle Car Operators 53,150 2,824,922,500
Mining and Geological Engineers, Including Mining Safety Engineers 95,550 9,129,802,500
Mining Machine Operators, All Other 51,740 2,677,027,600
Mixing and Blending Machine Setters, Operators, and Tenders 38,940 1,516,323,600
Mobile Heavy Equipment Mechanics, Except Engines 56,690 3,213,756,100
Model Makers, Metal and Plastic 40,210 1,616,844,100
Morticians, Undertakers, and Funeral Directors 62,060 3,851,443,600
Multimedia Artists and Animators 58,020 3,366,320,400
Music Directors and Composers 84,860 7,201,219,600
Natural Sciences Managers 118,520 14,046,990,400
Network and Computer Systems Administrators 85,560 7,320,513,600
Nuclear Engineers 110,620 12,236,784,400
Nuclear Medicine Technologists 83,110 6,907,272,100
Nuclear Technicians 59,630 3,555,736,900
Nurse Practitioners 116,150 13,490,822,500
Nursing Instructors and Teachers, Postsecondary 69,470 4,826,080,900
Occupational Health and Safety Specialists 78,470 6,157,540,900
Occupational Health and Safety Technicians 53,780 2,892,288,400
Occupational Therapists 73,680 5,428,742,400
Occupational Therapy Assistants 48,210 2,324,204,100
Operations Research Analysts 90,570 8,202,924,900
Optometrists 127,590 16,279,208,100
Orthotists and Prosthetists 72,850 5,307,122,500
Painters, Transportation Equipment 55,980 3,133,760,400
Paper Goods Machine Setters, Operators, and Tenders 40,880 1,671,174,400
Paralegals and Legal Assistants 56,510 3,193,380,100
Patternmakers, Metal and Plastic 46,310 2,144,616,100
Personal Financial Advisors 109,250 11,935,562,500
Petroleum Pump System Operators, Refinery Operators, and Gaugers 60,720 3,686,918,400
Pharmacists 126,840 16,088,385,600
Philosophy and Religion Teachers, Postsecondary 74,090 5,489,328,100
Physical Therapist Assistants 53,350 2,846,222,500
Physical Therapists 81,860 6,701,059,600
Physician Assistants 112,460 12,647,251,600
Physicists 134,710 18,146,784,100
Physics Teachers, Postsecondary 85,870 7,373,656,900
Plant and System Operators, All Other 63,770 4,066,612,900
Plumbers, Pipefitters, and Steamfitters 71,020 5,043,840,400
Podiatrists 199,980 39,992,000,400
Police and Sheriff's Patrol Officers 64,700 4,186,090,000
Political Science Teachers, Postsecondary 102,230 10,450,972,900
Postal Service Clerks 47,350 2,242,022,500
Postal Service Mail Carriers 49,570 2,457,184,900
Postal Service Mail Sorters, Processors, and Processing Machine Operators 49,190 2,419,656,100
Postmasters and Mail Superintendents 73,270 5,368,492,900
Power Distributors and Dispatchers 92,440 8,545,153,600
Power Plant Operators 78,360 6,140,289,600
Precision Instrument and Equipment Repairers, All Other 57,600 3,317,760,000
Private Detectives and Investigators 51,840 2,687,385,600
Probation Officers and Correctional Treatment Specialists 63,380 4,017,024,400
Producers and Directors 68,290 4,663,524,100
Production, Planning, and Expediting Clerks 49,410 2,441,348,100
Property, Real Estate, and Community Association Managers 64,290 4,133,204,100
Psychologists, All Other 86,420 7,468,416,400
Psychology Teachers, Postsecondary 72,570 5,266,404,900
Public Relations and Fundraising Managers 121,010 14,643,420,100
Public Relations Specialists 60,500 3,660,250,000
Pump Operators, Except Wellhead Pumpers 47,570 2,262,904,900
Purchasing Agents, Except Wholesale, Retail, and Farm Products 61,760 3,814,297,600
Purchasing Managers 116,310 13,528,016,100
Radiation Therapists 80,510 6,481,860,100
Radio, Cellular, and Tower Equipment Installers and Repairers 65,380 4,274,544,400
Radiologic Technologists 64,880 4,209,414,400
Rail Yard Engineers, Dinkey Operators, and Hostlers 54,860 3,009,619,600
Railroad Conductors and Yardmasters 66,620 4,438,224,400
Rail-Track Laying and Maintenance Equipment Operators 48,440 2,346,433,600
Real Estate Brokers 66,270 4,391,712,900
Real Estate Sales Agents 48,250 2,328,062,500
Recreation and Fitness Studies Teachers, Postsecondary 63,760 4,065,337,600
Recreational Vehicle Service Technicians 37,600 1,413,760,000
Refractory Materials Repairers, Except Brickmasons 47,440 2,250,553,600
Registered Nurses 77,540 6,012,451,600
Reinforcing Iron and Rebar Workers 64,470 4,156,380,900
Respiratory Therapists 67,460 4,550,851,600
Rolling Machine Setters, Operators, and Tenders, Metal and Plastic 39,480 1,558,670,400
Roof Bolters, Mining 54,150 2,932,222,500
Rotary Drill Operators, Oil and Gas 56,660 3,210,355,600
Sales Engineers 101,950 10,393,802,500
Sales Managers 136,930 18,749,824,900
Sales Representatives, Services, All Other 63,470 4,028,440,900
Sales Representatives, Wholesale and Manufacturing, Except Technical and Scientific Products 75,270 5,665,572,900
Sales Representatives, Wholesale and Manufacturing, Technical and Scientific Products 113,360 12,850,489,600
Secondary School Teachers, Except Special and Career/Technical Education 65,290 4,262,784,100
Securities, Commodities, and Financial Services Sales Agents 95,750 9,168,062,500
Service Unit Operators, Oil, Gas, and Mining 48,010 2,304,960,100
Set and Exhibit Designers 50,170 2,517,028,900
Ship Engineers 103,040 10,617,241,600
Signal and Track Switch Repairers 40,520 1,641,870,400
Social and Community Service Managers 77,700 6,037,290,000
Social Scientists and Related Workers, All Other 76,810 5,899,776,100
Social Work Teachers, Postsecondary 66,060 4,363,923,600
Social Workers, All Other 56,280 3,167,438,400
Sociology Teachers, Postsecondary 84,210 7,091,324,100
Software Developers, Applications 93,280 8,701,158,400
Software Developers, Systems Software 111,340 12,396,595,600
Soil and Plant Scientists 70,780 5,009,808,400
Sound Engineering Technicians 44,310 1,963,376,100
Special Education Teachers, All Other 69,770 4,867,852,900
Special Education Teachers, Kindergarten and Elementary School 63,330 4,010,688,900
Special Education Teachers, Middle School 65,290 4,262,784,100
Special Education Teachers, Secondary School 63,370 4,015,756,900
Speech-Language Pathologists 74,180 5,502,672,400
Stationary Engineers and Boiler Operators 57,420 3,297,056,400
Statisticians 94,640 8,956,729,600
Surveyors 67,560 4,564,353,600
Tank Car, Truck, and Ship Loaders 46,730 2,183,692,900
Tax Examiners and Collectors, and Revenue Agents 63,730 4,061,512,900
Technical Writers 67,260 4,523,907,600
Telecommunications Equipment Installers and Repairers, Except Line Installers 61,410 3,771,188,100
Tire Builders 42,500 1,806,250,000
Tool and Die Makers 57,790 3,339,684,100
Training and Development Managers 113,080 12,787,086,400
Training and Development Specialists 64,490 4,158,960,100
Transportation Inspectors 92,970 8,643,420,900
Transportation, Storage, and Distribution Managers 103,970 10,809,760,900
Urban and Regional Planners 70,850 5,019,722,500
Veterinarians 91,980 8,460,320,400
Water and Wastewater Treatment Plant and System Operators 51,720 2,674,958,400
Web Developers 75,970 5,771,440,900
Wholesale and Retail Buyers, Except Farm Products 59,080 3,490,446,400
Writers and Authors 65,180 4,248,432,400
Zoologists and Wildlife Biologists 60,060 3,607,203,600
ERROR:#VALUE!

Sheet2

Sheet3