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.

The pie-chart findings suggests that the company is not very diverse in any of the three major categories. Over 80% of the work force is male, over 60% of employees are caucasian, and more than 57% are limited to a high school education. In order to determine if the company was meeting its diversity goal, I would need to better understand what its expectations were in each category. For example, if there was an expectation that there would be 60% males in the workforce and 40% females, then I could measure the expectations versus the reality to determine if we failed to meet expecations and if so by how much. 

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.

The mode of the job title distributions is 1 as it occurs 8 times. Each of these positions are management positions. These findings indicate that a very small percentage of the total # of employees of this company (2%) are in management positions. 

Final essay:

Now that you have done all the work with data, 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!

a. Write a one-paragraph narrative summary of your findings, describing patterns of


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 responses in this workbook. Once you have entered your answers here, move the tab to the first tab position.

The Workforce Profile Analysis takes data for three hundred seventy-two employees of Company X and analyzes it to determine if any significant patterns exist.  Descriptive data Is utilized to evaluate the following: company makeup (i.e. sex, race, marital status), employee education level, years of service, region of the country and salary distribution. Sales history was also analyzed for the purpose of making future sales projections. The findings show that the company is primarily made up of single, high-school educated Caucasian males from the northeast region of the country. Less than three percent of employees are in management positions and more than half of the workforce (53%) works in non-skilled labor positions (general shop and machinery). Based on education level and years of experience, the average salary at the company is roughly $53,115 per year, with the majority of the company making between $30,000 and $70,000 per year. The company’s sales history has been relatively good overall and thus sales are projected to continue to grow in future years. 

Of all of the patterns identified in this analysis, those pertaining to gender, race, and education level are most relevant as they speak directly to the company’s goals of wanting a diverse and dynamic workforce. It does not appear that the company is meeting its diversity goals as the results of the analysis reveal that females are severely underrepresented as a percentage of the population at just 19%. Furthermore, Hispanics and Asians collectively make-up 13% of the total population. With Caucasian males making up more than 60% of the workforce, and less than 3% of the workforce being in management positions, it is highly unlikely that Hispanic or Asian females will be in positions of authority within this company. 

In order to determine if the results of this analysis are good or bad, it may be necessary to survey those in supervisory, middle and upper management positions to determine if similar patterns exist in this smaller group. I would survey everyone in supervisory, management, and executive level positions to better understand their race, gender, and educational background. Based on the results of that analysis, it would either prove or disprove whether or not the company had similar diversity issue in upper management as it does on the working level. If it was discovered that diversity issues were present in upper management as well, the recommendation would be made to recruit females from various racial and ethnic backgrounds to balance out the current disparity.