Economics Excel Problems

EconS 451: Advanced Food Economics and Marketing

Spring 2017

Homework 2

Name:

Remember, you are free to work in pairs for each assignment. However, two is the maximum number of people who can submit an assignment jointly. An assignment with more than two names on it will receive a score of zero. If you work with a partner, be sure both names are on the assignment.

Using the provided ice cream sales data.

1. Summarize in a table and graphically the number and percent of UPC’s by Brand.

2. Summarize in a table and graphically percent of sales by Brand.

3. Summarize in a table and graphically percent of sales by flavor.

4. Summarize in a table and graphically the distribution of pricing by pint.

5. Test and describe the relationship between types of flavors and brand. (Hint: Which has more specialized flavors, Private label/generic brands or Brand Name brands)