Question 1.Using the MakeupDB.xlsx dataset, create an areaplot 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.

#Interpretation: This area plot visualizes total makeup sales (colored areas) per product over time, revealing popular monthly choices and overall sales trends.

Question 2.Using the Sales by Region.xlsx dataset, create a bubble chart with Number of Projects onthe x-axis, Percentage of Market share on the y-axis, the size of the bubble using Sales, and each#bubble’s color using Sales Region.

Interpretation

This bubble chart reveals how sales volume (bubble size) and market share This bubble chart reveals how sales volume (bubble size) and market share (bubbles) vary across different sales regions (colors).vary across different sales regions (colors).