X AutoSave Off H Deliverable_Spreadsheet_Del1_Del3_Del4 (2) v Search (Alt+Q) A Lanna Taylor LT X File Home Insert Page Layout Formulas Data Review View Help Comments Share La From Text/CSV To Recent Sources IT Queries & Connections Y Clear Group Data Analysis Le From Web Properties 2B Ungroup Get Le Existing Connections -= Refresh ZJ Sort Filter Reapply Text to What-If Forecast Stocks Data From Table/Range All Edit Links Currencies Advanced Columns Analysis Sheet Subtotal Get & Transform Data Queries & Connections Data Types Sort & Filter Data Tools Forecast Outline Analysis E16 VIX fx A B C D E F G H J K L M N O P Q R S T U V 1 Salary N Mean 71879.4 4 Standard Error 1224.782 5 Median 66525 6 Mode 71420 7 Standard Deviation 23367.36 8 Sample Variance 5.46E+08 9 Kurtosis 2.548741 10 Skewness 1.228529 11 Range 167760 12 Minimum 32220 13 Maximum 199980 14 Sum 26164100 15 Count 364 16 17 18 19 20 21 22 23 24 25 26 Sheet1 Data | Sheet2 | Sheet3 + Ready Box Accessibility: Investigate We're starting the add-ins runtime, just a moment. + 100% 70.F 5:44 PM O Cloudy Search the web 11/1/2022 1W AutoSave Off Deliverable_01_Questions_ma (2) . Saved to this PC v Search (Alt+Q) A Lanna Taylor LT X File Home Insert Draw Design Layout References Mailings Review View Help Comments Editing Share ~ k Find Roboto * 11 ~ A" A Aa Ap Title Normal No Spacing c Replace Paste Heading 1 Heading 2 BI U~ ab X x A LA Dictate Editor Select v 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 O Median O Mode Midrange o Range O Variance 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% 70.F 5:44 PM Search the web X W Cloudy 11/1/2022X Off H Deliverable_Spreadsheet_Del1_Del3_Del4 (2) v Search (Alt+Q) A Lanna Taylor LT X AutoSave File Home Insert Page Layout Formulas Data Review View Help Comments Share [ From Text/CSV To Recent Sources IT Queries & Connections Y Clear Group Data Analysis Get Le From Web Le Existing Connections -= Refresh Properties Sort Filter Reapply Text to What-If Forecast 2B Ungroup Stocks ZJ Data From Table/Range All Edit Links Currencies Advanced Columns Analysis Sheet Subtotal Get & Transform Data Queries & Connections Data Types Sort & Filter Data Tools Forecast Outline Analysis B2 viX fx 71420 A B C D E F G H J K L M 1 Job Title Salary Accountants and Auditors 71,420| source: http://www.bls.gov/ 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 Sheet1 Data Sheet2 | Sheet3 + Ready Ex Accessibility: Investigate We're starting the add-ins runtime, just a moment. + 100% 74F 2:36 PM Search the web O Sunny 11/2/2022 2H Deliverable_Spreadsheet_Del1_Del3_Del4 (2) v X X AutoSave Off Search (Alt+Q) A Lanna Taylor LT File Home Insert Page Layout Formulas Data Review View Help Comments Share La From Text/CSV To Recent Sources IT Queries & Connections Y Clear Group Data Analysis Le From Web Le Existing Connections Properties Reapply 2B Ungroup -= Get Refresh Stocks Currencies ZJ Sort Filter Text to What-If Forecast Data From Table/Range All Edit Links Advanced Columns Analysis Sheet Subtotal Get & Transform Data Queries & Connections Data Types Sort & Filter Data Tools Forecast Outline Analysis B51 VIXfx 48290 A B C D E F G H 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 Sheet1 Data Sheet2 | Sheet3 + Ready x Accessibility: Investigate We're starting the add-ins runtime, just a moment. + 100% 74F 2:36 PM Search the web Sunny LOB CZ O 11/2/2022 2X AutoSave Off H Deliverable_Spreadsheet_Del1_Del3_Del4 (2) v Search (Alt+Q) A Lanna Taylor LT X File Home Insert Page Layout Formulas Data Review View Help Comments Share La From Text/CSV To Recent Sources IT Queries & Connections Y Clear Group Data Analysis Get Le From Web Le Existing Connections Properties Sort Filter Reapply Text to What-If Forecast 2B Ungroup -= Refresh Stocks ZJ Data From Table/Range All Edit Links Currencies Advanced Columns Analysis Sheet Subtotal Get & Transform Data Queries & Connections Data Types Sort & Filter Data Tools Forecast Outline Analysis B77 VIXfx 107860 A B C D E F G H J K L M 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 76 Computer Hardware Engineers 112,250 77 Computer Network Architects 107,860 78 Computer Network Support Specialists 60,200 Sheet1 Data Sheet2 | Sheet3 + Ready Ex Accessibility: Investigate We're starting the add-ins runtime, just a moment. + 100% 74F Search the web O 2:37 PM Sunny 11/2/2022 2X AutoSave Off H Deliverable_Spreadsheet_Del1_Del3_Del4 (2) v Search (Alt+Q) A Lanna Taylor LT X File Home Insert Page Layout Formulas Data Review View Help Comments Share La From Text/CSV To Recent Sources IT Queries & Connections Y Clear Group Data Analysis Get Le From Web Le Existing Connections Refresh Properties -= ZJ Sort Filter Reapply Text to What-If Forecast 2B Ungroup Stocks Currencies Data From Table/Range All Edit Links Advanced Columns Analysis Sheet Subtotal Get & Transform Data Queries & Connections Data Types Sort & Filter Data Tools Forecast Outline Analysis B103 VIXfx 53330 A B C D E F G H J K L M 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 01 Dietitians and Nutritionists 61,440 102 Directors, Religious Activities and Education 50,210 103 Drafters, All Other 53,330 104 Economics Teachers, Postsecondary 109,480 Sheet1 Data Sheet2 | Sheet3 + Ready Ex Accessibility: Investigate We're starting the add-ins runtime, just a moment. + 100% 74F 2:37 PM Search the web O Sunny 11/2/2022 2X AutoSave Off H Deliverable_Spreadsheet_Del1_Del3_Del4 (2) v Search (Alt+Q) A Lanna Taylor LT X File Home Insert Page Layout Formulas Data Review View Help Comments Share La From Text/CSV To Recent Sources IT Queries & Connections Y Clear Group Data Analysis Le From Web Le Existing Connections Properties Reapply 2B Ungroup -= Get Refresh Stocks Currencies ZJ Sort Filter Text to What-If Forecast Data From Table/Range All Edit Links Advanced Columns Analysis Sheet Subtotal Get & Transform Data Queries & Connections Data Types Sort & Filter Data Tools Forecast Outline Analysis B129 VIX fx 5 A B C D E F G H J K L M 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 126 Elevator Installers and Repairers 83,900 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 Sheet1 Data Sheet2 Sheet3 + Ready Ex Accessibility: Investigate We're starting the add-ins runtime, just a moment. + 100% 74F 2:37 PM Search the web O Sunny 11/2/2022 2X AutoSave Off H Deliverable_Spreadsheet_Del1_Del3_Del4 (2) v Search (Alt+Q) A Lanna Taylor LT X File Home Insert Page Layout Formulas Data Review View Help Comments Share La From Text/CSV To Recent Sources IT Queries & Connections Y Clear Group Data Analysis Get Le From Web Le Existing Connections Refresh Properties -= Sort Filter Reapply 2B Ungroup Currencies ZJ Text to What-If Forecast Stocks Data From Table/Range All Edit Links Advanced Columns Analysis Sheet Subtotal Get & Transform Data Queries & Connections Data Types Sort & Filter Data Tools Forecast Outline Analysis B105 vi X fx 72810 A B C D E F G H J K L M 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 126 Elevator Installers and Repairers 83,900 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 Sheet1 Data Sheet2 | Sheet3 + Ready Ex Accessibility: Investigate We're starting the add-ins runtime, just a moment. + 100% 74F 2:37 PM Search the web O Sunny 11/2/2022 2X Off H Search (Alt+Q) LT X AutoSave Deliverable_Spreadsheet_Del1_Del3_Del4 (2) v A Lanna Taylor File Home Insert Page Layout Formulas Data Review View Help Comments Share La From Text/CSV To Recent Sources IT Queries & Connections Y Clear Group Data Analysis Get Le From Web Le Existing Connections Refresh Properties Reapply -= ZJ Sort Filter Text to What-If Forecast 2B Ungroup Stocks Data From Table/Range All Edit Links Currencies Advanced Columns Analysis Sheet Subtotal Get & Transform Data Queries & Connections Data Types Sort & Filter Data Tools Forecast Outline Analysis B155 viX fx 51310 A B C D E F G H J K L M 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 Analyst 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 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 Sheet1 Data Sheet2 | Sheet3 + Ready Ex Accessibility: Investigate We're starting the add-ins runtime, just a moment. + 100% 74.F 2:37 PM Search the web O 11/2/2022 2 SunnyX AutoSave Off H Deliverable_Spreadsheet_Del1_Del3_Del4 (2) v Search (Alt+Q) A Lanna Taylor LT X File Home Insert Page Layout Formulas Data Review View Help Comments Share La From Text/CSV To Recent Sources IT Queries & Connections Y Clear Group Data Analysis Le From Web Sort Reapply What-If Forecast 2B Ungroup -= Get Le Existing Connections Refresh Properties Filter Text to Stocks Edit Links Currencies ZJ Data From Table/Range All Advanced Columns Analysis Sheet Subtotal Get & Transform Data Queries & Connections Data Types Sort & Filter Data Tools Forecast Outline Analysis B181 vixfx 56120 A B C D E F G H J K L M 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 162 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 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 Sheet1 Data Sheet2 | Sheet3 + Ready x Accessibility: Investigate We're starting the add-ins runtime, just a moment. + 100% 74F 2:38 PM Search the web O Sunny 11/2/2022 2X AutoSave Off H Deliverable_Spreadsheet_Del1_Del3_Del4 (2) v Search (Alt+Q) A Lanna Taylor LT X File Home Insert Page Layout Formulas Data Review View Help Comments Share [ From Text/CSV To Recent Sources IT Queries & Connections Y Clear Group Data Analysis Reapply 2B Ungroup -= Get Le From Web Le Existing Connections Refresh Properties ZJ Sort Filter Text to What-If Forecast Stocks Currencies Data From Table/Range All Edit Links Advanced Columns Analysis Sheet Subtotal Get & Transform Data Queries & Connections Data Types Sort & Filter Data Tools Forecast Outline Analysis B207 viXfx 69170 A B C D E F G H J K L M 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 187 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 82,760 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 Sheet1 Data Sheet2 | Sheet3 + Ready Ex Accessibility: Investigate We're starting the add-ins runtime, just a moment. + 100% 74F 2:38 PM Search the web O 11/2/2022 2 SunnyX AutoSave Off H Deliverable_Spreadsheet_Del1_Del3_Del4 (2) v Search (Alt+Q) A Lanna Taylor LT X File Home Insert Page Layout Formulas Data Review View Help Comments Share La From Text/CSV To Recent Sources IT Queries & Connections Y Clear Group Data Analysis Le From Web Le Existing Connections -= Refresh ZJ Filter Reapply Get Properties Sort Text to What-If Forecast 2B Ungroup Stocks Currencies Data From Table/Range All Edit Links Advanced Columns Analysis Sheet Subtotal Get & Transform Data Queries & Connections Data Types Sort & Filter Data Tools Forecast Outline Analysis B233 viX fx 83940 A B C D E F G H J K L M 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 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 Sheet1 Data Sheet2 Sheet3 + Ready Ex Accessibility: Investigate We're starting the add-ins runtime, just a moment. + 100% 74F 2:38 PM Search the web O 11/2/2022 2 Sunny