Deliverable 1 - Descrip X Untitled X w Deliverable_01_Questi x Untitled x * Deliverable_Spreadshe X Q course hero - Search X * Account Settings X + X C @ https://una.instructure.com/courses/74031/assignments/756617?module_item_id=1513271 . . . Fall 2022 UNA Competency Home Examine basic descriptive statistics, and demonstrate results using calculated values and statistical charts. Announcements Instructions Syllabus Scenario (information repeated for deliverable 01, 03, and 04) Modules A major client of your company is interested in the salary distributions of jobs in the state of Minnesota that range from Grades $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 E that contains the following information: People . A listing of the jobs by title + Big BlueButton . The salary (in dollars) for each job Zoom The client needs the preliminary findings by the end of the day, and your boss asks you to first compute some basic statistics. ? Course Evaluation Background information on the Data Office 365 The data set in the spreadsheet consists of 364 records that you will be analyzing from the Bureau of Labor Statistics. The data Tutor.com: 24/7 set contains a listing of several jobs titles with yearly salaries ranging from approximately $30,000 to $200,000 for the state of Online Tutoring Minnesota. Simple Syllabus What to Submit Microsoft Teams Your boss wants you to submit the spreadsheet with the completed calculations. Your research and analysis should be present classes within the answers provided on the worksheet. E This assignment should be completed using Microsoft Word (worksheet) and Microsoft Excel (with Analysis ToolPak installed), and both files should be submitted. The rubric shown in this Canvas dropbox lets you know how the assignment will be graded. Deliverable 1 Criteria Ratings Pts -71 Introduction & 25 nts 18 75 nts 125 nts 625 nts Onts 76.F X 2:08 PM Sunny Search the web 10/23/2022 1X AutoSave Off Deliverable_Spreadsheet_Del1_Del3_Del4 - Excel Search (Alt+Q) Lanna Taylor LT X File Home Insert Page Layout Formulas Data Review View Help Comments Share ~ Calibri v 11 ap Wrap Text General AutoSum AY O Paste EE Merge & Center * % 9 Conditional Format as Cell Fill BIUVFLAV Insert Delete Format Sort & Find & Analyze 00 0 Formatting Table Styles v Clear Filter ~ Select Data Undo Clipboard Font Alignment Number Styles Cells Editing Analysis H10 VIXfx A B C D E F G H I J K L M 1 Job Title Salary 2 Accountants and Auditors 71,420 source: http://www.bls.gov/ 3 Actuaries 99,870 Administrative Law Judges, Adjudicators, and Hearing Officers 112,660 Administrative Services Managers 93,150 6 Adult Basic and Secondary Education and Literacy Teachers and Instructors 54,890 Advertising and Promotions Managers 136,840 8 Advertising Sales Agents 63,000 9 Aerospace Engineering and Operations Technicians 69,230 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 17 Aircraft Structure, Surfaces, Rigging, and Systems Assemblers 48,860 18 Airfield Operations Specialists 55,190 19 Airline Pilots, Copilots, and Flight Engineers 101,050 20 Anthropologists and Archeologists 56,640 21 Appraisers and Assessors of Real Estate 71,530 22 Arbitrators, Mediators, and Conciliators 91,560 23 Architects, Except Landscape and Naval 85,930 24 Architectural and Civil Drafters 53,290 25 Architecture and Engineering Occupations 80,770 26 Architecture Teachers, Postsecondary 79,040 Data Sheet2 Sheet3 + Ready 12Accessibility: Good to go + 100% 76.F X W 2:09 PM Sunny Search the web 10/23/2022 1X AutoSave Off Deliverable_Spreadsheet_Del1_Del3_Del4 - Excel Search (Alt+Q) Lanna Taylor LT X File Home Insert Page Layout Formulas Data Review View Help Comments Share ~ Calibri v 11 ap Wrap Text General AutoSum AY O Paste EE Merge & Center * % 9 Conditional Format as Cell Fill Insert Delete Format Sort & Find & Analyze 00 0 Formatting > Table Styles v Clear Filter ~ Select Data Undo Clipboard Font Alignment Number Styles Cells Editing Analysis H10 VIXfx A B C D E F G H I J K L M 27 Archivists 49,970 28 Art Directors 85,820 29 Art, Drama, and Music Teachers, Postsecondary 70,390 30 Athletic Trainers 48,990 31 Atmospheric and Space Scientists 99,860 32 Atmospheric, Earth, Marine, and Space Sciences Teachers, Postsecondary 93,990 33 Audiologists 81,010 34 Avionics Technicians 55,680 35 Biomedical Engineers 108,290 36 Boilermakers 71,230 37 Broadcast News Analysts 73,660 38 Brokerage Clerks 48,850 39 Budget Analysts 75,010 40 Business and Financial Operations Occupations 72,420 41 Business Operations Specialists, All Other 69,870 42 Business Teachers, Postsecondary 90,540 43 Buyers and Purchasing Agents, Farm Products 62,290 44 Camera and Photographic Equipment Repairers 41,910 45 Captains, Mates, and Pilots of Water Vessels 67,220 46 Cardiovascular Technologists and Technicians 65,850 47 Career/Technical Education Teachers, Middle School 61,970 48 Career/Technical Education Teachers, Secondary School 64,740 49 Cargo and Freight Agents 45,820 50 Cartographers and Photogrammetrists 69,020 51 Chefs and Head Cooks 48,290 52 Chemical Engineers 86,360 Data Sheet2 | Sheet3 + Ready Accessibility: Good to go + 100% 76.F Search the web X W 2:09 PM 1 Sunny 10/23/2022X AutoSave Off Deliverable_Spreadsheet_Del1_Del3_Del4 - Excel Search (Alt+Q) Lanna Taylor LT X File Home Insert Page Layout Formulas Data Review View Help Comments Share ~ Calibri v 11 = = = 2 ap Wrap Text General AutoSum AY O Fill Paste EE Merge & Center * % 9 Conditional Format as Cell Insert Delete Format Sort & Find & Analyze 100 0 Formatting Table Styles v Clear Filter ~ Select Data Undo Clipboard Font Alignment Number Styles Cells Editing Analysis H10 VIX fx A B C D E F G H J K L M 50 Cartographers and Photogrammetrists 69,020 51 Chefs and Head Cooks 48,290 52 Chemical Engineers 86,360 53 Chemical Equipment Operators and Tenders 41,520 54 Chemical Plant and System Operators 48,830 55 Chemical Technicians 53,650 56 Chemistry Teachers, Postsecondary 88,390 57 Chemists 85,030 58 Child, Family, and School Social Workers 54,310 59 Chiropractors 79,250 60 Civil Engineers 87,310 61 Claims Adjusters, Examiners, and Investigators 62,230 62 Clinical, Counseling, and School Psychologists 82,130 63 Coil Winders, Tapers, and Finishers 33,490 64 Commercial and Industrial Designers 63,710 65 Commercial Pilots 83,220 66 Communications Equipment Operators, All Other 40,600 67 Communications Teachers, Postsecondary 66,990 68 Community and Social Service Occupations 47,550 69 Community Health Workers 40,340 70 Compensation and Benefits Managers 144,350 71 Compensation, Benefits, and Job Analysis Specialists 75,350 72 Compliance Officers 74,970 73 Computer and Information Research Scientists 117,200 74 Computer and Information Systems Managers 140,920 75 Computer and Mathematical Occupations 86,710 Data Sheet2 | Sheet3 + Ready 12Accessibility: Good to go + 100% 76.F X W 2:10 PM 1 Sunny Search the web 10/23/2022X AutoSave Off Deliverable_Spreadsheet_Del1_Del3_Del4 - Excel Search (Alt+Q) Lanna Taylor LT X File Home Insert Page Layout Formulas Data Review View Help Comments Share ~ Calibri v 11 ap Wrap Text General AutoSum AY O Fill Paste EE Merge & Center * % 9 Conditional Format as Cell Insert Delete Format Sort & Find & Analyze 00 0 Formatting Table Styles v Clear Filter ~ Select Data Undo Clipboard Font Alignment Number Styles Cells Editing Analysis H10 VIX fx A B C D E F G H I J K L M 76 Computer Hardware Engineers 112,250 77 Computer Network Architects 107,860 78 Computer Network Support Specialists 60,200 79 Computer Occupations, All Other 77,570 80 Computer Programmers 89,440 81 Computer Science Teachers, Postsecondary 96,020 82 Computer Systems Analysts 91,230 83 Computer User Support Specialists 55,520 84 Conservation Scientists 65,820 85 Construction and Building Inspectors 69,070 86 Construction Managers 93,290 87 Continuous Mining Machine Operators 42,760 88 Control and Valve Installers and Repairers, Except Mechanical Door 68,400 89 Conveyor Operators and Tenders 35,750 90 Cost Estimators 65,650 91 Crane and Tower Operators 59,680 92 Credit Analysts 82,060 93 Credit Counselors 49,650 94 Criminal Justice and Law Enforcement Teachers, Postsecondary 71,970 95 Curators 54,870 96 Database Administrators 88,410 97 Dental Hygienists 72,850 98 Derrick Operators, Oil and Gas 44,610 99 Detectives and Criminal Investigators 77,660 100 Diagnostic Medical Sonographers 78,560 101 Dietitians and Nutritionists 61,440 Data Sheet2 | Sheet3 + Ready Accessibility: Good to go + 100% 76.F X W 2:10 PM 1 Sunny Search the web L D CB 10/23/2022X AutoSave Off Deliverable_Spreadsheet_Del1_Del3_Del4 - Excel Search (Alt+Q) Lanna Taylor LT X File Home Insert Page Layout Formulas Data Review View Help Comments Share ~ v 11 General AutoSum Calibri ap Wrap Text AY O Fill Paste EE Merge & Center * % 9 Conditional Format as Cell Insert Delete Format Sort & Find & Analyze 100 0 Formatting Table Styles v Clear Filter ~ Select Data Undo Clipboard Font Alignment Number Styles Cells Editing Analysis H10 VIX fx A B C D E F G H I J K L M IUI Dietitians and Nutritionists 01,440 102 Directors, Religious Activities and Education 50,210 103 Drafters, All Other 53,330 104 Economics Teachers, Postsecondary 109,480 105 Economists 72,810 106 Editors 55,220 107 Education Administrators, All Other 79,860 108 Education Administrators, Elementary and Secondary School 102,010 109 Education Administrators, Postsecondary 91,970 110 Education Administrators, Preschool and Childcare Center/Program 57,390 111 Education Teachers, Postsecondary 64,880 112 Education, Training, and Library Occupations 55,000 113 Educational, Guidance, School, and Vocational Counselors 56,310 114 Electric Motor, Power Tool, and Related Repairers 40,360 115 Electrical and Electronics Drafters 58,770 116 Electrical and Electronics Engineering Technicians 62,450 117 Electrical and Electronics Installers and Repairers, Transportation Equipment 61,260 118 Electrical and Electronics Repairers, Commercial and Industrial Equipment 63,410 119 Electrical and Electronics Repairers, Powerhouse, Substation, and Relay 78,680 120 Electrical Engineers 94,390 121 Electrical Power-Line Installers and Repairers 79,120 122 Electricians 67,500 123 Electro-Mechanical Technicians 56,450 124 Electronics Engineers, Except Computer 99,490 125 Elementary School Teachers, Except Special Education 63,490 26 Elevator Installers and Repairers 83,900 Data Sheet2 | Sheet3 + Ready 12Accessibility: Good to go + 100% 76. F Search the web X W 2:10 PM 10/23/2022 1 SunnyX AutoSave Off Deliverable_Spreadsheet_Del1_Del3_Del4 - Excel Search (Alt+Q) Lanna Taylor LT X File Home Insert Page Layout Formulas Data Review View Help Comments Share ~ v 11 ap Wrap Text General AutoSum Calibri AY O Fill Paste EE Merge & Center * % 9 Conditional Format as Cell Insert Delete Format Sort & Find & Analyze 00 0 Formatting > Table Styles v Clear Filter ~ Select Data Undo Clipboard Font Alignment Number Styles Cells Editing Analysis H10 VIX fx A B C D E F G H I J K L M 127 Embalmers 46,100 128 Emergency Management Directors 87,050 129 Engineering Technicians, Except Drafters, All Other 57,360 130 English Language and Literature Teachers, Postsecondary 66,090 131 Environmental Engineering Technicians 42,190 132 Environmental Engineers 87,360 133 Environmental Science and Protection Technicians, Including Health 49,460 134 Environmental Science Teachers, Postsecondary 90,710 135 Environmental Scientists and Specialists, Including Health 74,110 136 Epidemiologists 77,440 137 Executive Secretaries and Executive Administrative Assistants 56,010 138 Exercise Physiologists 58,990 139 Explosives Workers, Ordnance Handling Experts, and Blasters 58,320 140 Extruding, Forming, Pressing, and Compacting Machine Setters, Operators, and Tenders 38,740 141 Farm and Home Management Advisors 74,190 142 Film and Video Editors 50,190 143 Financial Analysts 91,420 144 Financial Clerks, All Other 38,860 145 Financial Examiners 89,040 146 Financial Managers 133,980 147 Financial Specialists, All Other 70,440 148 Fire Inspectors and Investigators 65,710 149 Firefighters 35,750 150 First-Line Supervisors of Construction Trades and Extraction Workers 73,810 151 First-Line Supervisors of Correctional Officers 76,370 152 First-Line Supervisors of Farming, Fishing, and Forestry Workers 60,690 Data Sheet2 Sheet3 + Ready Accessibility: Good to go + 100% 76.F W 2:10 PM Search the web X 1 Sunny 10/23/2022X AutoSave Off Deliverable_Spreadsheet_Del1_Del3_Del4 - Excel Search (Alt+Q) Lanna Taylor LT X File Home Insert Page Layout Formulas Data Review View Help Comments Share ~ Calibri v 11 = = = ap Wrap Text General AutoSum AY O Fill Paste EE Merge & Center * % 9 Conditional Format as Cell Insert Delete Format Sort & Find & Analyze 00 0 Formatting Table Styles v Clear Filter ~ Select Data Undo Clipboard Font Alignment Number Styles Cells Editing Analysis H10 VIX fx A B C D E F G H I J K L M 153 First-Line Supervisors of Fire Fighting and Prevention Workers 71,570 154 First-Line Supervisors of Helpers, Laborers, and Material Movers, Hand 49,590 155 First-Line Supervisors of Landscaping, Lawn Service, and Groundskeeping Workers 51,310 156 First-Line Supervisors of Mechanics, Installers, and Repairers 66,430 157 First-Line Supervisors of Non-Retail Sales Workers 77,900 158 First-Line Supervisors of Office and Administrative Support Workers 60,960 159 First-Line Supervisors of Police and Detectives 87,970 160 First-Line Supervisors of Production and Operating Workers 62,830 161 First-Line Supervisors of Protective Service Workers, All Other 52,470 62 First-Line Supervisors of Transportation and Material-Moving Machine and Vehicle Operators 58,250 163 Fish and Game Wardens 46,110 164 Food Service Managers 56,800 165 Foreign Language and Literature Teachers, Postsecondary 68,890 166 Forensic Science Technicians 59,640 167 Forest and Conservation Technicians 42,970 168 Foresters 63,990 169 Forestry and Conservation Science Teachers, Postsecondary 90,080 170 Fundraisers 59,900 171 Funeral Service Managers 98,920 172 Gaming Supervisors 32,220 173 Gas Compressor and Gas Pumping Station Operators 56,220 174 Gas Plant Operators 67,370 175 General and Operations Managers 109,490 176 Geography Teachers, Postsecondary 80,130 177 Geological and Petroleum Technicians 54,390 178 Geoscientists, Except Hydrologists and Geographers 72,210 Data Sheet2 | Sheet3 + Ready 12Accessibility: Good to go + 100% 76.F X W 2:10 PM 1 Sunny Search the web 10/23/2022X AutoSave Off Deliverable_Spreadsheet_Del1_Del3_Del4 - Excel Search (Alt+Q) Lanna Taylor LT X File Home Insert Page Layout Formulas Data Review View Help Comments Share ~ Calibri v 11 A" A" ap Wrap Text General AutoSum AY O Fill Paste EE Merge & Center * % 9 Conditional Format as Cell Insert Delete Format Sort & Find & Analyze 00 0 Formatting > Table Styles v Clear Filter ~ Select Data Undo Clipboard Font Alignment Number Styles Cells Editing Analysis H10 VIXfx A B C D E F G H I J K L M 177 Geological and Petroleum Technicians 54,390 178 Geoscientists, Except Hydrologists and Geographers 72,210 179 Health and Safety Engineers, Except Mining Safety Engineers and Inspectors 88,300 180 Health Diagnosing and Treating Practitioners, All Other 82,600 181 Health Educators 56,120 182 Health Specialties Teachers, Postsecondary 82,450 183 Health Technologists and Technicians, All Other 54,160 184 Healthcare Practitioners and Technical Occupations 86,270 185 Healthcare Social Workers 58,530 186 Hearing Aid Specialists 55,690 87 Historians 62,210 188 History Teachers, Postsecondary 85,040 189 Hoist and Winch Operators 80,660 190 Home Economics Teachers, Postsecondary 71,420 191 Human Resources Managers 121,530 192 Human Resources Specialists 64,140 193 Industrial Engineering Technicians 53,110 194 Industrial Engineers 90,580 195 Industrial Machinery Mechanics 54,180 196 Industrial Production Managers 110,490 197 Information and Record Clerks, All Other 43,110 198 Information Security Analysts 95,930 199 Installation, Maintenance, and Repair Occupations 49,750 200 Instructional Coordinators 65,320 201 Insurance Appraisers, Auto Damage 62,970 202 Insurance Sales Agents 32,760 Data Sheet2 | Sheet3 + Ready Accessibility: Good to go + 100% 76.F Search the web X W 2:11 PM 1 Sunny 10/23/2022X Search (Alt+Q) LT X AutoSave Off Deliverable_Spreadsheet_Del1_Del3_Del4 - Excel Lanna Taylor File Home Insert Page Layout Formulas Data Review View Help Comments Share ~ AutoSum Calibri v 11 ap Wrap Text General AY O Fill Paste EE Merge & Center * % Conditional Format as Cell Insert Delete Format Sort & Find & Analyze 9 00 0 Formatting > Table Styles v Clear Filter ~ Select Data Undo Clipboard Font Alignment Number Styles Cells Editing Analysis H10 VIXfx A B C D E F G H I J K L M 203 Insurance Underwriters 66,930 204 Interior Designers 61,130 205 Judges, Magistrate Judges, and Magistrates 135,740 206 Kindergarten Teachers, Except Special Education 58,790 207 Labor Relations Specialists 69,170 208 Landscape Architects 69,200 209 Lawyers 124,230 210 Layout Workers, Metal and Plastic 49,700 211 Legal Occupations 97,570 212 Legal Support Workers, All Other 57,980 213 Librarians 62,790 214 Library Science Teachers, Postsecondary 72,520 215 Life Scientists, All Other 71,130 216 Life, Physical, and Social Science Occupations 71,500 217 Loading Machine Operators, Underground Mining 41,270 218 Loan Officers 78,040 219 Locomotive Engineers 66,150 220 Logging Workers, All Other 41,940 221 Logisticians 74,280 222 Magnetic Resonance Imaging Technologists 76,530 223 Management Analysts 83,560 224 Managers, All Other 126,600 225 Marine Engineers and Naval Architects 57,230 226 Market Research Analysts and Marketing Specialists 70,940 227 Marketing Managers 140,350 228 Marriage and Family Therapists 52,070 Data Sheet2 | Sheet3 + Ready Accessibility: Good to go + 100% 2:12 PM 76. F Search the web X W 10/23/2022 1 SunnyX AutoSave Off Deliverable_Spreadsheet_Del1_Del3_Del4 - Excel Search (Alt+Q) Lanna Taylor LT X File Home Insert Page Layout Formulas Data Review View Help Comments Share ~ Calibri v 11 ap Wrap Text General AutoSum AY O Fill Paste EE Merge & Center * % 9 Conditional Format as Cell Insert Delete Format Sort & Find & Analyze 00 0 Formatting > Table Styles v Clear Filter ~ Select Data Undo Clipboard Font Alignment Number Styles Cells Editing Analysis H10 VIXfx A B C D E F G H I J K L M 228 Marriage and Family Therapists 52,070 229 Materials Engineers 98,090 230 Mathematical Science Teachers, Postsecondary 71,370 231 Mechanical Drafters 58,680 232 Mechanical Engineering Technicians 56,050 233 Mechanical Engineers 83,940 234 Media and Communication Equipment Workers, All Other 47,300 235 Medical and Clinical Laboratory Technologists 65,770 236 Medical and Health Services Managers 108,280 237 Medical Equipment Repairers 63,230 238 Meeting, Convention, and Event Planners 54,500 239 Mental Health Counselors 46,580 240 Metal-Refining Furnace Operators and Tenders 43,310 241 Middle School Teachers, Except Special and Career/Technical Education 64,780 242 Millwrights 49,300 243 Mine Cutting and Channeling Machine Operators 46,410 244 Mine Shuttle Car Operators 53,150 245 Mining and Geological Engineers, Including Mining Safety Engineers 95,550 246 Mining Machine Operators, All Other 51,740 247 Mixing and Blending Machine Setters, Operators, and Tenders 38,940 248 Mobile Heavy Equipment Mechanics, Except Engines 56,690 249 Model Makers, Metal and Plastic 40,210 250 Morticians, Undertakers, and Funeral Directors 62,060 251 Multimedia Artists and Animators 58,020 252 Music Directors and Composers 84,860 253 Natural Sciences Managers 118,520 Data Sheet2 | Sheet3 + Ready 12Accessibility: Good to go + 100% 76.F W 2:12 PM Search the web X 1 Sunny 10/23/2022X AutoSave Off Deliverable_Spreadsheet_Del1_Del3_Del4 - Excel Search (Alt+Q) Lanna Taylor LT X File Home Insert Page Layout Formulas Data Review View Help Comments Share ~ Calibri v 11 ap Wrap Text General AutoSum AY O Fill Paste EE Merge & Center * % 9 Conditional Format as Cell Insert Delete Format Sort & Find & Analyze 00 0 Formatting > Table Styles v Clear Filter ~ Select Data Undo Clipboard Font Alignment Number Styles Cells Editing Analysis H10 VIX fx A B C D E F G H I J K L M 254 Network and Computer Systems Administrators 85,560 255 Nuclear Engineers 110,620 256 Nuclear Medicine Technologists 83,110 257 Nuclear Technicians 59,630 258 Nurse Practitioners 116,150 259 Nursing Instructors and Teachers, Postsecondary 69,470 260 Occupational Health and Safety Specialists 78,470 261 Occupational Health and Safety Technicians 53 , 780 262 Occupational Therapists 73,680 263 Occupational Therapy Assistants 48,210 264 Operations Research Analysts 90,570 265 Optometrists 127,590 266 Orthotists and Prosthetists 72,850 267 Painters, Transportation Equipment 55,980 268 Paper Goods Machine Setters, Operators, and Tenders 40,880 269 Paralegals and Legal Assistants 56,510 270 Patternmakers, Metal and Plastic 46,310 271 Personal Financial Advisors 109,250 272 Petroleum Pump System Operators, Refinery Operators, and Gaugers 60,720 273 Pharmacists 126,840 274 Philosophy and Religion Teachers, Postsecondary 74,090 275 Physical Therapist Assistants 53,350 276 Physical Therapists 81,860 277 Physician Assistants 112,460 278 Physicists 134,710 279 Physics Teachers, Postsecondary 85,870 Data Sheet2 | Sheet3 + Ready Accessibility: Good to go + 100% 76.F Search the web X W 2:12 PM 1 Sunny 10/23/2022X AutoSave Off Deliverable_Spreadsheet_Del1_Del3_Del4 - Excel Search (Alt+Q) Lanna Taylor LT X File Home Insert Page Layout Formulas Data Review View Help Comments Share ~ Calibri v 11 = = = 2 ap Wrap Text General AutoSum AY O Fill Paste EE Merge & Center * % 9 Conditional Format as Cell Insert Delete Format Sort & Find & Analyze 00 0 Formatting Table Styles v Clear Filter ~ Select Data Undo Clipboard Font Alignment Number Styles Cells Editing Analysis H10 VIX fx A B C D E F G H I J K L M 2/y Physics Teachers, Postsecondary 85,870 280 Plant and System Operators, All Other 63,770 281 Plumbers, Pipefitters, and Steamfitters 71,020 282 Podiatrists 199,980 283 Police and Sheriff's Patrol Officers 64,700 284 Political Science Teachers, Postsecondary 102,230 285 Postal Service Clerks 47,350 286 Postal Service Mail Carriers 49,570 287 Postal Service Mail Sorters, Processors, and Processing Machine Operators 49,190 288 Postmasters and Mail Superintendents 73,270 289 Power Distributors and Dispatchers 92,440 290 Power Plant Operators 78,360 291 Precision Instrument and Equipment Repairers, All Other 57,600 292 Private Detectives and Investigators 51,840 293 Probation Officers and Correctional Treatment Specialists 63,380 294 Producers and Directors 68,290 295 Production, Planning, and Expediting Clerks 49,410 296 Property, Real Estate, and Community Association Managers 64,290 297 Psychologists, All Other 86,420 298 Psychology Teachers, Postsecondary 72,570 299 Public Relations and Fundraising Managers 121,010 300 Public Relations Specialists 60,500 301 Pump Operators, Except Wellhead Pumpers 47,570 302 Purchasing Agents, Except Wholesale, Retail, and Farm Products 61,760 303 Purchasing Managers 116,310 304 Radiation Therapists 80,510 Data Sheet2 | Sheet3 + Ready 12Accessibility: Good to go + 100% 76.F Search the web X W 2:12 PM Sunny 10/23/2022 1X AutoSave Off Deliverable_Spreadsheet_Del1_Del3_Del4 - Excel Search (Alt+Q) Lanna Taylor LT X File Home Insert Page Layout Formulas Data Review View Help Comments Share ~ Calibri ap Wrap Text AutoSum v 11 General AY O Fill Paste BIUVFDAY EE Merge & Center * % 9 Conditional Format as Cell Insert Delete Format Sort & Find & Analyze 00 0 Formatting Table Styles v Clear Filter ~ Select Data Undo Clipboard Font Alignment Number Styles Cells Editing Analysis H18 VIX fx A B C D E F G H I J K L M 305 Radio, Cellular, and Tower Equipment Installers and Repairers 65,380 306 Radiologic Technologists 64,880 307 Rail Yard Engineers, Dinkey Operators, and Hostlers 54,860 308 Railroad Conductors and Yardmasters 66,620 309 Rail-Track Laying and Maintenance Equipment Operators 48,440 310 Real Estate Brokers 66,270 311 Real Estate Sales Agents 48,250 312 Recreation and Fitness Studies Teachers, Postsecondary 63,760 313 Recreational Vehicle Service Technicians 37,600 314 Refractory Materials Repairers, Except Brickmasons 47,440 315 Registered Nurses 77,540 316 Reinforcing Iron and Rebar Workers 64,470 317 Respiratory Therapists 67,460 318 Rolling Machine Setters, Operators, and Tenders, Metal and Plastic 39,480 319 Roof Bolters, Mining 54,150 320 Rotary Drill Operators, Oil and Gas 56,660 321 Sales Engineers 101,950 322 Sales Managers 136,930 323 Sales Representatives, Services, All Other 63,470 324 Sales Representatives, Wholesale and Manufacturing, Except Technical and Scientific Products 75,270 325 Sales Representatives, Wholesale and Manufacturing, Technical and Scientific Products 113,360 $26 Secondary School Teachers, Except Special and Career/Technical Education 65,290 327 Securities, Commodities, and Financial Services Sales Agents 95,750 328 Service Unit Operators, Oil, Gas, and Mining 48,010 329 Set and Exhibit Designers 50,170 330 Ship Engineers 103,040 Data Sheet2 | Sheet3 + Ready 12Accessibility: Good to go + 100% 76. F 2:13 PM Search the web X W 10/23/2022 1 SunnyX AutoSave Off Deliverable_Spreadsheet_Del1_Del3_Del4 - Excel Search (Alt+Q) Lanna Taylor LT X File Home Insert Page Layout Formulas Data Review View Help Comments Share ~ Calibri v 11 ap Wrap Text General AutoSum AY O Fill Paste EE Merge & Center * % 9 Conditional Format as Cell Insert Delete Format Sort & Find & Analyze 00 0 Formatting > Table Styles v Clear Filter ~ Select Data Undo Clipboard Font Alignment Number Styles Cells Editing Analysis H18 VIXfx A B C D E F G H I J K L M 331 Signal and Track Switch Repairers 40,520 332 Social and Community Service Managers 77,700 333 Social Scientists and Related Workers, All Other 76,810 334 Social Work Teachers, Postsecondary 66,060 335 Social Workers, All Other 56,280 336 Sociology Teachers, Postsecondary 84,210 337 Software Developers, Applications 93,280 338 Software Developers, Systems Software 111,340 339 Soil and Plant Scientists 70,780 340 Sound Engineering Technicians 44,310 341 Special Education Teachers, All Other 69,770 342 Special Education Teachers, Kindergarten and Elementary School 63,330 343 Special Education Teachers, Middle School 65,290 344 Special Education Teachers, Secondary School 63,370 345 Speech-Language Pathologists 74,180 346 Stationary Engineers and Boiler Operators 57,420 347 Statisticians 94,640 348 Surveyors 67,560 349 Tank Car, Truck, and Ship Loaders 46,730 350 Tax Examiners and Collectors, and Revenue Agents 63,730 351 Technical Writers 67,260 352 Telecommunications Equipment Installers and Repairers, Except Line Installers 61,410 353 Tire Builders 42,500 354 Tool and Die Makers 57,790 355 Training and Development Managers 113,080 356 Training and Development Specialists 64,490 Data Sheet2 | Sheet3 + Ready 12Accessibility: Good to go + 100% 76.F X W 2:13 PM Search the web 10/23/2022 1 SunnyX AutoSave Off Deliverable_Spreadsheet_Del1_Del3_Del4 - Excel Search (Alt+Q) Lanna Taylor LT X File Home Insert Page Layout Formulas Data Review View Help Comments Share ~ Calibri v 11 ap Wrap Text General AutoSum AY O Paste Merge & Center 9 Conditional Format as Cell Fill EE * % Insert Delete Format Sort & Find & Analyze 00 0 Formatting Table Styles v Clear Filter ~ Select Data Undo Clipboard Font Alignment Number Styles Cells Editing Analysis H18 VIXfx A B C D E F G H I J K L M 340 Sound Engineering Technicians 44,310 341 Special Education Teachers, All Other 69,770 342 Special Education Teachers, Kindergarten and Elementary School 63,330 343 Special Education Teachers, Middle School 65,290 344 Special Education Teachers, Secondary School 63,370 345 Speech-Language Pathologists 74.180 346 Stationary Engineers and Boiler Operators 57,420 347 Statisticians 94,640 348 Surveyors 67,560 349 Tank Car, Truck, and Ship Loaders 46,730 350 Tax Examiners and Collectors, and Revenue Agents 63,730 351 Technical Writers 67,260 352 Telecommunications Equipment Installers and Repairers, Except Line Installers 61,410 353 Tire Builders 42,500 354 Tool and Die Makers 57,790 355 Training and Development Managers 113,080 356 Training and Development Specialists 64,490 357 Transportation Inspectors 92,970 358 Transportation, Storage, and Distribution Managers 103,970 359 Urban and Regional Planners 70,850 360 Veterinarians 91,980 361 Water and Wastewater Treatment Plant and System Operators 51,720 362 Web Developers 75,970 363 Wholesale and Retail Buyers, Except Farm Products 59,080 364 Writers and Authors 65,180 365 Zoologists and Wildlife Biologists 60,060 Data Sheet2 | Sheet3 + Ready 12Accessibility: Good to go + 100% 76.F X W 2:14 PM Sunny Search the web 10/23/2022 1W AutoSave Off Deliverable_01_Questions_ma . Saved to this PC v Search (Alt+Q) Lanna Taylor X File Home Insert Draw Design Layout References Mailings Review View Help Comments Editing Share ~ k Find Roboto 18 ~ A" A" Aa Ap Normal No Spacing Paste BIUvab x x A LAB= = ~ ~ Heading 1 Heading 2 Title Gc Replace Dictate Editor Select Undo Clipboard Font Paragraph Styles Editing Voice Editor Deliverable 01 Worksheet 1. Introduce your scenario and data set. Provide a brief overview of the scenario you are given and describe the data set. 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. Page 1 of 3 265 words [ Text Predictions: On 2 Accessibility: Good to go " Focus + 100% 76.F Sunny Search the web X W 2:14 PM 10/23/2022 1W AutoSave Off Deliverable_01_Questions_ma . Saved to this PC v Search (Alt+Q) Lanna Taylor X File Home Insert Draw Design Layout References Mailings Review View Help Comments Editing Share ~ k 18 ~ A" A Aa Ap Find Roboto Normal No Spacing BI U~ ab x x A LA Heading 1 Heading 2 Title Gc Replace Paste Dictate Editor Select Undo Clipboard Font Paragraph Styles Editing Voice Editor 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 Name and describe each measure of variation. o Discuss the advantages and/or disadvantages of each. Answer and Explanation: Enter your step-by-step answer and explanations here. Page 2 of 3 265 words [ Text Predictions: On Accessibility: Good to go " Focus + 100% 76.F Sunny Search the web X W 2:14 PM 10/23/2022 1W AutoSave Off Deliverable_01_Questions_ma . Saved to this PC v Search (Alt+Q) Lanna Taylor X File Home Insert Draw Design Layout References Mailings Review View Help Comments Editing Share ~ k Find Roboto 18 ~ A" A Aa Ap Normal No Spacing Heading 1 Heading 2 Gc Replace Paste BI Uvab x x A LA Title Dictate Editor Select Undo Clipboard Font Paragraph Styles Editing Voice Editor 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 Mean Median Mode Midrange Range Variance o Standard deviation Answer and Explanation: Enter your step-by-step answer and explanations here. Page 3 of 3 265 words [ Text Predictions: On Accessibility: Good to go " Focus + 100% 76.F LOCBZ W 2:14 PM Sunny Search the web X 10/23/2022 1