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 illustrates the cumulative sales of makeup products over time, showcasing the monthly preferences and overall trends in sales volume.

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 displays the fluctuation of sales volume (represented by bubble size) and market share (indicated by bubble size) across various sales regions, each distinguished by different colors.