Question: When using a pivot table, you move job satisfaction scores, which are a continuous variable into the values box in the pivot table fields. You
When using a pivot table, you move "job satisfaction" scores, which are a continuous variable into the values box in the pivot table fields. You then put the variable "Location" into the Axis categories box. What additional step needs to be taken to ensure that the average is displayed instead of the sum?
When using a pivot table, you move "job satisfaction" scores, which are a continuous variable into the values box in the pivot table fields. You then put the variable "Location" into the Axis categories box. What additional step needs to be taken to ensure that the average is displayed instead of the sum?
No additional changes are needed. Doing this will correctly display and summarize job satisfaction by location.
You also need to add job satisfaction to the legend box of the pivot table fields to properly summarize this variable.
Use the value field settings option and change the summary from sum to average.
None of these are correct.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
