Assignment 5

1. Using the MakeupDB.xlsx dataset, create an area plot with Months on the x-axis, Dollars

an the y-axis, and Product as the category. Note: you will have to summarize the data by

month as a sum by month and product.

Eye liner continuously had the highest monthly sales of any cosmetic product between December 2003 and January 2007.

2.Using the Sales by Region.xlsx dataset, create a bubble chart with Number of Projects on

the x-axis, Percentage of Sales on the y-axis, the size of the bubble using Sales, and each

bubble’s color using Sales Region`

There are significant regional differences in the distribution of sales and projects, with the Northwest (NW) region having the highest number of both.