2. Given a set of sales data from Vendervault 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 a bar chart to see the number of observations / frequencies for "Sub-Category". Determine the mode for this Sub-Category". ii) 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 Vendervault Households to solve this issue? 3. You are recommended to use Microsoft Excel to perform all the analysis, however, any other software also acceptable as long as you answer all of the question. 4. You are required to present the findings / answer to all question in a report. Your report must be in Microsoft Word file only. 2. Given a set of sales data from Vendervault 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 a bar chart to see the number of observations / frequencies for "Sub-Category". Determine the mode for this Sub-Category". ii) 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 Vendervault Households to solve this issue? 3. You are recommended to use Microsoft Excel to perform all the analysis, however, any other software also acceptable as long as you answer all of the question. 4. You are required to present the findings / answer to all question in a report. Your report must be in Microsoft Word file only