Purchase Solution

Pivot Table

Not what you're looking for?

Ask Custom Question

The database DISH.XLS contains a transaction history describing more than 4,000 purchases of detergent at a number of stores in a grocery chain over a period of several weeks.

a. Compile a pivot table that gives a tabulation of sales (in cases) by brand (Dove, Sunlight etc.)
b. Compile a pivot table that gives a tabulation of sales broken down by brand and by week.
c. Compile a pivot table that gives a tabulation of sales broken down by brand, by week and by store
d. Compile a pivot table that gives a tabulation of the number of ounces purchased broken down by brand and by size of container. What is the sales volume in ounces for each brand?

Attachments
Purchase this Solution

Solution Summary

The excel file contains Pivot tables with excel sheets named as per sub-questions and the word document contains step by step instructions to create Pivot tables.

Purchase this Solution


Free BrainMass Quizzes
Economics, Basic Concepts, Demand-Supply-Equilibrium

The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.

Elementary Microeconomics

This quiz reviews the basic concept of supply and demand analysis.

Economic Issues and Concepts

This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.

Pricing Strategies

Discussion about various pricing techniques of profit-seeking firms.

Basics of Economics

Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.