How does your team support XYZ’s mission statement, which encourages a diverse work environment?

XYZ Company is a medium-sized manufacturing company in southern California. XYZ is developing a new product to stay competitive in their industry. Employees at XYZ were encouraged to submit interest to be part of a new product design team. The human resources department has compiled the files for 12 candidates for consideration.

Imagine you are a manager for XYZ and are selecting members who submitted their interest to be a part of a new product design team. With this product, XYZ is attempting to break into an international market. A diverse team is desirable, because senior management has requested that the team members come from various departments.

Review the Diversity and Statistics multimedia presentation.

Analyze the data in the presentation regarding the candidates.

Choose five candidates from the presentation to assemble your team. Your team must consist of at least one Sales Representative, one Information Technology Specialist, and one Customer Service Representative. The other two team members can come from any department.

Complete the statistical comparison Microsoft Excel worksheet.

Justify your selections using the worksheet to compare members of the Sales and IT departments

Write a report of your recommendations interpreting information in the employee files from the presentation. Include the following in your report:
How does your team support XYZ’s mission statement, which encourages a diverse work environment?
What selection criteria did you use?
What role did performance reviews play in your decision?
How did the analysis of the customer service and sales data influence your choices?
Did you consider standard deviation in your selection process? If so, how did it influence your decision?
What criteria will you use to evaluate the team’s success?
What challenges might your team experience?
Include a table or graph displaying the statistical computations and comparisons you calculated.
Include a narrative of how your computations and comparisons support your selections.