20181126223751scrocker_deliverable_1_sprdsht_corrections_10182018 x.xlsx20181126223846deliverable_
spreadsheet
_del1_del3_del4__1_.xlsx20181126223753scrocker_deliverable_1_wksht_10142018 x20181126223849deliverable_03_questions__1_ x
Scenario (information repeated for deliverable 01, 03, and 04)
A major client of your company is interested in the salary distributions of jobs in the state of Minnesota that range from $30,000 to $200,000 per year. As a Business Analyst, your boss asks you to research and analyze the salary distributions. You are given a spreadsheet (see attached) that contains the following information:
- A listing of the jobs by title
- The salary (in dollars) for each job
You have previously explained some of the basic statistics to your client already, and he really liked your work. Now he wants you to analyze the confidence intervals.
Background information on the Data
The data set in the spreadsheet consists of 364 records that you will be analyzing from the Bureau of Labor Statistics. The data set contains a listing of several jobs titles with yearly salaries ranging from approximately $30,000 to $200,000 for the state of Minnesota.
What to Submit
Your boss wants you to submit the *Excel spreadsheet* with the completed calculations. Your research and analysis should be present within the answers provided on the
worksheet.
(see attached).
**PLEASE READ** You should have one excel spreadsheet with the completed calculations AND The answer and explanations in the worksheet (Microsoft Word document). The worksheet will reference “Deliverable 1” – I have attached Deliverable 1 answers
Data
Job Title | Salary | ||||||||||||||
Accountants and Auditors | $ 71,420 | source: http://www.bls.gov/ | |||||||||||||
Actuaries | $ 99,870 | ||||||||||||||
Administrative Law Judges, Adjudicators, and Hearing Officers | $ 112,660 | ||||||||||||||
Administrative Services Managers | $ 93,150 | Measure of Center | |||||||||||||
Adult Basic and Secondary Education and Literacy Teachers and Instructors | $ 54,890 | Mean | $ 71,879.40 | ||||||||||||
Advertising and Promotions Managers | $ 136,840 | Median | $ 66,525.00 | ||||||||||||
Advertising Sales Agents | $ 63,000 | Modes | $ 71,420.00 | $ 35,750 | $ 72,850 | $ 64,880 | $ 65,290 | ||||||||
Aerospace Engineering and Operations Technicians | $ 69,230 | ||||||||||||||
Aerospace Engineers | $ 109,960 | ||||||||||||||
Agents and Business Managers of Artists, Performers, and Athletes | $ 85,910 | Measure of Variation | |||||||||||||
Agricultural and Food Science Technicians | $ 42,540 | Mid-range | |||||||||||||
Agricultural Inspectors | $ 39,700 | Range | $ 167,760.00 | ||||||||||||
Agricultural Sciences Teachers, Postsecondary | $ 92,010 | Variance | 546,033,522 | ||||||||||||
Air Traffic Controllers | $ 128,980 | Standard Deviation | $ 23,367.36 | ||||||||||||
Aircraft Cargo Handling Supervisors | $ 57,690 | ||||||||||||||
Aircraft Structure, Surfaces, Rigging, and Systems Assemblers | $ 48,860 | ||||||||||||||
Airfield Operations Specialists | $ 55,190 | ||||||||||||||
Airline Pilots, Copilots, and Flight Engineers | $ 101,050 | ||||||||||||||
Anthropologists and Archeologists | $ 56,640 | ||||||||||||||
Appraisers and Assessors of Real Estate | $ 71,530 | ||||||||||||||
Arbitrators, Mediators, and Conciliators | $ 91,560 | ||||||||||||||
Architects, Except Landscape and Naval | $ 85,930 | ||||||||||||||
Architectural and Civil Drafters | $ 53,290 | ||||||||||||||
Architecture and Engineering Occupations | $ 80,770 | ||||||||||||||
Architecture Teachers, Postsecondary | $ 79,040 | ||||||||||||||
Archivists | $ 49,970 | ||||||||||||||
Art Directors | $ 85,820 | ||||||||||||||
Art, Drama, and Music Teachers, Postsecondary | $ 70,390 | ||||||||||||||
Athletic Trainers | $ 48,990 | ||||||||||||||
Atmospheric and Space Scientists | $ 99,860 | ||||||||||||||
Atmospheric, Earth, Marine, and Space Sciences Teachers, Postsecondary | $ 93,990 | ||||||||||||||
Audiologists | $ 81,010 | ||||||||||||||
Avionics Technicians | $ 55,680 | ||||||||||||||
Biomedical Engineers | $ 108,290 | ||||||||||||||
Boilermakers | $ 71,230 | ||||||||||||||
Broadcast News Analysts | $ 73,660 | ||||||||||||||
Brokerage Clerks | $ 48,850 | ||||||||||||||
Budget Analysts | $ 75,010 | ||||||||||||||
Business and Financial Operations Occupations | $ 72,420 | ||||||||||||||
Business Operations Specialists, All Other | $ 69,870 | ||||||||||||||
Business Teachers, Postsecondary | $ 90,540 | ||||||||||||||
Buyers and Purchasing Agents, Farm Products | $ 62,290 | ||||||||||||||
Camera and Photographic Equipment Repairers | $ 41,910 | ||||||||||||||
Captains, Mates, and Pilots of Water Vessels | $ 67,220 | ||||||||||||||
Cardiovascular Technologists and Technicians | $ 65,850 | ||||||||||||||
Career/Technical Education Teachers, Middle School | $ 61,970 | ||||||||||||||
Career/Technical Education Teachers, Secondary School | $ 64,740 | ||||||||||||||
Cargo and Freight Agents | $ 45,820 | ||||||||||||||
Cartographers and Photogrammetrists | $ 69,020 | ||||||||||||||
Chefs and Head Cooks | $ 48,290 | ||||||||||||||
Chemical Engineers | $ 86,360 | ||||||||||||||
Chemical Equipment Operators and Tenders | $ 41,520 | ||||||||||||||
Chemical Plant and System Operators | $ 48,830 | ||||||||||||||
Chemical Technicians | $ 53,650 | ||||||||||||||
Chemistry Teachers, Postsecondary | $ 88,390 | ||||||||||||||
Chemists | $ 85,030 | ||||||||||||||
Child, Family, and School Social Workers | $ 54,310 | ||||||||||||||
Chiropractors | $ 79,250 | ||||||||||||||
Civil Engineers | $ 87,310 | ||||||||||||||
Claims Adjusters, Examiners, and Investigators | $ 62,230 | ||||||||||||||
Clinical, Counseling, and School Psychologists | $ 82,130 | ||||||||||||||
Coil Winders, Tapers, and Finishers | $ 33,490 | ||||||||||||||
Commercial and Industrial Designers | $ 63,710 | ||||||||||||||
Commercial Pilots | $ 83,220 | ||||||||||||||
Communications Equipment Operators, All Other | $ 40,600 | ||||||||||||||
Communications Teachers, Postsecondary | $ 66,990 | ||||||||||||||
Community and Social Service Occupations | $ 47,550 | ||||||||||||||
Community Health Workers | $ 40,340 | ||||||||||||||
Compensation and Benefits Managers | $ 144,350 | ||||||||||||||
Compensation, Benefits, and Job Analysis Specialists | $ 75,350 | ||||||||||||||
Compliance Officers | $ 74,970 | ||||||||||||||
Computer and Information Research Scientists | $ 117,200 | ||||||||||||||
Computer and Information Systems Managers | $ 140,920 | ||||||||||||||
Computer and Mathematical Occupations | $ 86,710 | ||||||||||||||
Computer Hardware Engineers | $ 112,250 | ||||||||||||||
Computer Network Architects | $ 107,860 | ||||||||||||||
Computer Network Support Specialists | $ 60,200 | ||||||||||||||
Computer Occupations, All Other | $ 77,570 | ||||||||||||||
Computer Programmers | $ 89,440 | ||||||||||||||
Computer Science Teachers, Postsecondary | $ 96,020 | ||||||||||||||
Computer Systems Analysts | $ 91,230 | ||||||||||||||
Computer User Support Specialists | $ 55,520 | ||||||||||||||
Conservation Scientists | $ 65,820 | ||||||||||||||
Construction and Building Inspectors | $ 69,070 | ||||||||||||||
Construction Managers | $ 93,290 | ||||||||||||||
Continuous Mining Machine Operators | $ 42,760 | ||||||||||||||
Control and Valve Installers and Repairers, Except Mechanical Door | $ 68,400 | ||||||||||||||
Conveyor Operators and Tenders | |||||||||||||||
Cost Estimators | $ 65,650 | ||||||||||||||
Crane and Tower Operators | $ 59,680 | ||||||||||||||
Credit Analysts | $ 82,060 | ||||||||||||||
Credit Counselors | $ 49,650 | ||||||||||||||
Criminal Justice and Law Enforcement Teachers, Postsecondary | $ 71,970 | ||||||||||||||
Curators | $ 54,870 | ||||||||||||||
Database Administrators | $ 88,410 | ||||||||||||||
Dental Hygienists | |||||||||||||||
Derrick Operators, Oil and Gas | $ 44,610 | ||||||||||||||
Detectives and Criminal Investigators | $ 77,660 | ||||||||||||||
Diagnostic Medical Sonographers | $ 78,560 | ||||||||||||||
Dietitians and Nutritionists | $ 61,440 | ||||||||||||||
Directors, Religious Activities and Education | $ 50,210 | ||||||||||||||
Drafters, All Other | $ 53,330 | ||||||||||||||
Economics Teachers, Postsecondary | $ 109,480 | ||||||||||||||
Economists | $ 72,810 | ||||||||||||||
Editors | $ 55,220 | ||||||||||||||
Education Administrators, All Other | $ 79,860 | ||||||||||||||
Education Administrators, Elementary and Secondary School | $ 102,010 | ||||||||||||||
Education Administrators, Postsecondary | $ 91,970 | ||||||||||||||
Education Administrators, Preschool and Childcare Center/Program | $ 57,390 | ||||||||||||||
Education Teachers, Postsecondary | |||||||||||||||
Education, Training, and Library Occupations | $ 55,000 | ||||||||||||||
Educational, Guidance, School, and Vocational Counselors | $ 56,310 | ||||||||||||||
Electric Motor, Power Tool, and Related Repairers | $ 40,360 | ||||||||||||||
Electrical and Electronics Drafters | $ 58,770 | ||||||||||||||
Electrical and Electronics Engineering Technicians | $ 62,450 | ||||||||||||||
Electrical and Electronics Installers and Repairers, Transportation Equipment | $ 61,260 | ||||||||||||||
Electrical and Electronics Repairers, Commercial and Industrial Equipment | $ 63,410 | ||||||||||||||
Electrical and Electronics Repairers, Powerhouse, Substation, and Relay | $ 78,680 | ||||||||||||||
Electrical Engineers | $ 94,390 | ||||||||||||||
Electrical Power-Line Installers and Repairers | $ 79,120 | ||||||||||||||
Electricians | $ 67,500 | ||||||||||||||
Electro-Mechanical Technicians | $ 56,450 | ||||||||||||||
Electronics Engineers, Except Computer | $ 99,490 | ||||||||||||||
Elementary School Teachers, Except Special Education | $ 63,490 | ||||||||||||||
Elevator Installers and Repairers | $ 83,900 | ||||||||||||||
Embalmers | $ 46,100 | ||||||||||||||
Emergency Management Directors | $ 87,050 | ||||||||||||||
Engineering Technicians, Except Drafters, All Other | $ 57,360 | ||||||||||||||
English Language and Literature Teachers, Postsecondary | $ 66,090 | ||||||||||||||
Environmental Engineering Technicians | $ 42,190 | ||||||||||||||
Environmental Engineers | $ 87,360 | ||||||||||||||
Environmental Science and Protection Technicians, Including Health | $ 49,460 | ||||||||||||||
Environmental Science Teachers, Postsecondary | $ 90,710 | ||||||||||||||
Environmental Scientists and Specialists, Including Health | $ 74,110 | ||||||||||||||
Epidemiologists | $ 77,440 | ||||||||||||||
Executive Secretaries and Executive Administrative Assistants | $ 56,010 | ||||||||||||||
Exercise Physiologists | $ 58,990 | ||||||||||||||
Explosives Workers, Ordnance Handling Experts, and Blasters | $ 58,320 | ||||||||||||||
Extruding, Forming, Pressing, and Compacting Machine Setters, Operators, and Tenders | $ 38,740 | ||||||||||||||
Farm and Home Management Advisors | $ 74,190 | ||||||||||||||
Film and Video Editors | $ 50,190 | ||||||||||||||
Financial Analysts | $ 91,420 | ||||||||||||||
Financial Clerks, All Other | $ 38,860 | ||||||||||||||
Financial Examiners | $ 89,040 | ||||||||||||||
Financial Managers | $ 133,980 | ||||||||||||||
Financial Specialists, All Other | $ 70,440 | ||||||||||||||
Fire Inspectors and Investigators | $ 65,710 | ||||||||||||||
Firefighters | |||||||||||||||
First-Line Supervisors of Construction Trades and Extraction Workers | $ 73,810 | ||||||||||||||
First-Line Supervisors of Correctional Officers | $ 76,370 | ||||||||||||||
First-Line Supervisors of Farming, Fishing, and Forestry Workers | $ 60,690 | ||||||||||||||
First-Line Supervisors of Fire Fighting and Prevention Workers | $ 71,570 | ||||||||||||||
First-Line Supervisors of Helpers, Laborers, and Material Movers, Hand | $ 49,590 | ||||||||||||||
First-Line Supervisors of Landscaping, Lawn Service, and Groundskeeping Workers | $ 51,310 | ||||||||||||||
First-Line Supervisors of Mechanics, Installers, and Repairers | $ 66,430 | ||||||||||||||
First-Line Supervisors of Non-Retail Sales Workers | $ 77,900 | ||||||||||||||
First-Line Supervisors of Office and Administrative Support Workers | $ 60,960 | ||||||||||||||
First-Line Supervisors of Police and Detectives | $ 87,970 | ||||||||||||||
First-Line Supervisors of Production and Operating Workers | $ 62,830 | ||||||||||||||
First-Line Supervisors of Protective Service Workers, All Other | $ 52,470 | ||||||||||||||
First-Line Supervisors of Transportation and Material-Moving Machine and Vehicle Operators | $ 58,250 | ||||||||||||||
Fish and Game Wardens | $ 46,110 | ||||||||||||||
Food Service Managers | $ 56,800 | ||||||||||||||
Foreign Language and Literature Teachers, Postsecondary | $ 68,890 | ||||||||||||||
Forensic Science Technicians | $ 59,640 | ||||||||||||||
Forest and Conservation Technicians | $ 42,970 | ||||||||||||||
Foresters | $ 63,990 | ||||||||||||||
Forestry and Conservation Science Teachers, Postsecondary | $ 90,080 | ||||||||||||||
Fundraisers | $ 59,900 | ||||||||||||||
Funeral Service Managers | $ 98,920 | ||||||||||||||
Gaming Supervisors | $ 32,220 | ||||||||||||||
Gas Compressor and Gas Pumping Station Operators | $ 56,220 | ||||||||||||||
Gas Plant Operators | $ 67,370 | ||||||||||||||
General and Operations Managers | $ 109,490 | ||||||||||||||
Geography Teachers, Postsecondary | $ 80,130 | ||||||||||||||
Geological and Petroleum Technicians | $ 54,390 | ||||||||||||||
Geoscientists, Except Hydrologists and Geographers | $ 72,210 | ||||||||||||||
Health and Safety Engineers, Except Mining Safety Engineers and Inspectors | $ 88,300 | ||||||||||||||
Health Diagnosing and Treating Practitioners, All Other | $ 82,600 | ||||||||||||||
Health Educators | $ 56,120 | ||||||||||||||
Health Specialties Teachers, Postsecondary | $ 82,450 | ||||||||||||||
Health Technologists and Technicians, All Other | $ 54,160 | ||||||||||||||
Healthcare Practitioners and Technical Occupations | $ 86,270 | ||||||||||||||
Healthcare Social Workers | $ 58,530 | ||||||||||||||
Hearing Aid Specialists | $ 55,690 | ||||||||||||||
Historians | $ 62,210 | ||||||||||||||
History Teachers, Postsecondary | $ 85,040 | ||||||||||||||
Hoist and Winch Operators | $ 80,660 | ||||||||||||||
Home Economics Teachers, Postsecondary | |||||||||||||||
Human Resources Managers | $ 121,530 | ||||||||||||||
Human Resources Specialists | $ 64,140 | ||||||||||||||
Industrial Engineering Technicians | $ 53,110 | ||||||||||||||
Industrial Engineers | $ 90,580 | ||||||||||||||
Industrial Machinery Mechanics | $ 54,180 | ||||||||||||||
Industrial Production Managers | $ 110,490 | ||||||||||||||
Information and Record Clerks, All Other | $ 43,110 | ||||||||||||||
Information Security Analysts | $ 95,930 | ||||||||||||||
Installation, Maintenance, and Repair Occupations | $ 49,750 | ||||||||||||||
Instructional Coordinators | $ 65,320 | ||||||||||||||
Insurance Appraisers, Auto Damage | $ 62,970 | ||||||||||||||
Insurance Sales Agents | $ 82,760 | ||||||||||||||
Insurance Underwriters | $ 66,930 | ||||||||||||||
Interior Designers | $ 61,130 | ||||||||||||||
Judges, Magistrate Judges, and Magistrates | $ 135,740 | ||||||||||||||
Kindergarten Teachers, Except Special Education | $ 58,790 | ||||||||||||||
Labor Relations Specialists | $ 69,170 | ||||||||||||||
Landscape Architects | $ 69,200 | ||||||||||||||
Lawyers | $ 124,230 | ||||||||||||||
Layout Workers, Metal and Plastic | $ 49,700 | ||||||||||||||
Legal Occupations | $ 97,570 | ||||||||||||||
Legal Support Workers, All Other | $ 57,980 | ||||||||||||||
Librarians | $ 62,790 | ||||||||||||||
Library Science Teachers, Postsecondary | $ 72,520 | ||||||||||||||
Life Scientists, All Other | $ 71,130 | ||||||||||||||
Life, Physical, and Social Science Occupations | $ 71,500 | ||||||||||||||
Loading Machine Operators, Underground Mining | $ 41,270 | ||||||||||||||
Loan Officers | $ 78,040 | ||||||||||||||
Locomotive Engineers | $ 66,150 | ||||||||||||||
Logging Workers, All Other | $ 41,940 | ||||||||||||||
Logisticians | $ 74,280 | ||||||||||||||
Magnetic Resonance Imaging Technologists | $ 76,530 | ||||||||||||||
Management Analysts | $ 83,560 | ||||||||||||||
Managers, All Other | $ 126,600 | ||||||||||||||
Marine Engineers and Naval Architects | $ 57,230 | ||||||||||||||
Market Research Analysts and Marketing Specialists | $ 70,940 | ||||||||||||||
Marketing Managers | $ 140,350 | ||||||||||||||
Marriage and Family Therapists | $ 52,070 | ||||||||||||||
Materials Engineers | $ 98,090 | ||||||||||||||
Mathematical Science Teachers, Postsecondary | $ 71,370 | ||||||||||||||
Mechanical Drafters | $ 58,680 | ||||||||||||||
Mechanical Engineering Technicians | $ 56,050 | ||||||||||||||
Mechanical Engineers | $ 83,940 | ||||||||||||||
Media and Communication Equipment Workers, All Other | $ 47,300 | ||||||||||||||
Medical and Clinical Laboratory Technologists | $ 65,770 | ||||||||||||||
Medical and Health Services Managers | $ 108,280 | ||||||||||||||
Medical Equipment Repairers | $ 63,230 | ||||||||||||||
Meeting, Convention, and Event Planners | $ 54,500 | ||||||||||||||
Mental Health Counselors | $ 46,580 | ||||||||||||||
Metal-Refining Furnace Operators and Tenders | $ 43,310 | ||||||||||||||
Middle School Teachers, Except Special and Career/Technical Education | $ 64,780 | ||||||||||||||
Millwrights | $ 49,300 | ||||||||||||||
Mine Cutting and Channeling Machine Operators | $ 46,410 | ||||||||||||||
Mine Shuttle Car Operators | $ 53,150 | ||||||||||||||
Mining and Geological Engineers, Including Mining Safety Engineers | $ 95,550 | ||||||||||||||
Mining Machine Operators, All Other | $ 51,740 | ||||||||||||||
Mixing and Blending Machine Setters, Operators, and Tenders | $ 38,940 | ||||||||||||||
Mobile Heavy Equipment Mechanics, Except Engines | $ 56,690 | ||||||||||||||
Model Makers, Metal and Plastic | $ 40,210 | ||||||||||||||
Morticians, Undertakers, and Funeral Directors | $ 62,060 | ||||||||||||||
Multimedia Artists and Animators | $ 58,020 | ||||||||||||||
Music Directors and Composers | $ 84,860 | ||||||||||||||
Natural Sciences Managers | $ 118,520 | ||||||||||||||
Network and Computer Systems Administrators | $ 85,560 | ||||||||||||||
Nuclear Engineers | $ 110,620 | ||||||||||||||
Nuclear Medicine Technologists | $ 83,110 | ||||||||||||||
Nuclear Technicians | $ 59,630 | ||||||||||||||
Nurse Practitioners | $ 116,150 | ||||||||||||||
Nursing Instructors and Teachers, Postsecondary | $ 69,470 | ||||||||||||||
Occupational Health and Safety Specialists | $ 78,470 | ||||||||||||||
Occupational Health and Safety Technicians | $ 53,780 | ||||||||||||||
Occupational Therapists | $ 73,680 | ||||||||||||||
Occupational Therapy Assistants | $ 48,210 | ||||||||||||||
Operations Research Analysts | $ 90,570 | ||||||||||||||
Optometrists | $ 127,590 | ||||||||||||||
Orthotists and Prosthetists | |||||||||||||||
Painters, Transportation Equipment | $ 55,980 | ||||||||||||||
Paper Goods Machine Setters, Operators, and Tenders | $ 40,880 | ||||||||||||||
Paralegals and Legal Assistants | $ 56,510 | ||||||||||||||
Patternmakers, Metal and Plastic | $ 46,310 | ||||||||||||||
Personal Financial Advisors | $ 109,250 | ||||||||||||||
Petroleum Pump System Operators, Refinery Operators, and Gaugers | $ 60,720 | ||||||||||||||
Pharmacists | $ 126,840 | ||||||||||||||
Philosophy and Religion Teachers, Postsecondary | $ 74,090 | ||||||||||||||
Physical Therapist Assistants | $ 53,350 | ||||||||||||||
Physical Therapists | $ 81,860 | ||||||||||||||
Physician Assistants | $ 112,460 | ||||||||||||||
Physicists | $ 134,710 | ||||||||||||||
Physics Teachers, Postsecondary | $ 85,870 | ||||||||||||||
Plant and System Operators, All Other | $ 63,770 | ||||||||||||||
Plumbers, Pipefitters, and Steamfitters | $ 71,020 | ||||||||||||||
Podiatrists | $ 199,980 | ||||||||||||||
Police and Sheriff’s Patrol Officers | $ 64,700 | ||||||||||||||
Political Science Teachers, Postsecondary | $ 102,230 | ||||||||||||||
Postal Service Clerks | $ 47,350 | ||||||||||||||
Postal Service Mail Carriers | $ 49,570 | ||||||||||||||
Postal Service Mail Sorters, Processors, and Processing Machine Operators | $ 49,190 | ||||||||||||||
Postmasters and Mail Superintendents | $ 73,270 | ||||||||||||||
Power Distributors and Dispatchers | $ 92,440 | ||||||||||||||
Power Plant Operators | $ 78,360 | ||||||||||||||
Precision Instrument and Equipment Repairers, All Other | $ 57,600 | ||||||||||||||
Private Detectives and Investigators | $ 51,840 | ||||||||||||||
Probation Officers and Correctional Treatment Specialists | $ 63,380 | ||||||||||||||
Producers and Directors | $ 68,290 | ||||||||||||||
Production, Planning, and Expediting Clerks | $ 49,410 | ||||||||||||||
Property, Real Estate, and Community Association Managers | $ 64,290 | ||||||||||||||
Psychologists, All Other | $ 86,420 | ||||||||||||||
Psychology Teachers, Postsecondary | $ 72,570 | ||||||||||||||
Public Relations and Fundraising Managers | $ 121,010 | ||||||||||||||
Public Relations Specialists | $ 60,500 | ||||||||||||||
Pump Operators, Except Wellhead Pumpers | $ 47,570 | ||||||||||||||
Purchasing Agents, Except Wholesale, Retail, and Farm Products | $ 61,760 | ||||||||||||||
Purchasing Managers | $ 116,310 | ||||||||||||||
Radiation Therapists | $ 80,510 | ||||||||||||||
Radio, Cellular, and Tower Equipment Installers and Repairers | $ 65,380 | ||||||||||||||
Radiologic Technologists | |||||||||||||||
Rail Yard Engineers, Dinkey Operators, and Hostlers | $ 54,860 | ||||||||||||||
Railroad Conductors and Yardmasters | $ 66,620 | ||||||||||||||
Rail-Track Laying and Maintenance Equipment Operators | $ 48,440 | ||||||||||||||
Real Estate Brokers | $ 66,270 | ||||||||||||||
Real Estate Sales Agents | $ 48,250 | ||||||||||||||
Recreation and Fitness Studies Teachers, Postsecondary | $ 63,760 | ||||||||||||||
Recreational Vehicle Service Technicians | $ 37,600 | ||||||||||||||
Refractory Materials Repairers, Except Brickmasons | $ 47,440 | ||||||||||||||
Registered Nurses | $ 77,540 | ||||||||||||||
Reinforcing Iron and Rebar Workers | $ 64,470 | ||||||||||||||
Respiratory Therapists | $ 67,460 | ||||||||||||||
Rolling Machine Setters, Operators, and Tenders, Metal and Plastic | $ 39,480 | ||||||||||||||
Roof Bolters, Mining | $ 54,150 | ||||||||||||||
Rotary Drill Operators, Oil and Gas | $ 56,660 | ||||||||||||||
Sales Engineers | $ 101,950 | ||||||||||||||
Sales Managers | $ 136,930 | ||||||||||||||
Sales Representatives, Services, All Other | $ 63,470 | ||||||||||||||
Sales Representatives, Wholesale and Manufacturing, Except Technical and Scientific Products | $ 75,270 | ||||||||||||||
Sales Representatives, Wholesale and Manufacturing, Technical and Scientific Products | $ 113,360 | ||||||||||||||
Secondary School Teachers, Except Special and Career/Technical Education | |||||||||||||||
Securities, Commodities, and Financial Services Sales Agents | $ 95,750 | ||||||||||||||
Service Unit Operators, Oil, Gas, and Mining | $ 48,010 | ||||||||||||||
Set and Exhibit Designers | $ 50,170 | ||||||||||||||
Ship Engineers | $ 103,040 | ||||||||||||||
Signal and Track Switch Repairers | $ 40,520 | ||||||||||||||
Social and Community Service Managers | $ 77,700 | ||||||||||||||
Social Scientists and Related Workers, All Other | $ 76,810 | ||||||||||||||
Social Work Teachers, Postsecondary | $ 66,060 | ||||||||||||||
Social Workers, All Other | $ 56,280 | ||||||||||||||
Sociology Teachers, Postsecondary | $ 84,210 | ||||||||||||||
Software Developers, Applications | $ 93,280 | ||||||||||||||
Software Developers, Systems Software | $ 111,340 | ||||||||||||||
Soil and Plant Scientists | $ 70,780 | ||||||||||||||
Sound Engineering Technicians | $ 44,310 | ||||||||||||||
Special Education Teachers, All Other | $ 69,770 | ||||||||||||||
Special Education Teachers, Kindergarten and Elementary School | $ 63,330 | ||||||||||||||
Special Education Teachers, Middle School | |||||||||||||||
Special Education Teachers, Secondary School | $ 63,370 | ||||||||||||||
Speech-Language Pathologists | $ 74,180 | ||||||||||||||
Stationary Engineers and Boiler Operators | $ 57,420 | ||||||||||||||
Statisticians | $ 94,640 | ||||||||||||||
Surveyors | $ 67,560 | ||||||||||||||
Tank Car, Truck, and Ship Loaders | $ 46,730 | ||||||||||||||
Tax Examiners and Collectors, and Revenue Agents | $ 63,730 | ||||||||||||||
Technical Writers | $ 67,260 | ||||||||||||||
Telecommunications Equipment Installers and Repairers, Except Line Installers | $ 61,410 | ||||||||||||||
Tire Builders | $ 42,500 | ||||||||||||||
Tool and Die Makers | $ 57,790 | ||||||||||||||
Training and Development Managers | $ 113,080 | ||||||||||||||
Training and Development Specialists | $ 64,490 | ||||||||||||||
Transportation Inspectors | $ 92,970 | ||||||||||||||
Transportation, Storage, and Distribution Managers | $ 103,970 | ||||||||||||||
Urban and Regional Planners | $ 70,850 | ||||||||||||||
Veterinarians | $ 91,980 | ||||||||||||||
Water and Wastewater Treatment Plant and System Operators | $ 51,720 | ||||||||||||||
Web Developers | $ 75,970 | ||||||||||||||
Wholesale and Retail Buyers, Except Farm Products | $ 59,080 | ||||||||||||||
Writers and Authors | $ 65,180 | ||||||||||||||
Zoologists and Wildlife Biologists | $ 60,060 |
Sheet3
Data
Job Title | Salary | ||
Accountants and Auditors | 71,420 | source: http://www.bls.gov/ | |
Actuaries | 99,870 | ||
Administrative Law Judges, Adjudicators, and Hearing Officers | 112,660 | ||
Administrative Services Managers | 93,150 | ||
Adult Basic and Secondary Education and Literacy Teachers and Instructors | 54,890 | ||
Advertising and Promotions Managers | 136,840 | ||
Advertising Sales Agents | 63,000 | ||
Aerospace Engineering and Operations Technicians | 69,230 | ||
Aerospace Engineers | 109,960 | ||
Agents and Business Managers of Artists, Performers, and Athletes | 85,910 | ||
Agricultural and Food Science Technicians | 42,540 | ||
Agricultural Inspectors | 39,700 | ||
Agricultural Sciences Teachers, Postsecondary | 92,010 | ||
Air Traffic Controllers | 128,980 | ||
Aircraft Cargo Handling Supervisors | 57,690 | ||
Aircraft Structure, Surfaces, Rigging, and Systems Assemblers | 48,860 | ||
Airfield Operations Specialists | 55,190 | ||
Airline Pilots, Copilots, and Flight Engineers | 101,050 | ||
Anthropologists and Archeologists | 56,640 | ||
Appraisers and Assessors of Real Estate | 71,530 | ||
Arbitrators, Mediators, and Conciliators | 91,560 | ||
Architects, Except Landscape and Naval | 85,930 | ||
Architectural and Civil Drafters | 53,290 | ||
Architecture and Engineering Occupations | 80,770 | ||
Architecture Teachers, Postsecondary | 79,040 | ||
Archivists | 49,970 | ||
Art Directors | 85,820 | ||
Art, Drama, and Music Teachers, Postsecondary | 70,390 | ||
Athletic Trainers | 48,990 | ||
Atmospheric and Space Scientists | 99,860 | ||
Atmospheric, Earth, Marine, and Space Sciences Teachers, Postsecondary | 93,990 | ||
Audiologists | 81,010 | ||
Avionics Technicians | 55,680 | ||
Biomedical Engineers | 108,290 | ||
Boilermakers | 71,230 | ||
Broadcast News Analysts | 73,660 | ||
Brokerage Clerks | 48,850 | ||
Budget Analysts | 75,010 | ||
Business and Financial Operations Occupations | 72,420 | ||
Business Operations Specialists, All Other | 69,870 | ||
Business Teachers, Postsecondary | 90,540 | ||
Buyers and Purchasing Agents, Farm Products | 62,290 | ||
Camera and Photographic Equipment Repairers | 41,910 | ||
Captains, Mates, and Pilots of Water Vessels | 67,220 | ||
Cardiovascular Technologists and Technicians | 65,850 | ||
Career/Technical Education Teachers, Middle School | 61,970 | ||
Career/Technical Education Teachers, Secondary School | 64,740 | ||
Cargo and Freight Agents | 45,820 | ||
Cartographers and Photogrammetrists | 69,020 | ||
Chefs and Head Cooks | 48,290 | ||
Chemical Engineers | 86,360 | ||
Chemical Equipment Operators and Tenders | 41,520 | ||
Chemical Plant and System Operators | 48,830 | ||
Chemical Technicians | 53,650 | ||
Chemistry Teachers, Postsecondary | 88,390 | ||
Chemists | 85,030 | ||
Child, Family, and School Social Workers | 54,310 | ||
Chiropractors | 79,250 | ||
Civil Engineers | 87,310 | ||
Claims Adjusters, Examiners, and Investigators | 62,230 | ||
Clinical, Counseling, and School Psychologists | 82,130 | ||
Coil Winders, Tapers, and Finishers | 33,490 | ||
Commercial and Industrial Designers | 63,710 | ||
Commercial Pilots | 83,220 | ||
Communications Equipment Operators, All Other | 40,600 | ||
Communications Teachers, Postsecondary | 66,990 | ||
Community and Social Service Occupations | 47,550 | ||
Community Health Workers | 40,340 | ||
Compensation and Benefits Managers | 144,350 | ||
Compensation, Benefits, and Job Analysis Specialists | 75,350 | ||
Compliance Officers | 74,970 | ||
Computer and Information Research Scientists | 117,200 | ||
Computer and Information Systems Managers | 140,920 | ||
Computer and Mathematical Occupations | 86,710 | ||
Computer Hardware Engineers | 112,250 | ||
Computer Network Architects | 107,860 | ||
Computer Network Support Specialists | 60,200 | ||
Computer Occupations, All Other | 77,570 | ||
Computer Programmers | 89,440 | ||
Computer Science Teachers, Postsecondary | 96,020 | ||
Computer Systems Analysts | 91,230 | ||
Computer User Support Specialists | 55,520 | ||
Conservation Scientists | 65,820 | ||
Construction and Building Inspectors | 69,070 | ||
Construction Managers | 93,290 | ||
Continuous Mining Machine Operators | 42,760 | ||
Control and Valve Installers and Repairers, Except Mechanical Door | 68,400 | ||
Conveyor Operators and Tenders | 35,750 | ||
Cost Estimators | 65,650 | ||
Crane and Tower Operators | 59,680 | ||
Credit Analysts | 82,060 | ||
Credit Counselors | 49,650 | ||
Criminal Justice and Law Enforcement Teachers, Postsecondary | 71,970 | ||
Curators | 54,870 | ||
Database Administrators | 88,410 | ||
Dental Hygienists | 72,850 | ||
Derrick Operators, Oil and Gas | 44,610 | ||
Detectives and Criminal Investigators | 77,660 | ||
Diagnostic Medical Sonographers | 78,560 | ||
Dietitians and Nutritionists | 61,440 | ||
Directors, Religious Activities and Education | 50,210 | ||
Drafters, All Other | 53,330 | ||
Economics Teachers, Postsecondary | 109,480 | ||
Economists | 72,810 | ||
Editors | 55,220 | ||
Education Administrators, All Other | 79,860 | ||
Education Administrators, Elementary and Secondary School | 102,010 | ||
Education Administrators, Postsecondary | 91,970 | ||
Education Administrators, Preschool and Childcare Center/Program | 57,390 | ||
Education Teachers, Postsecondary | 64,880 | ||
Education, Training, and Library Occupations | 55,000 | ||
Educational, Guidance, School, and Vocational Counselors | 56,310 | ||
Electric Motor, Power Tool, and Related Repairers | 40,360 | ||
Electrical and Electronics Drafters | 58,770 | ||
Electrical and Electronics Engineering Technicians | 62,450 | ||
Electrical and Electronics Installers and Repairers, Transportation Equipment | 61,260 | ||
Electrical and Electronics Repairers, Commercial and Industrial Equipment | 63,410 | ||
Electrical and Electronics Repairers, Powerhouse, Substation, and Relay | 78,680 | ||
Electrical Engineers | 94,390 | ||
Electrical Power-Line Installers and Repairers | 79,120 | ||
Electricians | 67,500 | ||
Electro-Mechanical Technicians | 56,450 | ||
Electronics Engineers, Except Computer | 99,490 | ||
Elementary School Teachers, Except Special Education | 63,490 | ||
Elevator Installers and Repairers | 83,900 | ||
Embalmers | 46,100 | ||
Emergency Management Directors | 87,050 | ||
Engineering Technicians, Except Drafters, All Other | 57,360 | ||
English Language and Literature Teachers, Postsecondary | 66,090 | ||
Environmental Engineering Technicians | 42,190 | ||
Environmental Engineers | 87,360 | ||
Environmental Science and Protection Technicians, Including Health | 49,460 | ||
Environmental Science Teachers, Postsecondary | 90,710 | ||
Environmental Scientists and Specialists, Including Health | 74,110 | ||
Epidemiologists | 77,440 | ||
Executive Secretaries and Executive Administrative Assistants | 56,010 | ||
Exercise Physiologists | 58,990 | ||
Explosives Workers, Ordnance Handling Experts, and Blasters | 58,320 | ||
Extruding, Forming, Pressing, and Compacting Machine Setters, Operators, and Tenders | 38,740 | ||
Farm and Home Management Advisors | 74,190 | ||
Film and Video Editors | 50,190 | ||
Financial Analysts | 91,420 | ||
Financial Clerks, All Other | 38,860 | ||
Financial Examiners | 89,040 | ||
Financial Managers | 133,980 | ||
Financial Specialists, All Other | 70,440 | ||
Fire Inspectors and Investigators | 65,710 | ||
Firefighters | |||
First-Line Supervisors of Construction Trades and Extraction Workers | 73,810 | ||
First-Line Supervisors of Correctional Officers | 76,370 | ||
First-Line Supervisors of Farming, Fishing, and Forestry Workers | 60,690 | ||
First-Line Supervisors of Fire Fighting and Prevention Workers | 71,570 | ||
First-Line Supervisors of Helpers, Laborers, and Material Movers, Hand | 49,590 | ||
First-Line Supervisors of Landscaping, Lawn Service, and Groundskeeping Workers | 51,310 | ||
First-Line Supervisors of Mechanics, Installers, and Repairers | 66,430 | ||
First-Line Supervisors of Non-Retail Sales Workers | 77,900 | ||
First-Line Supervisors of Office and Administrative Support Workers | 60,960 | ||
First-Line Supervisors of Police and Detectives | 87,970 | ||
First-Line Supervisors of Production and Operating Workers | 62,830 | ||
First-Line Supervisors of Protective Service Workers, All Other | 52,470 | ||
First-Line Supervisors of Transportation and Material-Moving Machine and Vehicle Operators | 58,250 | ||
Fish and Game Wardens | 46,110 | ||
Food Service Managers | 56,800 | ||
Foreign Language and Literature Teachers, Postsecondary | 68,890 | ||
Forensic Science Technicians | 59,640 | ||
Forest and Conservation Technicians | 42,970 | ||
Foresters | 63,990 | ||
Forestry and Conservation Science Teachers, Postsecondary | 90,080 | ||
Fundraisers | 59,900 | ||
Funeral Service Managers | 98,920 | ||
Gaming Supervisors | 32,220 | ||
Gas Compressor and Gas Pumping Station Operators | 56,220 | ||
Gas Plant Operators | 67,370 | ||
General and Operations Managers | 109,490 | ||
Geography Teachers, Postsecondary | 80,130 | ||
Geological and Petroleum Technicians | 54,390 | ||
Geoscientists, Except Hydrologists and Geographers | 72,210 | ||
Health and Safety Engineers, Except Mining Safety Engineers and Inspectors | 88,300 | ||
Health Diagnosing and Treating Practitioners, All Other | 82,600 | ||
Health Educators | 56,120 | ||
Health Specialties Teachers, Postsecondary | 82,450 | ||
Health Technologists and Technicians, All Other | 54,160 | ||
Healthcare Practitioners and Technical Occupations | 86,270 | ||
Healthcare Social Workers | 58,530 | ||
Hearing Aid Specialists | 55,690 | ||
Historians | 62,210 | ||
History Teachers, Postsecondary | 85,040 | ||
Hoist and Winch Operators | 80,660 | ||
Home Economics Teachers, Postsecondary | |||
Human Resources Managers | 121,530 | ||
Human Resources Specialists | 64,140 | ||
Industrial Engineering Technicians | 53,110 | ||
Industrial Engineers | 90,580 | ||
Industrial Machinery Mechanics | 54,180 | ||
Industrial Production Managers | 110,490 | ||
Information and Record Clerks, All Other | 43,110 | ||
Information Security Analysts | 95,930 | ||
Installation, Maintenance, and Repair Occupations | 49,750 | ||
Instructional Coordinators | 65,320 | ||
Insurance Appraisers, Auto Damage | 62,970 | ||
Insurance Sales Agents | 82,760 | ||
Insurance Underwriters | 66,930 | ||
Interior Designers | 61,130 | ||
Judges, Magistrate Judges, and Magistrates | 135,740 | ||
Kindergarten Teachers, Except Special Education | 58,790 | ||
Labor Relations Specialists | 69,170 | ||
Landscape Architects | 69,200 | ||
Lawyers | 124,230 | ||
Layout Workers, Metal and Plastic | 49,700 | ||
Legal Occupations | 97,570 | ||
Legal Support Workers, All Other | 57,980 | ||
Librarians | 62,790 | ||
Library Science Teachers, Postsecondary | 72,520 | ||
Life Scientists, All Other | 71,130 | ||
Life, Physical, and Social Science Occupations | 71,500 | ||
Loading Machine Operators, Underground Mining | 41,270 | ||
Loan Officers | 78,040 | ||
Locomotive Engineers | 66,150 | ||
Logging Workers, All Other | 41,940 | ||
Logisticians | 74,280 | ||
Magnetic Resonance Imaging Technologists | 76,530 | ||
Management Analysts | 83,560 | ||
Managers, All Other | 126,600 | ||
Marine Engineers and Naval Architects | 57,230 | ||
Market Research Analysts and Marketing Specialists | 70,940 | ||
Marketing Managers | 140,350 | ||
Marriage and Family Therapists | 52,070 | ||
Materials Engineers | 98,090 | ||
Mathematical Science Teachers, Postsecondary | 71,370 | ||
Mechanical Drafters | 58,680 | ||
Mechanical Engineering Technicians | 56,050 | ||
Mechanical Engineers | 83,940 | ||
Media and Communication Equipment Workers, All Other | 47,300 | ||
Medical and Clinical Laboratory Technologists | 65,770 | ||
Medical and Health Services Managers | 108,280 | ||
Medical Equipment Repairers | 63,230 | ||
Meeting, Convention, and Event Planners | 54,500 | ||
Mental Health Counselors | 46,580 | ||
Metal-Refining Furnace Operators and Tenders | 43,310 | ||
Middle School Teachers, Except Special and Career/Technical Education | 64,780 | ||
Millwrights | 49,300 | ||
Mine Cutting and Channeling Machine Operators | 46,410 | ||
Mine Shuttle Car Operators | 53,150 | ||
Mining and Geological Engineers, Including Mining Safety Engineers | 95,550 | ||
Mining Machine Operators, All Other | 51,740 | ||
Mixing and Blending Machine Setters, Operators, and Tenders | 38,940 | ||
Mobile Heavy Equipment Mechanics, Except Engines | 56,690 | ||
Model Makers, Metal and Plastic | 40,210 | ||
Morticians, Undertakers, and Funeral Directors | 62,060 | ||
Multimedia Artists and Animators | 58,020 | ||
Music Directors and Composers | 84,860 | ||
Natural Sciences Managers | 118,520 | ||
Network and Computer Systems Administrators | 85,560 | ||
Nuclear Engineers | 110,620 | ||
Nuclear Medicine Technologists | 83,110 | ||
Nuclear Technicians | 59,630 | ||
Nurse Practitioners | 116,150 | ||
Nursing Instructors and Teachers, Postsecondary | 69,470 | ||
Occupational Health and Safety Specialists | 78,470 | ||
Occupational Health and Safety Technicians | 53,780 | ||
Occupational Therapists | 73,680 | ||
Occupational Therapy Assistants | 48,210 | ||
Operations Research Analysts | 90,570 | ||
Optometrists | 127,590 | ||
Orthotists and Prosthetists | |||
Painters, Transportation Equipment | 55,980 | ||
Paper Goods Machine Setters, Operators, and Tenders | 40,880 | ||
Paralegals and Legal Assistants | 56,510 | ||
Patternmakers, Metal and Plastic | 46,310 | ||
Personal Financial Advisors | 109,250 | ||
Petroleum Pump System Operators, Refinery Operators, and Gaugers | 60,720 | ||
Pharmacists | 126,840 | ||
Philosophy and Religion Teachers, Postsecondary | 74,090 | ||
Physical Therapist Assistants | 53,350 | ||
Physical Therapists | 81,860 | ||
Physician Assistants | 112,460 | ||
Physicists | 134,710 | ||
Physics Teachers, Postsecondary | 85,870 | ||
Plant and System Operators, All Other | 63,770 | ||
Plumbers, Pipefitters, and Steamfitters | 71,020 | ||
Podiatrists | 199,980 | ||
Police and Sheriff’s Patrol Officers | 64,700 | ||
Political Science Teachers, Postsecondary | 102,230 | ||
Postal Service Clerks | 47,350 | ||
Postal Service Mail Carriers | 49,570 | ||
Postal Service Mail Sorters, Processors, and Processing Machine Operators | 49,190 | ||
Postmasters and Mail Superintendents | 73,270 | ||
Power Distributors and Dispatchers | 92,440 | ||
Power Plant Operators | 78,360 | ||
Precision Instrument and Equipment Repairers, All Other | 57,600 | ||
Private Detectives and Investigators | 51,840 | ||
Probation Officers and Correctional Treatment Specialists | 63,380 | ||
Producers and Directors | 68,290 | ||
Production, Planning, and Expediting Clerks | 49,410 | ||
Property, Real Estate, and Community Association Managers | 64,290 | ||
Psychologists, All Other | 86,420 | ||
Psychology Teachers, Postsecondary | 72,570 | ||
Public Relations and Fundraising Managers | 121,010 | ||
Public Relations Specialists | 60,500 | ||
Pump Operators, Except Wellhead Pumpers | 47,570 | ||
Purchasing Agents, Except Wholesale, Retail, and Farm Products | 61,760 | ||
Purchasing Managers | 116,310 | ||
Radiation Therapists | 80,510 | ||
Radio, Cellular, and Tower Equipment Installers and Repairers | 65,380 | ||
Radiologic Technologists | |||
Rail Yard Engineers, Dinkey Operators, and Hostlers | 54,860 | ||
Railroad Conductors and Yardmasters | 66,620 | ||
Rail-Track Laying and Maintenance Equipment Operators | 48,440 | ||
Real Estate Brokers | 66,270 | ||
Real Estate Sales Agents | 48,250 | ||
Recreation and Fitness Studies Teachers, Postsecondary | 63,760 | ||
Recreational Vehicle Service Technicians | 37,600 | ||
Refractory Materials Repairers, Except Brickmasons | 47,440 | ||
Registered Nurses | 77,540 | ||
Reinforcing Iron and Rebar Workers | 64,470 | ||
Respiratory Therapists | 67,460 | ||
Rolling Machine Setters, Operators, and Tenders, Metal and Plastic | 39,480 | ||
Roof Bolters, Mining | 54,150 | ||
Rotary Drill Operators, Oil and Gas | 56,660 | ||
Sales Engineers | 101,950 | ||
Sales Managers | 136,930 | ||
Sales Representatives, Services, All Other | 63,470 | ||
Sales Representatives, Wholesale and Manufacturing, Except Technical and Scientific Products | 75,270 | ||
Sales Representatives, Wholesale and Manufacturing, Technical and Scientific Products | 113,360 | ||
Secondary School Teachers, Except Special and Career/Technical Education | 65,290 | ||
Securities, Commodities, and Financial Services Sales Agents | 95,750 | ||
Service Unit Operators, Oil, Gas, and Mining | 48,010 | ||
Set and Exhibit Designers | 50,170 | ||
Ship Engineers | 103,040 | ||
Signal and Track Switch Repairers | 40,520 | ||
Social and Community Service Managers | 77,700 | ||
Social Scientists and Related Workers, All Other | 76,810 | ||
Social Work Teachers, Postsecondary | 66,060 | ||
Social Workers, All Other | 56,280 | ||
Sociology Teachers, Postsecondary | 84,210 | ||
Software Developers, Applications | 93,280 | ||
Software Developers, Systems Software | 111,340 | ||
Soil and Plant Scientists | 70,780 | ||
Sound Engineering Technicians | 44,310 | ||
Special Education Teachers, All Other | 69,770 | ||
Special Education Teachers, Kindergarten and Elementary School | 63,330 | ||
Special Education Teachers, Middle School | |||
Special Education Teachers, Secondary School | 63,370 | ||
Speech-Language Pathologists | 74,180 | ||
Stationary Engineers and Boiler Operators | 57,420 | ||
Statisticians | 94,640 | ||
Surveyors | 67,560 | ||
Tank Car, Truck, and Ship Loaders | 46,730 | ||
Tax Examiners and Collectors, and Revenue Agents | 63,730 | ||
Technical Writers | 67,260 | ||
Telecommunications Equipment Installers and Repairers, Except Line Installers | 61,410 | ||
Tire Builders | 42,500 | ||
Tool and Die Makers | 57,790 | ||
Training and Development Managers | 113,080 | ||
Training and Development Specialists | 64,490 | ||
Transportation Inspectors | 92,970 | ||
Transportation, Storage, and Distribution Managers | 103,970 | ||
Urban and Regional Planners | 70,850 | ||
Veterinarians | 91,980 | ||
Water and Wastewater Treatment Plant and System Operators | 51,720 | ||
Web Developers | 75,970 | ||
Wholesale and Retail Buyers, Except Farm Products | 59,080 | ||
Writers and Authors | 65,180 | ||
Zoologists and Wildlife Biologists | 60,060 |
Sheet2
Sheet3
Deliverable 01 Worksheet
1. Introduce your scenario and data set.
· Provide a brief overview of the scenario you are given and describe the data set.
· Describe how you will be analyzing the data set.
· Classify the variables in your data set.
· Which variables are quantitative/qualitative?
· If it is a quantitative variable, is it discrete or continuous?
· Describe the level of measurement for each variable included in the data set (nominal, ordinal, interval, ratio).
Answer and Explanation:
Enter your step-by-step answer and explanations here.
· The client wants to know the salary distribution of jobs that pay between $30,000 and $200,000 in the state of Minnesota. I have obtained data on 364 individuals in various job titles who are within the required range from the Bureau of Statistics.
· I will analyze my data using Excel and present my results using graphical tools such as charts, histograms, scatter plots, histograms and tables to present my data.
I intend to use descriptive statistics such as frequency tables, median, mean, mode, variance, skewness and frequency tables to describe the distribution of the data obtained.
· Classification of my data
· A Job title is a qualitative categorical variable because it takes names as values. It has a nominal level of measurement because it uses words.
· Salary is a quantitative continuous variable because it takes numeric values. It has an interval-ratio level of measurement.
2. Discuss the importance of the Measures of Center.
· Name and describe each measure of center.
· Discuss the advantages and disadvantages of each.
Answer and Explanation:
Enter your step-by-step answer and explanations here.
Measures of the center are used to approximate and explain the middle value or average of the given data set to understand where the center of data distribution is located. The three measures of center are mean, median and mode.
1. The mean is defined as the arithmetic average of a data set and is calculated by adding all the values in the data and dividing by the number of values. Its advantage is that it can be used as a basis for statistical analysis and tests of significance. One disadvantage of the mean is that it is very sensitive to extreme values or outliers.
2. The median is the middle value or observation of a data set arranged in numerical order. This means that half of the values are below the median and half of the values are above it. Its advantage is that it is not sensitive to outliers. It is also a better descriptive measure when dealing with a skewed data set. Its disadvantage is that it cannot be used to test statistical significance in a dataset.
3. The mode refers to the value that appears most frequently in a data set. It is easy to locate which is one of its advantages. The mode is also good in measuring datasets with nominal variables. A disadvantage of the mode is that there may be two or more mode in a data set the same time. The mode is also sensitive to the mean.
3. Discuss the importance of the Measures of Variation.
· Name and describe each measure of variation.
· Discuss the advantages and disadvantages of each.
Answer and Explanation:
Enter your step-by-step answer and explanations here.
Measuring variation helps researchers measure the spread of data hence distinguishing if it is from systematic trends or differences. There measures of variation; variance, standard deviation, and range.
1. Variance is a measure of the spread of a set of values from the average value or the mean. Its advantage is that it helps us explain the volatility of a value. Its disadvantage is that it is hard to calculate manually and it is affected extreme outliers
2. Standard deviation is a measure of how close or far away from values are spread from the mean. Its advantage is that it helps us understand how data is clustered around the mean. It is also not sensitive to outliers. Its disadvantage is that it does not give a full range of the data. It is also difficult to compute.
3. The range is a measure between the largest and smallest values of a dataset. It is easier to calculate and can be used to measure variation in cases where accuracy is not necessary. Its disadvantage is that it is only affected by two values.
4. Calculate the measures of center and measures of variation from the data set and list them below. Be sure to include (a) an interpretation of each measure in the context of the scenario (for example, if the median is larger than the mean, what does it mean? What does the value of standard deviation tell you?) and (b) correct units of measurement. Show your calculations in your spreadsheet. You do not need to include Excel functions in your written answer below.
· Mean
· Median
· Mode
· Midrange
· Range
· Variance
· Standard deviation
Answer and Explanation:
Enter your step-by-step answer and explanations here.
Measure of center
1. Mean – $71,879
2. Median – $66,525
3. Mode – $71, 420
The average salary for individuals in different jobs titles that earn salaries between $30,000 and $200,000 in Minnesota is $71,879, and the mode is $71,420.The median is $66,525 which is smaller than the mean. This means that the distribution of this range of salaries is skewed to the right. It also indicates that there are outliers in the higher end.
Measure of variation
1. Mid-range – $66,525
2. Range – $167,760
3. Variance – 546,033,522
4. Standard deviation – 23,367
The range for the salary is $167,760 which is very large and indicates that there is a greater dispersion of the salaries between $30,000 and $200,000. The variance of the data is 546,033,522, and the standard deviation is 23,367 which indicate that the salaries for the different job titles deviate from the average salary for the group by $23,376. This is a large deviation, and this might be due to the possibility of outliers as we have seen above when interpreting the measure of center. If you eliminated the outliers from the data, the standard deviation might be smaller.
Deliverable 03 Worksheet
1. Discuss the importance of constructing confidence intervals for the population mean by answering these questions.
· What are confidence intervals?
· What is a point estimate?
· What is the best point estimate for the population mean? Explain.
· Why do we need confidence intervals?
Answer and Explanation:
Enter your step-by-step answer and explanations here.
2. Using the data from the Excel workbook, construct a
95%
confidence interval for the population mean. Assume that your data is normally distributed and σ is unknown. Include a statement that correctly interprets the confidence interval in context of the scenario.
Hint: Use the sample mean and sample standard deviation from Deliverable 1.
Answer and Explanation:
Enter your step-by-step answer and explanations here.
3. Using the data from the Excel workbook, construct a
99%
confidence interval for the population mean. Assume that your data is normally distributed and σ is unknown. Include a statement that correctly interprets the confidence interval in context of the scenario.
Hint: Use the sample mean and sample standard deviation from Deliverable 1.
Answer and Explanation:
Enter your step-by-step answer and explanations here.
4. Compare your answers for (2) and (3). You notice that the 99% confidence interval is wider. What is the advantage of using a wider confidence interval? Why would you not always use the 99% confidence interval? Explain with an example.
Answer and Explanation:
Enter your step-by-step answer and explanations here.
5. We want to estimate the mean salary in Minnesota. How many jobs must be randomly selected for their respective mean salaries if we want 95% confidence that the sample mean is within $126 of the population mean and σ = $1150.
Is the current sample size of 364 in the data set in our Excel workbook large enough? Explain.
Answer and Explanation:
Enter your step-by-step answer and explanations here.