No plagiarism

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

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

Electrical and Electronic Engineering Technologists and Technicians
65,190

Electrical and Electronics Drafters
71,300

Electrical and Electronics Installers and Repairers, Transportation Equipment
70,100

Electrical and Electronics Repairers, Commercial and Industrial Equipment
66,820

Electrical and Electronics Repairers, Powerhouse, Substation, and Relay
98,380

Electrical Engineers
102,910

Electrical Power-Line Installers and Repairers
82,290

Electrical, Electronic, and Electromechanical Assemblers, Except Coil Winders, Tapers, and Finishers
38,230

Electricians
69,040

Electro-Mechanical and Mechatronics Technologists and Technicians
56,970

Electronic Equipment Installers and Repairers, Motor Vehicles
43,920

Electronics Engineers, Except Computer
103,230

Elementary School Teachers, Except Special Education
62,560

Elevator and Escalator Installers and Repairers
88,360

Emergency Management Directors
91,710

Emergency Medical Technicians and Paramedics
43,730

Engine and Other Machine Assemblers
47,040

Engineering Teachers, Postsecondary
109,600

Engineers, All Other
102,080

English Language and Literature Teachers, Postsecondary
70,290

Environmental Engineering Technologists and Technicians
54,190

Environmental Engineers
107,430

Environmental Science and Protection Technicians, Including Health
63,150

Environmental Science Teachers, Postsecondary
102,650

Environmental Scientists and Specialists, Including Health
78,260

Epidemiologists
76,270

Excavating and Loading Machine and Dragline Operators, Surface Mining
56,370

Executive Secretaries and Executive Administrative Assistants
62,490

Exercise Physiologists
59,140

Exercise Trainers and Group Fitness Instructors
46,430

Extruding and Drawing Machine Setters, Operators, and Tenders, Metal and Plastic
44,090

Extruding, Forming, Pressing, and Compacting Machine Setters, Operators, and Tenders
41,980

Fabric and Apparel Patternmakers
56,160

Farm and Home Management Educators
50,170

Farm Equipment Mechanics and Service Technicians
49,250

Farmers, Ranchers, and Other Agricultural Managers
99,890

Farming, Fishing, and Forestry Occupations
39,060

Farmworkers and Laborers, Crop, Nursery, and Greenhouse
35,320

Fashion Designers
73,170

Fence Erectors
38,760

Fiberglass Laminators and Fabricators
38,460

File Clerks
35,540

Film and Video Editors
74,230

Financial and Investment Analysts, Financial Risk Specialists, and Financial Specialists, All Other
93,730

Financial Clerks, All Other
45,060

Financial Examiners
92,590

Financial Managers
142,210

Fine Artists, Including Painters, Sculptors, and Illustrators
67,860

Fire Inspectors and Investigators
76,020

Firefighters
41,180

Flight Attendants
54,320

Floor Layers, Except Carpet, Wood, and Hard Tiles
46,190

Food and Tobacco Roasting, Baking, and Drying Machine Operators and Tenders
38,940

Food Batchmakers
36,700

Food Cooking Machine Operators and Tenders
39,870

Food Preparation Workers
31,330

Food Processing Workers, All Other
32,940

Food Scientists and Technologists
79,830

Food Service Managers
62,820

Foreign Language and Literature Teachers, Postsecondary
72,490

Forensic Science Technicians
70,440

Forest and Conservation Technicians
46,340

Forest and Conservation Workers
43,440

Foresters
63,190

Forging Machine Setters, Operators, and Tenders, Metal and Plastic
42,080

Foundry Mold and Coremakers
42,370

Fundraisers
64,540

Funeral Attendants
32,350

Funeral Home Managers
111,710

Furnace, Kiln, Oven, Drier, and Kettle Operators and Tenders
45,550

Furniture Finishers
40,230

Gas Plant Operators
74,140

General and Operations Managers
120,190

Genetic Counselors
83,330

Geographers
71,360

Geography Teachers, Postsecondary
81,340

Geological and Hydrologic Technicians
59,740

Geoscientists, Except Hydrologists and Geographers
83,570

Glaziers
56,910

Graders and Sorters, Agricultural Products
31,190

Graphic Designers
54,360

Grinding, Lapping, Polishing, and Buffing Machine Tool Setters, Operators, and Tenders, Metal and Plastic
40,600

Grounds Maintenance Workers, All Other
45,990

Hairdressers, Hairstylists, and Cosmetologists
33,510

Hazardous Materials Removal Workers
59,830

Health and Safety Engineers, Except Mining Safety Engineers and Inspectors
95,540

Health Education Specialists
60,610

Health Information Technologists, Medical Registrars, Surgical Assistants, and Healthcare Practitioners and Technical Workers, All Other
77,450

Healthcare Practitioners and Technical Occupations
91,990

Healthcare Social Workers
57,960

Healthcare Support Occupations
33,320

Healthcare Support Workers, All Other
40,400

Hearing Aid Specialists
51,440

Heat Treating Equipment Setters, Operators, and Tenders, Metal and Plastic
38,960

Heating, Air Conditioning, and Refrigeration Mechanics and Installers
62,820

Heavy and Tractor-Trailer Truck Drivers
51,040

Helpers–Brickmasons, Blockmasons, Stonemasons, and Tile and Marble Setters
58,360

Helpers–Carpenters
36,640

Helpers–Electricians
43,890

Helpers–Installation, Maintenance, and Repair Workers
36,730

Helpers–Painters, Paperhangers, Plasterers, and Stucco Masons
42,660

Helpers–Pipelayers, Plumbers, Pipefitters, and Steamfitters
38,810

Highway Maintenance Workers
53,640

History Teachers, Postsecondary
79,230

Hoist and Winch Operators
78,860

Home Appliance Repairers
44,090

Human Resources Assistants, Except Payroll and Timekeeping
45,490

Human Resources Managers
128,440

Human Resources Specialists
70,010

Hydrologists
80,880

Industrial Engineering Technologists and Technicians
57,080

Industrial Engineers
94,400

Industrial Machinery Mechanics
60,900

Industrial Production Managers
117,850

Industrial Truck and Tractor Operators
45,960

Information and Record Clerks, All Other
48,010

Information Security Analysts
103,750

Inspectors, Testers, Sorters, Samplers, and Weighers
45,680

Installation, Maintenance, and Repair Occupations
54,700

Installation, Maintenance, and Repair Workers, All Other
48,110

Instructional Coordinators
76,820

Insulation Workers, Floor, Ceiling, and Wall
48,990

Insulation Workers, Mechanical
75,970

Insurance Claims and Policy Processing Clerks
47,680

Insurance Sales Agents
78,220

Insurance Underwriters
83,160

Interior Designers
62,480

Interpreters and Translators
52,110

Interviewers, Except Eligibility and Loan
39,660

Jewelers and Precious Stone and Metal Workers
38,490

Judges, Magistrate Judges, and Magistrates
147,750

Judicial Law Clerks
58,710

Kindergarten Teachers, Except Special Education
63,010

Labor Relations Specialists
73,310

Laborers and Freight, Stock, and Material Movers, Hand
37,700

Landscape Architects
74,960

Landscaping and Groundskeeping Workers
36,720

Lathe and Turning Machine Tool Setters, Operators, and Tenders, Metal and Plastic
46,490

Law Teachers, Postsecondary
137,280

Lawyers
131,460

Layout Workers, Metal and Plastic
46,640

Legal Occupations
103,830

Legal Secretaries and Administrative Assistants
57,350

Legal Support Workers, All Other
72,470

Legislators
35,750

Librarians and Media Collections Specialists
64,700

Library Assistants, Clerical
33,130

Library Science Teachers, Postsecondary
72,330

Library Technicians
46,020

Licensed Practical and Licensed Vocational Nurses
49,840

Life, Physical, and Social Science Occupations
83,020

Light Truck Drivers
42,810

Lighting Technicians and Media and Communication Equipment Workers, All Other
72,990

Loan Interviewers and Clerks
44,650

Loan Officers
79,740

Locksmiths and Safe Repairers
50,060

Locomotive Engineers
77,170

Lodging Managers
62,800

Logging Equipment Operators
43,890

Logisticians
77,650

Machine Feeders and Offbearers
36,400

Machinists
52,710

Magnetic Resonance Imaging Technologists
80,230

Mail Clerks and Mail Machine Operators, Except Postal Service
33,890

Maintenance and Repair Workers, General
49,180

Maintenance Workers, Machinery
52,220

Management Analysts
98,600

Management Occupations
124,020

Market Research Analysts and Marketing Specialists
78,600

Marketing Managers
150,820

Marriage and Family Therapists
63,700

Massage Therapists
53,060

Material Moving Workers, All Other
45,920

Materials Engineers
101,220

Materials Scientists
96,570

Mathematical Science Teachers, Postsecondary
82,750

Meat, Poultry, and Fish Cutters and Trimmers
33,380

Mechanical Door Repairers
43,860

Mechanical Drafters
63,090

Mechanical Engineering Technologists and Technicians
63,400

Mechanical Engineers
88,340

Media and Communication Workers, All Other
58,730

Medical and Health Services Managers
111,360

Medical Appliance Technicians
52,800

Medical Assistants
43,090

Metal-Refining Furnace Operators and Tenders
53,970

Meter Readers, Utilities
59,720

Microbiologists
76,660

Middle School Teachers, Except Special and Career/Technical Education
63,670

Milling and Planing Machine Setters, Operators, and Tenders, Metal and Plastic
48,460

Millwrights
64,340

Motorcycle Mechanics
45,270

Multiple Machine Tool Setters, Operators, and Tenders, Metal and Plastic
42,610

Museum Technicians and Conservators
39,910

Music Directors and Composers
49,120

Musical Instrument Repairers and Tuners
41,510

Natural Sciences Managers
141,930

Network and Computer Systems Administrators
86,860

New Accounts Clerks
43,290

News Analysts, Reporters, and Journalists
64,260

Nuclear Engineers
119,750

Nuclear Medicine Technologists
87,530

Nurse Midwives
123,600

Nurse Practitioners
118,900

Nursing Assistants
36,040

Nursing Instructors and Teachers, Postsecondary
72,590

Optometrists
137,530

Order Clerks
38,660

Orderlies
39,200

Orthotists and Prosthetists
79,420

Outdoor Power Equipment and Other Small Engine Mechanics
42,030

Packaging and Filling Machine Operators and Tenders
38,030

Painters, Construction and Maintenance
55,490

Painting, Coating, and Decorating Workers
41,780

Paper Goods Machine Setters, Operators, and Tenders
40,000

Paralegals and Legal Assistants
58,270

Parking Enforcement Workers
40,940

Parts Salespersons
38,460

Passenger Vehicle Drivers, Except Bus Drivers, Transit and Intercity
38,540

Patternmakers, Metal and Plastic
59,470

Paving, Surfacing, and Tamping Equipment Operators
56,830

Payroll and Timekeeping Clerks
52,640

Personal Care and Service Occupations
33,490

Personal Financial Advisors
153,830

Personal Service Managers, All Other; Entertainment and Recreation Managers, Except Gambling; and Managers, All Other
128,080

Pest Control Workers
40,400

Pesticide Handlers, Sprayers, and Applicators, Vegetation
35,810

Petroleum Pump System Operators, Refinery Operators, and Gaugers
66,730

Pharmacists
130,690

Pharmacy Aides
31,260

Pharmacy Technicians
39,770

Philosophy and Religion Teachers, Postsecondary
76,750

Phlebotomists
40,150

Photographers
60,630

Physical Therapist Aides
38,250

Physical Therapist Assistants
57,920

Physical Therapists
86,020

Physician Assistants
122,280

Physicists
145,770

Physics Teachers, Postsecondary
99,590

Pile Driver Operators
72,200

Pipelayers
76,390

Plant and System Operators, All Other
60,460

Plasterers and Stucco Masons
73,340

Plumbers, Pipefitters, and Steamfitters
76,080

Podiatrists
168,430

Police and Sheriff’s Patrol Officers
74,370

Political Science Teachers, Postsecondary
91,630

Postal Service Clerks
50,830

Postal Service Mail Carriers
52,520

Postal Service Mail Sorters, Processors, and Processing Machine Operators
49,720

Postmasters and Mail Superintendents
77,100

Postsecondary Teachers, All Other
56,050

Pourers and Casters, Metal
40,590

Power Distributors and Dispatchers
84,680

Power Plant Operators
89,580

Precision Instrument and Equipment Repairers, All Other
65,650

Prepress Technicians and Workers
51,170

Preschool Teachers, Except Special Education
40,280

Print Binding and Finishing Workers
40,960

Printing Press Operators
45,500

Probation Officers and Correctional Treatment Specialists
70,070

Procurement Clerks
44,970

Producers and Directors
73,100

Production Occupations
43,430

Production Workers, All Other
37,180

Production, Planning, and Expediting Clerks
53,440

Project Management Specialists and Business Operations Specialists, All Other
76,740

Proofreaders and Copy Markers
45,930

Property Appraisers and Assessors
66,790

Property, Real Estate, and Community Association Managers
74,580

Protective Service Occupations
55,170

Psychiatric Aides
42,830

Psychologists, All Other
94,360

Psychology Teachers, Postsecondary
87,560

Public Relations and Fundraising Managers
118,470

Public Relations Specialists
67,860

Public Safety Telecommunicators
57,050

Pump Operators, Except Wellhead Pumpers
50,320

Purchasing Managers
127,070

Radiation Therapists
85,090

Radio, Cellular, and Tower Equipment Installers and Repairers
70,570

Radiologic Technologists and Technicians
70,570

Rail Car Repairers
63,170

Rail Yard Engineers, Dinkey Operators, and Hostlers
62,730

Railroad Brake, Signal, and Switch Operators and Locomotive Firers
57,410

Railroad Conductors and Yardmasters
67,060

Rail-Track Laying and Maintenance Equipment Operators
54,340

Real Estate Brokers
58,690

Real Estate Sales Agents
46,760

Receptionists and Information Clerks
32,880

Recreation and Fitness Studies Teachers, Postsecondary
67,050

Recreational Therapists
49,630

Recreational Vehicle Service Technicians
64,360

Refuse and Recyclable Material Collectors
40,230

Registered Nurses
80,960

Rehabilitation Counselors
42,000

Reinforcing Iron and Rebar Workers
71,620

Religious Workers, All Other
54,750

Reservation and Transportation Ticket Agents and Travel Clerks
51,780

Residential Advisors
41,090

Respiratory Therapists
69,830

Riggers
67,200

Rock Splitters, Quarry
40,120

Rolling Machine Setters, Operators, and Tenders, Metal and Plastic
43,610

Roofers
58,860

Sales and Related Occupations
48,160

Sales and Related Workers, All Other
37,900

Sales Engineers
97,960

Sales Managers
136,490

Sales Representatives of Services, Except Advertising, Insurance, Financial Services, and Travel
71,790

Sales Representatives, Wholesale and Manufacturing, Except Technical and Scientific Products
80,210

Sales Representatives, Wholesale and Manufacturing, Technical and Scientific Products
91,120

Sawing Machine Setters, Operators, and Tenders, Wood
37,010

School Bus Monitors and Protective Service Workers, All Other
37,850

Secondary School Teachers, Except Special and Career/Technical Education
64,540

Secretaries and Administrative Assistants, Except Legal, Medical, and Executive
42,560

Securities, Commodities, and Financial Services Sales Agents
104,300

Security and Fire Alarm Systems Installers
59,760

Security Guards
38,800

Self-Enrichment Teachers
43,400

Separating, Filtering, Clarifying, Precipitating, and Still Machine Setters, Operators, and Tenders
45,050

Septic Tank Servicers and Sewer Pipe Cleaners
54,710

Service Unit Operators, Oil and Gas
58,400

Set and Exhibit Designers
56,850

Sewing Machine Operators
34,260

Sheet Metal Workers
67,270

Shipping, Receiving, and Inventory Clerks
39,980

Shoe and Leather Workers and Repairers
36,800

Signal and Track Switch Repairers
70,820

Skincare Specialists
43,120

Slaughterers and Meat Packers
32,830

Social and Community Service Managers
78,960

Social and Human Service Assistants
38,490

Social Science Research Assistants
49,770

Social Sciences Teachers, Postsecondary, All Other
87,340

Social Scientists and Related Workers, All Other
94,680

Social Work Teachers, Postsecondary
70,300

Social Workers, All Other
63,910

Sociologists
59,400

Sociology Teachers, Postsecondary
79,390

Software Developers and Software Quality Assurance Analysts and Testers
108,060

Soil and Plant Scientists
68,240

Sound Engineering Technicians
56,680

Special Education Teachers, All Other
65,920

Special Education Teachers, Kindergarten and Elementary School
59,180

Special Education Teachers, Middle School
64,820

Special Education Teachers, Preschool
63,590

Special Education Teachers, Secondary School
64,490

Special Effects Artists and Animators
67,300

Speech-Language Pathologists
75,680

Stationary Engineers and Boiler Operators
63,440

Statistical Assistants
50,730

Statisticians
88,620

Stockers and Order Fillers
33,210

Stonemasons
43,230

Structural Iron and Steel Workers
58,290

Structural Metal Fabricators and Fitters
46,210

Substance Abuse, Behavioral Disorder, and Mental Health Counselors
53,450

Substitute Teachers, Short-Term
36,550

Surgical Technologists
61,300

Survey Researchers
69,020

Surveying and Mapping Technicians
58,410

Surveyors
66,020

Switchboard Operators, Including Answering Service
37,580

Tailors, Dressmakers, and Custom Sewers
38,380

Tank Car, Truck, and Ship Loaders
45,140

Tapers
65,290

Tax Examiners and Collectors, and Revenue Agents
67,110

Tax Preparers
51,540

Teaching Assistants, Except Postsecondary
33,510

Teaching Assistants, Postsecondary
39,070

Technical Writers
70,480

Telecommunications Equipment Installers and Repairers, Except Line Installers
52,150

Telecommunications Line Installers and Repairers
52,450

Telemarketers
37,910

Tellers
33,500

Textile Knitting and Weaving Machine Setters, Operators, and Tenders
34,930

Therapists, All Other
57,900

Title Examiners, Abstractors, and Searchers
53,710

Tool and Die Makers
58,470

Tool Grinders, Filers, and Sharpeners
44,820

Training and Development Managers
119,920

Training and Development Specialists
73,780

Transit and Railroad Police
74,270

Transportation and Material Moving Occupations
42,230

Transportation Inspectors
85,040

Transportation, Storage, and Distribution Managers
107,750

Travel Agents
48,300

Tutors and Teachers and Instructors, All Other
42,710

Umpires, Referees, and Other Sports Officials
42,220

Underground Mining Machine Operators and Extraction Workers, All Other
62,920

Upholsterers
42,680

Urban and Regional Planners
82,290

Veterinarians
92,800

Veterinary Technologists and Technicians
38,120

Water and Wastewater Treatment Plant and System Operators
59,400

Web Developers and Digital Interface Designers
82,500

Weighers, Measurers, Checkers, and Samplers, Recordkeeping
40,160

Welders, Cutters, Solderers, and Brazers
48,070

Welding, Soldering, and Brazing Machine Setters, Operators, and Tenders
48,760

Wind Turbine Service Technicians
61,880

Woodworkers, All Other
31,470

Woodworking Machine Setters, Operators, and Tenders, Except Sawing
36,950

Word Processors and Typists
46,110

Writers and Authors
64,640

Zoologists and Wildlife Biologists
62,370

Question 1

1a. Provide a brief overview of the scenario you are given and describe the data set.

1b. Describe how you will be analyzing the data set.

1c. List and define all variables in the data set. Define each variable as follows and explain your reasoning.

i. Provide the two variable names in the data set.
>
>
ii. Define both variable as either Quantitative or Qualitative. Explain your answers.
>
>
iii. For the quantiative variable listed, define them as either Discrete or Continuous. Explain your answer.
>
iv. Provide the level of measurement for both variables. Explain your answers.
>
>

Question 2

2. Name and describe each Measure of Center below. Include the advantages and disadvantages of each Measure of Center.

Question 3

3. Name and describe each Measure of Variation below. Include the advantages and disadvantages of each Measure of Variation.

Question 4

4a. Calculate the Measures of Center and Measures of Variation on the “Data” tab in this document.
Under each measurement, provide the following: the calculation (including the formula), the value, the units of measurement, and an interpretation of the calculation in context of the scenario.
i. Mean

ii. Median

iii. Mode

iv. Midrange

v. Range

vi. Variance

vii. Standard Deviation
4b. Compare your mean and median. Does the data appear to be skewed or symmetrical? Explain your reasoning.