Forum Discussion

null null's avatar
null null
Copper Contributor
Dec 21, 2017

Employee Attrition Variables

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?

BI & Data Analytics
Tutorial

3 Replies

  • jmaxweUW's avatar
    jmaxweUW
    Copper Contributor
    May 28, 2020
    I think you want a regression analysis. Use R. 🙂
  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Dec 21, 2017

    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:

    https://support.office.com/en-us/article/Load-the-Analysis-ToolPak-in-Excel-6a63e598-cd6d-42e3-9317-6b40ba1a66b4

    http://www.excel-easy.com/data-analysis/analysis-toolpak.html

Resources