Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Deliverable 1 - Descriptive Statistics Assignment Content Competency Describe the data using the measures of central tendency and measures of variability. Student Success Criteria View

Deliverable 1 - Descriptive Statistics

Assignment Content

Competency

Describe the data using the measures of central tendency and measures of variability.

Student Success Criteria

View the grading rubric for this deliverable by selecting the "This item is graded with a rubric" link, which is located in theDetails & Informationpane.

Instructions

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 aspreadsheetthat contains the following information:

  • A listing of the jobs by title
  • The salary (in dollars) for each job

Deliverable 1 - Descriptive Statistics.xlsx

The client needs the preliminary findings by the end of the day. Your boss asks you to first compute some basic statistics and then analyze the results in the four questions given in the Excel spreadsheet.

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 spreadsheet with the completed calculations, answers, and analysis.

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 Formulas/Answers
Administrative Services Managers 93,150 Mean
Adult Basic and Secondary Education and Literacy Teachers and Instructors 54,890 Median
Advertising and Promotions Managers 136,840 Mode
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 Midrange
Aircraft Structure, Surfaces, Rigging, and Systems Assemblers 48,860 Range
Airfield Operations Specialists 55,190 Variance
Airline Pilots, Copilots, and Flight Engineers 101,050 Standard Deviation
Anthropologists and Archeologists 56,640
Appraisers and Assessors of Real Estate 71,530 Maximum
Arbitrators, Mediators, and Conciliators 91,560 Minimum
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 37,150
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 73,980
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,550
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 37,150
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,900
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 72,500
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 72,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 73,980
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 189,660
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 65,550
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,750
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 65,750
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Linear Algebra with Applications

Authors: Steven J. Leon

7th edition

131857851, 978-0131857858

More Books

Students also viewed these Mathematics questions