For the excel below:

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".

B C D E Questions Q1 How meaningful is your work? (Meaningful Work) Q2 How challenging is your job? (Challenging Work) Q3 In a typical week, how often do you feel stressed at work? (Job Stress) Q4 How well are you paid for the work you do? (Pay) Q5 How realistic are the expectations of your supervisor? (Realistic Expectation) Q6 How satisfied are you with your job? (Job Satisfaction) Q7 How likely are you to look for another job outside the company? (Look for job) RATING Very Realistic Very Satisfied Very Likely Moderately Meaningful Moderately Challenging Moderately Often Moderately Well Moderately Realistic Moderately Satisfied Moderately Likely Extremely Meaningful Very Meaningful Extremely Challenging Very Challenging Extemely Often Very Often Extremely Well Very Well Extremely Realistic Extremely Satisfied Extremely Likely F G H J L M N Slightly Meaningful Slightly Challenging Slightly Often Slightly Well Slightly Realistic Slightly Dissatisfied Slightly Likely Not at all meaningful Not at all challening Not at all stressed Not at all well Not at all realistic Not at all satisfied Not at all likely Dept ID HR Meaningful Work 5 Challenging Work 5 Job Stress Pay Realistic Expectation Job Satisfaction Look for job 4 2 4 3 1 OPS 4 2 2 2 3 4 5 FIN 4 5 2 4 3 3 4 PAY 3 5 3 3 OPS 3 4 4 OPS 2 5 MKT 4 5 OPS 4 2 2 2 = 1 5 - = OPS 2 OPS 4 5 4 = OPS 4 5 HR 4 1 4 MKT 4 5 2 MKT 2 5 3 - OPS 5 1 5 MKT 4 4 3 OPS 4 4 PAY 5 A OPS 1 5 5 MKT 4 4 2 - OPS 4 5 2 OPS 3 5 3 3 4 OPS 1 3 4 OPS 5 2 1 4 PROC 5 5 OPS 2 1 4 - MKT A 2 OPS 2 4 4 = PAY 5 5 5 4 OPS 1 4 1 4 OPS 3 2 5 PROC 2 4 = FIN 3 3 PROC 3 1 5 4 OPS 2 5 5 OPS 4 4 1 OPS 3 4 1 OPS 5 3 MKT 4 4 3 3 OPS 2 5 1 - OPS 4 5 2 OPS 3 3 2 - OPS 3 5 2 4 4 4 4 OPS 1 3 OPS 2 2 2 = HR 5 5 3 4 3 4 3 4 _ OPS 1 1 3 4 = PAY 4 4 4 3 PAY 4 4 4 5 5 4 4 4 MKT 3 3 2 HR 4 4 3 4 OPS 3 3 5 MKT 3 5 4 3 2 3 PROC 1 3 2 2 4 2 5 PROC 2 2 1 4 4 5 4