Answered step by step
Verified Expert Solution
Question
1 Approved Answer
AutoSave On ANANE WORKFORCE COMPOSITION ANALYSIS_FALL 2021 - 2 - Saving... LO Jacob Anane O X File Home Insert Draw Page Layout Formulas Data Review
AutoSave On ANANE WORKFORCE COMPOSITION ANALYSIS_FALL 2021 - 2 - Saving... LO Jacob Anane O X File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat Share Comments Insert Calibri ~ 11 ~ A A ab Wrap Text General Ex AY O Ex Delete Paste Merge & Center ~ $ ~ % 9 08 40 Conditional Format as Cell Sort & Find & Analyze Formatting Table ~ Styles v Format Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis C4 X V A B C D E F G 9 12/31/2019 10 10 Emp # Hire Date Role Salary Hrly Rate Yrs of Svc Ed 11 4000 4/23/2015 Sr Cyber Investigator $92,267 19 12 4004 7/13/2002 Cyber Analyst $111,801 16 13 4010 11/25/2018 Forensics Analyst $90,688 16 14 4012 1/26/2010 Cyber Analyst $95,985 14 15 4013 12/29/2011 Cyber Analyst $100,520 19 16 4014 10/2/2011 Forensics Analyst $125,156 19 17 4015 1/1/2012 Cyber Analyst $78,475 16 18 4020 5/9/2011 Cyber Analyst $93,518 14 19 4022 5/27/2004 Cyber Analyst $69,529 16 20 4023 2/6/2014 Advertising $128,384 16 21 4025 12/12/2014 Cyber Mgr $151,174 16 22 4027 8/19/2006 Sr Cyber Investigator $71,914 16 23 4029 6/5/2011 Cyber Analyst $152,446 14 24 4030 7/10/2011 IT Staff $57,727 16 25 4031 10/20/2013 Cyber Software Engineer $78,869 16 26 4034 5/21/2006 IT Staff $90,930 19 27 4037 9/13/2013 Forensics Analyst $67,866 14 QR Questions_Responses DATA + Ready + 100% 12:52 PM o O X 54% 77.F Mostly sunny ~ 9 0 6 ( 4) 11/2/2021AutoSave On . ANANE WORKFORCE_COMPOSITION ANALYSIS_FALL 2021 - 2 - Upload Pending LO Jacob Anane O X File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat Share Comments Insert Calibri ~ 11 ~ A A ab Wrap Text General Ex AY O Ex Delete Paste Sort & Find & Analyze E Cell Merge & Center $ ~ % 9 08 40 Conditional Format as Formatting Table ~ Styles v Format Filter ~ Select Data Clipboard Font N Alignment Number Styles Cells Editing Analysis A UPLOAD PENDING Click Save to retry your upload. Save X i COULDN'T VERIFY SUBSCRIPTION Excel couldn't verify your Microsoft 365 subscription. Please make sure that you're connected to the Internet. Retry X C4 X V fx A B C D E F G 25 4031 10/20/2013 Cyber Software Engineer $78,869 16 26 4034 5/21/2006 IT Staff $90,930 19 27 4037 9/13/2013 Forensics Analyst $67,866 14 28 4038 4/14/2012 Cyber Analyst $64,580 16 29 4039 5/30/2013 Cyber Analyst $91,771 16 30 4044 12/3/2015 Cyber Analyst $59,219 14 31 4045 6/7/2016 Physical Security $32,367 12 32 4046 9/4/2006 Cyber Analyst $115,974 16 33 4055 6/17/2018 T Staff $99,786 14 34 4060 2/1/2012 Sr Cyber Investigator $73,650 19 35 4061 2/28/2012 Cyber Analyst $154,933 16 36 4064 1/18/2016 Cyber Analyst $144,571 16 37 4067 10/29/2012 Malware Reverse Engineer $124,996 16 38 890t 7/15/2003 Cyber Analyst $145,776 16 39 4070 4/4/2017 Forensics Analyst $80,191 16 40 4075 10/2/2016 Forensics Analyst $75,053 14 QR Questions_Responses DATA + Ready + 100% 2:54 PM o o X 100% 77.F Mostly sunny DE 11/2/2021O AutoSave On . ANANE WORKFORCE_COMPOSITION ANALYSIS_FALL 2021 - 2 - Upload Pending LO Jacob Anane X Share Comments File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat Insert Ex AY O Calibri ~ 11 ~ A A ab Wrap Text General Ex Delete Cell Merge & Center $ ~ % 9 08 40 Conditional Format as Sort & Find & Analyze Paste E Formatting Table ~ Styles v Format Filter ~ Select Data Cells Editing Analysis Clipboard Font N Alignment Number Styles X A UPLOAD PENDING Click Save to retry your upload. Save i COULDN'T VERIFY SUBSCRIPTION Excel couldn't verify your Microsoft 365 subscription. Please make sure that you're connected to the Internet. Retry X C4 X V fx D E F G A B C 387 388 Roles # 1 African-Am 389 Acctg/Fin N Asian 390 Admin Caucasian 391 Advertising 3 4 392 CEC Hispanic TOTAL 393 CFC 394 CIO 395 Controller Gender 396 COO Cyber Analyst 1 Male 397 2 Female 398 Cyber Mgr TOTAL 399 Cyber Software Engineer 400 Eng Mgr 401 Forensics Analyst Education Level 402 Investigator QR Questions_Responses DATA (+ + 100% Ready 2:54 PM X 100% 77.F Mostly sunny 11/2/2021
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