Pivot Table Note: Include command for excel purpose ASPCA wanted to find out if there was a relation

Pivot Table

Note: Include command for excel purpose

ASPCA wanted to find out if there was a relationship between the type of animals preferred and the gender of the owner. They gathered data from 50 randomly chosen pet owners who owned either one cat or one dog:

gender

type

gender

type

female

cat

male

cat

male

dog

female

cat

male

dog

male

cat

male

dog

female

dog

female

cat

female

cat

female

cat

female

dog

female

dog

male

cat

female

cat

male

dog

male

dog

male

dog

female

dog

male

dog

female

dog

male

cat

male

dog

female

dog

male

cat

female

cat

male

cat

male

dog

female

dog

female

cat

female

cat

female

cat

female

cat

male

cat

female

cat

female

cat

female

dog

male

dog

male

cat

female

dog

male

dog

male

cat

male

cat

female

dog

male

dog

male

cat

male

dog

male

cat

female

dog

male

dog

Use Excel’s capabilities to create a pivot table that shows the number of pets owned by each gender.

gender

type

gender

type

female

cat

male

cat

male

dog

female

cat

male

dog

male

cat

male

dog

female

dog

female

cat

female

cat

female

cat

female

dog

female

dog

male

cat

female

cat

male

dog

male

dog

male

dog

female

dog

male

dog

female

dog

male

cat

male

dog

female

dog

male

cat

female

cat

male

cat

male

dog

female

dog

female

cat

female

cat

female

cat

female

cat

male

cat

female

cat

female

cat

female

dog

male

dog

male

cat

female

dog

male

dog

male

cat

male

cat

female

dog

male

dog

male

cat

male

dog

male

cat

female

dog

male

dog

 

 

Looking for a Similar Assignment? Hire our Top Techical Tutors while you enjoy your free time! All papers are written from scratch and are 100% Original. Try us today! Active Discount Code FREE15