Visualizations: Part A

1. Calculate and show the total sales by month for both 2014 and 2015 (use the best visualization to show this).
2. From Problem 1, which were the lowest / highest sales months respectively? Calculate the difference of the total sales by month from 2014 to 2015. Show and describe how they compare.
3. Create a bar chart that shows the total sales by year for all years.
4. Create a pivot table that shows the total sales by state and by all years (make sure the pivot table is in it's "best" format). Use conditional formatting visualizations to help show the differences.

Analytical Techniques: Part B

1. How does 2015 compare to the all of the previous years? What are the rates of change?
2. What are the total sales for the "black Friday" sale of 2015? (Use Friday - Monday.) Was this a "good" black Friday sale? How do we know?
3. Which state has grown / declined the most by total sales (dollars) from 2014 to 2015?
4. Use a pivot table to: calculate the average sales by state and calculate the standard deviations of the sales by state. Which of the 3 states deviated the most?