Statistical Analysis.xlsx

# Skew of the salary distribution suggests that there

• Essay
• 46

This preview shows pages 3–10. Sign up to view the full content.

skew of the salary distribution suggests that there is a long tail of high earners, most likely the employees who have served longer have achieved senior positions. The current proportions of race and gender may be appropriate. While comparing to population gives an estimate, the firm should their applicant pool; if 61% of their applicants are white, 26% are black, 6% asian, and 7% hispanic, then they are accurately repre the diversity of that pool. The same applies to gender, and to education. With respect to job titles, the company should make sure fills all departments' staffing needs.

This preview has intentionally blurred sections. Sign up to view the full version.

ill answer plain. 99 to ales were centage d 2017. more tics, namic ribe how
an r findings. portant. the way it on! ers.) rly rate e same With a , most est the d 50%, have at nse, as Cyber

This preview has intentionally blurred sections. Sign up to view the full version.

r, on the s growth alaries for t 75%). h for the lar curity. The r and d look at esenting that it
Sameer Navathe 10/31/2018 7 Workforce Profile Analysis Section 1: Data Format for: Number Date Text Currency Currency mm/dd/yy Emp # Hire Date Role Salary Hrly Rate 1001 03/15/99 CEO \$290,210 \$139.52 1002 12/15/99 CIO \$279,723 \$134.48 1003 09/07/12 Sr Cyber Analyst \$166,750 \$80.17 1004 06/13/12 Cyber Analyst \$131,924 \$63.43 1005 10/25/08 Cyber Analyst \$142,687 \$68.60 1006 08/05/06 Cyber Analyst \$150,307 \$72.26 1014 06/03/09 IT Staff \$98,818 \$47.51 1015 07/08/13 Investigator \$81,250 \$39.06 1016 09/23/08 Cyber Analyst \$92,719 \$44.58 1018 01/15/11 Acctg/Fin \$72,836 \$35.02 1018 05/03/12 Cyber Analyst \$82,157 \$39.50 1019 05/21/07 Cyber Analyst \$98,317 \$47.27 1024 08/17/11 Cyber Analyst \$83,005 \$39.91 1036 09/25/00 Cyber Analyst \$107,822 \$51.84 1038 08/21/12 IT Staff \$85,451 \$41.08 1043 06/18/09 Forensics Analyst \$76,168 \$36.62 1048 09/19/13 Physical Security \$61,655 \$29.64 1049 02/23/04 IT Staff \$88,421 \$42.51 1053 05/31/13 Cyber Analyst \$80,241 \$38.58 1053 09/08/09 Cyber Analyst \$85,293 \$41.01 1055 06/15/01 Controller \$149,836 \$72.04 1055 06/04/01 Cyber Analyst \$106,663 \$51.28 1055 9/30/2001 Cyber Analyst \$107,385 \$51.63 1056 05/06/07 Cyber Analyst \$98,059 \$47.14 Format cells in column according to indicated format.

This preview has intentionally blurred sections. Sign up to view the full version.

Sameer Navathe 10/31/2018 8 1059 02/14/12 Acctg/Fin \$126,589 \$60.86 1061 02/02/09 Cyber Analyst \$99,931 \$48.04 1062 03/04/13 Acctg/Fin \$112,238 \$53.96 1062 07/08/09 Cyber Mgr \$162,803 \$78.27 1069 02/03/11 Cyber Software Engineer \$179,938 \$86.51 1070 08/21/09 Cyber Analyst \$95,498 \$45.91 1071 01/09/05 Cyber Software Engineer \$166,238 \$79.92 1071 08/08/05 Cyber Software Engineer \$167,019 \$80.30 1075 01/14/10 Cyber Analyst \$84,317 \$40.54 1079 10/15/03 Investigator \$71,459 \$34.36 1083 08/27/09 Cyber Analyst \$85,396 \$41.06 1083 4/30/2000 Cyber Analyst \$108,771 \$52.29 1084 03/15/99 Public and Business Office Team \$135,671 \$65.23 1088 10/03/11 Sr Forensics Mgr \$173,974 \$83.64 1096 03/06/06 Cyber Analyst \$100,502 \$48.32 1097 08/14/05 Cyber Analyst \$110,571 \$53.16 1098 01/13/14 Cyber Software Engineer \$162,245 \$78.00 1101 06/08/02 Investigator \$125,994 \$60.57 1102 04/08/00 IT Staff \$88,900 \$42.74 1104 02/01/05 Cyber Analyst \$112,450 \$54.06 1105 09/06/12 Investigator \$92,633 \$44.54 1106 5/9/2002 Cyber Analyst \$115,744 \$55.65 1108 06/15/07 Forensics Analyst \$127,403 \$61.25 1109 02/22/07 Cyber Analyst \$99,201 \$47.69 1113 05/02/12 Cyber Analyst \$82,124 \$39.48 1113 09/08/00 Sr Cyber Investigator \$151,695 \$72.93 1116 12/30/08 Cyber Analyst \$112,235 \$53.96 1116 04/05/00 Quality Assurance \$111,526 \$53.62 1117 05/27/09 Forensics Analyst \$136,360 \$65.56 1117 08/15/12 Cyber Analyst \$121,262 \$58.30 1128 06/07/10 Cyber Mgr \$174,104 \$83.70 1130 03/15/99 Cyber Analyst \$79,438 \$38.19 1132 07/10/09 Cyber Analyst \$85,822 \$41.26 1133 02/12/09 Public and Business Office Team \$93,337 \$44.87 1136 12/14/11 Cyber Analyst \$82,523 \$39.67
Sameer Navathe 10/31/2018 9 1138 10/18/10 Forensics Analyst \$124,017 \$59.62 1138 4/12/2008 Cyber Analyst \$94,204 \$45.29 1140 07/10/09 Cyber Analyst \$85,934 \$41.31 1141 06/18/09 Forensics Analyst \$75,999 \$36.54 1142 06/17/09 Cyber Analyst \$86,901 \$41.78 1145 02/16/09 Forensics Analyst \$75,131 \$36.12 1145 11/05/09 Cyber Analyst \$74,680 \$35.90 1145 09/15/04 Cyber Analyst \$103,327 \$49.68 1150 04/26/13 Cyber Analyst \$80,808 \$38.85 1153 02/05/12 Sr Cyber Investigator \$154,843 \$74.44 1156 05/21/11 Cyber Analyst \$83,395 \$40.09 1167 11/15/11 Cyber Analyst \$82,766 \$39.79 1169 01/22/09 Cyber Analyst

This preview has intentionally blurred sections. Sign up to view the full version.

This is the end of the preview. Sign up to access the rest of the document.
• Fall '16
• Dr. Bass
• Cybersecurity, Trigraph, analyst, Northwest Airlines, Sr Cyber Analyst, Sr Cyber Investigator

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern