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

0

Scenario

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

Deliverable 1 – Descriptive Statistics

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.

Instructions

The Excel spreadsheet contains five tabs. The first tab, labeled “data” requires you to calculate all measures of center and variation using the correct Excel formulas. The next four tabs contain questions for you to complete. Ensure that you are completely answering all questions with explanations, and your work is shown when needed.

You must submit the spreadsheet with the completed calculations, answers, and analysis.

Resources

Microsoft Excel is required to complete this assignment. If

Data

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *

All Rights Reserved Terms and Conditions
College pals.com Privacy Policy 2010-2018

Job Title Yearly Average Salary
Accountants and Auditors 76,130 Salary Calculations Formulas/Answers
Actuaries 112,030 Mean
Acupuncturists and Healthcare Diagnosing or Treating Practitioners, All Other 80,390 Median
Adhesive Bonding Machine Operators and Tenders 39,460 Modes
Administrative Law Judges, Adjudicators, and Hearing Officers 114,760
Adult Basic Education, Adult Secondary Education, and English as a Second Language Instructors 58,860
Advertising and Promotions Managers 122,770
Advertising Sales Agents 51,930
Aerospace Engineers 115,910
Agents and Business Managers of Artists, Performers, and Athletes 65,160
Agricultural and Food Science Technicians 43,580
Agricultural Equipment Operators 38,540 Midrange
Agricultural Inspectors 59,800 Range
Agricultural Sciences Teachers, Postsecondary 100,480 Variance
Agricultural Workers, All Other 37,230 Standard Deviation
Air Traffic Controllers 141,410
Aircraft Cargo Handling Supervisors 55,100 Maximum
Aircraft Mechanics and Service Technicians 79,080 Minimum
Aircraft Service Attendants and Transportation Workers, All Other 31,380
Animal Caretakers 30,980
Animal Control Workers 45,440
Animal Scientists 70,410
Animal Trainers 39,580
Anthropologists and Archeologists 74,440
Anthropology and Archeology Teachers, Postsecondary 84,040
Architects, Except Landscape and Naval 100,650
Architectural and Civil Drafters 57,170
Architectural and Engineering Managers 152,910
Architecture and Engineering Occupations 84,810
Archivists 47,820
Area, Ethnic, and Cultural Studies Teachers, Postsecondary 86,380
Art Directors 111,960
Art, Drama, and Music Teachers, Postsecondary 101,350
Artists and Related Workers, All Other 47,680
Arts, Design, Entertainment, Sports, and Media Occupations 57,790
Athletes and Sports Competitors 164,800
Athletic Trainers 53,660
Atmospheric and Space Scientists 87,970
Atmospheric, Earth, Marine, and Space Sciences Teachers, Postsecondary 87,730
Audio and Video Technicians 49,970
Audiologists 89,780
Audiovisual Equipment Installers and Repairers 52,730
Automotive Body and Related Repairers 51,390
Automotive Glass Installers and Repairers 44,420
Automotive Service Technicians and Mechanics 46,780
Avionics Technicians 66,350
Bailiffs 52,770
Bakers 33,750
Barbers 42,630
Bicycle Repairers 33,250
Bill and Account Collectors 43,090
Billing and Posting Clerks 43,790
Bioengineers and Biomedical Engineers 110,240
Biological Science Teachers, Postsecondary 84,010
Biological Scientists, All Other 75,860
Biological Technicians 46,510
Boilermakers 85,170
Bookkeeping, Accounting, and Auditing Clerks 44,960
Brickmasons and Blockmasons 71,450
Bridge and Lock Tenders 62,060
Broadcast Announcers and Radio Disc Jockeys 33,510
Broadcast Technicians 40,130
Brokerage Clerks 56,660
Budget Analysts 81,270
Building and Grounds Cleaning and Maintenance Occupations 35,320
Bus and Truck Mechanics and Diesel Engine Specialists 53,700
Bus Drivers, Transit and Intercity 44,050
Business and Financial Operations Occupations 80,310
Business Teachers, Postsecondary 111,630
Butchers and Meat Cutters 35,790
Buyers and Purchasing Agents 71,920
Cabinetmakers and Bench Carpenters 42,620
Calibration Technologists and Technicians and Engineering Technologists and Technicians, Except Drafters, All Other 62,510
Camera and Photographic Equipment Repairers 46,030
Camera Operators, Television, Video, and Film 52,340
Captains, Mates, and Pilots of Water Vessels 76,860
Cardiovascular Technologists and Technicians 66,690
Career/Technical Education Teachers, Middle School 72,630
Career/Technical Education Teachers, Postsecondary 72,500
Career/Technical Education Teachers, Secondary School 64,540
Cargo and Freight Agents 56,250
Carpenters 54,990
Carpet Installers 60,830
Cartographers and Photogrammetrists 70,720
Cement Masons and Concrete Finishers 56,900
Chefs and Head Cooks 54,750
Chemical Engineers 107,610
Chemical Equipment Operators and Tenders 44,960
Chemical Plant and System Operators 53,320
Chemical Technicians 54,230
Chemistry Teachers, Postsecondary 83,350
Chemists 87,960
Chief Executives 198,110
Child, Family, and School Social Workers 57,570
Chiropractors 93,540
Choreographers 47,290
Civil Engineering Technologists and Technicians 67,790
Civil Engineers 95,620
Claims Adjusters, Examiners, and Investigators 70,430
Cleaning, Washing, and Metal Pickling Equipment Operators and Tenders 36,990
Clergy 50,670
Clinical Laboratory Technologists and Technicians 59,840
Clinical, Counseling, and School Psychologists 85,560
Coaches and Scouts 42,850
Coating, Painting, and Spraying Machine Setters, Operators, and Tenders 43,680
Coil Winders, Tapers, and Finishers 37,000
Coin, Vending, and Amusement Machine Servicers and Repairers 46,130
Commercial and Industrial Designers 76,570
Commercial Pilots 111,690
Communications Equipment Operators, All Other 51,000
Communications Teachers, Postsecondary 69,300
Community and Social Service Occupations 52,300
Community and Social Service Specialists, All Other 48,220
Community Health Workers 44,260
Compensation and Benefits Managers 121,640
Compensation, Benefits, and Job Analysis Specialists 75,190
Compliance Officers 84,510
Computer and Information Research Scientists 133,340
Computer and Information Systems Managers 152,080
Computer and Mathematical Occupations 94,570
Computer Hardware Engineers 114,120
Computer Network Architects 126,050
Computer Network Support Specialists 71,410
Computer Numerically Controlled Tool Operators 47,370
Computer Numerically Controlled Tool Programmers 65,870
Computer Occupations, All Other 91,640
Computer Programmers 87,940
Computer Science Teachers, Postsecondary 83,010
Computer Systems Analysts 100,280
Computer User Support Specialists 57,960
Computer, Automated Teller, and Office Machine Repairers 44,290
Concierges 32,790
Construction and Building Inspectors 74,430
Construction and Extraction Occupations 62,590
Construction Managers 97,310
Continuous Mining Machine Operators 68,830
Control and Valve Installers and Repairers, Except Mechanical Door 74,880
Conveyor Operators and Tenders 40,620
Cooks, All Other 35,030
Cooks, Institution and Cafeteria 35,160
Cooks, Restaurant 32,650
Cooling and Freezing Equipment Operators and Tenders 45,490
Correctional Officers and Jailers 54,360
Cost Estimators 69,640
Costume Attendants 51,060
Counselors, All Other 46,710
Counter and Rental Clerks 34,030
Couriers and Messengers 38,790
Court, Municipal, and License Clerks 47,860
Craft Artists 44,360
Crane and Tower Operators 57,420
Credit Analysts 80,470
Credit Authorizers, Checkers, and Clerks 48,630
Credit Counselors 49,760
Criminal Justice and Law Enforcement Teachers, Postsecondary 60,880
Crushing, Grinding, and Polishing Machine Setters, Operators, and Tenders 47,670
Curators 61,010
Customer Service Representatives 42,710
Cutting and Slicing Machine Setters, Operators, and Tenders 42,970
Cutting, Punching, and Press Machine Setters, Operators, and Tenders, Metal and Plastic 42,240
Data Entry Keyers 33,950
Data Scientists and Mathematical Science Occupations, All Other 98,260
Database Administrators and Architects 106,380
Dental Assistants 53,670
Dental Hygienists 76,410
Dental Laboratory Technicians 44,210
Dentists, All Other Specialists 195,210
Designers, All Other 68,260
Desktop Publishers 49,970
Detectives and Criminal Investigators 82,600
Diagnostic Medical Sonographers 83,360
Dietetic Technicians 39,680
Dietitians and Nutritionists 64,350
Directors, Religious Activities and Education 65,240
Dispatchers, Except Police, Fire, and Ambulance 49,970
Drafters, All Other 57,300
Dredge Operators 72,550
Drilling and Boring Machine Tool Setters, Operators, and Tenders, Metal and Plastic 37,000
Driver/Sales Workers 31,320
Drywall and Ceiling Tile Installers 52,230
Earth Drillers, Except Oil and Gas; and Explosives Workers, Ordnance Handling Experts, and Blasters 54,590
Economists 102,090
Editors 64,150
Education Administrators, All Other 82,010
Education Administrators, Kindergarten through Secondary 111,070
Education Administrators, Postsecondary 110,580
Education and Childcare Administrators, Preschool and Daycare 62,810
Education Teachers, Postsecondary 74,570
Educational Instruction and Library Occupations 57,200
Educational Instruction and Library Workers, All Other 52,580
Educational, Guidance, and Career Counselors and Advisors 61,220
Electric Motor, Power Tool, and Related Repairers 46,760