Missing something

profileStruggling2021
deliverable1_.xlsx

Data

Job Title Salary
Accountants and Auditors 68500 source: http://www.bls.gov/
Actuaries 97070
Administrative Law Judges, Adjudicators, and Hearing Officers 141840 Calculations Formulas/Answers
Administrative Services Managers 96180 Mean 71990.1813186813
Adult Basic and Secondary Education and Literacy Teachers and Instructors 63940 Median 67310
Advertising and Promotions Managers 105130 Mode 59800
Advertising Sales Agents 51740 73870
Aerospace Engineering and Operations Technicians 56140 59630
Aerospace Engineers 115220 58140
Agents and Business Managers of Artists, Performers, and Athletes 74580 66710
Agricultural and Food Science Technicians 42060 79960
Agricultural Inspectors 54140 81590
Agricultural Sciences Teachers, Postsecondary 87390 58660
Air Traffic Controllers 114906
Aircraft Cargo Handling Supervisors 50380 Midrange 79950
Aircraft Structure, Surfaces, Rigging, and Systems Assemblers 51410 Range 159960
Airfield Operations Specialists 59800 Variance 518653199.741138
Airline Pilots, Copilots, and Flight Engineers 115670 Standard Deviation 22773.9588069606
Anthropologists and Archeologists 55720
Appraisers and Assessors of Real Estate 52870
Arbitrators, Mediators, and Conciliators 86430
Architects, Except Landscape and Naval 81000
Architectural and Civil Drafters 62210
Architecture and Engineering Occupations 73850
Architecture Teachers, Postsecondary 73870
Archivists 76749
Art Directors 98924
Art, Drama, and Music Teachers, Postsecondary 78700
Athletic Trainers 45440
Atmospheric and Space Scientists 93900
Atmospheric, Earth, Marine, and Space Sciences Teachers, Postsecondary 96590
Audiologists 97230
Avionics Technicians 47320
Biomedical Engineers 99000
Boilermakers 76310
Broadcast News Analysts 71040
Brokerage Clerks 57260
Budget Analysts 75940
Business and Financial Operations Occupations 64880
Business Operations Specialists, All Other 67980
Business Teachers, Postsecondary 109800
Buyers and Purchasing Agents, Farm Products 62290
Camera and Photographic Equipment Repairers 32280
Captains, Mates, and Pilots of Water Vessels 63890
Cardiovascular Technologists and Technicians 59630
Career/Technical Education Teachers, Middle School 69050
Career/Technical Education Teachers, Secondary School 63430
Cargo and Freight Agents 40910
Cartographers and Photogrammetrists 72120
Chefs and Head Cooks 47660
Chemical Engineers 87200
Chemical Equipment Operators and Tenders 45460
Chemical Plant and System Operators 54920
Chemical Technicians 50360
Chemistry Teachers, Postsecondary 96330
Chemists 59630
Child, Family, and School Social Workers 58140
Chiropractors 86820
Civil Engineers 91430
Claims Adjusters, Examiners, and Investigators 66030
Clinical, Counseling, and School Psychologists 76150
Coil Winders, Tapers, and Finishers 36610
Commercial and Industrial Designers 66710
Commercial Pilots 130059
Communications Equipment Operators, All Other 43160
Communications Teachers, Postsecondary 85310
Community and Social Service Occupations 43790
Community Health Workers 37190
Compensation and Benefits Managers 121570
Compensation, Benefits, and Job Analysis Specialists 67210
Compliance Officers 67637
Computer and Information Research Scientists 121310
Computer and Information Systems Managers 137140
Computer and Mathematical Occupations 81640
Computer Hardware Engineers 95500
Computer Network Architects 112050
Computer Network Support Specialists 70940
Computer Occupations, All Other 92960
Computer Programmers 84280
Computer Science Teachers, Postsecondary 89290
Computer Systems Analysts 90600
Computer User Support Specialists 53680
Conservation Scientists 67540
Construction and Building Inspectors 64150
Construction Managers 99150
Continuous Mining Machine Operators 55330
Control and Valve Installers and Repairers, Except Mechanical Door 64960
Conveyor Operators and Tenders 35110
Cost Estimators 69480
Crane and Tower Operators 53980
Credit Analysts 72870
Credit Counselors 46720
Criminal Justice and Law Enforcement Teachers, Postsecondary 66980
Curators 66230
Database Administrators 91730
Dental Hygienists 71930
Derrick Operators, Oil and Gas 38120
Detectives and Criminal Investigators 90890
Diagnostic Medical Sonographers 74340
Dietitians and Nutritionists 60370
Directors, Religious Activities and Education 43690
Drafters, All Other 51790
Economics Teachers, Postsecondary 137920
Economists 106280
Editors 58820
Education Administrators, All Other 79960
Education Administrators, Elementary and Secondary School 103570
Education Administrators, Postsecondary 110110
Education Administrators, Preschool and Childcare Center/Program 81590
Education Teachers, Postsecondary 65020
Education, Training, and Library Occupations 47920
Educational, Guidance, School, and Vocational Counselors 56550
Electric Motor, Power Tool, and Related Repairers 63800
Electrical and Electronics Drafters 69010
Electrical and Electronics Engineering Technicians 68060
Electrical and Electronics Installers and Repairers, Transportation Equipment 54060
Electrical and Electronics Repairers, Commercial and Industrial Equipment 55970
Electrical and Electronics Repairers, Powerhouse, Substation, and Relay 81590
Electrical Engineers 91870
Electrical Power-Line Installers and Repairers 67430
Electricians 60590
Electro-Mechanical Technicians 54700
Electronics Engineers, Except Computer 100610
Elementary School Teachers, Except Special Education 62620
Elevator Installers and Repairers 88340
Embalmers 48770
Emergency Management Directors 79270
Engineering Technicians, Except Drafters, All Other 63250
English Language and Literature Teachers, Postsecondary 81700
Environmental Engineering Technicians 56810
Environmental Engineers 84870
Environmental Science and Protection Technicians, Including Health 45090
Environmental Science Teachers, Postsecondary 92530
Environmental Scientists and Specialists, Including Health 84320
Epidemiologists 85620
Executive Secretaries and Executive Administrative Assistants 55770
Exercise Physiologists 54300
Explosives Workers, Ordnance Handling Experts, and Blasters 62910
Extruding, Forming, Pressing, and Compacting Machine Setters, Operators, and Tenders 38680
Farm and Home Management Advisors 38940
Film and Video Editors 62280
Financial Analysts 85660
Financial Clerks, All Other 44080
Financial Examiners 99800
Financial Managers 134370
Financial Specialists, All Other 87690
Fire Inspectors and Investigators 58590
Firefighters 49620
First-Line Supervisors of Construction Trades and Extraction Workers 82160
First-Line Supervisors of Correctional Officers 84290
First-Line Supervisors of Farming, Fishing, and Forestry Workers 42540
First-Line Supervisors of Fire Fighting and Prevention Workers 91930
First-Line Supervisors of Helpers, Laborers, and Material Movers, Hand 49590
First-Line Supervisors of Landscaping, Lawn Service, and Groundskeeping Workers 54280
First-Line Supervisors of Mechanics, Installers, and Repairers 66430
First-Line Supervisors of Non-Retail Sales Workers 72920
First-Line Supervisors of Office and Administrative Support Workers 58120
First-Line Supervisors of Police and Detectives 101240
First-Line Supervisors of Production and Operating Workers 60990
First-Line Supervisors of Protective Service Workers, All Other 46280
First-Line Supervisors of Transportation and Material-Moving Machine and Vehicle Operators 58250
Fish and Game Wardens 75430
Food Service Managers 51340
Foreign Language and Literature Teachers, Postsecondary 73350
Forensic Science Technicians 79630
Forest and Conservation Technicians 46640
Foresters 65970
Forestry and Conservation Science Teachers, Postsecondary 90080
Fundraisers 57720
Funeral Service Managers 82590
Gaming Supervisors 32220
Gas Compressor and Gas Pumping Station Operators 62720
Gas Plant Operators 70130
General and Operations Managers 124190
Geography Teachers, Postsecondary 82530
Geological and Petroleum Technicians 39180
Geoscientists, Except Hydrologists and Geographers 70730
Health and Safety Engineers, Except Mining Safety Engineers and Inspectors 84880
Health Diagnosing and Treating Practitioners, All Other 67650
Health Educators 41781
Health Specialties Teachers, Postsecondary 136670
Health Technologists and Technicians, All Other 45940
Healthcare Practitioners and Technical Occupations 67470
Healthcare Social Workers 53600
Hearing Aid Specialists 46970
Historians 84337
History Teachers, Postsecondary 88590
Hoist and Winch Operators 80,660
Home Economics Teachers, Postsecondary 74490
Human Resources Managers 112430
Human Resources Specialists 61460
Industrial Engineering Technicians 55460
Industrial Engineers 82720
Industrial Machinery Mechanics 55930
Industrial Production Managers 100480
Information and Record Clerks, All Other 45700
Information Security Analysts 97360
Installation, Maintenance, and Repair Occupations 45990
Instructional Coordinators 66810
Insurance Appraisers, Auto Damage 70380
Insurance Sales Agents 66080
Insurance Underwriters 76990
Interior Designers 62010
Judges, Magistrate Judges, and Magistrates 58140
Kindergarten Teachers, Except Special Education 55850
Labor Relations Specialists 51870
Landscape Architects 68960
Lawyers 140920
Layout Workers, Metal and Plastic 42830
Legal Occupations 82900
Legal Support Workers, All Other 59800
Librarians 56320
Library Science Teachers, Postsecondary 78830
Life Scientists, All Other 82630
Life, Physical, and Social Science Occupations 62840
Loading Machine Operators, Underground Mining 41270
Loan Officers 63040
Locomotive Engineers 71960
Logging Workers, All Other 41940
Logisticians 74600
Magnetic Resonance Imaging Technologists 70580
Management Analysts 92200
Managers, All Other 88600
Marine Engineers and Naval Architects 82410
Market Research Analysts and Marketing Specialists 62380
Marketing Managers 122260
Marriage and Family Therapists 55600
Materials Engineers 91510
Mathematical Science Teachers, Postsecondary 78880
Mechanical Drafters 58540
Mechanical Engineering Technicians 60220
Mechanical Engineers 92040
Media and Communication Equipment Workers, All Other 76540
Medical and Clinical Laboratory Technologists 65770
Medical and Health Services Managers 113030
Medical Equipment Repairers 58310
Meeting, Convention, and Event Planners 52370
Mental Health Counselors 46580
Metal-Refining Furnace Operators and Tenders 44990
Middle School Teachers, Except Special and Career/Technical Education 66630
Millwrights 58660
Mine Cutting and Channeling Machine Operators 46250
Mine Shuttle Car Operators 56930
Mining and Geological Engineers, Including Mining Safety Engineers 93920
Mining Machine Operators, All Other 69160
Mixing and Blending Machine Setters, Operators, and Tenders 41970
Mobile Heavy Equipment Mechanics, Except Engines 58950
Model Makers, Metal and Plastic 57100
Morticians, Undertakers, and Funeral Directors 69800
Multimedia Artists and Animators 59890
Music Directors and Composers 46260
Natural Sciences Managers 113620
Network and Computer Systems Administrators 87700
Nuclear Engineers 121650
Nuclear Medicine Technologists 79440
Nuclear Technicians 88770
Nurse Practitioners 101960
Nursing Instructors and Teachers, Postsecondary 72450
Occupational Health and Safety Specialists 75610
Occupational Health and Safety Technicians 61740
Occupational Therapists 82290
Occupational Therapy Assistants 61860
Operations Research Analysts 90310
Optometrists 111790
Orthotists and Prosthetists 82380
Painters, Transportation Equipment 45230
Paper Goods Machine Setters, Operators, and Tenders 37110
Paralegals and Legal Assistants 56990
Patternmakers, Metal and Plastic 56260
Personal Financial Advisors 121750
Petroleum Pump System Operators, Refinery Operators, and Gaugers 66550
Pharmacists 120280
Philosophy and Religion Teachers, Postsecondary 78010
Physical Therapist Assistants 58720
Physical Therapists 90040
Physician Assistants 104730
Physicists 118520
Physics Teachers, Postsecondary 89040
Plant and System Operators, All Other 56830
Plumbers, Pipefitters, and Steamfitters 77570
Podiatrists 192180
Police and Sheriff's Patrol Officers 73870
Political Science Teachers, Postsecondary 90250
Postal Service Clerks 49310
Postal Service Mail Carriers 50160
Postal Service Mail Sorters, Processors, and Processing Machine Operators 49820
Postmasters and Mail Superintendents 75620
Power Distributors and Dispatchers 84830
Power Plant Operators 79100
Precision Instrument and Equipment Repairers, All Other 64170
Private Detectives and Investigators 58290
Probation Officers and Correctional Treatment Specialists 64300
Producers and Directors 75970
Production, Planning, and Expediting Clerks 48390
Property, Real Estate, and Community Association Managers 66710
Psychologists, All Other 79010
Psychology Teachers, Postsecondary 89680
Public Relations and Fundraising Managers 115180
Public Relations Specialists 63620
Pump Operators, Except Wellhead Pumpers 51520
Purchasing Agents, Except Wholesale, Retail, and Farm Products 61760
Purchasing Managers 111380
Radiation Therapists 84640
Radio, Cellular, and Tower Equipment Installers and Repairers 49240
Radiologic Technologists 63420
Rail Yard Engineers, Dinkey Operators, and Hostlers 54790
Railroad Conductors and Yardmasters 65740
Rail-Track Laying and Maintenance Equipment Operators 54600
Real Estate Brokers 86260
Real Estate Sales Agents 59010
Recreation and Fitness Studies Teachers, Postsecondary 60080
Recreational Vehicle Service Technicians 34450
Refractory Materials Repairers, Except Brickmasons 49210
Registered Nurses 71730
Reinforcing Iron and Rebar Workers 86290
Respiratory Therapists 56910
Rolling Machine Setters, Operators, and Tenders, Metal and Plastic 38060
Roof Bolters, Mining 58900
Rotary Drill Operators, Oil and Gas 49720
Sales Engineers 98760
Sales Managers 75432
Sales Representatives, Services, All Other 61930
Sales Representatives, Wholesale and Manufacturing, Except Technical and Scientific Products 69900
Sales Representatives, Wholesale and Manufacturing, Technical and Scientific Products 81950
Secondary School Teachers, Except Special and Career/Technical Education 68380
Securities, Commodities, and Financial Services Sales Agents 86070
Service Unit Operators, Oil, Gas, and Mining 42200
Set and Exhibit Designers 54620
Ship Engineers 57066
Signal and Track Switch Repairers 37720
Social and Community Service Managers 63870
Social Scientists and Related Workers, All Other 79960
Social Work Teachers, Postsecondary 54580
Social Workers, All Other 65890
Sociology Teachers, Postsecondary 87710
Software Developers, Applications 96110
Software Developers, Systems Software 106700
Soil and Plant Scientists 57080
Sound Engineering Technicians 58660
Special Education Teachers, All Other 59400
Special Education Teachers, Kindergarten and Elementary School 65430
Special Education Teachers, Middle School 62160
Special Education Teachers, Secondary School 68560
Speech-Language Pathologists 78760
Stationary Engineers and Boiler Operators 79090
Statisticians 88190
Surveyors 60215
Tank Car, Truck, and Ship Loaders 45470
Tax Examiners and Collectors, and Revenue Agents 79850
Technical Writers 67410
Telecommunications Equipment Installers and Repairers, Except Line Installers 57580
Tire Builders 42500
Tool and Die Makers 54680
Training and Development Managers 101500
Training and Development Specialists 59910
Transportation Inspectors 86790
Transportation, Storage, and Distribution Managers 92220
Urban and Regional Planners 79510
Veterinarians 93830
Water and Wastewater Treatment Plant and System Operators 54560
Web Developers 56820
Wholesale and Retail Buyers, Except Farm Products 55080
Writers and Authors 53050
Zoologists and Wildlife Biologists 62420

Question 1

1a. Provide a brief overview of the scenario you are given and describe the data set. The data analysis is from the Bureau of Labor Statistics and consists of 364 records that contain jobs located in Minnesota. The salaries range from $30,000 to $200,000 per year. esearch and analyze the salary distributions for one of our major clients.

1b. Describe how you will be analyzing the data set. Two variables present in this scenario; the first variable is job titles which are qualitative variables as they do not contain any numerical numbers. The second variable is salaries and considered a quantitative variable considering the data has a numeric property. Because the salary variable is quantitative, it is deemed continuous as the amount of money made annually can continuously change due to pay increases, promotions, and bonuses.

1c. List all variables in the data set. Define each variable as follows and explain your reasoning. > Quantitative or Qualitative? > If the variable is quantitative, is it Discrete or Continuous? > What is the level of measurement? (Nominal, Ordinal, Interval, or Ratio) Identifying the qualitative and quantitative variables makes it easier to determine the measurement level for both variables. The qualitative variables are the job titles as they have no numerical significance and can classify as a nominal measurement. Because an absolute zero can occur when analyzing, the listed salaries is consider a ratio measurement. By being employed, it is deemed a ratio since you could not make less than zero. If an incurred salary of zero occurred, one would not be employed.

Question 2

2. Name and describe each Measure of Center below. Include the advantages and disadvantages of each Measure of Center. Widely used to represent values in data sets is called measures of the center; this includes the mean, median, mode, and midrange.These measurement values are the center of data sets.The mean is usually the most significant of all numerical measurements used to describe data, and what most people associate to as an average” (Triola, 2018). some advantages of utilizing the mean are; it is a familiarity to most people; every data set has only one mean and is readily used for comparison. Disadvantages of the mean are that it is affected by extreme values, hard to calculate in extensive data, and not be calculated forgroup data with open-ended classes (Rasmussen 2018).The median in a data set is the measure of the center that is the middle value that arranges in an increasing or decreasing order (Triola, 2018). An advantage of the median is that extreme values do not influence the median. The use of the median has such disadvantages that it is not as valuable for statistical testing. Next is themode, “The mode of a data set is the value(s) that occur(s) with the greatestfrequency” (Triola, 2018). Essential properties of mode are that that mode can be found with qualitative data and can have only one mode, more than one mode, or no mode (Triola, 2018). Also, the mode has disadvantages, such as it might not beinformative and can vary from each sample.The final measure of the center is midrange. “The midrange of a data set is the measure of center that is the value that is midway amidst the maximum and minimum values in the original data set;” “because the midrange applies only the maximum and minimum values, it is very sensitive to those extremes, so the midrange is not resistant” (Triola, 2018 pg. 86). The rarely used midrange is not regularly a value; however, it is simple to measure and implements a midpoint in the data.

Question 3

3. Name and describe each Measure of Variation below. Include the advantages and disadvantages of each Measure of Variation. Measures of variation are the measurements that show how separate the data points are," and include range, Variance, and standard deviation (Rasmussen 2018). the variation between the maximum value and the minimum value is known as the range (Triola, 2018). The range's advantage is that it is easy to compute. The disadvantages of the range are only using extreme values, is rarely used, and does not provide information regarding the data inside the range. "Variance is the expectation of the squared deviation of a random variable from its mean. Informally, how spread out the data is. Advantages of Variance are calculating the standard deviation and each value in the data set used in calculation" (Rasmussen 2018). disadvantages of variances are: not easily calculated manually, and extreme values can skew the Variance. Finally, we have the standard deviation. "Standard deviation is the measure of how much data values deviate away from the mean. If individual observations vary greatly from the group mean, the standard deviation is big; and vice versa" (Rasmussen 2018). Advantages of standard deviation include; The value is never negative and is helpful in statistical methods and theoretical work, whereas the disadvantages are that it is hard to calculate manually and is not helpful for nominal or ordinal data. Using measures of center and variation allows analyzing data better.

Question 4

4. Calculate the Measures of Center and Measures of Variation on the "Data" tab in this document. List each value below and include the following: > Interpret each calculation in context of the scenario. (For example, if the median is larger than the mean, what does it mean? What does the value of standard deviation tell you?) > Include correct units of measurement on each answer. The average salary amount, or mean, of all the information collected, is $71,990.18 The total value of the median or middle salaries entered is $67,310 The mean and median could be considered a positive skew or skewed to the right .$159,960 There were seven modes that populated in the array $ 58,130 $58,660, $59,8000 $59,630, $66,710,$73,870,$79,960, $81,590. Due to the multiple modes, this is considered a multimodal mode. To obtain the midrange, first the maximum and minimum both had to be determined. The maximum is $192,180 and the minimum is $32,280. After finding the range in the salaries, the calculation for the midrange is $159,900 /2 =$79,950 The midrange tells us that the spread is diverse as there is a large difference between the min and the max of the salaries. The next value to find was the Variance which is $518,653,199.7. The Variance tells us the spread from the mean is minimal. Next, calculate the range and got $159,960. Due to the wide range, there is great variability in the data. Finally, after computing the standard deviation, it calculates out to $22,773.96 This standard deviation indicates that the data set values are farther away from the mean on an average.