Employee Attrition Variables

Copper Contributor

Have an excel file which indicates which employees have left or are still with the company, along with all their historical work data (job satisfaction, tenure, education, performance, etc.). What kind of analyses or functions should I run that will help find the greatest correlation or factor leading to attrition?

3 Replies

Dear null null,

 

I've updated your attached workbook with some analysis using PivotTables and PivotCharts.

This may help you to analyze and illustrate the data set that you have.

 

I think that your data set needs for deep statistical analysis.

Here some references that may help you:

Load Analysis ToolPak Add-in

Analysis Toolpak Tutorial

Thank you! 

I think you want a regression analysis. Use R. :)