Using the data range C13:J113 from the Emp_Satisfaction_Survey sheet, insert a pivot table on the ANALYSIS Sheet to count the number of employees from each department that took the survey. (Note: Use Dept ID in ROWS section of the pivot field area). Rename the column headings appropriately (i.e. survey headcount).
In the column next to the count of employees type the total headcount for each
department. See the table above. Label this column as "Org Headcount".
What percent of the employees were chosen to participate in the survey? is this percentage a good representation of the organization.
Does the number of employees chosen from each department to
take a survey, a good sample representation of the department?
12 JX A B C D E F G H I J K 1 RATING 2 * Questions 5 3 3 Q1 How meaningful is your work? (Meaningful Work) Extremely Meaningful Very Meaningful Moderately Meaningful Slightly Meaningful Not at all meaningful 4 Q2 How challenging is your job? (Challenging Work) Extremely Challenging Very Challenging Moderately Challenging Slightly Challenging Not at all challening 5 Q3 In a typical week, how often do you feel stressed at work? (Job Stress) Extemely Often Very Often Moderately Often Slightly Often Not at all stressed 6 04 How well are you paid for the work you do? (Pay) Extremely Well Very Well Moderately Well Slightly Well Not at all well Q5 How realistic are the expectations of your supervisor? (Realistic Expectation) Extremely Realistic Very Realistic Moderately Realistic Slightly Realistic Not at all realistic 8 Q6 How satisfied are you with your job? (Job Satisfaction) Extremely Satisfied Very Satisfied Moderately Satisfied Slightly Dissatisfied Not at all satisfied 9 Q7 How likely are you to look for another job outside the company? (Look for job) Extremely Likely Very Likely Moderately Likely Slightly Likely Not at all likely 10 11 12 13 Dept ID Meaningful Work Challenging Work Job Stress Pay Realistic Expectation Job Satisfaction Look for job 14 HR 5 2 15 OPS 16 FIN 17 PAY 18 OPS HAAA 19 OPS 20 MKT 21 OPS 22 OPS 23 OPS 24 OPS 25 HR AAND 26 MKT MKT OPS 1 W U W W H N W H U N WU NNA MKT 30 OPS 31 PAY 32 OPS 33 MKT AHUIUI AUIN 34 OPS 35 OPS 36 OPS 37 OPS PROC OPS ANNNN H WU WAH W A N W N D W W H N A W H W N W H A N W N U N W W AU M D D U U U D N N A N D U N U H A WUH U HAUL 38 39 40 MKT WUHUHWA A N N N W U U A U A A A H U U A UI UI N N V V W W UIN N H U H A W N N U W A W U W N A H H H H N W AU AN W U U D N W H H H W A N A N W W H H A U N H A W W W AOPS 39 MKT OPS PAY OPS OPS 44 PROC 45 FIN PROC OPS OPS OPS OPS MKT OPS OPS OPS OPS HR A W A N N W A D U W N N A H W N H H N W H H H H N W U U H A W U U A UI N N H VI UT N W N A N A D D N W W W W A D D W W W N W A N N N H W W H H U U W A N H U A N H Q D D U D N D H U N N U V W A N W A D D H H U U N H N W U H H U A H N N A D H W D Un D N H U A N D D W H A N U U W A UT W D UT D H H W N N U W N N N W U V W U H W UT OPS H W H W H W A H N A N W A D U A A W W A N A H A U D U W H A W N A N A WU NAN W U N U H H U N W U H A W A D D H A U N H A U W U U AU ADUH WNWAUDAN N W W D D U U N H W W A W U D D H W U N H A W W A N A H W A N W H H W H W N W U OPS HR HR OPS PAY PAY HR MKT HR OPS MKT PROC PROC OPS OPS OPS OPS OPS HR PROCPROC FIN HR OPS OPS - A U U WA N W N H W WN MKT OPS OPS 84 FIN 85 OPS 86 OPS PROC 88 OPS 89 MKT 90 OPS OPS Un D W N N A N H A D D D N UI UI UI UT U U D D W UI N U H U U H H U H W N A D U H N W U N A H H A W H N N H U A N U A W H N N N A W U N N W U WUND Un D H UT W N D UT W W UT H UI W UI N W D N UT H A W U W U A N N N H N H W U U OPS H H H W H U NA W N U U N U H H H W H H H W AH N H N U W NU WNAUP 93 OPS W W N UT UT A H W U N W A W W H UT UT UT W W H H UT A H A W UT H W A W H A A W UT H W W A W N W U D D D UT W H W H N W W W N W A N W U W N W N H UTUWN 94 FIN 95 OPS 96 OPS 97 OPS 98 MKT H U W UT W D UT W W U H N W W N U H N W U NUA. 99 OPS 100 OPS 101 102 OPS 103 OPS OPS 104 FIN 105 OPS 106 MKT 107 OPS 108 HR 109 FIN 110 PROC 111 OPS 112 113 114 115 116
