Rasmussen College Job Data Analysis Excel Sheet Attached is what I need help with If you have any questions please feel free to reach out to me! Instructio

Rasmussen College Job Data Analysis Excel Sheet Attached is what I need help with If you have any questions please feel free to reach out to me! Instructions: The following questions on the next six tabs are shown to you by a student who is asking for help. Your job is
showing the student how to solve each problem in detail. You are expected to explain all of the steps in your own words.
Key:
– This problem is an incorrect. Your job is to find the errors, correct the errors, and explain what they did wrong.
– This problem is partially finished. You must complete the problem by showing all steps and explain your corrections
– This problem is blank. You must start from scratch and explain how you will approach the problem, how you solve it,
who is asking for help. Your job is to help the student walk through the problems by
of the steps in your own words.
plain what they did wrong.
explain your corrections.
ch the problem, how you solve it, and explain why you took each step.
Assume that a randomly selected subject is given a bone density test. Those tests follow a standard normal dis
the probability that the bone density score for this subject is between -1.07 and 2.07.
Student’s partially finished answer:
We first need to find the probability for each of these z-scores using Excel. For -1.07, the probability from the left is
2.07, the probability from the left is 0.980774.
Show your calculations using Excel functions in the area to the right of this text box and finish answering the problem
below.
ests follow a standard normal distribution. Find
07, the probability from the left is 0.14231, and for
and finish answering the problem with explanations
The U.S. Airforce requires that pilots have a height between 62 in. and 78 in. If women’s heights are normally d
mean of 63.8 in. and a standard deviation of 2.6 in, find the percentage of women that meet the height requireme
Show your calculations using Excel functions in the area to the right of this text box and answer the problem with expl
f women’s heights are normally distributed with a
that meet the height requirement.
and answer the problem with explanations below.
Women’s pulse rates are normally distributed with a mean of 68.5 beats per minute and a standard deviation o
minute. What is the z-score for a woman having a pulse rate of 65 beats per minute?
Student’s incorrect answer:
Let
=
−

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