Hypothesis Testingand to be answeredusing Microsoft Excel.

This is the given

The HR department of ABC Manufacturing Industry studied the Job Performance and Job satisfaction of 120 employees. The information such as gender and job status were collected. Given below are the hypotheses of the study 1. There is no significant difference among the level of job satisfaction of the employees when they are grouped according to 1.1 gender 1.2 job status 2. There is no significant difference among the level of job performance of the employees when they are grouped according to 1.1 gender 1.2 job status WHAT TO DO? 1. Perform hypothesis testing using the following steps 1. State the null and alternative hypotheses 2. State the level of significance and identify the test statistic 3. Show Computation and Solution (Excel Solution must be included) 4. Decision and ConclusionA B C D E F Gender Job Status Educational Attainment Length of Service Job Satisfaction Job Performance 2 Male Outsourced with MA units 16-23 years 2.59 3 3 Male Outsourced BS/AB 8-15 years 2.64 2.27 4 Male Outsourced with MA units 24-31 years 2.91 3.09 5 Male Outsourced BS/AB 24-31 years 2.91 2.73 6 Male Outsourced with MA units 8-15 years 3.18 3.18 7 Female Regular BS/AB 8-15 years 4.18 4 Female Regular with MA units 8-15 years 4.18 3.55 9 Female Regular BS/AB 7 and below 4.18 3.82 10 Female Regular with MA units 7 and below 4.23 3.55 11 Female Outsourced MA graduate 16-23 years 4.23 4 12 Male Outsourced MA graduate 16-23 years 3.23 3.18 13 Male Outsourced with MA units 8-15 years 3.27 3.09 14 Male Outsourced MA graduate 24-31 years 3.32 3.55 15 Male Outsourced with MA units 8-15 years 3.36 3.09 16 Male Outsourced BS/AB 7 and below 3.41 3 17 Male Outsourced with MA units 8-15 years 3.5 3 18 Male Outsourced with MA units 7 and below 4 3.91 19 Male Regular with MA units 24-31 years 4.05 3.82 20 Male Regular with MA units 16-23 years 4.05 4.73 21 Male Outsourced with MA units 24-31 years 4.05 3.36 22 Male Outsourced BS/AB 7 and below 4.23 3.91 23 Male Regular with MA units 7 and below 4.27 3.91 24 Female Regular MA graduate 24-31 years 4.09 4 25 Female Regular with MA units 16-23 years 4.09 3 26 Male Outsourced BS/AB 16-23 years 3.59 3.18 27 Male Outsourced BS/AB 7 and below 3.64 3.45 28 Male Regular MA graduate 8-15 years 3.86 4 29 Male Outsourced MA graduate 24-31 years 4 4.2730 Female Outsourced with MA units 7 and below 4.09 4.09 31 Female Outsourced BS/AB 7 and below 4.09 3.36 32 Female Regular B5/AB 16-23 years 4.09 4.09 33 Male Outsourced with MA units 7 and below 4.36 3.91 34 Male Regular with MA units 8-15 years 4.36 3.55 35 Male Regular with MA units 8-15 years 4.41 3.55 36 Male Outsourced MA graduate 24-31 years 4.41 4 37 Female Outsourced BS/AB 7 and below 4.09 3.91 38 Female Outsourced BS/AB 7 and below 4.09 3.27 39 Female Regular BS/AB 7 and below 4.09 3.64 40 Male Outsourced MA graduate 7 and below 4.27 3.09 41 Male Regular MA graduate 16-23 years 4.32 4.09 42 Male Outsourced MA graduate 7 and below 4.32 4.45 43 Male Regular with MA units 16-23 years 4.45 3.82 44 Male Regular with MA units 7 and below 4.45 3.73 45 Male Outsourced BS/AB 8-15 years 4.45 3.73 46 Male Regular BS/AB 7 and below 4.5 4 47 Male Regular MA graduate 16-23 years 4.55 4.36 48 Male Regular MA graduate 16-23 years 4.55 4.36 49 Female Outsourced BS/AB 16-23 years 4.5 4.18 50 Female Regular MA graduate 24-31 years 4.55 4 51 Female Regular MA graduate 24-31 years 4.59 4.55 52 Female Outsourced MA graduate 24-31 years 4.59 4.18 53 Male Regular with MA units 8-15 years 4.68 4.36 54 Male Outsourced BS/AB 7 and below 4.68 4.36 55 Male Regular BS/AB 8-15 years 4.73 3.09 56 Female Outsourced with MA units 16-23 years 4.68 4.45 57 Female Outsourced MA graduate 24-31 years 4.68 4.73 58 Female Regular BS/AB 24-31 years 4.73 4.09 59 Female Outsourced MA graduate 16-23 years 4.77 3.7360 Male Outsourced MA graduate 7 and below 4.68 4.36 61 Male Regular with MA units 16-23 years 4.77 4.91 62 Male Outsourced BS/AB 7 and below 4.77 4.27 63 Male Regular with MA units 8-15 years 4.82 3.82 64 Female Regular with MA units 8-15 years 3.64 3.18 65 Female Regular MA graduate 16-23 years 3.64 3.64 66 Male Regular with MA units 8-15 years 3.91 4.18 67 Male Regular MA graduate 16-23 years 3.95 4.18 68 Male Regular with MA units 16-23 years 4 4 69 Female Outsourced BS/AB 8-15 years 3.68 3.36 70 Female Regular BS/AB 8-15 years 3.86 3.27 71 Female Outsourced MA graduate 24-31 years 3.86 3.36 72 Female Regular MA graduate 16-23 years 3.91 3.64 73 Female Regular MA graduate 16-23 years 3.91 3.64 74 Female Outsourced MA graduate 24-31 years 3.95 3.82 75 Female Outsourced MA graduate 24-31 years 4.05 4 76 Female Outsourced MA graduate 24-31 years 4.09 3.45 77 Female Regular with MA units 24-31 years 4.86 4.27 78 Female Regular MA graduate 24-31 years 4.95 4.36 79 Male Regular MA graduate 24-31 years 4.55 2.64 80 Male Outsourced BS/AB 7 and below 4.59 4.45 81 Female Outsourced with MA units 8-15 years 4.14 4 82 Female Regular MA graduate 24-31 years 4.14 3.91 83 Female Regular with MA units 16-23 years 4.14 3.73 84 Female Regular MA graduate 16-23 years 4.14 3.64 85 Female Outsourced BS/AB 7 and below 4.18 3.82 86 Female Regular with MA units 16-23 years 4.18 4.27 87 Female Outsourced BS/AB 7 and below 4.18 3.82 88 Female Regular with MA units 16-23 years 4.18 4.45 89 Female Outsourced with MA units 8-15 years 4.18 4.8290 Male Regular MA graduate 24-31 years 4.64 4.45 91 Male Regular BS/AB 7 and below 4.64 4.36 92 Male Outsourced with MA units 16-23 years 4.64 3.91 93 Male Outsourced BS/AB 7 and below 4 64 4.09 94 Female Regular MA graduate 24-31 years 4.18 3.27 95 Female Regular BS/AB 7 and below 4.18 3.73 96 Female Outsourced BS/AB 7 and below 4.18 3.82 97 Male Regular with MA units 8-15 years 3.68 3.45 98 Male Outsourced MA graduate 16-23 years 3.73 3.82 99 Male Outsourced BS/AB 7 and below 3.77 3.64 100 Male Regular BS/AB 8-15 years 3.82 4.55 101 Male Outsourced BS/AB 8-15 years 3.82 3.09 102 Male Outsourced BS/AB 8-15 years 3.82 3.09 103 Male Outsourced BS/AB 7 and below 3.82 3 104 Male Outsourced BS/AB 7 and below 3.82 2.91 105 Male Regular BS/AB 8-15 years 3.82 3.45 106 Male Regular MA graduate 16-23 years 3.86 3.55 107 Female Outsourced BS/AB 8-15 years 4.23 4.09 108 Female Outsourced BS/AB 8-15 years 4.23 3.27 109 Female Outsourced with MA units 8-15 years 4.23 3.73 110 Female Regular BS/AB 8-15 years 4.23 3.55 111 Female Regular B5/AB 8-15 years 4.23 3.36 112 Female Regular MA graduate 16-23 years 4.27 4.09 113 Female Outsourced with MA units 16-23 years 4.32 3.73 114 Female Regular MA graduate 24-31 years 4.32 4.73 115 Female Outsourced MA graduate 16-23 years 4.36 4.55 116 Female Regular MA graduate 24-31 years 4.41 3.55 117 Female Outsourced with MA units 24-31 years 4.95 118 Female Regular with MA units 24-31 years 4.95 4.73119 Female Regular with MA units 24-31 years 4.95 4.82 120 Female Regular MA graduate 24-31 years in 5 121 Female Regular MA graduate 24-31 years 5 5