In: Statistics and Probability
A few months ago, the upper management at a large corporation decided they wanted to make major changes in the organization. Leadership is concerned that employees may be resistant to the change, and they want to find out if there is a change management method that would help employees accept change more effectively and keep employee satisfaction high. Two methods they have considered are the ADKAR Framework and the Prosci Change Management Methodology. The company wants to implement a small change in two departments before they make any major organization changes and would like to test the methods. The corporation uses the Devine Company to measure employee satisfaction with an anonymous survey.
Make a recommendation based on the findings
Analyze the data from Part 1 using Microsoft® Excel® software.
Group 1 | Group 2 |
1.3 | 6.5 |
2.5 | 8.7 |
2.3 | 9.8 |
8.1 | 10.2 |
5 | 7.9 |
7 | 6.5 |
7.5 | 8.7 |
5.2 | 7.9 |
4.4 | 8.7 |
7.6 | 9.1 |
9 | 8.4 |
7.6 | 6.4 |
4.5 | 7.2 |
1.1 | 5.8 |
5.6 | 6.9 |
6.2 | 5.9 |
7 | 7.6 |
6.9 | 7.8 |
5.6 | 7.3 |
5.2 | 4.6 |
9 | 8.4 |
7.6 | 6.4 |
4.5 | 7.2 |
1.1 | 5.8 |
5.6 | 6.9 |
6.2 | 5.9 |
7 | 7.6 |
6.9 | 7.8 |
5.6 | 7.3 |
5.2 | 4.6 |
Example of Output You Would Use to Answer These Questions
t Test: Two-Sample Assuming Equal Variances |
||
Variable 1 |
Variable 2 |
|
Mean |
4.875 |
8 |
Variance |
5.267857143 |
18.28571429 |
Observations |
8 |
8 |
Pooled variance |
11.77678571 |
|
Hypothesized mean difference |
0 |
|
df |
14 |
|
t stat |
-1.821237697 |
|
P(T <= t) one-tail |
0.045002328 |
|
t Critical one-tail |
1.761310136 |
|
P(T <= t) two-tail |
0.090004655 |
|
t Critical two-tail |
2.144786688 |
THANK YOU!!!!
The significance level is 0.05.
Note: Please provide alpha from Week 3 to answer the second question
The means and variance for each variable are:
ADKAR Frame work: mean = 4.875 variance = 5.267857143
Prosci Change Management Methodology: mean = 8 variance = 18.28571429
The test statistic is -1.821237697
The critical value for the one-tailed test is 1.761310136
The critical value for the two-tailed test is 2.144786688
Our test was two-tailed.
We are able to reject the null hypothesis for the one-tailed test not for a two-tailed test because the absolute value of the test statistic is less than the critical value for the one-tailed test but not less than the critical value for a two-tailed test. Hence, there was a difference in a one-sided test.
It can be concluded that both methods help employees accept change more effectively and keep employee satisfaction at a similar level.
If you have more questions you can send them to us and we will try our best to help you out.
Good luck with your studies!!!