Organizational Research Methods
The report should be professional looking, including charts, tables, and results of statistical tests to answer the questions below. This report should be produced in MSWord and be appropriate for readability by managers. 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.”
Choose only active employees (“Status” = Active), and investigate the following:
1.
a. Create a chart that describes the composition of the workforce by gender for the company as a whole (2 points).
Suggested Techniques: Bar chart, pie chart (summaries for groups of cases)
b. Create a table that describes the composition of the workforce by gender for each department (2 points)
Suggested Techniques: Cross tab with percentages
c. Select the appropriate statistical test, tell me which test it is, and interpret if the differences in gender by department are statistically significant (4 points).
2.
a. Create a chart that describes the composition of the workforce by race for the company as a whole (2 points).
Suggested Techniques: Bar chart, pie chart (summaries for groups of cases)
b. Create a table that describes the composition of the workforce by race for each department (2 points)
Suggested Techniques: Cross tab with percentages
c. Select the appropriate statistical test, tell me which test it is, and interpret if the differences in race by department are statistically significant (4 points).
3.
a. 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 (6 points).
Suggested Techniques: histogram, P-P plot or Q-Q plot, box plot, K-S test,
andz scores for outliers
4.
a. 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) (1 point).
b. 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 (3 points).
c. 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) (4 points)?
d. 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)(4 points)?
5.
a. Create a) a chart and b) a table that reports the average length of service by department (3 points).
Suggested Techniques: a) Bar chart (summaries for groups of cases, using
means by department)
b) means table
b. Select the appropriate statistical test, and tell me if theoverall differences in length of service by department are statistically significant (3 points).
6.
a. For employees with the job title “Production Tech,” create a table that reports the average current salary for men versus women (2 points).
b. Select the appropriate statistical test, and tell me if the differences in average salaries for men versus women are statistically significant (4 points).
For active AND terminated employees (COMPLETE DATASET):
7.
a. 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 (2 points).
Suggested Techniques: Frequencies & pie chart
8.
a. Create a table that describes the turnover rate (“status”) by gender (2 points).
Suggested Techniques: Cross tab with percentages
b. 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 (2 points).
9.
a. Create a table that describes the turnover rate (“status”) by race (2 points).
Suggested Techniques: Cross tab with percentages
b. 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 (2 points).
10.
a. Create a table that describes the turnover rate (“status”) by department (2 points).
Suggested Techniques: Cross tab with percentages
b. Select the appropriate statistical test, tell me which test it is, and interpret if the differences in turnover rate by departmentare statistically significant (2 points).
ORDER THIS ESSAY HERE NOW AND GET A DISCOUNT !!!
