I've done much research, but it's difficult to get oriented without a specific background in statistics so any help would be appreciated. Since I'm the resident database/metrics/analysis professional I've been tapped to assist in answering some questions that HR leadership has presented. One such question is to try and prove or quantify a correlation between Base Salary, Salary Position in Range, and tenure and turnover.
I have two data sets that are identical except one is for employees who voluntarily left the company and the other is current employees in the same positions. The columns are Tenure (IN Months) / Annual Salary / PIR (As a %)
With some simple SQL I was able to derive some pretty obvious aggregate numbers which are displayed below (all #s are averages):
As you can see, people who leave are (outside of the first 2 tiers) generally paid much lower in their salary range and aren't as tenured. I have just recently begun a foray into R but am unsure as to which models/packages to use for multivariate testing.
The Ask: How can I visualize and/or model a statistical correlation between these variables in such a way I can say with a fair amount of confidence that they are related?
I also have access to pretty much every piece of comp or HR data imaginable so eventually I would then stress test these results against other variables, but to get started this would be amazing.
Does anyone have any pointers on which packages or models I should begin researching which would work best with the format of my data? Or pointers on a better way to arrange or structure the data in tandem with different packages (e.g. combining all data into 1 table with a Termination Flag). I'm not necessarily asking someone to walk me through it step by step, but a starting direction would be extremely helpful. I have already successfully utilized R to do some simple regression testing with ggscatter so I'm capable of using the program, just in some serious need of advice here.