1) What is the difference between the means of employees' length of experience within their organizations and their decisions of staying or leaving their current job?
2) What is the difference between the means of employees' length of experience with their managers and their decisions of staying or leaving their current job?
By using one-way ANOVA, analyze and determine whether there are any significant differences between the means of employees' length of experience (within the organizations and with the managers) in regards to their decisions of staying or leaving their current job. Use only Excel software to analyze this problem. Use graphics to support your answer. Note: The responses are less than 30. It is not big deal if the results are significant or not, the purpose of this questions is to show one-way ANOVA is the best test to analyze this kind of problem. So please include the assumptions of one-way ANOVA in your answer.
| RespondentID |
I have worked at my current organization for |
I have worked with my current manager for |
How often have you seriously considered quitting your present job? |
| 1 |
1 |
4 |
2 |
| 2 |
5 |
1 |
2 |
| 3 |
2 |
3 |
3 |
| 4 |
4 |
1 |
2 |
| 5 |
1 |
1 |
1 |
| 6 |
5 |
4 |
2 |
| 7 |
4 |
1 |
5 |
| 8 |
4 |
4 |
1 |
| 9 |
3 |
4 |
2 |
| 10 |
4 |
2 |
1 |
| 11 |
4 |
3 |
1 |
| 12 |
4 |
5 |
1 |
| 13 |
4 |
2 |
4 |
| 14 |
4 |
5 |
2 |
| 15 |
4 |
5 |
1 |
| 16 |
5 |
4 |
2 |
| 17 |
2 |
3 |
2 |
| 18 |
2 |
3 |
3 |
| 19 |
4 |
1 |
1 |
| 20 |
1 |
1 |
2 |
| 21 |
4 |
5 |
4 |
| 22 |
5 |
2 |
4 |