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
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 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.
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.
Your boss wants you to submit the spreadsheet with the completed calculations, answers, and analysis.
Data
| Job Title | Salary | ||||
| Accountants and Auditors | 71,470 | source: http://www.bls.gov/ | |||
| Actuaries | 99,870 | ||||
| Administrative Law Judges, Adjudicators, and Hearing Officers | 112,660 | Calculations/Values | Formulas/Answers | ||
| Administrative Services Managers | 93,150 | Mean | |||
| Adult Basic and Secondary Education and Literacy Teachers and Instructors | 54,890 | Standard Deviation | |||
| Advertising and Promotions Managers | 136,840 | n | |||
| 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,100 | ||||
| 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,880 | ||||
| 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 | 65,050 | ||||
| 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 | 35,100 | ||||
| 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 | 30,110 | ||||
| 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 | 71,470 | ||||
| Human Resources Managers | 121,530 | ||||
| Human Resources Specialists | 64,140 | ||||
| Industrial Engineering Technicians | 53,110 | ||||
| Industrial Engineers | 90,580 | ||||
| Industrial Machinery Mechanics | 54,180 | ||||
