Essay About Sale Unit Of Men And Operation Time

Regression for Sale Unit of Men’s Wallet
Essay Preview: Regression for Sale Unit of Men’s Wallet
Report this essay
Group Assignment:Regression for Sale Unit of Men’s WalletGroup AAi Huanhuan 14210690645Chen Lijuan 15210690175Gao Yuyang 15210690240Hong Sha 15210690278Li Yishan 15210690374Wang Dan 15210690510Kyungrok Kim 15210690747Kim Bokyung 15210690767Background and IntroductionNowadays E-commerce is becoming more and more popular and increasing number of shops selling clothes and accessories are being opened on Taobao, Tmall, etc. But online shoppers have to consider many factors to maximize their sales and profit and at the same time reduce the risks. So we tried to find the relationships between the sales volume of Men’s Wallets and some factors including operation time, shop region, comment numbers, customer numbers, product prices, discount percentages, etc. These thousands of data were collected from the back operation system of Taobao and Tmall. After analysis, we shall give a regression model, in other words, a formula, to give a guidance or reference to online shoppers or potential online shoppers to operate their Men’s Wallet online shops.DataWe collected a package of data about sales of men’s wallets. The raw data are from online shopping platforms-Taobao, Tmall and JD worldwide. Of course, they are also from different online stores. The sample size is 1790. We selected 8 dimensions of data which are both what we are interested in and quantifiable. Then we sort out the data as follows.NumberStore NameSales Volume (unit)Operation Time (Day)RegionPriceDiscountCustomersCommentsCollection Add1兴展通讯921219891628 20.38%144231075172经典时尚品牌代理10751710850 0.00%819180043513依嘻嘻405157301393 0.00%23833487614香港代购1516852652301280 63.91%4113548475爱媚时尚店6413040668 0.00%404196934 ……        1789东的外贸13267099 10.00%14312721790郭允枫22268031 14.56%17421We denote 1 dependent variable and 7 independent variables. Here are details.Y-Sales Volume (unit), means how many wallets are sold in the store during the operation time;X1-Operation time (day), means how many days from the day the store started to Dec 1st,2015;X2-Region, logical value, means whether the store provides free shopping, if yes, the number is 1, if not, 0;X3-Price, means original price;X4-Discount, means currently promoted price ratio of original price;X5-Customers, means the number of customers who bought the wallets;X6-Comments, means the number of comments the store got;X7-Collection Add, means how many accounts added the store on their collection.Understand the data: mean, variance, histogramFor the raw data, we have 7 variables for reference about the sale units of the men’s wallet.We will calculate mean, variance and generate histogram to understand the data Preliminary. Correlation has been shown and Scatter plot can be found in check part. So here we will show mean, variance and histogram.Due there’s a logic number (0, 1), it’s no use to calculate the mean and variance of this kind of data. So we will not calculate the region mean, variance and hitogram. Sales Volume (Unit)Mean: 177Variance: 232161[pic 1]Operation Time (Day)Mean: 896Variance: 509659[pic 2]Price (RMB)Mean: 328.8Variance: 186758.5[pic 3]Discount (%)Mean: 32.48%Variance: 0.063[pic 4]Customers (People)Mean: 109Variance: 85984[pic 5]Comments (Item)Mean: 258Variance: 1161080[pic 6]Collection Add (Item)Mean: 712Variance: 4353023[pic 7]Then we got the correlations of the variables through computer: Sales Volume (unit)Operation Time (Day)RegionPriceDiscountCustomersCommentsCollection AddSales Volume (unit)1       Operation Time (Day)0.0385931      Region0.113860.0451581     Price-0.03905-0.15543-0.177041    Discount-0.044780.067474-0.04039-0.113021   Customers0.8101960.0328750.091465-0.05017-0.018051  Comments0.6224110.0489920.102775-0.058510.0152680.7377231 Collection Add0.4590250.1547920.078729-0.035360.0484210.5100890.7147851