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 4 – Hypothesis Tests
In prior engagements, you have already explained to your client about the basic statistics and discussed the importance of constructing confidence intervals for the population mean. Your client says that he remembers a little bit about hypothesis testing, but he is a little fuzzy. He asks you to give him the full explanation of all steps in hypothesis testing and wants your conclusion about two claims concerning the average salary for all jobs in the state of Minnesota.
Instructions
The data set in the spreadsheet consists of 599 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.
The Excel spreadsheet contains four tabs. The first tab, labeled “data”, requires you to calculate the mean, standard deviation, and sample size using the correct Excel formulas. The next three tabs contain questions for you to complete. Ensure that you are completely answering all questions with
Data
| Job Title | Yearly Average Salary | ||||
| Accountants and Auditors | 76,130 | ||||
| Actuaries | 112,030 | ||||
| Acupuncturists and Healthcare Diagnosing or Treating Practitioners, All Other | 80,390 | Calculations/Values | Formulas/Answers | ||
| Adhesive Bonding Machine Operators and Tenders | 39,460 | Mean | |||
| Administrative Law Judges, Adjudicators, and Hearing Officers | 114,760 | Standard Deviation | |||
| Adult Basic Education, Adult Secondary Education, and English as a Second Language Instructors | 58,860 | n | |||
| 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 | ||||
| Agricultural Inspectors | 59,800 | ||||
| Agricultural Sciences Teachers, Postsecondary | 100,480 | ||||
| Agricultural Workers, All Other | 37,230 | ||||
| Air Traffic Controllers | 141,410 | ||||
| Aircraft Cargo Handling Supervisors | 55,100 | ||||
| Aircraft Mechanics and Service Technicians | 79,080 | ||||
| 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 |