DAM PROJECT
GROUP 6
Impact of COD on E-commerce Sales
Navin Chandran
Deepak Krishnan
R Santosh Kumar
Sivaramakrishnan R
Karuppaiya A
P Mohan Prashanth
P Praveen
Describing Data
THE GLOBE COMES HERE
Reading data
Libraries Used
Importing and cleaning data
cod.df = read.csv("PromotionDataV4.csv")
cod.df$isMetro <- ifelse(cod.df$ShippingCity %like% "Delhi" | cod.df$ShippingCity %like% "Mumbai" | cod.df$ShippingCity %like% "Kolkata" | cod.df$ShippingCity %like% "Chennai" | cod.df$ShippingCity %like% "Bangalore" | cod.df$ShippingCity %like% "Hyderabad",1,0)
cod <- subset(cod.df,FinalTotalPrice!=0)
attach(cod)
Unique Customers
cod.df$CustomerID <- as.numeric(cod.df$CustomerID)
unique_customers<-unique(cod.df$CustomerID)
length(unique_customers)
[1] 31869
Correlation Matrix
cod_df <- cod[,c("FinalTotalPrice","COD","VendorDiscount","WebsiteDiscount")]
cod_mat <- rcorr(as.matrix(cod_df), type="pearson")
cod_mat
FinalTotalPrice COD VendorDiscount WebsiteDiscount
FinalTotalPrice 1.00 0.09 0.10 0.31
COD 0.09 1.00 0.01 -0.05
VendorDiscount 0.10 0.01 1.00 -0.33
WebsiteDiscount 0.31 -0.05 -0.33 1.00
n= 45507
P
FinalTotalPrice COD VendorDiscount WebsiteDiscount
FinalTotalPrice 0.000 0.000 0.000
COD 0.000 0.027 0.000
VendorDiscount 0.000 0.027 0.000
WebsiteDiscount 0.000 0.000 0.000
Correlation between Price and Discount
corrgram(cod[,c("FinalTotalPrice","VendorDiscount","WebsiteDiscount")], lower.panel = panel.shade, upper.panel = panel.pie)
Correlation between COD and Discounts
corrgram(cod[,c("COD","HasVendorDiscount","HasWebsiteDiscount")], lower.panel = panel.shade, upper.panel = panel.pie)
Based on glmulti initiating best model
model <- lm(FinalTotalPrice~1+SubCategory+Brand+ProductSize+ProductColor+COD+VendorDiscount+WebsiteDiscount+isMetro,data = cod)
summary(model)
Call:
lm(formula = FinalTotalPrice ~ 1 + SubCategory + Brand + ProductSize +
ProductColor + COD + VendorDiscount + WebsiteDiscount + isMetro,
data = cod)
Residuals:
Min 1Q Median 3Q Max
-2221.8 -106.5 -16.6 86.7 5593.0
Coefficients:
Estimate Std. Error t value Pr(>|t|)
(Intercept) 2.681e+01 1.001e+02 0.268 0.788850
SubCategoryASYMMETRIC DRESS 2.646e+02 7.112e+01 3.720 0.000199
SubCategoryBEACHWEAR -8.665e+01 1.148e+02 -0.755 0.450518
SubCategoryBODYCON DRESS 3.882e+02 6.302e+01 6.160 7.33e-10
SubCategoryCAMISOLES -3.317e+02 6.017e+01 -5.513 3.54e-08
SubCategoryCAPRIS 2.543e+02 5.910e+01 4.303 1.69e-05
SubCategoryCAPS & HATS 2.641e+02 4.997e+01 5.285 1.26e-07
SubCategoryCASUAL JACKETS 1.255e+03 5.345e+01 23.485 < 2e-16
SubCategoryCASUAL SHIRTS 1.383e+02 5.015e+01 2.758 0.005827
SubCategoryCHINOS 6.022e+02 5.363e+01 11.227 < 2e-16
SubCategoryDENIM JACKETS 4.453e+02 7.576e+01 5.878 4.19e-09
SubCategoryDRESSES 4.040e+02 4.821e+01 8.379 < 2e-16
SubCategoryETHNIC JACKETS 6.491e+02 5.468e+01 11.870 < 2e-16
SubCategoryFORMAL SHIRTS -7.896e+01 1.518e+02 -0.520 0.602871
SubCategoryFORMAL TROUSERS 4.889e+02 8.404e+01 5.818 6.01e-09
SubCategoryGSTOP235BLK 1.836e+02 2.085e+02 0.880 0.378614
SubCategoryHENLEY T-SHIRTS -1.650e+01 4.904e+01 -0.336 0.736513
SubCategoryHIGH NECK T SHIRTS 5.114e+01 4.914e+01 1.041 0.297994
SubCategoryJACKETS & BLAZERS 3.037e+03 6.195e+01 49.026 < 2e-16
SubCategoryJEANS 4.962e+02 1.512e+02 3.282 0.001032
SubCategoryJEGGINGS 5.452e+02 5.042e+01 10.815 < 2e-16
SubCategoryJUMPSUITS 5.321e+02 5.076e+01 10.483 < 2e-16
SubCategoryKURTAS 2.032e+02 5.182e+01 3.921 8.84e-05
SubCategoryKURTIS 1.178e+02 5.126e+01 2.297 0.021610
SubCategoryLEGGINGS -1.343e+01 6.083e+01 -0.221 0.825234
SubCategoryLOUNGEWEAR 9.316e+00 1.267e+02 0.074 0.941404
SubCategoryMANDARIN T-SHIRTS 1.978e+02 5.654e+01 3.498 0.000469
SubCategoryNIGHTWEAR -1.804e+01 5.790e+01 -0.311 0.755438
SubCategoryOFF SHOULDER/TUBE/HALTER 3.927e+02 1.267e+02 3.100 0.001935
SubCategoryPOLO-T-SHIRTS 6.727e+01 4.884e+01 1.377 0.168453
SubCategoryQUILTED JACKETS 5.883e+02 1.517e+02 3.878 0.000105
SubCategoryROUND NECK SWEATERS 3.951e+02 6.412e+01 6.162 7.25e-10
SubCategoryROUND NECK T-SHIRTS -6.482e+01 4.892e+01 -1.325 0.185139
SubCategoryROUND NECK VESTS -1.244e+02 7.150e+01 -1.739 0.082011
SubCategorySALWAR 1.316e+02 5.457e+01 2.412 0.015850
SubCategorySCARVES -3.206e+02 9.371e+01 -3.422 0.000623
SubCategorySHIFT DRESS 1.760e+02 5.711e+01 3.081 0.002061
SubCategorySHIRTS 1.730e+02 4.830e+01 3.582 0.000341
SubCategorySHORTS -1.670e+01 4.966e+01 -0.336 0.736606
SubCategorySHRUGS 8.038e+01 5.020e+01 1.601 0.109309
SubCategorySKATER DRESS 3.045e+02 6.007e+01 5.069 4.02e-07
SubCategorySKIRTS 2.913e+02 4.871e+01 5.980 2.25e-09
SubCategorySTOCKINGS -6.463e+02 2.098e+02 -3.080 0.002072
SubCategorySUITS 1.827e+03 5.855e+01 31.205 < 2e-16
SubCategorySUMMER JACKETS 8.965e+02 1.122e+02 7.988 1.41e-15
SubCategorySWEATERS 1.670e+02 5.149e+01 3.244 0.001178
SubCategorySWEATSHIRTS 5.555e+02 5.306e+01 10.470 < 2e-16
SubCategoryT SHIRTS -3.908e+01 4.872e+01 -0.802 0.422517
SubCategoryTOPS 3.554e+00 4.817e+01 0.074 0.941185
SubCategoryTRACK PANTS 4.890e+02 5.522e+01 8.855 < 2e-16
SubCategoryTRACKPANTS 1.472e+03 1.514e+02 9.725 < 2e-16
SubCategoryTRACKSUITS 3.220e+03 2.086e+02 15.437 < 2e-16
SubCategoryTROUSERS 1.950e+02 4.860e+01 4.013 6.01e-05
SubCategoryTUNICS 7.918e+01 5.164e+01 1.533 0.125186
SubCategoryV NECK SWEATERS 1.970e+02 9.124e+01 2.159 0.030866
SubCategoryV NECK T-SHIRTS -1.327e+02 4.902e+01 -2.707 0.006785
SubCategoryWAISTCOATS 4.585e+02 5.039e+01 9.098 < 2e-16
SubCategoryWINTER JACKETS 6.718e+02 4.905e+01 13.697 < 2e-16
BrandFABALLEY 7.844e+01 4.717e+00 16.627 < 2e-16
BrandGRITSTONES -2.056e+02 8.837e+00 -23.269 < 2e-16
BrandHARPA 4.292e+01 4.668e+00 9.193 < 2e-16
BrandMEIRA -2.916e+02 5.098e+00 -57.189 < 2e-16
BrandMISS CHASE 5.029e+01 6.519e+00 7.714 1.24e-14
BrandMONTEIL & MUNERO -1.382e+02 9.397e+00 -14.706 < 2e-16
BrandMR BUTTON 8.948e+02 1.364e+01 65.626 < 2e-16
BrandTHE VANCA -3.951e+01 5.145e+00 -7.680 1.62e-14
BrandTSHIRT COMPANY 5.177e+01 7.639e+00 6.777 1.24e-11
ProductSize30 2.856e+01 3.799e+01 0.752 0.452166
ProductSize32 1.812e+01 3.600e+01 0.503 0.614850
ProductSize34 -5.688e+01 4.403e+01 -1.292 0.196419
ProductSize36 3.883e+01 5.775e+01 0.672 0.501366
ProductSize38 6.844e+02 3.548e+01 19.287 < 2e-16
ProductSize3XL 5.094e+02 5.781e+01 8.812 < 2e-16
ProductSize40 7.240e+02 3.531e+01 20.501 < 2e-16
ProductSize42 7.108e+02 3.595e+01 19.769 < 2e-16
ProductSize44 7.207e+02 3.899e+01 18.484 < 2e-16
ProductSize46 2.340e+02 2.062e+02 1.134 0.256601
ProductSizeFree Size 7.612e+02 3.984e+01 19.104 < 2e-16
ProductSizeL 3.837e+02 3.151e+01 12.177 < 2e-16
ProductSizeM 3.861e+02 3.150e+01 12.256 < 2e-16
ProductSizeS 3.772e+02 3.152e+01 11.968 < 2e-16
ProductSizeXL 3.926e+02 3.154e+01 12.445 < 2e-16
ProductSizeXS 3.613e+02 3.258e+01 11.092 < 2e-16
ProductSizeXXL 3.945e+02 3.181e+01 12.401 < 2e-16
ProductColorAQUA BLUE 3.440e+02 8.329e+01 4.130 3.63e-05
ProductColorBEIGE 3.865e+02 8.317e+01 4.647 3.38e-06
ProductColorBLACK 3.455e+02 8.283e+01 4.171 3.03e-05
ProductColorBLUE 3.633e+02 8.289e+01 4.383 1.18e-05
ProductColorBROWN 3.223e+02 8.338e+01 3.865 0.000111
ProductColorCAMEL 3.666e+02 1.229e+02 2.983 0.002859
ProductColorCHARCOAL GREY 4.205e+02 1.434e+02 2.932 0.003374
ProductColorCOBALT BLUE 8.018e+02 8.898e+01 9.011 < 2e-16
ProductColorCOFFEE 4.179e+02 8.678e+01 4.815 1.47e-06
ProductColorCREAM 3.575e+02 8.457e+01 4.227 2.38e-05
ProductColorDARK GREY 2.056e+02 8.422e+01 2.441 0.014640
ProductColorFUCHSIA 3.564e+02 8.320e+01 4.283 1.85e-05
ProductColorGOLDEN 5.827e+02 8.465e+01 6.883 5.92e-12
ProductColorGREEN 3.158e+02 8.296e+01 3.807 0.000141
ProductColorGREY 3.324e+02 8.295e+01 4.007 6.16e-05
ProductColorGREY MILANGE 3.164e+02 8.332e+01 3.797 0.000147
ProductColorICE BLUE 4.322e+02 9.547e+01 4.527 5.99e-06
ProductColorKHAKI 3.450e+02 8.494e+01 4.062 4.87e-05
ProductColorLAVENDER 1.582e+03 1.667e+02 9.485 < 2e-16
ProductColorLEMON 2.184e+02 9.180e+01 2.379 0.017370
ProductColorLIGHT BLUE 3.044e+02 8.955e+01 3.399 0.000678
ProductColorLIGHT GREY 2.724e+02 8.384e+01 3.249 0.001157
ProductColorLILAC 1.095e+02 1.313e+02 0.834 0.404128
ProductColorMAGENTA 1.970e+02 2.190e+02 0.900 0.368237
ProductColorMAROON 3.261e+02 8.308e+01 3.925 8.68e-05
ProductColorMULTI 2.917e+02 8.301e+01 3.513 0.000443
ProductColorMUSTARD YELLOW 2.469e+02 8.553e+01 2.886 0.003903
ProductColorNAVY BLUE 3.725e+02 8.293e+01 4.492 7.08e-06
ProductColorNUDE 3.829e+02 8.384e+01 4.566 4.98e-06
ProductColorOFF WHITE 3.652e+02 8.444e+01 4.325 1.53e-05
ProductColorOLIVE 4.092e+02 8.417e+01 4.862 1.16e-06
ProductColorORANGE 3.223e+02 8.304e+01 3.881 0.000104
ProductColorPEACH 3.807e+02 8.314e+01 4.579 4.68e-06
ProductColorPINK 3.853e+02 8.293e+01 4.647 3.38e-06
ProductColorPURPLE 2.962e+02 8.316e+01 3.561 0.000369
ProductColorRED 3.727e+02 8.288e+01 4.497 6.91e-06
ProductColorRUST 4.248e+02 8.449e+01 5.028 4.98e-07
ProductColorSILVER 8.825e+02 9.132e+01 9.664 < 2e-16
ProductColorTAN 1.026e+03 2.201e+02 4.661 3.16e-06
ProductColorVIOLET INDIGO 3.172e+02 8.653e+01 3.665 0.000248
ProductColorWHITE 3.436e+02 8.294e+01 4.143 3.44e-05
ProductColorWINE 3.904e+02 8.449e+01 4.621 3.83e-06
ProductColorYELLOW 3.042e+02 8.314e+01 3.659 0.000253
COD 4.630e+01 1.985e+00 23.329 < 2e-16
VendorDiscount -4.522e-01 5.589e-03 -80.923 < 2e-16
WebsiteDiscount -2.573e-01 8.441e-03 -30.488 < 2e-16
isMetro -1.874e-02 1.963e+00 -0.010 0.992384
(Intercept)
SubCategoryASYMMETRIC DRESS ***
SubCategoryBEACHWEAR
SubCategoryBODYCON DRESS ***
SubCategoryCAMISOLES ***
SubCategoryCAPRIS ***
SubCategoryCAPS & HATS ***
SubCategoryCASUAL JACKETS ***
SubCategoryCASUAL SHIRTS **
SubCategoryCHINOS ***
SubCategoryDENIM JACKETS ***
SubCategoryDRESSES ***
SubCategoryETHNIC JACKETS ***
SubCategoryFORMAL SHIRTS
SubCategoryFORMAL TROUSERS ***
SubCategoryGSTOP235BLK
SubCategoryHENLEY T-SHIRTS
SubCategoryHIGH NECK T SHIRTS
SubCategoryJACKETS & BLAZERS ***
SubCategoryJEANS **
SubCategoryJEGGINGS ***
SubCategoryJUMPSUITS ***
SubCategoryKURTAS ***
SubCategoryKURTIS *
SubCategoryLEGGINGS
SubCategoryLOUNGEWEAR
SubCategoryMANDARIN T-SHIRTS ***
SubCategoryNIGHTWEAR
SubCategoryOFF SHOULDER/TUBE/HALTER **
SubCategoryPOLO-T-SHIRTS
SubCategoryQUILTED JACKETS ***
SubCategoryROUND NECK SWEATERS ***
SubCategoryROUND NECK T-SHIRTS
SubCategoryROUND NECK VESTS .
SubCategorySALWAR *
SubCategorySCARVES ***
SubCategorySHIFT DRESS **
SubCategorySHIRTS ***
SubCategorySHORTS
SubCategorySHRUGS
SubCategorySKATER DRESS ***
SubCategorySKIRTS ***
SubCategorySTOCKINGS **
SubCategorySUITS ***
SubCategorySUMMER JACKETS ***
SubCategorySWEATERS **
SubCategorySWEATSHIRTS ***
SubCategoryT SHIRTS
SubCategoryTOPS
SubCategoryTRACK PANTS ***
SubCategoryTRACKPANTS ***
SubCategoryTRACKSUITS ***
SubCategoryTROUSERS ***
SubCategoryTUNICS
SubCategoryV NECK SWEATERS *
SubCategoryV NECK T-SHIRTS **
SubCategoryWAISTCOATS ***
SubCategoryWINTER JACKETS ***
BrandFABALLEY ***
BrandGRITSTONES ***
BrandHARPA ***
BrandMEIRA ***
BrandMISS CHASE ***
BrandMONTEIL & MUNERO ***
BrandMR BUTTON ***
BrandTHE VANCA ***
BrandTSHIRT COMPANY ***
ProductSize30
ProductSize32
ProductSize34
ProductSize36
ProductSize38 ***
ProductSize3XL ***
ProductSize40 ***
ProductSize42 ***
ProductSize44 ***
ProductSize46
ProductSizeFree Size ***
ProductSizeL ***
ProductSizeM ***
ProductSizeS ***
ProductSizeXL ***
ProductSizeXS ***
ProductSizeXXL ***
ProductColorAQUA BLUE ***
ProductColorBEIGE ***
ProductColorBLACK ***
ProductColorBLUE ***
ProductColorBROWN ***
ProductColorCAMEL **
ProductColorCHARCOAL GREY **
ProductColorCOBALT BLUE ***
ProductColorCOFFEE ***
ProductColorCREAM ***
ProductColorDARK GREY *
ProductColorFUCHSIA ***
ProductColorGOLDEN ***
ProductColorGREEN ***
ProductColorGREY ***
ProductColorGREY MILANGE ***
ProductColorICE BLUE ***
ProductColorKHAKI ***
ProductColorLAVENDER ***
ProductColorLEMON *
ProductColorLIGHT BLUE ***
ProductColorLIGHT GREY **
ProductColorLILAC
ProductColorMAGENTA
ProductColorMAROON ***
ProductColorMULTI ***
ProductColorMUSTARD YELLOW **
ProductColorNAVY BLUE ***
ProductColorNUDE ***
ProductColorOFF WHITE ***
ProductColorOLIVE ***
ProductColorORANGE ***
ProductColorPEACH ***
ProductColorPINK ***
ProductColorPURPLE ***
ProductColorRED ***
ProductColorRUST ***
ProductColorSILVER ***
ProductColorTAN ***
ProductColorVIOLET INDIGO ***
ProductColorWHITE ***
ProductColorWINE ***
ProductColorYELLOW ***
COD ***
VendorDiscount ***
WebsiteDiscount ***
isMetro
---
Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
Residual standard error: 202.7 on 45376 degrees of freedom
Multiple R-squared: 0.6411, Adjusted R-squared: 0.6401
F-statistic: 623.5 on 130 and 45376 DF, p-value: < 2.2e-16
Performing Normality and Linearity Tests
Visual inspection code
Error in shapiro.test(FinalTotalPrice) :
sample size must be between 3 and 5000