Answer Happy

Excel Module Assignment Instructions for Unit 5 For this assignment, you will be asked to develop a set of summaries of the data set EcommerceData.xlsx This is a larger data set from the website Kaggle (data link here) For this dataset, please generate the following: 1. A relative frequency table for the Mode of Shipment, with a corresponding pic chart (your table should have % of Grand Total instead of Count). 2. A frequency table for Warehouse Block, with a corresponding bar chart. 3. A frequency table for the Mode of Shipment for each Warehouse Block 4. A histogram for the Weight in Grams column, with twelve bins 5. A histogram for Discount Offered column, with a bin width of 7. 6. A table displaying the Number of Previous Purchases as the rows and with the following columns: a. The sum of the costs of products b. The average of the costs of products The sum of the discount offered d. The average of the discount offered c.