Kennedy King College Confidence Intervals Excel Worksheet PLEASE REFER TO GRADING RUBRIC APA FORMAT IF APPLIESCompetencyGiven a real-life application, deve

Kennedy King College Confidence Intervals Excel Worksheet PLEASE REFER TO GRADING RUBRIC APA FORMAT IF APPLIESCompetencyGiven a real-life application, develop a confidence interval for a population parameter and its interpretation.InstructionsScenario (information repeated for deliverable 01, 03, and 04)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
You have previously explained some of the basic statistics to your client already, and he really liked your work. Now he wants you to analyze the confidence intervals.Background information on the DataThe data set in the spreadsheet consists of 364 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.What to SubmitYour boss wants you to submit the spreadsheet with the completed calculations, answers, and analysis.Grading Rubric

F
F
C
B
A

0
1
2
3
4

Not Submitted
No Pass
Competence
Proficiency
Mastery

Not Submitted
Did not correctly solve a majority of the problems or at least one problem left blank.
Correctly solved a majority of the problems.
Correctly solved almost all the problems.
All problems are solved correctly.

Not Submitted
Very few steps are provided to explain how to solve the problem OR the steps provided have several errors.
Fairly complete and detailed steps are provided to explain how to solve the problem OR the steps provided have some errors.
Mostly complete and detailed steps are provided to explain how to solve the problem.
Complete and detailed steps are provided to explain how to solve the problem.

Not Submitted
Explanations generally lack a basic understanding of the statistical concepts or lack of proper terminology.
Explanations demonstrate a basic understanding of most of the statistical concepts and terminology, but some explanations may be incomplete or incorrect.
Explanations demonstrate a proficient understanding of most of the statistical concepts and terminology, but with small errors.
Explanations demonstrate a mastery of understanding of the statistical concepts and terminology.

Not Submitted
The majority of variables, equations, and expressions are not properly formatted.
The majority of variables, equations, and expressions are properly formatted.
Almost all variables, equations, and expressions are properly formatted.
All variables, equations, and expressions are properly formatted. 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
57580
42500
54680
101500
59910
86790
92220
79510
93830
54560
56820
59080
62170
63420
1. Discuss the importance of constructing confidence intervals for the population mean by answering these questio
a. What are confidence intervals?
b. What is a point estimate?
c. What is the best point estimate for the population mean? Explain.
d. Why do we need confidence intervals?
mean by answering these questions.
2. Using the data from the ‘Data’ tab in this workbook, construct a 95% confidence interval for the population mean.
Assume that your data is normally distributed and σ is unknown. Include a statement that correctly interprets the
confidence interval in context of the scenario.
Hint: Use the sample mean and sample standard deviation from Deliverable 1. Do NOT copy and paste the values.
Show all calculations (including the critical value, margin of error, and limits of the confidence interval) to the right. Incl
a breakdown of the steps and a correct statistical interpretation of the answer below.
nterval for the population mean.
nt that correctly interprets the
T copy and paste the values.
nfidence interval) to the right. Include
Calculations/Values
Mean
Standard Deviation
n
Critical Value
Margin of Error
Lower Limit
Upper Limit
Formulas/Answers
3. Using the data from the ‘Data’ tab in this workbook, construct a 99% confidence interval for the population mean.
Assume that your data is normally distributed and σ is unknown. Include a statement that correctly interprets the
confidence interval in context of the scenario.
Hint: Use the sample mean and sample standard deviation from Deliverable 1. Do not copy and paste
Show all calculations (including the critical value, margin of error, and limits of the confidence interval) to the right. Inclu
breakdown of the steps and a correct statistical interpretation of the answer below.
terval for the population mean.
t that correctly interprets the
opy and paste the values.
idence interval) to the right. Include a
Calculations/Values
Mean
Standard Deviation
n
Critical Value
Margin of Error
Lower Limit
Upper Limit
Formulas/Answers
4. Compare your answers for (2) and (3). You notice that the 99% confidence interval is wider. What is the advanta
confidence interval? Why would you not always use the 99% confidence interval? Explain with an example.
val is wider. What is the advantage of using a wider
Explain with an example.
5. We want to estimate the mean salary in Minnesota. (a) How many jobs must be randomly selected for their respec
mean salaries if we want 95% confidence that the sample mean is within $124 of the population mean and σ = $1175
Is the current sample size of 364 in the data set in our Excel workbook large enough? Explain.
Show your calculations using Excel functions in the area to the right of this text box and answer the problem with
explanations below.
andomly selected for their respective
e population mean and σ = $1175. (b)
d answer the problem with

Purchase answer to see full
attachment