Expert answer:Descriptive Statistics

Solved by verified expert:CompetencyExamine basic descriptive statistics, and demonstrate results using calculated values and statistical charts.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 $25,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 jobThe client needs the preliminary findings by the end of the day, and your boss asks you to first compute some basic statistics.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 $25,000 to $200,000 for the state of Minnesota.What to SubmitYour research and analysis should be presented on the Word document provided. All calculations and work should be provided on a separate Excel workbook that should be submitted to your boss as well.
deliverable_01_questions.docx

deliverable_spreadsheet_2.xlsx

Don't use plagiarized sources. Get Your Custom Essay on
Expert answer:Descriptive Statistics
Just from $10/Page
Order Essay

Unformatted Attachment Preview

Deliverable 01 Worksheet
1. Introduce your scenario and data set.
o Provide a brief overview of the scenario you are given and describe the data set.
o Describe how you will be analyzing the data set.
o Classify the variables in your data set.
▪ Which variables are quantitative/qualitative?
▪ If it is a quantitative variable, is it discrete or continuous?
▪ Describe the level of measurement for each variable included in the data set
(nominal, ordinal, interval, ratio).
Answer and Explanation:
Enter your step-by-step answer and explanations here.
2. Discuss the importance of the Measures of Center.
o Name and describe each measure of center.
o Discuss the advantages and/or disadvantages of each.
Answer and Explanation:
Enter your step-by-step answer and explanations here.
3. Discuss the importance of the Measures of Variation.
o
o
Name and describe each measure of variation.
Discuss the advantages and/or disadvantages of each.
Answer and Explanation:
Enter your step-by-step answer and explanations here.
4. Calculate the measures of center and measures of variation from the data set and list
them below. Be sure to include (a) an interpretation of each measure 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?) and (b) correct units of measurement.
Show your calculations in your spreadsheet. You do not need to include Excel functions in
your written answer below.
o
o
o
o
o
o
o
Mean
Median
Mode
Midrange
Range
Variance
Standard deviation
Answer and Explanation:
Enter your step-by-step answer and explanations here.
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
64,150
99,870
103,000
85,610
47,760
117,030
52,970
62,690
112,270
77,690
41,570
42,470
92,010
138,050
39,970
48,860
56,010
95,530
67,150
61,080
82,160
80,300
51,570
73,850
79,040
37,570
73,230
63,020
46,970
46,990
77,820
79,050
57,890
101,320
71,230
43,020
46,600
68,080
64,880
63,160
70,200
62,290
41,910
58,540
66,100
48,550
source: http://www.bls.gov/
60,660
46,530
65,460
38,570
77,020
37,470
42,560
48,530
76,160
73,260
54,360
67,480
82,570
58,630
75,860
36,650
57,590
58,710
40,600
59,650
43,790
35,070
134,890
69,320
70,550
118,780
129,520
81,640
103,110
101,250
58,970
75,400
79,730
76,000
89,730
51,670
64,220
65,640
85,110
42,760
65,680
34,490
60,340
68,290
75,060
44,800
61,210
45,850
90,280
72,270
44,610
69,990
77,140
59,700
45,880
49,280
93,100
60,860
53,230
78,570
102,480
83,100
50,070
57,530
47,920
52,820
38,450
54,440
60,910
60,370
60,980
75,790
89,830
78,330
66,250
56,110
91,480
59,180
88,700
46,100
79,070
57,460
58,320
42,190
73,020
48,760
78,600
66,160
73,710
51,920
59,230
56,670
37,040
68,410
42,110
80,210
37,260
84,550
118,800
61,250
66,230
29,350
69,490
75,230
50,050
69,860
49,590
46,790
63,170
68,030
56,880
88,320
58,520
48,200
58,250
46,110
50,090
61,620
53,980
42,690
59,690
90,080
59,660
97,620
32,220
56,220
63,070
84,260
73,700
53,150
69,700
82,080
75,050
49,790
82,450
54,130
67,470
57,380
57,580
62,210
74,990
77,140
71,420
105,090
58,220
51,310
85,780
53,180
95,250
41,700
87,480
45,990
58,180
63,450
60,720
61,460
49,730
58,140
54,980
70,360
63,480
114,090
42,830
82,900
54,340
59,040
65,910
66,570
62,840
41,270
71,340
59,470
41,940
67,230
72,710
77,480
112,490
57,230
63,840
124,920
45,830
98,820
64,450
57,700
53,270
78,580
51,210
65,770
95,800
60,120
50,010
46,580
43,350
58,870
46,160
46,410
53,150
95,550
45,660
38,030
55,680
37,560
62,590
59,110
57,150
106,490
82,280
110,620
81,290
59,630
106,870
69,470
75,110
49,330
72,420
47,550
80,060
115,660
72,980
45,420
37,880
54,820
45,700
88,560
58,860
127,730
70,570
53,390
78,840
106,710
102,460
73,560
58,840
69,560
190,620
63,770
87,540
41,170
53,250
56,790
69,590
89,190
74,300
55,050
40,540
62,370
61,110
47,710
58,050
89,580
67,820
99,240
56,750
45,000
61,760
104,950
78,720
59,410
63,510
56,580
60,630
56,520
74,240
38,800
56,640
35,370
47,440
74,460
53,290
66,240
34,160
54,150
56,660
92,070
115,240
55,530
62,690
103,370
60,750
66,840
48,010
48,680
69,300
37,720
72,830
73,680
61,750
53,450
72,100
90,620
102,840
58,390
55,730
67,900
58,030
61,020
61,920
68,080
55,890
84,400
63,110
43,440
60,810
64,700
61,700
42,500
55,470
104,300
60,730
98,540
90,730
70,080
82,470
52,550
64,600
59,080
58,300
59,520

Purchase answer to see full
attachment

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Order your essay today and save 30% with the discount code ESSAYSHELP