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.

The plot reveals that mascara consistently generates the highest sales across the months(from 2004 to 2006), while other products like lip gloss and foundation contribute less but still show seasonal peaks.

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.

The Northwest (NW) region leads in both market share (42%) and number of products, while the Northeast (NE) region has the lowest market share at 3% with only 5 products.