Conduct a hypothesis test at a 5% level of significance to see if the proportion of employees who are no longer active (include all reasons) in the production department (in more than the acceptable 25% level). conduct the test with the help of excel   Admin

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

Conduct a hypothesis test at a 5% level of significance to see if the proportion of employees who are no longer active (include all reasons) in the production department (in more than the acceptable 25% level). conduct the test with the help of excel

  Admin IT/IS Sales Proportion Grand Total
Resigned  33.33% 60.00% 66.67% 90.59% 84.62%
Retired 0.00% 0.00% 0.00% 7.06% 5.77%
Another position 33.33% 20.00% 16.67% 30.59% 28.85%
Relocation 0.00% 0.00% 16.67% 5.88% 5.77%
Maternity (No return) 0.00% 0.00% 16.67% 2.35% 2.88%
Unhappy 0.00% 10.00% 0.00% 16.47% 14.42%
Money 0.00% 0.00% 0.00% 12.94% 10.58%
Hours 0.00% 20.00% 0.00% 7.06% 7.69%
Education 0.00% 0.00% 0.00% 7.06% 5.77%
Medical 0.00% 10.00% 16.67% 1.18% 2.88%
Terminated 66.67% 40.00% 33.33% 9.41% 15.38%
Attendance 33.33% 0.00% 16.67% 4.71% 5.77%
Misconduct 0.00% 0.00% 16.67% 1.18% 1.92%
performance 0.00% 10.00% 0.00% 2.35% 2.88%
Learned he is a gangster 0.00% 10.00% 0.00% 0.00% 0.96%
No-call, No-show 33.33% 20.00% 0.00% 1.18% 3.85%
Grand Total 100.00% 100.00% 100.00% 100.00% 100.00%

 

  Departments        
Employment Status Admin IT/IS Sales Proportion Grand Total
Active 13 45 27 128 213
N/A-StillEmployed 13 45 27 128 213
Resigned 1 6 4 77 88
Retired       6 6
Another position 1 2 1 26 30
Relocation     1 5 6
Maternity (No return)     1 2 3
Unhappy   1   14 15
Money       11 11
Hours   2   6 8
Education       6 6
Medical   1 1 1 3
Terminated 2 4 2 8 16
Attendance 1   1 4 6
Misconduct     1 1 2
performance   1   2 3
Learned he is a gangster   1     1
No-call, No-show 1 2   1 4
Grand Total 16 55 33 213 317
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman