1.Given a set of sales data from Vender Vault Households that supply furniture and other equipment for the month of January to March 2017 (refer to the attached Microsoft excel file - title: "Sales Data"). The data contains 14 variables with 500 observations. The description of data is as follows:

Variables Description

Order ID Unique ID for an order

Order Date Date when the order is made

Ship Mode Method of delivery of product to customer

Customer Name Customer Name

Segment Market segment for the customer

Country Customer's country

City City where customer reside

Product ID Unique ID for a particular product

Category General types of product

Sub-Category Specific types of product

Sales Sales value of particular product (USD)

Quantity Number of unit customer purchase (Unit)

Discount Percentage of discount for particular product (%)

Profit Profit after sales minus by the cost and discount (USD)

Vendervault Households CEO hired your team to assist them to have a better understanding of their business data. You are required to answer the below question that highlighted by the CEO:

i)Create pie chart for the number of observation / frequencies for "Ship Mode", "Segment" and "Category". Include the percentage of each category in the pie chart.

ii)Create bar chart to see the number of observations / frequencies for "Sub-Category". Determine the mode for this "Sub-Category".

iii)Determine the average "Sales" for January, February and March separately.

iv)Determine the total "Sales" by "Segment" and represent the data by using a chart.

v)What is the product "Category" that has the lowest profit as overall? What is your recommendation to Vender Vault Households to solve this issue?

excel link dropbox : https://www.dropbox.com/scl/fi/o44tahm37dtf8hckhndaq/Book.xlsx?cloud_editor=excel&dl=0&rlkey=ww1gwdinurzd8kw1ll5bxjft9&wdrcid=9146f57c-1917-4836-9c14-44a74766c304&wdrldc=1