Question: Assignment: Project Analysis (Hypothesis Testing Using R) Given: Research questions: What are the factors for high employee turnover rate in a particular retail company? Hypothesis:
Assignment: Project Analysis (Hypothesis Testing Using R)
Given: Research questions:
What are the factors for high employee turnover rate in a particular retail company?
Hypothesis:
Hypothesis 1: Job satisfaction (JS) has a negative impact on employee turnover in retail companies.
Hypothesis 2: Career management (CM) has a negative impact on employee turnover in retail companies.
Hypothesis 3: Work-life balance (WB)has a negative impact on employee turnover in retail companies.
Data were collected from 40 Participants and the full data is attached below.
Question: By looking at the variables in Employee turnover dataset, (applying bivariate and multivariate statistical methods using business data ); Conduct a significance test in R for the above three hypotheses at a confidence interval of 90%. For each test, discuss and summarize in detail: A. Accept the hypothesis? B. Summarize the whole process of the analysis for each hypothesis.
Employee turnover dataset data
| Satisfaction Survey Data | |||||||||
| Participants | Gender | Age | Educational Level | Work status | JS-1 | JS-2 | WLB-1 | WLB-2 | CM |
| D6526 | Female | 20 - 30 | High school diploma | Part-time | 75 | 25 | 25 | 75 | 25 |
| D6528 | Female | 31 - 40 | Associate Degree | Full time | 75 | 25 | 25 | 25 | 25 |
| D6325 | Female | 31 - 40 | Associate Degree | Full time | 75 | 25 | 75 | 75 | 25 |
| D5256 | Male | 31 - 40 | Associate Degree | Full time | 75 | 75 | 50 | 25 | 75 |
| D5897 | Male | 20 - 30 | Associate Degree | Part-time | 75 | 75 | 0 | 75 | 25 |
| D7859 | Female | 20 - 30 | High school diploma | Part-time | 50 | 75 | 75 | 75 | 100 |
| D6115 | Female | 20 - 30 | Associate Degree | Part-time | 25 | 0 | 50 | 75 | 0 |
| D7425 | Male | 20 - 30 | Associate Degree | Full time | 50 | 75 | 25 | 25 | 75 |
| D5522 | Female | 20 - 30 | Associate Degree | Full time | 50 | 50 | 25 | 25 | 75 |
| D7777 | Female | 20 - 30 | High school diploma | Part-time | 75 | 25 | 25 | 75 | 50 |
| D6487 | Female | 20 - 30 | High school diploma | Part-time | 25 | 50 | 25 | 25 | 50 |
| D5145 | Female | 41 - 50 | Associate Degree | Full time | 75 | 25 | 75 | 25 | 50 |
| D7955 | Female | 20 - 30 | High school diploma | Part-time | 50 | 75 | 0 | 75 | 75 |
| D8452 | Female | 20 - 30 | High school diploma | Part-time | 25 | 75 | 50 | 75 | 75 |
| D8422 | Female | 20 - 30 | Associate Degree | Part-time | 25 | 25 | 75 | 75 | 25 |
| D7112 | Female | 20 - 30 | Associate Degree | Full time | 25 | 0 | 25 | 75 | 25 |
| D6666 | Female | 20 - 30 | Associate Degree | Full time | 75 | 25 | 25 | 25 | 25 |
| D5802 | Female | 20 - 30 | Associate Degree | Full time | 50 | 75 | 25 | 25 | 75 |
| D7410 | Male | 20 - 30 | Associate Degree | Part-time | 75 | 25 | 75 | 75 | 25 |
| D8223 | Male | 20 - 30 | High school diploma | Part-time | 25 | 25 | 25 | 75 | 100 |
| D7020 | Male | 20 - 30 | Associate Degree | Part-time | 75 | 75 | 25 | 75 | 0 |
| D7039 | Female | 20 - 30 | Associate Degree | Part-time | 25 | 50 | 25 | 75 | 25 |
| D8912 | Male | 20 - 30 | Associate Degree | Full time | 25 | 25 | 25 | 25 | 100 |
| D6099 | Male | 20 - 30 | Associate Degree | Full time | 25 | 25 | 50 | 75 | 75 |
| D5380 | Male | 31 - 40 | Associate Degree | Part-time | 25 | 100 | 0 | 75 | 75 |
| D8050 | Female | 20 - 30 | High school diploma | Part-time | 25 | 25 | 25 | 25 | 0 |
| D7621 | Female | 20 - 30 | High school diploma | Part-time | 25 | 0 | 75 | 75 | 100 |
| D5000 | Female | 20 - 30 | High school diploma | Part-time | 25 | 25 | 25 | 75 | 0 |
| D8000 | Female | 20 - 30 | Associate Degree | Part-time | 25 | 25 | 0 | 75 | 0 |
| D8010 | Male | 20 - 30 | Associate Degree | Full time | 25 | 75 | 25 | 25 | 0 |
| D8012 | Male | 20 - 30 | Associate Degree | Full time | 25 | 25 | 75 | 75 | 25 |
| D8015 | Male | 20 - 30 | High school diploma | Part-time | 25 | 0 | 25 | 75 | 0 |
| D8018 | Female | 20 - 30 | High school diploma | Part-time | 25 | 25 | 50 | 25 | 50 |
| D7625 | Female | 20 - 30 | Associate Degree | Part-time | 25 | 75 | 75 | 75 | 25 |
| D7627 | Male | 31 - 40 | Associate Degree | Part-time | 25 | 100 | 75 | 25 | 25 |
| D7629 | Female | 20 - 30 | Associate Degree | Full time | 25 | 25 | 25 | 25 | 75 |
| D6222 | Female | 20 - 30 | Associate Degree | Full time | 25 | 75 | 25 | 75 | 75 |
| D6224 | Male | 20 - 30 | Associate Degree | Full time | 75 | 0 | 75 | 75 | 25 |
| D6226 | Male | 20 - 30 | High school diploma | Part-time | 75 | 75 | 25 | 25 | 25 |
| D6228 | Male | 20 - 30 | Associate Degree | Full time | 75 | 100 | 0 | 25 | 25 |
| Satisfaction Survey Data | |||||||||
| Participants | Gender | Age | Educational Level | Work status | I am given the resources to do my job | The Compensation provided by the company is fair. | I feel that I have a good work-life balance. | I experience high levels of job stress. | The training and development opportunities provided by the company are satisfactory. |
| D6526 | Female | 20 - 30 | High school diploma | Part-time | Agree | Disagree | Disagree | Agree | Disagree |
| D6528 | Female | 31 - 40 | Associate Degree | Full time | Agree | Disagree | Disagree | Disagree | Disagree |
| D6325 | Female | 31 - 40 | Associate Degree | Full time | Agree | Disagree | Agree | Agree | Disagree |
| D5256 | Male | 31 - 40 | Associate Degree | Full time | Agree | agree | Neutral | Disagree | Agree |
| D5897 | Male | 20 - 30 | Associate Degree | Part-time | Agree | agree | Agree | Disagree | |
| D7859 | Female | 20 - 30 | High school diploma | Part-time | Neutral | agree | Agree | Agree | Strongly agree |
| D6115 | Female | 20 - 30 | Associate Degree | Part-time | Disagree | Strongly disagree | Neutral | Agree | Strongly disagree |
| D7425 | Male | 20 - 30 | Associate Degree | Full time | Neutral | agree | Disagree | Disagree | Agree |
| D5522 | Female | 20 - 30 | Associate Degree | Full time | Neutral | Neutral | Disagree | Disagree | Agree |
| D7777 | Female | 20 - 30 | High school diploma | Part-time | Agree | Disagree | Disagree | Agree | Neutral |
| D6487 | Female | 20 - 30 | High school diploma | Part-time | Disagree | Neutral | Disagree | Disagree | Neutral |
| D5145 | Female | 41 - 50 | Associate Degree | Full time | Agree | Disagree | Agree | Disagree | Neutral |
| D7955 | Female | 20 - 30 | High school diploma | Part-time | Neutral | agree | Agree | Agree | |
| D8452 | Female | 20 - 30 | High school diploma | Part-time | Disagree | agree | Neutral | Agree | Agree |
| D8422 | Female | 20 - 30 | Associate Degree | Part-time | Disagree | Disagree | Agree | Agree | Disagree |
| D7112 | Female | 20 - 30 | Associate Degree | Full time | Disagree | Strongly disagree | Disagree | Agree | Disagree |
| D6666 | Female | 20 - 30 | Associate Degree | Full time | Agree | Disagree | Disagree | Disagree | Disagree |
| D5802 | Female | 20 - 30 | Associate Degree | Full time | Neutral | agree | Disagree | Disagree | Agree |
| D7410 | Male | 20 - 30 | Associate Degree | Part-time | Agree | Disagree | Agree | Agree | Disagree |
| D8223 | Male | 20 - 30 | High school diploma | Part-time | Disagree | Disagree | Disagree | Agree | Strongly agree |
| D7020 | Male | 20 - 30 | Associate Degree | Part-time | Agree | agree | Disagree | Agree | Strongly disagree |
| D7039 | Female | 20 - 30 | Associate Degree | Part-time | Disagree | Neutral | Disagree | Agree | Disagree |
| D8912 | Male | 20 - 30 | Associate Degree | Full time | Disagree | Disagree | Disagree | Disagree | Strongly agree |
| D6099 | Male | 20 - 30 | Associate Degree | Full time | Disagree | Disagree | Neutral | Agree | Agree |
| D5380 | Male | 31 - 40 | Associate Degree | Part-time | Disagree | Strongly agree | Strongly disagree | Agree | Agree |
| D8050 | Female | 20 - 30 | High school diploma | Part-time | Disagree | Disagree | Disagree | Disagree | Strongly disagree |
| D7621 | Female | 20 - 30 | High school diploma | Part-time | Disagree | Strongly disagree | Agree | Agree | Strongly agree |
| D5000 | Female | 20 - 30 | High school diploma | Part-time | Disagree | Disagree | Disagree | Agree | Strongly disagree |
| D8000 | Female | 20 - 30 | Associate Degree | Part-time | Disagree | Disagree | Strongly disagree | Agree | Strongly disagree |
| D8010 | Male | 20 - 30 | Associate Degree | Full time | Disagree | agree | Disagree | Disagree | Strongly disagree |
| D8012 | Male | 20 - 30 | Associate Degree | Full time | Disagree | Disagree | Agree | Agree | Disagree |
| D8015 | Male | 20 - 30 | High school diploma | Part-time | Disagree | Strongly disagree | Disagree | Agree | Strongly disagree |
| D8018 | Female | 20 - 30 | High school diploma | Part-time | Disagree | Disagree | Neutral | Disagree | Neutral |
| D7625 | Female | 20 - 30 | Associate Degree | Part-time | Disagree | agree | Agree | Agree | Disagree |
| D7627 | Male | 31 - 40 | Associate Degree | Part-time | Disagree | Strongly agree | Agree | Disagree | Disagree |
| D7629 | Female | 20 - 30 | Associate Degree | Full time | Disagree | Disagree | Disagree | Disagree | Agree |
| D6222 | Female | 20 - 30 | Associate Degree | Full time | Disagree | agree | Disagree | Agree | Agree |
| D6224 | Male | 20 - 30 | Associate Degree | Full time | Agree | Strongly disagree | Agree | Agree | Disagree |
| D6226 | Male | 20 - 30 | High school diploma | Part-time | Agree | agree | Disagree | Disagree | Disagree |
| D6228 | Male | 20 - 30 | Associate Degree | Full time | Agree | Strongly agree | Strongly disagree | Disagree | Disagree |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
