Module 03: Discussion 01: Candy Types
2
Please see the attached data set that shows candy preference and consumption by
state (and includes a tab with State Abbreviations- hint, consider using a vlookup to add
a column that turns the abbreviation into full state name for easier analysis).
Provide analysis that includes three pivot tables, three pivot charts/charts (one pie chart,
one stacked bar chart and one additional chart type of your choice), and a summary of
what you found. Consider the size of the data set and if you may want to focus on just a
subset (could be a subset of states, a subset of candy types, etc. and if you choose to
do so, make sure this is part of your explanation).
