Project: Conduct Quantitative Analysis

Quantitative Analysis

Awais Khan &D &P

&A

Awais Khan &D 1&P

 Apply Quantitative Reasoning Now that you have completed your analysis, think about the patterns you have seen in the workforce. In this final section, you will answer five questions and write a short essay. 1. From the created histogram, it appears that a large share of employees have a salary between $61,000–$110,000 or $131,000–$170,000. This may indicate a reasonable promotion rate for new and seasoned employees. Is this distribution unimodal or bimodal? Please explain. Ans: The histogram indicates shows a gradual increase in employee salaries and a drastic increase between the salary bin $60000 and $70000. The income then stabilizes in an increasing manner then begins tto drastically decrease. The abnormal spikes even though steadies after a while indicates a bimodal method of distribution 2. The line chart, as detailed in your "Graph Charts" Excel spreadsheet, shows sales generally increasing over the years, although sales in the first two years were notably lower. Assuming that the sales are linear, please use the Forecast tool to find projected sales for 2020 thru 2024. Hint: An easy way to do this is to highlight the sales from the data page and apply the Forecast tool to this data or use the forecast function in excel. You will generate a chart on a new sheet with projected sales; rename this sheet "Projected Sales". Ans: I have added the tab call (Projected Sales) for this question. 3. The standard deviation provides insight into the distribution of values around the mean. If the standard deviation is small, in general, the more narrow the range between the lowest and highest value. That is, values will cluster close to the mean. From your descriptive statistics, describe your standard deviations of Salary, Hryly Rate, Yrs Worked, Education, and Age. What does this tell you about the variables? Ans: Based on the salary structure the starndard deviation from the data apperas to be high. The salary band with the most employee appears to be $90000 and $100000. this is evident from the calculated mean of $99675. This however is contrasted by the hourly late of $15 paid to the employees. This is an indication that majority of the employee have an average living while the lower band get a much less pay. The employees have a score of 9.94 in age per year. This therefore shows the close corelation between the salries paid the age, hourly rate and the years worked in the company. FEEDBACK: First, there are FIVE standard deviations to discuss and you only touch on three of them. Also, saying the "standard deviation from the data appears to be high" doesn't mean anything. What does having a standard deviation of $32,852 mean for the variable of Salary? What are the standard deviations for the other variables and what do they mean? 4. The company has a keen interest in the educational, race, and gender makeup of its workforce. Its emphasis is on a diverse, dynamic workforce. From your "Graph Charts" spreadsheet, describe your pie chart findings for these characteristics of the workforce. Describe how you would determine if the company was meeting expectations on these characteristics. Ans: The data indicates that the company has a less focus on the diversity of it's employees both in terms of gender and race. This is dicated by the geographical location of the company which forces it to adapt to the environment and culture of the local people. The company can however considr in hiring new employees who are of different gender and race to balance the already existing imbalance. The most noticeable diversity is seen in the gender where 79% of the employees are male and only 21% are female. This can help the company to consider hiring more female employees. Also they need to create a balance and a diversity in the marital status of its employees. FEEDBACK: There are three pie charts and you need to describe with numerical and mathematical data all three of these pie charts. Not just the pie chart for gender. Additionally, you did not answer the second part of the question. You were NEVER asked if the comapny was diverse. You were NEVER asked what the company could do to become more diverse. You were simply asked to describe the process of analysis. HOW would you determine IF the company were diverse. How?? What process would you follow to analyze the information. This question is essentially asking you to figure out how you would analyze the data for the essay. 5. The company is conducting an analysis on how many positions to create to keep up with demand. Specifically, it wants to know an estimate of the number of positions per job title. From your Excel chart, identify the mode of the job title distribution. Describe your findings. Ans: Majority of the employees in the company are not in the managerial position and this can create a strain in the managerial team. Thus the comapany needs to hire more managers based on the data provided below. With the rate of growth of the ompany it is necessary to have enough senior employees to ensure that the junior employes are competent. Therefore it is inevitable for the company to evade hiring of new staff in the need to grow. Key Emp # in Company Acctg/Fin 12 Acctg/Fin 12 Admin 3 Advertising 6 CEO 1 CFO 1 CIO 1 Controller 18 COO 1 Cyber Analyst 146 Cyber Mgr 8 Cyber Software Engineer 23 Eng Mgr 3 Forensics Analyst 39 Investigator 8 IT Mgr 2 IT Staff 18 Logistics 5 Logistics Mgr 1 Malware Reverse Engineer 16 Marketing 5 Physical Security 18 Public and Business Office Team 14 Public and Business Office Team Mgr 1 Quality Assurance 5 Sr Cyber Analyst 2 Sr Cyber Investigator 26 Sr Forensics Mgr 122 Sr Public and Business Office Team Mgr 3 Admin 3 Advertising 6 CEO 1 CFO 1 CIO 1 Controller 18 COO 1 Cyber Analyst 146 Cyber Mgr 8 Cyber Software Engineer 23 Eng Mgr 3 Forensics Analyst 39 Investigator 8 IT Mgr 2 IT Staff 18 Logistics 5 Logistics Mgr 1 Malware Reverse Engineer 16 Marketing 5 Physical Security 18 Public and Business Office Team 14 Public and Business Office Team Mgr 1 Quality Assurance 5 Sr Cyber Analyst 2 Sr Cyber Investigator 26 Sr Forensics Mgr 122 Sr Public and Business Office Team Mgr 3 FEEDBACK: You did not answer the question. You were simply asked for the MDOE of the job titles. The mode is the item in a population that occurs the most frequently. The population for this question is the list of job titles, so which job title occurs the most? Now that you have done all the work with data, you will write a short three- to four-paragraph summary of your analysis. This is important. While you have done a wonderful job with your analysis, you can never assume that the end user will be able to interpret the data the way it should be understood. Supporting narrative is helpful. Never simply provide a "raw data" dump. Instead, seek to provide information! Structure your essay like this: a. Write a one-paragraph narrative summary of your findings, describing patterns of interest. b. Provide an explanation of the potential relevance of such patterns. c. Provide a description of how you would investigate further to determine if your results are "good or bad" for the company. Prepare your response in this workbook. (Simply expand this text box to accommodate your essay and other answers, or you can copy and paste from another document.) FINAL ESSAY: Findings The company's forecast for 2020 to 2024 shows a steady curve with the possibility of a steady drop or rise in sales. Based on the forecast data it is safe to say that with all factors held constant the company will contiue to make steady profits but with adverse effects in the company it is possible to make huge losses or better profits. Therefore it is advisable for the company to seek other ways to motivate its employees such as internal promotions. This ensure that there is maximuma co-orporation of employees thus yielding better results. Also the average salary for the company is about $100000 which is a good opportunity for the employees to work in. The company needs to ensure that there is diversity in terms or race, marital status and the gender of it's employees. This eliminates discrimanation and domination of one group due to being the majority. Diversity creates a team work spirit and eliminates the unhealthy competitive nature of company employees. The company should also consider offering tuition courses or suggesting them to it's employees so as employees can be motivated to apply for the top senior management jobs. This creates a steady and healty flow of employees and a professional culture work environment. The data provided is however not sufficient to judge and place the company at it's true position rather more analysis is needed to know the actual lace and position of the company both currently and in future. The analysis may involve how the drastic drift in diversity of employees may affect the company and how the salary mean and general statistics may interfere with employee perfomance. An analysis of how the company can best motivate it's employees is also keen. FEEDBACK: You have not analyzed the information or written an essay that is connected.: - Paragraph 1: Identify a pattern of interest - Paragraph 2: Explain why that pattern you identified is of interest - Paragraph 3: What additional information do you need to be able to fully analyze the pattern For paragraph 1, you identified a pattern with sales. Paragraph 2 is addressing diversity. The two are not related. Additionally, you have no information on the market, no data on economic demand, no information on productivity. In other words, you have no data with which to perform any kind of ecomonic analysis. All you have is HR data and a known interest in diversity, so that should be the focus of your analysis. Take a look at the screen shot to the right. I took a subset of the employees who are in a specific role, identified their year of hire, determined how many of each race were hired each year and then used the forecast tool to calculate the trend and projection. This is analysis. I can look at this and see that the hiring used to be focused on Caucasians, but that this has stagnated and has been holding steady or slightly declining for the last 4 years. You can look at the projections and determine that the company seems to be more focused on hiring African Americans and a slight focus on hiring Asians. Based on this, maybe the company is implementing changes in their hiring practices. Maybe the company is advertising in communities with a higher number of minorities instead of advertising positions in the more caucasian environments. This is something you could ask for. This is analysis. Find the pattern, determine if it is significant, and then identify the information that is relevant to the pattern but currently missing and needed to complete the analysis. This is the type of work you need to do to get a passing grade on this assignment.

DATA

Awais Khan March 17,2021 1

Excel Summary Stats

Graphs-Charts

Emplyees by Gender

Male Female 0.793010752688172 0.20698924731182797

Employee by education level

HS AA BA/BS Masters+ 4.8387096774193547E-2 0.23387096774193547 0.54569892473118276 0.17204301075268819

Employees by Marital Status

Married Single 0.72043010752688175 0.27956989247311825

Sales Summary

Sa les Summary (Provided) Yr 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 Sales Summary (Provided) Sales 1656871.8930150992 47830244.546799615 84088009.193400696 130427572.07159656 146938882.11983776 139117817.9909192 143547199.3314777 144834874.89356914 149578841.81593996 155740613.19537732 144759828.34312081 156714300.52984941 150201379.20405364 154750828.73739058 158253462.20716339 156494222.6692971 165800497.95999998

No of Employees By Race

# African-Am Asian Caucasian Hispanic TOTAL 1 2 3 4 98 25 216 33 372 % African-Am Asian Caucasian Hispanic TOTAL 1 2 3 4 26.344086021505376 6.7204301075268811 58.064516129032263 8.870967741935484 100

No of Employees per state

# PA IL NE 149 125 98 % PA IL NE 40.05376344086021 6 33.602150537634408 26.344086021505376

Histogram

Histogram

Frequency 20000 30000 40000 50000 60000 70000 80000 90000 100000 110000 120000 130000 140000 150000 160000 170000 180000 190000 200000 More 0 0 3 5 12 40 60 58 43 33 30 16 10 18 25 10 6 2 0 1

Bin

Frequency

Sorted Data