{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

09.2_Pivot_Tables_Day_2_Problems

# 09.2_Pivot_Tables_Day_2_Problems - Pivot Table Homework...

This preview shows pages 1–2. Sign up to view the full content.

Pivot Table Homework Problems R: 12/27/06 dld With the source data (file: Western-Regional_DataSet_2.xls) referenced with the pivot table tutorial, answer the following questions: 1. How much bicycle revenue did the Provo store receive in the month of October? 2. How many bicycles did Provo sell in the month of October? 3. What was the total revenue received from pajamas comprising all three months and all three stores? 4. What percentage of Bicycle revenue was Candy revenue for the Orem store for all three months, how about shirts? 5. a). What is the average sum of revenue received for snacks in San Jose for all three months? Hint: you can get the sum of the snack revenue in the pivot table. Then you must divide the sum by the number of months (3) outside of the pivot table. b). What is the average monthly snack revenue received for snacks in all three store? Hint: you can get the sum of the revenue amounts in the pivot table and then you must divide the sum by 9 (3 months X 3 stores) outside of the pivot table.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 2

09.2_Pivot_Tables_Day_2_Problems - Pivot Table Homework...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online