Pivot Table Assessment

This is the file needed to answer this assessment question: Pivot Tables Question 1

In the file above, you are given data on production of 5 products at plants in 4 cities. Use a PivotTable to summarize the fraction of defective products produced at each plant. Setup a slicer that let’s me show any subset of products and a timeline that let’s me slice and dice over time. Which plant appears to produce the highest percentage of defectives? The lowest?

This is the file needed to answer this assessment question: Pivot Tables Question 2

In the file above, everything before the hyphen  is a product code and the number after the hyphen is units sold. The letter indicates the product family. Use a PivotTable to determine total sales for each product family and summarize the sales with a Pie Chart.

This is the file needed to answer this assessment question: Pivot Tables Question 3

In the file above, you are given the following information about a sample of people that is representative of the US.

1. Do they subscribe to Garden and Gun Magazine?
2. Income Level (Upper, Middle, or Low)
3. Location ( Urban, Rural, or Suburban)

Summarize your PivotTable with a PivotChart

This is the file needed to answer this assessment question: Pivot Tables Question 4

Many men and women were asked to rate the age of member of the opposite sex they find the most attractive.

In the file above, you are given each person’s age, gender, and the age of a member of the opposite sex they find most attractive.

For example, person 1 is a 30 year old woman who finds 30 year old men most attractive and a person 2 is a 42 year
old man who finds 27 years old women most attractive.

Constuct a PivotTable and PivotChart that help you understand how men and women answer this question differently. Then use your PivotTable to explain
how the answer to this question differs by gender.

Hint: Group by age