Home

Employee Attrition Variables

%3CLINGO-SUB%20id%3D%22lingo-sub-139120%22%20slang%3D%22en-US%22%3EEmployee%20Attrition%20Variables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-139120%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHave%20an%20excel%20file%20which%20indicates%20which%20employees%20have%20left%20or%20are%20still%20with%20the%20company%2C%20along%20with%20all%20their%20historical%20work%20data%20(job%20satisfaction%2C%20tenure%2C%20education%2C%20performance%2C%20etc.).%20What%20kind%20of%20analyses%20or%20functions%20should%20I%20run%20that%20will%20help%20find%20the%20greatest%20correlation%20or%20factor%20leading%20to%20attrition%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-139120%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETutorial%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-139838%22%20slang%3D%22en-US%22%3ERe%3A%20Employee%20Attrition%20Variables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-139838%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-139302%22%20slang%3D%22en-US%22%3ERe%3A%20Employee%20Attrition%20Variables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-139302%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20null%20null%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI've%20updated%20your%20attached%20workbook%20with%20some%20analysis%20using%20PivotTables%20and%20PivotCharts.%3C%2FP%3E%0A%3CP%3EThis%20may%20help%20you%20to%20analyze%20and%20illustrate%20the%20data%20set%20that%20you%20have.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20think%20that%20your%20data%20set%20needs%20for%20deep%20statistical%20analysis.%3C%2FP%3E%0A%3CP%3EHere%20some%20references%20that%20may%20help%20you%3A%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FLoad-the-Analysis-ToolPak-in-Excel-6a63e598-cd6d-42e3-9317-6b40ba1a66b4%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3ELoad%20Analysis%20ToolPak%20Add-in%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fwww.excel-easy.com%2Fdata-analysis%2Fanalysis-toolpak.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAnalysis%20Toolpak%20Tutorial%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
null null
New 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?

2 Replies
Highlighted

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! 

Related Conversations
Creating tabs on split form.
User2428 in Access on
1 Replies
Statistical models in Excel
David Liu in Excel on
1 Replies