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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!