How to:
Using the data range C13:J113 from the Emp_Satisfaction_Survey sheet, insert a pivot table on the ANALYSIS Sheet (below the first pivot table), to display the average rating by Dept ID for Q1 of the survey. The average ratings must be converted to 2 decimal places. Make sure to rename the column headings appropriately
Questions RATING Q1 How meaningful is your work? (Meaningful Work) How challenging is your job? (Challenging Work) Extremely Meaningful Extremely Challenging Very Meaningful Q3 In a typical week, how often do you feel stressed at work? (Job Stress) Slightly Meaningful Q4 How well are you paid for the work you do? (Pay) Extemely Often Very Challenging Moderately Meaningful Very Often Moderately Challenging Moderately Often Slightly Challenging Not at all meaningful Extremely Well Very Well Moderately Well Slightly Often Not at all challening Q5 How realistic are the expectations of your supervisor? (Realistic Expectation) Not at all stressed Q6 How satisfied are you with your job? (Job Satisfaction) Extremely Realistic Very Realistic Slightly Well Moderately Realistic Not at all well 10 Q7 How likely are you to look for another job outside the company? (Look for job) Extremely Satisfied Slightly Realistic Extremely Likely Very Satisfied Very Likely Moderately Satisfied Moderately Likely Slightly Dissatisfied Not at all realistic Slightly Likely Not at all satisfied Not at all likely 13 Dept ID HR Meaningful Work Challenging Work Job Stress Pay Realistic Expectation Job Satisfaction Look for job OPS FIN PAY OPS OPS MKT OPS OPS OPS OPS HR MKT HANWNUN W W MKT OPS UI N UT MKT OPS PAY OPS MKT OPS OPS MANNAND OPS OPS PROC OPS MKT OPS PAY OPS OPS PROC FIN PROC OPS OPS OPS OPS MKT OPS OPS OPS OPS HR OPS OPS HR HR OPS PAY PAY 8 9 8 HR MKT HR OPS MKT PROC PROC U N N UNWANWAAAHHUUNH NW UHHVAHNNAAN AMWNNALOPS OPS AWW ANDHW NNNN WW L H N W UT UT H OPS OPS OPS HR OPS OPS HR HR OPS N W D PAY PAY HR MKT HR OPS MKT PROC PROC OPS OPS OPS OPS OPS HR PROC FIN HR H N W W W N W A N W H W N W N H U U W N W W A A U V N H W W A W U A OPS W W N U K A H W U N W A W W H U U NI W W H H U A H A W U H W A W H A A W U N U H H U N W U H A W A A A HA UN H A V W U U A UTA A N U KI KI KI KI KI A A W UI N U H U U H H U H W N A A WA N N WA A V W NNAL OPS MKT OPS OPS FIN OPS OPS PROC K D H U W N A KI W W U H K W U N W A N U H A W U W U A N N N H N H W U U A NH U A NAD OPS MKT H U W W W A NI W W U H N W W N U H N W UI N U A A A U V W A N W N H W W N W NA NAD OPS OPS OPS OPS FIN OPS OPS OPS NNY MKT OPS 100 101 OPS 102 OPS 103 OPS 104 OPS 105 FIN 106 OPS 107 MKT 108 OPS HR 109 FIN LAWNNANNA 110 PROC 111 Ops M H W W A W N W In A 112 113 114 115 116 117 118
