Custom Carpentry Inc. – Data Analytics Assignment Help

Assignment Task

Your objective is to develop a detailed report of employee salary and turnover for your CEO, the President of Custom Carpentry Inc. using the dataset: CUSTOM_CARPENTRY.SAV
The report should be professional looking, including charts, tables, and results of statistical tests to answer the questions below. Each graph, table, or statistical test needs to be formatted appropriately, professional presented, and explained in plain terms for managerial decision making. For all tests, use a p <.05 as “statistically significant.” You will submit the report and a syntax file for your work.
Choose only active employees (Status = “Active”), and investigate the following:
Create a chart that best describes the composition of the workforce by gender for the company as a whole.
Create a table that best describes the composition of the workforce by gender for each department.
Suggested Techniques: Cross tab with percentages
Select the appropriate statistical test, tell me which test it is, and interpret if the differences in gender by department are statistically significant.
Create a chart that best describes the composition of the workforce by race for the company as a whole.
Create a table that best describes the composition of the workforce by race for each department.
Select the appropriate statistical test, tell me which test it is, and interpret if the differences in race by department are statistically significant.
Determine if a) length of service and b) current salary are normally distributed. If they contain outliers, identify the outliers (by last name) but leave them in for all subsequent analyses.
Suggested Techniques: histogram, P-P plot, box plot, and z scores for outliers
Provide a scatterplot of the relationship between length of service and current salary for non-exempt employees (hint: filter cases for “status” = active AND “FLSA” = non-exempt).
For only non-exempt employees (i.e., don’t compare to exempt employees), select the appropriate statistical test and tell me if length of service and current salary are significantly related.
Report the group means, select the appropriate statistical test, and determine if starting salary and current salary are significantly different from one another for non-exempt employees with less than 2 years of service (i.e., only examine non-exempt employees with less than 2 years of service)?
Report the group means, select the appropriate statistical test, and determine if starting salary and current salary are significantly different from one another for non-exempt employees with less than 5 years of service (i.e., only examine non-exempt employees with less than 5 years of service)?
Create a) a chart and b) a table that reports the average length of service by department.

Suggested Techniques:

a) Bar chart (summaries for groups of cases, using means by department)
b) means table
Select the appropriate statistical test, and tell me if the overall differences in length of service by department are statistically significant.
For employees with the job title “Production Tech,” create a table that reports the average current salary for men versus women.
Select the appropriate statistical test, and tell me if the differences in average salaries for men versus women are statistically significant.
For active AND terminated employees (COMPLETE DATASET):
What was the overall turnover rate for Custom Carpentry? In other words, a) what percent of total employees terminated versus are still active (i.e., frequencies for “status” variable) for the company? Then, b) create a pie chart that describes this turnover rate.
Suggested Techniques: Frequencies & pie chart
Create a table that describes the turnover rate (“status”) by gender.
Suggested Techniques: Cross tab with percentages
Select the appropriate statistical test, tell me which test it is, and interpret if the differences in turnover rate by gender (men versus women) are statistically significant.
Create a table that describes the turnover rate (“status”) by race.
Select the appropriate statistical test, tell me which test it is, and interpret if the differences in turnover rate by race are statistically significant.
Create a table that describes the turnover rate (“status”) by department.
Select the appropriate statistical test, tell me which test it is, and interpret if the differences in turnover rate by department are statistically significant.
Choose only terminated employees (Status = “Terminated”), and investigate the following:
Create a table that describes the turnover reason (“status”) by department.
Interpret the reasons for turnover by department in a paragraph. Which departments do you see turnover issues that need to be addressed?