Reference no: EM133891226
Assignment
Background:
A mid-sized technology company wants to analyze the factors influencing employee productivity. They have collected data on various variables related to their employees' work environment and performance. The company aims to understand which factors are most impactful on productivity and how they can improve it.
Objective:
Students are required to perform a multiple regression analysis to determine the relationship between employee productivity and several independent variables. Initially, they will run the regression analysis without considering the number of projects handled, monthly working hours, and the log-transformed monthly working hours.
Variables in the Dataset:
A. Employee Productivity (dependent variable): Average number of tasks completed per month. This is the target variable the company wants to understand and predict.
B. Training Hours: Number of hours an employee has spent in training. This variable captures the level of training employees have received, which is hypothesized to positively influence productivity.
C. Work Experience: Number of years an employee has worked. This variable reflects the experience level of employees, which is expected to correlate positively with productivity.
D. Employee Engagement: Average engagement score of the employee, rated on a scale from 1 to 10. Higher engagement is believed to result in higher productivity.
E. Remote Work (dummy variable): Indicates whether the employee works remotely (1 if remote, 0 if on-site). This variable helps to understand the impact of working location on productivity.
F. Monthly Working Hours: Total number of hours worked per month. This variable will initially be excluded from the regression analysis but is crucial for understanding the overall workload of the employees.
Construction of Correlation Matrix and Interpretation:
Use Excel to create a correlation matrix that displays the correlation coefficients between the variables in the dataset.
The matrix should include the following variables:
1. Employee Productivity
2. Training Hours
3. Work Experience
4. Employee Engagement
5. Remote Work
6. Monthly Working Hours
Analyze the correlation coefficients to understand the strength and direction of the relationships between variables. Highlight any strong correlations that could indicate multicollinearity issues, where two or more variables are highly correlated with each other, potentially affecting the regression analysis. Get the instant assignment help.
Initial Regression Analysis:
Use Excel to develop a multiple regression model with "Employee Productivity" as the dependent variable and the following independent variables: Training Hours, Work Experience, Employee Engagement, and Remote Work. Do not include the "Projects Handled" and "Monthly Working Hours" variables in this model. After running the regression analysis, interpret the coefficients to understand the relationship between each predictor and employee productivity. Focus on the p-values to determine which variables are statistically significant, indicating a reliable effect on productivity. Review the R-squared value to assess the model's explanatory power.
Second Regression Analysis:
Use Excel to develop a multiple regression model with "Employee Productivity" as the dependent variable and all the independent variables: Training Hours, Work Experience, Employee Engagement, Remote Work, Projects Handled, and Monthly Working Hours. After running the regression analysis, interpret the coefficients to understand the relationship between each predictor and employee productivity. Focus on the p-values to determine which variables are statistically significant, indicating a reliable effect on productivity. Review the R-squared value to assess the model's explanatory power.
Third Regression Analysis:
Use Excel to develop a multiple regression model with "Employee Productivity" as the dependent variable and all the independent variables, including the log-transformed monthly working hours. Include the following independent variables: Training Hours, Work Experience, Employee Engagement, Remote Work, Projects Handled, and Log(Monthly Working Hours). After running the regression analysis, interpret the coefficients to understand the relationship between each predictor and employee productivity. Focus on the p-values to determine which variables are statistically significant, indicating a reliable effect on productivity. Review the R-squared value to assess the model's explanatory power. Transform the "Monthly Working Hours" variable into its log form before running the regression.
Model Selection Based on Adjusted R-Squared:
After developing the multiple regression models, compare the models based on their adjusted R-squared values. Select the model with the highest adjusted R-squared value as the best-fitting model. Justify your choice and discuss how this model provides the best balance between explanatory power and simplicity.
Predicting Employee Productivity Using Significant Independent Variables:
Based on the selected model in the previous question, generate predictions for employee productivity based on given data points for the significant variables. Based on the final model, provide recommendations on which factors the company should focus on to optimize its employee productivity. Discuss any potential strategies the company could implement to leverage these significant factors effectively.