Question: I was asked to compose a pivot table for the following demographics: The number of men ages 3544 years, who have a household income between

I was asked to compose a pivot table for the following demographics:

  • The number of men ages 3544 years, who have a household income between $75,000 and $99,999 and who play exclusively at a public park pickleball court.
  • The number of divorced men, ages 3544 years, who learned about pickleball from friends and family.
  • The number and percentage of males and females (# and %) who earned between $50,000 and $74,999 and play only at a public park five or more times per month.
  • The number of married females who play 13 plus times per month and spend less than $50 annually on equipment.

How do I go about creating this particular table on excel ie what goes into columns, rows and values

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 Mathematics Questions!