Pivot table excel

User Generated

Rznyvzb

Business Finance

Description

Using the attached file Pivot Table HW, answer the questions in the worksheet using a pivot table. Copy and paste each table you create to answer the questions and paste in the worksheet.

Unformatted Attachment Preview

Gender Man Man Man Woman Woman Man Man Man Woman Man Woman Man Woman Man Woman Man Man Woman Man Woman Woman Woman Man Man Woman Man Man Man Woman Man Man Woman Woman Man Man Woman Man Woman Woman Man Man Man Man Woman Frequency Income 4 4 6 6 5 3 5 6 4 4 5 6 4 4 4 6 3 4 6 5 1 3 3 3 2 2 6 4 2 6 4 3 5 1 2 6 2 6 2 3 6 1 4 4 30 58 48 58 53 49 48 52 47 63 48 45 43 55 32 52 44 75 53 54 68 50 39 55 60 39 55 64 30 59 36 58 46 71 61 49 20 47 61 53 49 33 59 60 Man Woman Woman Woman Man Man Man Woman Woman Man Man Man Woman Man Woman Man Man Man Man Woman Man Man Woman Woman Man Man Woman Woman Man Man Man Man Woman Woman Woman Woman Man Woman Woman Man Woman Woman Man Woman Man Woman Man 3 6 2 3 5 2 4 4 3 1 4 4 6 5 2 4 5 3 2 2 6 4 2 4 4 4 5 4 4 2 3 2 5 3 4 3 2 2 3 3 4 2 3 3 4 6 2 40 49 32 69 49 61 64 78 66 24 34 65 46 53 78 36 49 22 65 69 50 44 60 58 48 62 49 51 56 67 65 71 58 38 52 74 70 30 66 78 45 34 69 53 54 51 62 Man Woman Woman Woman Man Woman Woman Woman Woman Man Man Man Woman Woman Woman Man Man Man Man Woman Man Woman Man Woman Man Man Man Woman Woman Man Man Man Man Man Woman Woman Man Man Man Man Woman Woman Man Man Woman Man Woman 3 3 3 3 2 6 1 2 6 2 3 4 3 1 3 2 4 4 3 2 3 2 4 4 2 4 4 4 4 3 2 4 3 3 6 1 2 2 1 1 3 6 6 1 3 4 3 52 85 86 36 78 56 68 72 47 65 76 51 53 68 62 39 70 65 93 75 69 84 56 51 76 27 66 64 52 63 69 63 26 77 52 94 33 84 32 63 65 50 52 86 22 33 44 Woman Woman Woman Man Woman Woman Woman Woman Woman Man 3 6 2 3 2 4 2 4 1 1 56 48 30 31 64 32 62 71 64 79 MdDonalds tracks visits by individuals and wants to understand its customers better 1. Create a Pivot Table 2. What is the average frequency of visits among men? Answer: 3. What is the average frequency of visits among women? Answer: 4. How many men visited McDonalds in this data set? Answer: 5. How many women visited McDonalds in this data set? Answer:
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hello, I hope this a...

Similar Content

Related Tags