Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 aspreadsheetthat contains the following information:
- A listing of the jobs by title
- The salary (in dollars) for each job
Assignment Content Competency Describe the data using the measures of central tendency and measures of variability. Student Success Criteria View the grading rubric for this deliverable by selecting the "This item is graded with a rubric" link, which is located in the Details & Information pane. Instructions Scenario (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 ly cloudy f2 TA f5 % 2 3 4 5 8 W E R T Y U. A listing of the jobs by title . The salary (in dollars) for each job Deliverable 1 - Descriptive Statistics.xIsx The client needs the preliminary findings by the end of the day. Your boss asks you to first compute some basic statistics and then analyze the results in the four questions given in the Excel spreadsheet. Background information on the Data The 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 Submit Your boss wants you to submit the spreadsheet with the completed calculations, answers, and analysis. tly cloudy 13 FA f5 16 144 DII a $ % 2 3 4 5 8 W E R T S DAutoSave O on H Deliverable 1 - Descriptive Statistics Search (Alt+Q) lakenya barber LB Review View Help Comments Share File Home Insert Draw Page Layout Formulas Data Insert ~ 11 A A 22 Wrap Text General O Calibri EX Delete ~ Conditional Format as Cell Sort & Find & Analyze Paste B I U . F - CA- BEE Merge & Center ~ Formatting Table Styles Format ~ Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis F18 B D 1 Job Title Salary 2 Accountants and Auditors 71,470 source: http://www.bls.gov/ Actuaries 99,870 4 Administrative Law Judges, Adjudicators, and Hearing Officers 12,660 Calculations Formulas/Answers 5 Administrative Services Managers 93,150 Mean 6 Adult Basic and Secondary Education and Literacy Teachers and Instructors 54,890 Median 7 Advertising and Promotions Managers 136,840 Mode 8 Advertising Sales Agents 63,000 9 Aerospace Engineering and Operations Technicians 10 Aerospace Engineers 109,960 11 Agents and Business Managers of Artists, Performers, and Athletes 85,910 12 Agricultural and Food Science Technicians 42,540 13 Agricultural Inspectors 39,700 14 Agricultural Sciences Teachers, Postsecondary 92 ,010 15 Air Traffic Controllers 128,980 16 Aircraft Cargo Handling Supervisors 57,690 Midrange 17 Aircraft Structure, Surfaces, Rigging, and Systems Assemblers 48,860 Range 18 Airfield Operations Specialists 55 ,190 Variance 19 Airline Pilots, Copilots, and Flight Engineers 101,050 Standard Deviation 20 Anthropologists and Archeologists 56,640 21 Appraisers and Assessors of Real Estate 71,530 Maximum Data Question 1 Question 2 | Question 3 | Question 4| + Ready Accessibility; Good to go 69OF 8:28 PM Cloudy 12/6/2022 hp go 6 PO W R70 board Font Alignment Number tBox 2 X V A B D F G H la. Provide a brief overview of the scenario you are given and describe the data set. O 1b. Describe how you will be analyzing the data set. I O Data Question 1 Question 2 Question 3 Question 4 + ly { Accessibility: Good to go 69.F O Cloudy 12 f3 f4 f5 16 a 2 3 4 5TELE Merge & Center ~ N Font Alignment Number 2 X fx B C D E F G H K O 1c. List all variables in the data set. Define each variable as follows and explain your reasoning. i. Provide the two variable names in the data set. ii. Define both variable as either Quantitative or Qualitative. Explain your answers. iii. For the quantiative variable listed, define them as either Discrete or Continuous. Explain your answer. iv. Provide the level of measurement for both variables. Explain your answers. I Data Question 1 Question 2 Question 3 Question 4 + Accessibility: Good to go 9.F Cloudy 12 13 f 4 16 144 a % 2 3 4 5 O Q WPage Layout Formulas Data Review Home Insert Draw View Help Shape Format Calibri (Body) ~ 11 ~A A al Wrap Text General ste B I U V Y Av BEE E Merge & Center $ % 9 08 40 Conditional Format as Formatting Table board Font Alignment Number Styles tBox 1 X fic A B D E G H K M O 2. Name and describe each Measure of Center below. Include the advantages and disadvantages of each Measure of Center H Data Question 1 Question 2 Question 3 Question 4 + Accessibility: Good to go 690F Cloudy O f2 T5 144 DII DDI 2 O Q W E R T 4 S D F G H K11 ~ A A General Calibri (Body) 29 Wrap Text B I U V V LA- = =2 3 2 Merge & Center $% 9 08 -08 Conditional Format as Formatting ~ Table Styles pard Font Alignment Number OX 1 X V A B D E G H K M 3. Name and describe each Measure of Variation below. Include the advantages and disadvantages of each Measure of Variation. H Data Question 1 Question 2 Question 3 Question 4 Accessibility: Good to go 69.F Cloudy W 13 f5 16 144 19 DII 10 DDI # 3 4 W E R T S D F G H KBEE E Merge & Center $ ~ % 9 08 :08 Conditional Format as Cell Formatting Table . Styles Font Alignment Number Styles board Box 2 X V fic G H K M N A 4a. Calculate the Measures of Center and Measures of Variation on the "Data" tab in this document. Under each measurement, provide the following: the calculation (including the Excel formula), the value, the units of measurement, and an interpretation of the calculation in context of the scenario. i. Mean ii. Median iii. Mode iv. Midrange I v. Range vi. Variance vii. Standard Deviation Data Question 1 Question 2 Question 3 Question 4 + Accessibility: Good to go 69.F O Cloudy f2 f6 144 DII DDI a # 3 4 5 Q W E R T S D F G H K Z X V B N M4b. Compare your mean and median. Does the data appear to be skewed or symmetrical? Explain your reasoning. H TO Data Question 1 Question 2 Question 3 Question 4 Accessibility: Good to go 69.F X Cloudy + 144 DII # 3 4 Q W E R T Y 4 S D F G H Z X C V B N
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started