Exercise: The data set on the Data sheet lists information about 400 customer transactions. A pivot table has been created below from this data set. For each of the following questions, manipulate the pivot table so that you can see the requested value. Then copy the appropriate pivot table cell and paste it special as a value to the specified cell to the right. The grader will only check that you have the correct numerical values, so you can use any manipulations you want to answer the questions. 1. Cell L3: Find the sum of Total Cost for all transactions by females in the West. 2. Cell L4: Find the average of Total Cost for all transactions by males in regions other than the West 3. Cell LS: Find the number of transactions on Monday mornings. 4. Cell L6: Find the percentage of all transactions made by males, that occur on Tuesday afternoons. 5. Cell L7: Find the sum of Total Cost for all transactions by males on Tuesday evenings, shown as a percentage of the sum of Total Cost over all transactions. 6. Cell L8: Find the maximum Total Cost amount for all transactions paid with credit cards (Visa or Mastercard) by females. 7. Cell 19: Find the standard deviation (Std Dev version) of Total Cost for all transactions made on Fridays. B. Cell 10: Find the sum of Total cost for all transactions made in May. (Hint: Group on Date.) Hint: You might need to review Displaying Counts in various Ways on the Topic page associated with this gule. Answers 1. $11,307.69 2. $149.97 3. 12 4. 5. 6. 7 8. Pivot Table Average of Total Cost Column Labels Row Labels T Male Grand Total MidWest 115.5153571 115.5153571 NorthEast 170.015283 170.015283 South 146.7 146.7 Grand Total 149.9661261 149.9661261 Click in this area to work with the Pivot Table report Exercise: The data set on the Data sheet lists information about 400 customer transactions. A pivot table has been created below from this data set. For each of the following questions, manipulate the pivot table so that you can see the requested value. Then copy the appropriate pivot table cell and paste it special as a value to the specified cell to the right. The grader will only check that you have the correct numerical values, so you can use any manipulations you want to answer the questions. 1. Cell L3: Find the sum of Total Cost for all transactions by females in the West. 2. Cell L4: Find the average of Total Cost for all transactions by males in regions other than the West 3. Cell LS: Find the number of transactions on Monday mornings. 4. Cell L6: Find the percentage of all transactions made by males, that occur on Tuesday afternoons. 5. Cell L7: Find the sum of Total Cost for all transactions by males on Tuesday evenings, shown as a percentage of the sum of Total Cost over all transactions. 6. Cell L8: Find the maximum Total Cost amount for all transactions paid with credit cards (Visa or Mastercard) by females. 7. Cell 19: Find the standard deviation (Std Dev version) of Total Cost for all transactions made on Fridays. B. Cell 10: Find the sum of Total cost for all transactions made in May. (Hint: Group on Date.) Hint: You might need to review Displaying Counts in various Ways on the Topic page associated with this gule. Answers 1. $11,307.69 2. $149.97 3. 12 4. 5. 6. 7 8. Pivot Table Average of Total Cost Column Labels Row Labels T Male Grand Total MidWest 115.5153571 115.5153571 NorthEast 170.015283 170.015283 South 146.7 146.7 Grand Total 149.9661261 149.9661261 Click in this area to work with the Pivot Table report