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
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
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
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
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman