DAM Project_Group 5
Om Joy Halder
Mayank
Priyanshi
Anurag
Nitin
Animesh
date: 28-11-2017 autosize: true
What is the average price paid with/without COD?
ecom<- read.csv(paste("PromotionDataV4.csv", sep= " "))
Has_COD = subset(ecom, ecom$COD == 1 )
Not_COD = subset(ecom, ecom$COD == 0)
# Average price paid with COD
mean(Has_COD$FinalTotalPrice)
[1] 774.6938
# Average price paid without COD
mean(Not_COD$FinalTotalPrice)
[1] 723.248
Illustration
par(mfrow=c(1,2))
hist(Has_COD$FinalTotalPrice, xlab = "Final Price", ylab = "Frequency", col = " blue")
hist(Not_COD$FinalTotalPrice, xlab = "Final Price", ylab = "Frequency", col = " green")
Does payment method has an impact on total price?
Call:
lm(formula = ecom$FinalTotalPrice ~ ecom$COD, data = ecom)
Residuals:
Min 1Q Median 3Q Max
-774.7 -208.7 -94.3 143.0 6203.3
Coefficients:
Estimate Std. Error t value Pr(>|t|)
(Intercept) 723.248 2.572 281.19 <2e-16 ***
ecom$COD 51.446 3.285 15.66 <2e-16 ***
---
Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
Residual standard error: 342.7 on 45896 degrees of freedom
Multiple R-squared: 0.005317, Adjusted R-squared: 0.005295
F-statistic: 245.3 on 1 and 45896 DF, p-value: < 2.2e-16
Here, we see there is a significant relation between payment method and total price as the p value is less than 0.05. As stated in the data description payment through COD comes with an extra charge, this regression corroborates that that mode of payment influence the final price.
Do consumers prefer COD? (analysing impact of COD on Demand in units sold and revenue generated)
# Units sold
nrow(Has_COD)
[1] 28144
nrow(Not_COD)
[1] 17754
# Total Revenue
mytable <- aggregate(ecom$FinalTotalPrice ~ ecom$COD, FUN = sum)
mytable
ecom$COD ecom$FinalTotalPrice
1 0 12840545
2 1 21802982
```
Here, we see that more number of units have been sold through COD than through elctronic payment. Consequently, more revenue has been accrued through cash payment. So, we can presume that COD is more popular method of payment.
Do customers prefer COD for higher priced products or lower priced products?
x<- mean(ecom$FinalTotalPrice)
sum(Has_COD$FinalTotalPrice> x)
[1] 11518
sum(Has_COD$FinalTotalPrice< x)
[1] 16626
Consumer Behaviour: Are people more likely / less likely to use COD when they buy under promotions compared to when they buy without promotions?
mytable2 <- xtabs(~ecom$COD+ecom$HasVendorDiscount, data= ecom )
mytable2
ecom$HasVendorDiscount
ecom$COD 0 1
0 8765 8989
1 13917 14227
chisq.test(mytable2)
Pearson's Chi-squared test with Yates' continuity correction
data: mytable2
X-squared = 0.024833, df = 1, p-value = 0.8748
mytable3 <- xtabs(~ecom$COD+ecom$HasWebsiteDiscount, data= ecom )
mytable3
ecom$HasWebsiteDiscount
ecom$COD 0 1
0 10642 7112
1 19229 8915
Does the customer's location (captured by Pin code/Shipping State) affects his/her choice of payment method?
Metro <- ecom[which(ecom$ShippingCity==c("Kolkata", "New Delhi", "Bangalore", "Mumbai")),]
NonMetro <- ecom[which(ecom$ShippingCity!=c("Kolkata", "New Delhi", "Bangalore", "Mumbai")),]
View(Metro)
View(NonMetro)
```
mytable <- table(Metro$COD)
mytable
0 1
1688 2042
prop.table(mytable)*100
0 1
45.25469 54.74531
mytable2 <- table(NonMetro$COD)
mytable2
0 1
16066 26102
prop.table(mytable2)*100
0 1
38.09998 61.90002
Which brand is purchased more frequently with/without COD?
mytable <- xtabs(~ Brand, data=Has_COD)
mytable
Brand
ATHENA FABALLEY GRITSTONES HARPA
2811 4023 4320 4148
MEIRA MISS CHASE MONTEIL & MUNERO MR BUTTON
3261 1141 4183 534
THE VANCA TSHIRT COMPANY
2884 839
Highest Selling Brand with COD
barplot(mytable,
main="Highest Selling Brands for COD",
xlab="Brands", ylab="Frequency", breaks= 200)
Highest Selling Brand without COD
mytable2 <- xtabs(~ Brand, data=Not_COD)
mytable2
Brand
ATHENA FABALLEY GRITSTONES HARPA
1329 2876 2581 3123
MEIRA MISS CHASE MONTEIL & MUNERO MR BUTTON
2161 537 2356 314
THE VANCA TSHIRT COMPANY
1920 557
Which website discounts were most popular with customers?
mytable5 <- xtabs(~WebsiteDiscountCode+COD , data=ecom)
mytable5
COD
WebsiteDiscountCode 0 1
ACT200 2 0
ACT300 1 3
ACT500 0 3
AIRTP15PJB6XF5J9 1 0
AIRTP15PJB8DGNWU 1 0
AIRTP15PJBKAEMPZ 1 0
AIRTP15PJBKDRACV 1 0
AIRTP15PJBNRH9YM 1 0
AIRTP15PJBQLY45C 1 0
AIRTP15PJBRMVYRQ 1 0
AIRTP15PJBS5Y3GA 1 0
AIRTP15PJBZAQ9ZM 1 0
APP05 1128 1558
APP30 362 647
APPY30 324 625
AXIS30 2 0
AXISAPP300 8 0
BIRTHDAY3502FCE 0 2
BIRTHDAY3502ZUY 4 0
BIRTHDAY350EQJH 1 0
BIRTHDAY350HPFZ 1 0
BIRTHDAY45034TE 0 1
CITIOMG 26 0
COUPONDUNIA400 27 17
CROCS30 0 5
CRYOC5000JZA3MVA 0 2
DENIM30 0 3
DEUTSCHE30 2 0
DINV3Y4JHG 0 1
DINV7MC8X8 0 1
DINV7NJGLM 0 1
DINV835CP4 0 2
DINV87EUED 0 1
DINV9W9YMN 0 1
DINVA9SZE5 0 1
DINVDX46PR 0 2
DINVFLTBYH 0 2
DINVGEMUZZ 0 1
DINVH4K87Y 0 1
DINVHZ68ZL 0 1
DINVJBCW6T 0 2
DINVN63KPS 0 1
DINVR563LN 0 2
DINVT4KNAF 0 1
DINVTPPP6A 0 1
DINVTPWVW9 0 1
DINVTVUZ8B 0 1
DINVYVQZ38 0 1
DPRO3QAL8C 0 1
DPRON758TL 0 1
DRINVQ42NYZ 0 1
DRUND23433U 0 1
DRUND3YA3P8 0 1
DRUND6HC859 0 1
DRUNDA68KJX 0 1
DRUNDAVDU6T 0 1
DRUNDCE6U6G 0 2
DRUNDCMNVJX 0 1
DRUNDD3KUCG 0 1
DRUNDD854G7 0 1
DRUNDDL7EEJ 0 1
DRUNDF8Z2N9 0 1
DRUNDFQ6QFC 0 1
DRUNDGXWQXJ 0 2
DRUNDMDQ8D5 0 1
DRUNDQ8QFB4 0 1
DRUNDQAA5N8 0 1
DRUNDR76JCP 0 1
DRUNDSKAKJZ 0 1
DRUNDVQELG6S8 0 3
DRUNDVWLP49 0 1
DRUNDXN4KRG 0 1
DRUNDY4P3J9 0 1
DRUNDZSNAY3 0 1
DRUNF7SXES9 0 1
DSHTV1000J5W4R3R 1 0
DSHTV1000J6SNVVP 0 1
DSHTV1000JAFP48W 1 0
DSHTV1000JE4VWER 1 0
DSHTV1000JHVYELZ 0 1
DSHTV1000JN966ZV 0 2
DSHTV1000JP6WGHT 0 1
DSHTV1000JYCLN79 2 0
DSHTV1000JZLX5DU 0 1
DSHTV600JB2CGMKT 1 0
DSHTV600JB3C2VEB 2 0
DSHTV600JB7EQ78J 1 0
DSHTV600JBHUUMBQ 1 0
DSHTV600JBJ398P4 1 0
DSHTV600JBM7FML8 1 0
DSHTV600JBN2AV2M 0 1
DSHTV600JBNMS755 1 0
DSHTV600JBP5K5XT 1 0
DSHTV600JBQMZH26 1 0
DSHTV600JBQRQH7Z 0 2
DSHTV600JBTC8VEK 1 0
DSHTV600JBTNKT3X 0 1
DSHTV600JBTX2LH7 0 1
DSHTV600JBUGV9VD 1 0
DSHTV600JBV4QU89 1 0
DSHTV600JBYEHZTP 1 0
DSHTV600JBYQ6ZZE 0 1
DUND333XY6 0 1
DUNDE6EPM6 0 2
DUNDGDE2HR 0 1
DUNDRJ4BBP 0 1
DUNFD9AZWH 0 1
EMPLP35JAB86QXCY 0 2
EMPLP35JAB8MGR2H 0 1
EMPLP35JABGUUF5D 0 2
EMPLP35JABHRRRVT 1 0
EMPLP35JABKCP7XW 0 1
EMPLP35JABLUY4RL 1 0
EMPLP35JABMU9LB7 1 0
EMPLP35JABPNVFGA 1 0
EMPLP35JABQ8TLHG 2 0
EMPLP35JABRL5HJV 1 0
EMPLP35JABSKWA8T 1 0
EMPLP35JABVJPMXW 2 0
EMPLP35JABWXFZTS 1 0
EMPLP35JABYB48HK 1 0
EXCD25SXDJ 0 1
EXCD26FNWL 0 1
EXCD28DRUS 0 1
EXCD2BZ7E3 0 1
EXCD2KFHG7 0 1
EXCD2KK8B4 0 1
EXCD2LZ2U5 0 1
EXCD2N4BEQ 0 1
EXCD2NYVFH 0 1
EXCD2RF2MC 0 1
EXCD2YTG46 0 1
EXCD2ZE22K 0 1
EXCD35BMS7 0 1
EXCD37T275 0 1
EXCD37T99T 0 1
EXCD38Z76C 0 1
EXCD39WCB4 0 1
EXCD3EMPZP 0 1
EXCD3HYDYN 0 1
EXCD3JTQQU 0 1
EXCD3MC7AZ 0 1
EXCD3MCULJ 0 1
EXCD3N754X 0 1
EXCD3PTP5W 0 1
EXCD3VNACU 0 1
EXCD3XYVZV 0 1
EXCD4BDH8Q 0 1
EXCD4BW3U6 0 1
EXCD4EN4BB 0 1
EXCD4EQMVV 0 1
EXCD4JADSE 0 1
EXCD4K282R 0 1
EXCD4KZVB9 0 1
EXCD4QJKUJ 0 1
EXCD4RRMTD 0 1
EXCD4U2LBC 0 1
EXCD4V8KVJ 0 1
EXCD4W4CNS 0 1
EXCD4Y3XSS 0 1
EXCD54RQKY 0 1
EXCD57GQVZ 0 1
EXCD5ACCM3 0 1
EXCD5LN8UV 0 1
EXCD5PYQHV 0 1
EXCD5W2DS5 0 1
EXCD5Z95UG 0 1
EXCD5ZPUNP 0 1
EXCD63VG7Z 0 1
EXCD647JRP 0 2
EXCD656GEK 0 1
EXCD66RTJ2 0 1
EXCD6BJUPQ 0 1
EXCD6BYWYJ 0 1
EXCD6CWFUF 0 1
EXCD6CYT78 0 1
EXCD6FZJVY 0 1
EXCD6KNK7U 0 1
EXCD6LH8FT 0 1
EXCD6VNCF4 0 1
EXCD6W7RWR 0 1
EXCD73GJ4Y 0 1
EXCD76C3E8 0 2
EXCD77AGLA 0 1
EXCD79J4VT 0 1
EXCD7AU24X 0 1
EXCD7ERV4K 0 1
EXCD7FZ6HX 0 1
EXCD7HN2LB 0 1
EXCD7N6QJY 0 1
EXCD7NVN44 0 1
EXCD7QHWPE 0 1
EXCD7T2Y2G 0 1
EXCD7VCXV7 0 1
EXCD85LLY9 0 1
EXCD85P499 0 1
EXCD89NZ4W 0 1
EXCD8GFLXG 0 1
EXCD8JC7GQ 0 1
EXCD8JS86N 0 1
EXCD8MC8FX 0 2
EXCD8TL4AH 0 1
EXCD8VE2GX 0 1
EXCD8ZEDKH 0 1
EXCD94M83D 0 1
EXCD9G476G 0 1
EXCD9GHSHH 0 1
EXCD9GLKNL 0 1
EXCD9JYLMW 0 1
EXCD9K2U4Y 0 1
EXCD9QG7P6 0 1
EXCD9QVWKE 0 1
EXCD9QX3TF 0 1
EXCD9X9XQT 0 1
EXCDA744R8 0 1
EXCDA8VEWG 0 1
EXCDAF5UAN 0 1
EXCDAMYSJM 0 1
EXCDAPAK3J 0 1
EXCDB2EGHR 0 1
EXCDB9P4JB 0 1
EXCDBAR7NY 0 1
EXCDBDE8RP 0 1
EXCDBLDEYN 0 1
EXCDBLKUSZ 0 1
EXCDBR47V8 0 1
EXCDBV2XEW 0 1
EXCDBVZZSY 0 1
EXCDBWDGHZ 0 1
EXCDBYRCM4 0 1
EXCDC4ARSU 0 1
EXCDC6V5LD 0 1
EXCDC9VN2S 0 1
EXCDCD92LA 0 1
EXCDCETXJU 0 1
EXCDCFMUMA 0 1
EXCDCGMWRP 0 1
EXCDCMVAK7 0 1
EXCDCQN4WW 0 1
EXCDCT6P39 0 1
EXCDCT86FN 0 1
EXCDCUU6RN 0 1
EXCDCVUNEV 0 1
EXCDCWJ7J2 0 1
EXCDD6YHN4 0 1
EXCDDDN6GW 0 1
EXCDDFA4GF 0 1
EXCDDFJJ7E 0 1
EXCDDKAESE 0 1
EXCDDKWXKX 0 1
EXCDDWQ77N 0 1
EXCDDYER35 0 1
EXCDDYVD8Y 0 1
EXCDE98FBS 0 1
EXCDE9X2K6 0 1
EXCDEEM87F 0 1
EXCDEKSBQ9 0 1
EXCDELB4C6 0 2
EXCDER5TKK 0 1
EXCDF2FSNU 0 1
EXCDF3HBZT 0 1
EXCDF477XZ 0 2
EXCDFLFKC4 0 1
EXCDFN9ZAW 0 1
EXCDFP7SGL 0 1
EXCDFSDGCB 0 1
EXCDFUK5B9 0 1
EXCDFYWUHP 0 1
EXCDFZGTA7 0 1
EXCDFZUEPU 0 2
EXCDG2MMKW 0 1
EXCDG6DZTJ 0 1
EXCDGABTLZ 0 1
EXCDGBUHSV 0 1
EXCDGCSZ3C 0 1
EXCDGDFLLZ 0 1
EXCDGK7N8Q 0 2
EXCDGMQALR 0 1
EXCDGV72LQ 0 1
EXCDGXLE4Q 0 1
EXCDGZSYLU 0 1
EXCDH4R4VZ 0 1
EXCDH5HJX5 0 1
EXCDH5PB9H 0 1
EXCDHJY6T4 0 1
EXCDHKBT6P 0 1
EXCDHNZAR4 0 2
EXCDHQXHRE 0 1
EXCDHRD5L4 0 1
EXCDHUDKVY 0 2
EXCDHXGBTB 0 2
EXCDHY3YT6 0 1
EXCDHZ4BEE 0 1
EXCDJ2XQG4 0 1
EXCDJ9C6DJ 0 1
EXCDJACEPJ 0 1
EXCDJAYDSB 0 1
EXCDJBPC8B 0 1
EXCDJMU9A9 0 1
EXCDJQQPFC 0 1
EXCDJQWH4Y 0 1
EXCDJUJ223 0 1
EXCDK4RM3N 0 1
EXCDK5BEVN 0 1
EXCDKG4QMS 0 1
EXCDKKSA74 0 1
EXCDKNG9T6 0 1
EXCDKP9KXF 0 1
EXCDKPNMEJ 0 1
EXCDKRSYV7 0 1
EXCDKTR723 0 1
EXCDKYJCVP 0 1
EXCDL2LAQB 0 1
EXCDL5NVPV 0 1
EXCDL69F2C 0 1
EXCDL7UGDZ 0 1
EXCDLACWVD 0 1
EXCDLATEJK 0 1
EXCDLBEWAG 0 1
EXCDLBX9ER 0 1
EXCDLK44JY 0 1
EXCDLKM8T2 0 1
EXCDLKYJPA 0 1
EXCDLL3RX5 0 1
EXCDLPGW4D 0 1
EXCDLPRYQ9 0 1
EXCDLSSQ78 0 1
EXCDLSUD5Y 0 2
EXCDLW5TDM 0 1
EXCDLWP8L4 0 1
EXCDLWPNBC 0 1
EXCDM27S92 0 1
EXCDM5KLJC 0 1
EXCDM6G5TM 0 1
EXCDM9B498 0 1
EXCDM9ZN9Z 0 1
EXCDMC7JPR 0 1
EXCDME6V47 0 1
EXCDMKTS8P 0 1
EXCDMRKZCH 0 1
EXCDMUGVA2 0 1
EXCDMV7NUW 0 1
EXCDMX58N2 0 1
EXCDMYWLF7 0 1
EXCDN26A7T 0 1
EXCDN3M6XT 0 1
EXCDNACQ44 0 1
EXCDNHYZMX 0 1
EXCDNJ5PNT 0 1
EXCDNQ2CCU 0 1
EXCDNU5BTR 0 1
EXCDNU5RH7 0 1
EXCDNVWUB8 0 1
EXCDP2ZMG4 0 1
EXCDP645E3 0 1
EXCDPBGD5J 0 1
EXCDPCX7VV 0 1
EXCDPDRL57 0 1
EXCDPG64Y3 0 1
EXCDPM7K6Y 0 1
EXCDPP36K3 0 1
EXCDPWA6K9 0 1
EXCDPXRX3G 0 1
EXCDPZ5NTG 0 1
EXCDQ3F7ME 0 1
EXCDQ5GN9L 0 1
EXCDQ5M83J 0 1
EXCDQ68EWH 0 1
EXCDQAWHMM 0 1
EXCDQD6CME 0 1
EXCDQJDKTG 0 1
EXCDQKJ7N3 0 1
EXCDQMETKL 0 1
EXCDQPWAJN 0 1
EXCDQRQGQN 0 1
EXCDQRWPTD 0 1
EXCDQSY4EA 0 1
EXCDQU6AN2 0 1
EXCDQU99W6 0 1
EXCDQWZHH2 0 1
EXCDR93E7U 0 1
EXCDRKKDYA 0 1
EXCDRL24DD 0 1
EXCDS5HURE 0 1
EXCDS6UE5G 0 1
EXCDS7S7D7 0 1
EXCDS8CFW9 0 1
EXCDSDR2UX 0 1
EXCDSFALL7 0 1
EXCDSGUUDW 0 1
EXCDSKZTHE 0 1
EXCDSQHXFL 0 1
EXCDST48TC 0 1
EXCDSU2C9Z 0 1
EXCDT4K8XE 0 1
EXCDT9HHGB 0 1
EXCDTAATVC 0 1
EXCDTD8RZW 0 1
EXCDTPH4B9 0 1
EXCDTPLVL5 0 1
EXCDTYNZ34 0 1
EXCDTYTZPP 0 1
EXCDU4SVU9 0 1
EXCDU5KFHG 0 1
EXCDU84BFC 0 1
EXCDUAYW58 0 1
EXCDUBC7PM 0 1
EXCDUCV4JE 0 2
EXCDUGWV9D 0 1
EXCDUJ8696 0 1
EXCDUK7FCK 0 1
EXCDUSQNAL 0 1
EXCDUT237J 0 1
EXCDUXHWJU 0 1
EXCDV2KWVV 0 1
EXCDV5MZDZ 0 1
EXCDV8PCBC 0 1
EXCDV8UZAG 0 1
EXCDV93ZTC 0 1
EXCDVB8R4L 0 1
EXCDVDU9QU 0 1
EXCDVFJMY4 0 1
EXCDVGGG6X 0 1
EXCDVGXFW7 0 1
EXCDVPGLAF 0 1
EXCDVU8BS9 0 1
EXCDVUXWPN 0 1
EXCDVX6EJ6 0 1
EXCDVYFD9G 0 1
EXCDW38QPS 0 1
EXCDW4PWUM 0 2
EXCDW6BL3T 0 1
EXCDWB47VA 0 1
EXCDWBYDDX 0 1
EXCDWGWYH8 0 1
EXCDWGZE59 0 1
EXCDWJ7PQG 0 1
EXCDWNHBBA 0 1
EXCDWSRVRV 0 1
EXCDWYGLMN 0 1
EXCDX2CWLN 0 1
EXCDX2X4Y5 0 1
EXCDX5Z67Z 0 1
EXCDXA5VQR 0 1
EXCDXF5HEH 0 1
EXCDXFMBVZ 0 1
EXCDXHP2SS 0 1
EXCDXHS3W3 0 1
EXCDXJ7YNM 0 1
EXCDXL7ZP9 0 1
EXCDXLB9MW 0 1
EXCDXU8S7A 0 1
EXCDXUFNRY 0 1
EXCDXW2LB6 0 1
EXCDXX5XRF 0 1
EXCDY57N87 0 1
EXCDYDE8XC 0 1
EXCDYFN2ME 0 1
EXCDYFUZJG 0 1
EXCDYLXX2R 0 1
EXCDYQ32BW 0 1
EXCDYSRVL4 0 1
EXCDYV925L 0 1
EXCDYXGZ8M 0 1
EXCDZ96WLB 0 1
EXCDZ9Q5MA 0 2
EXCDZACLP5 0 1
EXCDZBRWHL 0 1
EXCDZC4HA5 0 1
EXCDZF5GT5 0 1
EXCDZKMRSK 0 1
EXCDZLY6YP 0 1
EXCDZNHXRS 0 1
EXCDZQE8V6 0 1
EXCDZRYZ4A 0 1
EXCDZTCM5S 0 1
EXCDZV3HY7 0 1
EXCDZY25PA 0 1
FCHRV250JB23NL6S 2 0
FCHRV250JB2NRL66 1 0
FCHRV250JB2QSXQN 1 0
FCHRV250JB2UC4SC 2 0
FCHRV250JB36CAA4 0 1
FCHRV250JB39HNHR 1 0
FCHRV250JB39S4CX 1 0
FCHRV250JB3GXD8U 1 0
FCHRV250JB3J24NK 1 0
FCHRV250JB3LZA9N 1 0
FCHRV250JB4VRKD7 0 1
FCHRV250JB5PG6XV 1 0
FCHRV250JB68BJ7Z 0 1
FCHRV250JB6KD8TY 2 0
FCHRV250JB6KSUPF 1 0
FCHRV250JB6NP23W 1 0
FCHRV250JB6NYGYM 2 0
FCHRV250JB7RF9UV 1 0
FCHRV250JB7YAREP 0 1
FCHRV250JB86V3FX 1 0
FCHRV250JB8CX5L5 0 1
FCHRV250JB8PSMGG 0 1
FCHRV250JB8VQPSD 1 0
FCHRV250JBAC48XU 1 0
FCHRV250JBAFY5P5 1 0
FCHRV250JBBDDB3B 0 1
FCHRV250JBBGFZAK 1 0
FCHRV250JBBNFH4S 1 0
FCHRV250JBCB38KA 1 0
FCHRV250JBCMLRUQ 1 0
FCHRV250JBCTS3UV 1 0
FCHRV250JBDSVTBY 1 0
FCHRV250JBEMPMLS 0 1
FCHRV250JBEPN2GD 1 0
FCHRV250JBEZWEQQ 2 0
FCHRV250JBF59JT7 1 0
FCHRV250JBF8YHF8 1 0
FCHRV250JBFN6VJQ 1 0
FCHRV250JBFSX5VZ 1 0
FCHRV250JBFXJG64 0 1
FCHRV250JBG4LQVL 1 0
FCHRV250JBGA635K 1 0
FCHRV250JBGVR3FZ 1 0
FCHRV250JBGYH2NZ 1 0
FCHRV250JBHR2DS3 1 0
FCHRV250JBJ69V3R 1 0
FCHRV250JBJPTEHA 0 1
FCHRV250JBJYKXTM 0 1
FCHRV250JBLDYBV5 1 0
FCHRV250JBLGCEX8 0 1
FCHRV250JBLP2CTP 0 1
FCHRV250JBLPE8NC 0 1
FCHRV250JBMCEKVG 0 1
FCHRV250JBMKK86R 1 0
FCHRV250JBMYHQ86 0 4
FCHRV250JBN8MSUN 1 0
FCHRV250JBN9VEPC 1 0
FCHRV250JBP42TJB 0 3
FCHRV250JBP6ALPG 1 0
FCHRV250JBPB7EXW 0 1
FCHRV250JBPS99X5 1 0
FCHRV250JBPYNUWD 1 0
FCHRV250JBRC4CTP 1 0
FCHRV250JBT4ANM9 3 0
FCHRV250JBTCYPPT 1 0
FCHRV250JBTK5GVK 0 1
FCHRV250JBTWKXM2 1 0
FCHRV250JBTX3F84 1 0
FCHRV250JBUHDFZ7 0 1
FCHRV250JBVL2FK2 1 0
FCHRV250JBWA6ZFV 2 0
FCHRV250JBWD6PXN 2 0
FCHRV250JBWDPJZF 1 0
FCHRV250JBWNJSKS 1 0
FCHRV250JBWV9UJX 1 0
FCHRV250JBWVC4DF 0 2
FCHRV250JBWZJ2EX 2 0
FCHRV250JBX3GRSN 0 1
FCHRV250JBX3YB3Y 1 0
FCHRV250JBX6Z2KY 1 0
FCHRV250JBXX6VTA 1 0
FCHRV250JBY2LX4B 0 1
FCHRV250JBY5KYMF 2 0
FCHRV250JBY7HACK 1 0
FCHRV250JBYY8SJ6 1 0
FCHRV250JBZ9X4JC 0 1
FCHRV250JBZJHH2F 1 0
FCHRV250JBZQHHDA 0 1
FCRRTO7323C 0 1
FCRRTOAR7MU 1 0
FCRRTOM4TZ8 2 0
FCRRTOU66SD 0 2
FCRRTOWFUAE 0 1
FCRRTOY9926 1 0
HAPPY30 96 111
HDFC30 75 0
HDFCB250 5 0
HIKEP30JAB2ZXSQF 0 1
HIKEP30JAB43S6PH 0 1
HIKEP30JAB4LUQFS 0 2
HIKEP30JAB4TDLS9 0 3
HIKEP30JAB4TDPFX 1 0
HIKEP30JAB4ULL5H 0 1
HIKEP30JAB5ELA2D 0 2
HIKEP30JAB7BLVYK 1 0
HIKEP30JAB8DTKTG 0 1
HIKEP30JAB98UBS5 0 2
HIKEP30JAB9EUZUB 0 2
HIKEP30JABBEZKX9 0 1
HIKEP30JABBR25PD 0 1
HIKEP30JABCHGNYF 1 0
HIKEP30JABD9JUGZ 1 0
HIKEP30JABEARHFG 0 1
HIKEP30JABEKH268 0 1
HIKEP30JABFX4B4A 0 1
HIKEP30JABGEY6ES 1 0
HIKEP30JABJYHXP6 0 1
HIKEP30JABJYN9WA 1 0
HIKEP30JABJZW5QU 0 1
HIKEP30JABKMSQPK 1 0
HIKEP30JABKSF5MB 0 1
HIKEP30JABLSHJLG 1 0
HIKEP30JABLX3TDW 1 0
HIKEP30JABMHXSDW 0 1
HIKEP30JABMZSXZR 0 1
HIKEP30JABNG54DQ 1 0
HIKEP30JABPUAEMV 1 0
HIKEP30JABS4B6XZ 0 1
HIKEP30JABTFTL2N 1 0
HIKEP30JABTJ79GN 0 2
HIKEP30JABTSFJD6 2 0
HIKEP30JABU3VL8T 0 1
HIKEP30JABUHAMQ6 1 0
HIKEP30JABW99KKL 1 0
HIKEP30JABWVP2RQ 0 1
HIKEP30JABYSDUZW 0 1
HIKEP30JABZW9SBL 0 1
HIKEP30MAYPH8J3D 0 1
HULKP30JABY5SLBJ 1 0
IBIBO30 3 2
ICICI30 69 0
ICICV250JG 40 0
ICICV500JG 235 0
IKFWA3000J97L2AT 0 1
IKFWA3000JTB7JB7 0 1
INDUSIND30 1 0
JABXP30JAB4F6YP3 0 2
JABXP30JAB86D72Q 1 0
JABXP30JAB87C8MD 2 0
JABXP30JABJDCYU8 0 1
JABXP30JABS8223V 1 0
JABXP30JABT6AQSQ 0 2
JABXP30JABVSKW2D 1 0
JABXP30JABVVGUCA 1 0
JABXP30JABZ692CZ 0 1
JABXP30JABZBD2Z4 1 0
JEGQ25 1 6
JEMLV3005D9 7 1
JEMLV3007KX 2 1
JEMLV300FAV 4 5
JEMLV300HX2 0 2
JEMLV300UJ5 1 3
JSEOC1000JTXW6MX 1 0
KOTAK30 6 0
KOTKV250SC 3 0
LIVEP10 9 2
LUMIA2403ARTA7 0 1
LUMIA24067JHJH 0 1
LUMIA240779VLB 1 0
LUMIA240B3DHEP 1 0
LUMIA240BFL32K 1 0
LUMIA240CB56X9 0 1
LUMIA240J3MFB4 0 1
LUMIA240KERWRM 0 1
LUMIA240M9UDEL 0 2
LUMIA240SCVEK3 0 1
LUMIA240VH828P 0 2
LYLAP20MWBQZ934A 1 0
LYLFA050JBPAXJNZ 0 1
MAGZP27PNT 1 6
MAGZP30MAD 1 2
MAGZP30MAP 0 2
MB20 1 1
MISBP15KC8T2Z 0 1
MISSYOU400M6QD 12 7
MISSYOU400RXMJ 6 2
MRMAV250JBV964QL 0 1
MRMAV250JBW5BD86 0 1
MY350 2 1
MYDALA150 1 0
MYDAV350JB5DSS9L 0 1
MYDAV350JBA2RJBN 1 0
MYDAV350JBQ6QSRL 1 0
NEW20 1 7
NEW25 103 115
NEW30 258 522
NIL 10642 19229
ORD2JUWUJ3V 0 1
ORD4WXUL9 0 1
ORD53CUCFJW 0 1
ORD7DK9M52R 0 1
ORD7SA5AGWW 1 0
ORDBAHEP5JY 0 1
ORDCLW6C2AA 0 1
ORDG4PLBD9L 0 1
ORDGBJWZK9G 0 1
ORDJMW36W9N 0 1
ORDLFG87V 0 1
ORDLNPMWRUW 0 2
ORDMCKWK6CF 0 6
ORDPLQEZTA6 1 0
ORDQBZZJH9V 0 1
ORDU5KVQZD7 0 1
ORDV8EDBLDE 0 2
ORDW3UUE7RL 0 1
ORP9WTC7A 0 1
ORPF3EQLP 0 1
ORPJRAH8B 0 1
ORPY7CSMZ 0 1
OYESC500EVEHTVSS 0 1
PANASONIC600 8 15
PAYMP20PJB2T2TTF 1 0
PAYMP20PJB3FQ7P7 1 0
PAYMP20PJB3WX6VD 0 1
PAYMP20PJB4DJ4YP 1 0
PAYMP20PJB4FXYQ8 1 0
PAYMP20PJB4VVFJV 0 1
PAYMP20PJB7598FZ 2 0
PAYMP20PJB7Q6XK8 1 0
PAYMP20PJB7XQJ3Z 1 0
PAYMP20PJB86C9MH 1 0
PAYMP20PJB88LPFE 1 0
PAYMP20PJB9KH2W7 1 0
PAYMP20PJB9MTVY7 1 0
PAYMP20PJBA9X47M 0 1
PAYMP20PJBAWGUXL 1 0
PAYMP20PJBC2FHE7 0 5
PAYMP20PJBCH7SUV 1 0
PAYMP20PJBCQHUEA 2 0
PAYMP20PJBDGDQBB 1 0
PAYMP20PJBDL4MPE 1 0
PAYMP20PJBE9PZ3L 0 1
PAYMP20PJBEBWUSQ 1 0
PAYMP20PJBEE7TFJ 1 0
PAYMP20PJBEXRNK9 1 0
PAYMP20PJBGZD8EV 1 0
PAYMP20PJBH7RNRP 1 0
PAYMP20PJBHUSEQU 1 0
PAYMP20PJBK5Z7HU 0 1
PAYMP20PJBKTZWHM 0 1
PAYMP20PJBMABFHY 1 0
PAYMP20PJBNFGY3R 1 0
PAYMP20PJBNMKGDR 3 0
PAYMP20PJBNYLQSL 0 1
PAYMP20PJBPG2BK8 0 1
PAYMP20PJBPLTDAB 1 0
PAYMP20PJBRA7V57 0 1
PAYMP20PJBS8N2NG 1 0
PAYMP20PJBSQRFCQ 1 0
PAYMP20PJBT3833M 1 0
PAYMP20PJBTA2E7Y 1 0
PAYMP20PJBTPEVZX 1 0
PAYMP20PJBV267RZ 0 5
PAYMP20PJBVFY8RS 0 1
PAYMP20PJBVLV46S 1 0
PAYMP20PJBVURBX3 0 1
PAYMP20PJBW5KQ5W 1 0
PAYMP20PJBW9CUTA 0 2
PAYMP20PJBWJYEPK 1 0
PAYMP20PJBWS5RLS 1 0
PAYMP20PJBX4ZFMP 2 0
PAYMP20PJBY4ZDW3 2 0
PAYMP20PJBZ6TM9W 1 0
PAYMP20PJBZFRSNK 4 0
PAYMP20PJBZXN7AE 3 0
PAYMV250JB26N5VT 2 0
PAYMV250JB26XBJK 0 1
PAYMV250JB29W2CG 1 0
PAYMV250JB2CKTXV 2 0
PAYMV250JB2JCS37 1 0
PAYMV250JB2MUHSV 0 1
PAYMV250JB2NNAVC 1 0
PAYMV250JB2QUC7Q 1 0
PAYMV250JB2RBGNS 0 2
PAYMV250JB2RSBE3 1 0
PAYMV250JB2U4725 0 1
PAYMV250JB2V5GQU 1 0
PAYMV250JB2W4322 1 0
PAYMV250JB32JT7H 1 0
PAYMV250JB345476 1 0
PAYMV250JB3876VL 2 0
PAYMV250JB3DNAFS 1 0
PAYMV250JB3LRJ5S 0 2
PAYMV250JB3PVCPD 0 1
PAYMV250JB3RYLSB 1 0
PAYMV250JB3STLFS 1 0
PAYMV250JB3TBTRH 0 1
PAYMV250JB3VVGML 1 0
PAYMV250JB437W2Q 1 0
PAYMV250JB44L9RT 1 0
PAYMV250JB4ABDX8 1 0
PAYMV250JB4BR3S5 1 0
PAYMV250JB4GC2DG 0 1
PAYMV250JB4GDYHC 1 0
PAYMV250JB4N9BVM 1 0
PAYMV250JB4PY58T 0 1
PAYMV250JB4VRHND 2 0
PAYMV250JB4XBN5Z 1 0
PAYMV250JB4Z9VDG 1 0
PAYMV250JB54ZAL4 2 0
PAYMV250JB5ELVTE 1 0
PAYMV250JB5QVVFR 1 0
PAYMV250JB5QY6HV 1 0
PAYMV250JB5S8UWN 1 0
PAYMV250JB5SUJEA 0 1
PAYMV250JB5TPEQT 2 0
PAYMV250JB5UDU6H 0 1
PAYMV250JB5W3EQD 1 0
PAYMV250JB667WDM 1 0
PAYMV250JB6725R6 1 0
PAYMV250JB68R6NH 0 1
PAYMV250JB6AUDDQ 1 0
PAYMV250JB6B34U5 0 1
PAYMV250JB6B3FVS 2 0
PAYMV250JB6C8L3T 1 0
PAYMV250JB6H4SQ5 0 1
PAYMV250JB6MZQQ4 1 0
PAYMV250JB6NG4MP 0 1
PAYMV250JB6NJQ8Z 0 1
PAYMV250JB6QTZHD 1 0
PAYMV250JB6RAPN4 2 0
PAYMV250JB6T3N9R 1 0
PAYMV250JB76WKZW 1 0
PAYMV250JB7EK6QC 1 0
PAYMV250JB7FFWLY 2 0
PAYMV250JB7GBCEC 2 0
PAYMV250JB7N8PKH 1 0
PAYMV250JB7P6DGP 1 0
PAYMV250JB7PU3LP 3 0
PAYMV250JB7U8FCJ 1 0
PAYMV250JB7V7RSY 1 0
PAYMV250JB826VLY 0 1
PAYMV250JB85VXT8 1 0
PAYMV250JB8G7AWQ 0 1
PAYMV250JB8GE3WY 1 0
PAYMV250JB8JEQ33 1 0
PAYMV250JB8NMUKJ 3 0
PAYMV250JB8Y6UV4 1 0
PAYMV250JB94GEJ6 2 0
PAYMV250JB99282U 2 0
PAYMV250JB99V4R6 1 0
PAYMV250JB9AXM3X 1 0
PAYMV250JB9ESZBZ 0 1
PAYMV250JB9J2YLT 1 0
PAYMV250JB9P3NAE 1 0
PAYMV250JBAFZHGD 0 2
PAYMV250JBANMBG7 1 0
PAYMV250JBB3CR8X 1 0
PAYMV250JBB3P5TK 1 0
PAYMV250JBB4KE7E 3 0
PAYMV250JBB6NUHZ 1 0
PAYMV250JBBAV82R 1 0
PAYMV250JBBCMJ8W 1 0
PAYMV250JBBP9523 1 0
PAYMV250JBBPKC7T 1 0
PAYMV250JBBQ5CNY 1 0
PAYMV250JBBZWY4Z 1 0
PAYMV250JBC7CRHQ 1 0
PAYMV250JBC89ZRS 0 1
PAYMV250JBC8F32L 1 0
PAYMV250JBCG5KYE 0 1
PAYMV250JBCKVDMQ 2 0
PAYMV250JBCLD2Y6 1 0
PAYMV250JBCZKAWY 1 0
PAYMV250JBD2PMUW 1 0
PAYMV250JBD5CPFU 1 0
PAYMV250JBDUR5WF 1 0
PAYMV250JBDYASVT 1 0
PAYMV250JBE42DF5 1 0
PAYMV250JBE7JLS4 0 3
PAYMV250JBEDFYE3 2 0
PAYMV250JBEKES5Y 0 1
PAYMV250JBEKSGCZ 1 0
PAYMV250JBEKUSSR 1 0
PAYMV250JBEL4GKT 0 1
PAYMV250JBELFMDP 1 0
PAYMV250JBELR69N 0 1
PAYMV250JBENG2SJ 0 1
PAYMV250JBENXLUW 1 0
PAYMV250JBEQTBX7 2 0
PAYMV250JBES48A9 3 0
PAYMV250JBF26KQC 1 0
PAYMV250JBF3GQDH 1 0
PAYMV250JBFCS8F6 0 1
PAYMV250JBFHZDTH 1 0
PAYMV250JBFRNTXA 1 0
PAYMV250JBFTU5YZ 1 0
PAYMV250JBFWQX7R 1 0
PAYMV250JBFYDVWE 1 0
PAYMV250JBG2B927 2 0
PAYMV250JBG7KKV2 1 0
PAYMV250JBG83Z3K 1 0
PAYMV250JBG85X4K 1 0
PAYMV250JBGCXRHS 2 0
PAYMV250JBGEMGPY 1 0
PAYMV250JBGJ7SNT 0 1
PAYMV250JBGJL7N7 1 0
PAYMV250JBGRBKKC 1 0
PAYMV250JBGS2Q4W 1 0
PAYMV250JBH2M85R 1 0
PAYMV250JBH8DYSQ 0 1
PAYMV250JBHD2NHW 2 0
PAYMV250JBHETDJP 1 0
PAYMV250JBHHKSX4 1 0
PAYMV250JBHPDT5D 0 1
PAYMV250JBHT8THT 1 0
PAYMV250JBHV56JF 1 0
PAYMV250JBHVHLM5 1 0
PAYMV250JBJ257GF 1 0
PAYMV250JBJ49ZE3 1 0
PAYMV250JBJ835Y2 1 0
PAYMV250JBJ8J5XU 2 0
PAYMV250JBJ98G8Y 1 0
PAYMV250JBJAWPEP 1 0
PAYMV250JBJDCQWN 1 0
PAYMV250JBJLPJYT 2 0
PAYMV250JBJSDVDE 3 0
PAYMV250JBJVLMER 1 0
PAYMV250JBJW792T 1 0
PAYMV250JBK62UDR 3 0
PAYMV250JBK7VLCG 1 0
PAYMV250JBKAD3H2 0 1
PAYMV250JBKCPGMZ 1 0
PAYMV250JBKERNRW 1 0
PAYMV250JBKMHB54 1 0
PAYMV250JBKSMARQ 1 0
PAYMV250JBKTSPBE 1 0
PAYMV250JBKU6KMU 1 0
PAYMV250JBKY5NPD 1 0
PAYMV250JBL2Y94K 0 1
PAYMV250JBL4XWCV 1 0
PAYMV250JBL68BTM 1 0
PAYMV250JBL755SX 1 0
PAYMV250JBLFSUNQ 0 1
PAYMV250JBLLCRL2 1 0
PAYMV250JBLLSRK5 1 0
PAYMV250JBLR428R 1 0
PAYMV250JBLX2LFH 0 1
PAYMV250JBLYX8NU 1 0
PAYMV250JBM45NSX 0 1
PAYMV250JBMEH6XP 0 2
PAYMV250JBMF9X3W 0 1
PAYMV250JBMKHHH4 0 1
PAYMV250JBMN8QSS 2 0
PAYMV250JBNH5XPA 0 1
PAYMV250JBNHSJXG 1 0
PAYMV250JBNJL3CA 1 0
PAYMV250JBNRE38W 1 0
PAYMV250JBNWK7J8 0 1
PAYMV250JBPAVH6B 2 0
PAYMV250JBPD7ZZ3 1 0
PAYMV250JBPDY8AR 0 1
PAYMV250JBPKXS2L 0 2
PAYMV250JBPNPBD9 1 0
PAYMV250JBPPTZYL 0 1
PAYMV250JBPPWG9E 1 0
PAYMV250JBPQARXJ 0 1
PAYMV250JBPQNPPT 0 2
PAYMV250JBPWR9AN 1 0
PAYMV250JBPWWTFA 2 0
PAYMV250JBQ4V47N 0 2
PAYMV250JBQ6TVM8 1 0
PAYMV250JBQAQ5CQ 1 0
PAYMV250JBQGGT3H 1 0
PAYMV250JBQVL9Z9 1 0
PAYMV250JBQVMAMW 1 0
PAYMV250JBQXMBNU 1 0
PAYMV250JBQXVBV9 0 2
PAYMV250JBR47LUY 2 0
PAYMV250JBR56TMR 1 0
PAYMV250JBR98KMY 1 0
PAYMV250JBRB5UMV 1 0
PAYMV250JBRGXEEJ 1 0
PAYMV250JBRHME8P 2 0
PAYMV250JBRJV8G3 1 0
PAYMV250JBRM9QYT 1 0
PAYMV250JBS64K8S 1 0
PAYMV250JBS6KJJC 0 1
PAYMV250JBSR6PXU 0 1
PAYMV250JBSZYG2A 1 0
PAYMV250JBT896ZV 1 0
PAYMV250JBTB4T8U 1 0
PAYMV250JBTU8X5M 0 1
PAYMV250JBTXVWMA 1 0
PAYMV250JBU4MSC6 1 0
PAYMV250JBU7TCW4 0 2
PAYMV250JBU7WCX3 2 0
PAYMV250JBUGSFQN 1 0
PAYMV250JBUNW4EV 0 2
PAYMV250JBURV4B2 1 0
PAYMV250JBUSAHVM 0 1
PAYMV250JBUZT7QJ 0 1
PAYMV250JBV2JRVL 0 1
PAYMV250JBV4CBWY 1 0
PAYMV250JBVA3LDY 1 0
PAYMV250JBVCDM4Q 1 0
PAYMV250JBVT2H46 0 1
PAYMV250JBVULFST 1 0
PAYMV250JBVVA3PD 1 0
PAYMV250JBVZFFJW 1 0
PAYMV250JBW3VDWW 1 0
PAYMV250JBW7M4XQ 1 0
PAYMV250JBWA9BUD 1 0
PAYMV250JBWCYW9Z 1 0
PAYMV250JBWJ6DGF 1 0
PAYMV250JBWR9EFY 1 0
PAYMV250JBWU5EW5 1 0
PAYMV250JBWY9VJW 1 0
PAYMV250JBX4KNH7 0 1
PAYMV250JBX9GASU 1 0
PAYMV250JBX9UV4Q 1 0
PAYMV250JBXKRC5U 1 0
PAYMV250JBXX4BXE 1 0
PAYMV250JBY587PY 1 0
PAYMV250JBY5EUKU 1 0
PAYMV250JBY89NYJ 1 0
PAYMV250JBYDLA77 1 0
PAYMV250JBYGQDAY 1 0
PAYMV250JBYSQQCE 1 0
PAYMV250JBYVRFP2 1 0
PAYMV250JBYWTQ54 1 0
PAYMV250JBZ662W4 1 0
PAYMV250JBZ6B6JU 1 0
PAYMV250JBZ8JJJN 1 0
PAYMV250JBZC8F4F 1 0
PAYMV250JBZDL8ZY 1 0
PAYMV250JBZFZEAD 0 1
PAYMV250JBZGE57G 1 0
PAYMV250JBZLSKM7 0 1
PAYMV250JBZV3K47 0 1
POLO20 0 1
PYTMP25JAB3JP9NZ 0 1
PYTMP25JAB6TV5EK 1 0
PYTMP25JAB88FDCJ 1 0
PYTMP25JABCCENS5 1 0
PYTMP25JABCUR4X8 1 0
PYTMP25JABEB5HWN 1 0
PYTMP25JABGETWM8 1 0
PYTMP25JABGSV66W 1 0
PYTMP25JABHFPHLH 1 0
PYTMP25JABLFD62N 1 0
PYTMP25JABM3X9ZN 1 0
PYTMP25JABN85C3U 0 1
PYTMP25JABQHUMED 1 0
PYTMP25JABQWLDN7 1 0
PYTMP25JABUBYG93 0 1
PYTMP25JABV5BENS 0 2
PYTMP25JABYAQGHE 1 0
PYTMP25JABYV25WN 0 1
PYTMP25JABZ9JVGL 1 0
R360C100EVC444ZG 1 0
R360C500EV8Y376L 0 1
R360C500EVY9XKEN 0 1
REA200 2 2
REA300 1 5
REA500 5 2
REBRC3000J65V55F 0 1
RUND4YRU5J 0 1
RUND5PAZ67 0 1
RUND7DWM7N 0 1
RUND7P2LQU 0 1
RUND8SEXDN 0 1
RUND97CTBQ 0 1
RUNDFHJ9LE 0 1
RUSH25 26 22
RUSH30 463 681
SALE30 580 719
SAMSUNG30 3 3
SANFE20 0 1
SBIRC1610EWSQZXX 2 0
SBIRC1714E3LD5VM 0 1
SBIRC2457EU6KBF6 0 3
SBIRC3000E33HR73 0 1
SBIRC3000E3H738Z 0 2
SBIRC3000E3KHPXR 1 0
SBIRC3000E4CCMV9 1 0
SBIRC3000E5FWDQ2 0 1
SBIRC3000E6DKYC7 0 1
SBIRC3000E72U9SB 0 1
SBIRC3000E78QXLG 0 1
SBIRC3000E8MFY4S 3 0
SBIRC3000E95J6PZ 0 2
SBIRC3000EAEPKX5 0 1
SBIRC3000EBA2X48 0 1
SBIRC3000EBY3ESH 1 0
SBIRC3000ED7MSYG 1 0
SBIRC3000EDL3Z4X 1 0
SBIRC3000EFGXG97 1 0
SBIRC3000EFRD4WK 0 1
SBIRC3000EGU78X5 0 1
SBIRC3000EH7PHFX 1 0
SBIRC3000EJK4AW2 2 0
SBIRC3000EL44ZN6 1 0
SBIRC3000EM2ATX4 0 1
SBIRC3000ESZN55N 0 1
SBIRC3000EW5KM8X 1 0
SBIRC3000EXCUVUY 1 0
SBIRC3000EZ68WZW 1 0
SBIRC5000E26V97J 1 0
SBIRC5000E3Z8TV3 0 2
SBIRC5000E62B55Z 0 3
SBIRC5000EAHDGGD 0 2
SBIRC5000EBHSDEM 0 4
SBIRC5000EBJ7DTB 1 0
SBIRC5000EBP4Z6E 0 1
SBIRC5000EKMFP4F 0 1
SBIRC5000EMJAGRL 0 1
SBIRC5000EPRK5QA 0 1
SBIRC5000ERF4JJB 0 3
SBIRC5000ERHQN7T 0 1
SBIRC899EV85GDER 0 1
SDCRV500JB3VM4PF 0 1
SDCRV500JB7XRM8S 1 0
SDCRV500JBTU8ZVL 0 1
SHOP1000 3 7
SHOP300 16 13
SHOP500 12 7
SHOP750 0 3
SNW20 29 30
SODEXOD20 32 25
SODEXOD600 14 11
SORRYRE35TQW 1 0
SORRYRE48EPD 1 0
SORRYRNRTNZZ4 0 1
SPELP50JAB6U2BWL 1 0
SPORTS20 5 3
SPORTS30 0 7
STAN30 2 0
STYLE20 87 130
STYLE25 376 431
STYLE30 710 989
T10KRG 1 0
TASYP30PJB38LAYP 1 0
TASYP30PJB5J2JHB 1 0
TASYP30PJB7ZQC2U 0 1
TASYP30PJB8AMM2N 1 0
TASYP30PJBBEFL7R 0 1
TASYP30PJBBMVXZD 0 2
TASYP30PJBDESHU8 1 0
TASYP30PJBEASMUY 1 0
TASYP30PJBFNGBGM 1 0
TASYP30PJBH88QK7 1 0
TASYP30PJBLJC83R 1 0
TASYP30PJBLPR8AS 1 0
TASYP30PJBLY8Q9K 3 0
TASYP30PJBM3HBER 1 0
TASYP30PJBML2KFD 2 0
TASYP30PJBN4BKEL 2 0
TASYP30PJBNF6PG9 2 0
TASYP30PJBQ7QVQZ 0 1
TASYP30PJBSXFXGV 0 1
TASYP30PJBU25UN2 1 0
TASYP30PJBUE9ZKD 1 0
TASYP30PJBVKUGXU 1 0
TASYV250JB333M4N 1 0
TASYV250JB3LDP3H 1 0
TASYV250JB3U6JLJ 1 0
TASYV250JB4VRY8N 1 0
TASYV250JB7B3N7H 1 0
TASYV250JB7PZ635 1 0
TASYV250JBB8CX74 2 0
TASYV250JBC3LPRS 1 0
TASYV250JBDHW3JT 1 0
TASYV250JBDXZ2H8 1 0
TASYV250JBFA2HYN 1 0
TASYV250JBFMRFS8 0 1
TASYV250JBFX6248 1 0
TASYV250JBKFJJTC 1 0
TASYV250JBKXYVQ8 0 1
TASYV250JBLHMRA2 1 0
TASYV250JBLLWDD7 0 1
TASYV250JBMAPY5R 1 0
TASYV250JBN38R2P 1 0
TASYV250JBNAVH56 0 1
TASYV250JBNTB9ZG 1 0
TASYV250JBNW7ZVC 2 0
TASYV250JBPNJP99 1 0
TASYV250JBQ66WR6 1 0
TASYV250JBQEJYGP 2 0
TASYV250JBQXN4U9 4 0
TASYV250JBRCDDX7 1 0
TASYV250JBS6WQT7 1 0
TASYV250JBVEFPMW 1 0
TASYV250JBWZ474R 1 0
TASYV250JBX22K27 0 1
TASYV250JBY7N7Z2 1 0
TASYV250JBZC642Q 0 1
TASYV250JBZGZTPA 0 1
TATAD500 2 0
TESTINGAUTOLIVE 0 1
TT30 1 12
VDCNV250JB 1 0
WC3005516c499e1895 1 0
WC3005517a23083414 0 1
WC3005518a8e76e12b 0 1
WC300551d4cae14764 2 0
WC300551d726b77144 1 0
WC300551edc48beadb 2 1
WC300551f832221393 1 0
WC300551fb7027d647 3 0
WC300551fdace99ea9 1 0
WC300551fe39f1c7a4 1 0
WC3005520e5cf74883 0 1
WC300552144d476b99 0 1
WC3005521763a392ba 0 1
WC300552200e9bcf7c 1 0
WC3005522405faeeef 0 1
WC30055225873893c3 0 1
WC300552293e0f40fb 1 0
WC300552297e25f1cb 1 0
WC30055229e0b3d91a 1 0
WC3005522a40d56a0c 0 1
WC3005522a7356b8f6 0 1
WC3005522b1db72ec9 0 1
WC30055235f732fc4b 0 1
WC30055238cdd8540e 0 1
WC3005523971b2c9e9 0 1
WC3005523ae07af4e1 1 0
WC3005523b1b521a8c 1 0
WC3005523b32853721 1 0
WC3005523f70f376f2 2 0
WC30055240d323e978 0 1
WC300552424babf9d5 0 1
WC3005524e97b0cb1c 1 0
WC30055255809daa0d 0 3
WC30055256c4229fcb 0 1
WC3005525854400d26 0 1
WC300552600a508843 1 0
WC3005526a70414fef 1 0
WC3005526cd308bcf5 2 0
WC3005526efcecd1b2 2 0
WC30055273f2ca6971 1 0
WC300552753348d745 1 0
WC30055276faf17126 0 1
WC3005527894d1f768 2 0
WC3005527cbcf60ebc 1 0
WC30055280138764a3 0 1
WC300552842fd80b66 1 0
WC3005528cb5a1e386 0 1
WC3005528d8d8d3ca8 1 0
WC30055292fbc45544 1 0
WC3005529400f73320 2 0
WC30055295b636a8ea 2 0
WC300552a3d686041f 0 1
WC300552a426b6e78f 0 1
WC300552b7db2c93c8 1 0
WC300552b99f56c73d 1 0
WC300552bdd04952d3 0 3
WC300552bea24a0735 1 0
WC300552bf768d6635 0 2
WC300552bf9c89aac7 1 0
WC300552bfcf78c317 1 0
WC300552d2fd37c974 1 0
WC300552e2e4fab8c2 1 0
WC300552e2f9e652f8 0 2
WC300552e5ba637434 1 0
WC300552e768bb0386 1 0
WC300552e7c9cecee1 0 1
WC300552ea2adebb08 0 1
WC300552f171847d54 1 0
WC300552f403dcb17b 1 0
WC300552f4be495b49 1 0
WC300552f793fc74f4 1 0
WC300552f7dd4c1083 1 0
WC300552f82c22bc62 1 0
WC300552fc5e4b2620 1 0
WC300552ff4c2c029f 1 0
WC300552ff522c90ec 1 0
WC300552ffa0319a43 1 0
WC300553082ad0de55 0 1
WC30055309f8601e21 2 0
WC3005530ce82d0aa6 0 2
WC3005530ef3056fd1 2 0
WC30055315ae6ec0de 1 0
WC3005532065cf2381 1 0
WC300553277e90ed2c 1 0
WC30055329fd6cf484 1 0
WC3005532a0d3c04b4 1 0
WC3005532ab489f92b 0 1
WC3005532c728c6526 1 0
WC3005533699fbd058 1 0
WC30055337d590968a 0 1
WC30055337ff2a5831 0 1
WC3005533a9b0b9346 2 0
WC3005533b1b1c9346 0 1
WC3005533bde2aadcf 1 0
WC30055348bec156a5 1 0
WC3005534974a016c8 1 0
WC3005534beb393f11 1 0
WC3005534e7837a342 1 0
WC3005535fa2779f29 2 0
WC30055361994af214 1 0
WC30055365f91e627f 1 0
WC30055367ab57910b 1 0
WC30055368bfeb784e 2 0
WC30055371a77d8088 1 0
WC3005537cdd17cbfb 0 1
WC300553892c05bf9c 1 0
WC3005538da64a633e 0 1
WC3005539241d16123 1 0
WC30055396f5233017 0 1
WC3005539b0c556f52 1 0
WC3005539fd7e63cbf 1 0
WC300553a01efda312 2 0
WC300553a14ba4a540 0 1
WC300553a1b1e52e9b 1 0
WC300553a20c2a126b 2 0
WC300553a26ce62fb5 0 1
WC300553a6fc4e8e46 0 1
WC300553a76b35429b 0 1
WC300553abd86f2216 0 1
WC300553b271ea2001 0 1
WC300553b39d644e67 0 1
WC300553b4149c35b2 0 1
WC300553b48f845ea4 1 0
WC300553b5fe6d003c 0 1
WC300553b750de3734 1 0
WC300553bb93276155 1 0
WC300553bcef88fd81 1 0
WC300553be98a5f463 1 0
WC300553c70d9a76ea 0 1
WC300553c925578508 0 1
WC300553c98f2bfdeb 1 0
WC300553c9a4bc4712 0 1
WC300553cdbe27a06b 0 1
WC300553d015902136 0 1
WC300553d01f72cbf6 0 1
WC300553d2123508e6 1 0
WC300553d40a97f0a0 1 0
WC300553dd501347ab 1 0
WC300553dd893f1021 0 1
WC300553e05a84124f 0 1
WC300553e0ab0c5ba9 0 1
WC300553e1c037b276 2 0
WC300553f0c315704c 0 1
WC300553f9cbf62de7 0 2
WC300554030563ecb4 3 0
WC300554077c22f11c 1 0
WC300554099537724c 2 0
WC3005540c2e14f790 1 0
WC300554120387ac83 0 1
WC300554128e986752 1 0
WC3005541a993b47a7 0 1
WC3005541e5c387229 0 1
WC3005542341ae10dd 0 1
WC300554238ad7a432 0 1
WC30055424d9f99dbc 0 1
WC300554275a0d7b78 1 0
WC300554336bba5efe 0 1
WC30055433a8de9315 1 0
WC3005543723e825c0 1 0
WC30055437968c710a 1 0
WC300554380f0aed96 0 1
WC30055438ee01323f 1 0
WC300554395f5d461a 1 0
WC30055441d0b5b59d 1 0
WC3005544674f9807d 1 0
WC3005544701c01300 1 0
WC3005544d88799d2b 0 1
WC3005544ea95a6848 1 0
WC3005545fa6223075 0 1
WC300554609a44d01f 0 2
WC30055463108bc8a1 1 0
WC30055467232809c3 1 0
WC3005546f0ee8e1f2 0 1
WC30055478748354bf 1 0
WC3005547aa54d22c8 1 0
WC3005548411129903 0 1
WC300554892f13bee0 0 1
WC500551d02e121dfb 2 0
WC500551e9c8745bac 0 1
WC500551eb5ad016ee 0 3
WC500551f809b179ac 1 0
WC500551f832221972 1 0
WC5005520076aa3862 2 0
WC5005520fe4768150 0 1
WC50055213222a1dce 0 1
WC500552183576d06b 1 0
WC50055223c1e69430 0 1
WC5005522486e7f392 0 1
WC50055225552f1af3 1 0
WC50055228d3b3c8f2 0 1
WC5005522a40d56f85 0 1
WC500552317634934c 0 1
WC50055241ceabd8f4 0 1
WC5005524e6528eab2 0 1
WC500552583c3a4b53 2 0
WC50055263f276cade 0 1
WC500552662b7a6065 1 0
WC50055278efded4f3 1 0
WC5005527f715a91e6 0 1
WC500552811eb41040 0 1
WC5005528fc1f3d48a 0 3
WC50055290028d8521 1 0
WC50055294de19cc4c 0 1
WC500552a0481c3ea1 0 2
WC500552a2b4119cf4 0 1
WC500552a4d7615d3c 1 0
WC500552a738426f41 2 0
WC500552a9c0ff265c 1 0
WC500552ac3aa080bb 0 1
WC500552b4ba7acfdd 2 0
WC500552b60d8116f7 1 0
WC500552bbb15841b3 1 0
WC500552bea92399b4 1 0
WC500552beb52bad2e 1 0
WC500552d657d39c1a 0 1
WC500552deb649a4b2 2 0
WC500552e15d38ba30 1 0
WC500552e69894439d 1 0
WC500552ebae886aaf 1 0
WC500552f4be4961f3 2 0
WC500552fc495951ed 2 0
WC50055309f86024ec 1 0
WC5005530add31ea27 2 0
WC5005530bfa7a8ebd 0 1
WC500553133ec26174 1 0
WC500553141e83ec67 0 3
WC5005531b5563b737 2 0
WC5005532304f8197d 0 2
WC5005532503300467 0 2
WC50055325a216b4bb 0 1
WC50055326f7b534b9 1 0
WC5005532988e0798d 1 0
WC500553353590985f 1 0
WC5005533b0fc04892 1 0
WC5005533c43c5ff3c 1 0
WC50055349788b9323 0 1
WC5005534b9952197d 0 1
WC5005534dd2246ade 1 0
WC5005534e83949304 1 0
WC5005535d88a2a735 2 0
WC50055362f4728afc 0 1
WC50055363e2f3d99f 1 0
WC5005537648ad7e8f 2 0
WC5005537853881bac 1 0
WC500553789a10a02e 1 0
WC5005537cf6c0cdaa 1 0
WC5005537fb1da7aae 0 1
WC5005538a026d4c07 1 0
WC5005539125fe7528 0 1
WC50055392eec6ba26 0 2
WC500553930008cc4c 0 1
WC5005539543c87819 1 0
WC50055399a580194d 0 2
WC5005539dbcca7a7f 1 0
WC5005539f5602d2f0 1 0
WC500553a0439127bb 0 1
WC500553a29ff7f34b 3 0
WC500553a617a6b1fe 1 0
WC500553b16113dffe 1 0
WC500553b3d4b45ceb 1 0
WC500553b4c3aacfcb 0 1
WC500553b511868443 0 2
WC500553b749887957 0 2
WC500553b9a3e16a36 2 0
WC500553bf4f921309 0 1
WC500553c602473ad6 0 1
WC500553ce22a9c6dc 1 0
WC500553d110e3c9da 0 1
WC500553d2e1f78786 1 0
WC500553db4870e9f8 1 0
WC500553dd5bc55c35 1 0
WC500553e015e3e5ca 1 0
WC500553e05ca174a8 0 3
WC500553e0b11232c3 0 2
WC500553e1c037c36c 3 0
WC500553e325e2765d 0 2
WC500553e5a3667e9e 2 0
WC500553e9e35df054 0 1
WC500553f27091dbdb 0 1
WC500553fa2e8d9ed1 0 2
WC500553fcf73400ad 0 1
WC5005540aacd9a174 0 1
WC5005540c2e14fd3a 2 0
WC500554101c5e9a64 2 0
WC50055411257b9a82 1 0
WC5005541af65f00bd 2 0
WC5005541f77565d5e 1 0
WC50055423ca43a5bb 4 0
WC500554306f057af5 0 1
WC500554318e5d8ef0 0 1
WC5005543a2ae5ce6b 1 0
WC5005543bbb323066 0 1
WC5005543d6929f60c 0 2
WC50055447ed3b2f3f 2 0
WC5005544804a51e6e 1 0
WC5005545e1324d091 1 0
WC5005545f66722c2e 1 0
WC50055461012b1afe 1 0
WC500554675a0ef1f2 3 0
WC50055472de7a9072 0 1
WC50055475931cd4b0 1 0
WC50055483bb32a15e 0 1
WC50055485e0633fa1 0 1
WC50055488bab0f4fc 0 1
WCHTV200JB3D7CJ3 0 1
WCHTV200JB57CSD8 1 0
WCHTV200JB7GBXW7 0 1
WCHTV200JB9DDS66 0 1
WCHTV200JBAT6JGW 0 1
WCHTV200JBCT2D5M 2 0
WCHTV200JBD93QMS 0 1
WCHTV200JBLRQVEL 1 0
WCHTV200JBLV97J4 0 1
WCHTV200JBMKH9ZH 1 0
WCHTV200JBP2K5D5 0 1
WCHTV200JBQPVDUY 1 0
WCHTV200JBS34NU2 0 1
WCHTV200JBYACJNP 0 1
WCHTV200JBZ3D89X 1 0
WEL200 5 11
WEL400 5 4
WEL600 0 1
WINJA1000E6DGWZV 1 0
WOW25 117 130
WOW30 770 835
XYZAP272VRR8B 1 0
XYZAP273F9MEK 0 1
XYZAP273MQVPN 1 0
XYZAP273WCQDV 1 0
XYZAP274FDBPX 0 1
XYZAP274MLDVZ 1 0
XYZAP274QYFT2 1 0
XYZAP275487HZ 1 0
XYZAP275BPHGL 1 0
XYZAP275GBYHA 1 0
XYZAP275L5VLY 1 0
XYZAP275M8N2G 0 1
XYZAP275SSSF7 0 1
XYZAP2769FJ4H 0 1
XYZAP276C59ZM 0 1
XYZAP276FJ8KF 0 1
XYZAP276FX5L6 2 0
XYZAP2776N2ZB 1 0
XYZAP277CPUAA 0 1
XYZAP277N2V23 1 0
XYZAP277YYW3B 1 0
XYZAP277Z3KUM 2 0
XYZAP278P8XNQ 0 2
XYZAP278Z6TJ3 1 0
XYZAP279R4E3V 1 0
XYZAP279V3Z5G 0 1
XYZAP279YDKF9 1 0
XYZAP27A97HK6 0 1
XYZAP27AGPRFL 0 2
XYZAP27B7S56B 1 0
XYZAP27B9F83A 0 2
XYZAP27BQFPTB 1 0
XYZAP27C2J4HC 0 1
XYZAP27C7ZHAK 3 0
XYZAP27CNEMNR 0 1
XYZAP27CW2VJF 0 1
XYZAP27D9SZHB 1 0
XYZAP27DBJYZB 0 1
XYZAP27E37T6W 0 1
XYZAP27EW8Z93 1 0
XYZAP27GFGVSK 1 0
XYZAP27GL6MZV 1 0
XYZAP27GS7UBM 1 0
XYZAP27GTDKJM 0 1
XYZAP27GZ22HC 1 0
XYZAP27J7YTNJ 0 1
XYZAP27JFB3WV 0 1
XYZAP27JPVD5P 1 0
XYZAP27KH2ANX 1 0
XYZAP27KMZMM3 1 0
XYZAP27LA2LNX 2 0
XYZAP27LF7D49 1 0
XYZAP27MWLKA2 0 1
XYZAP27N75AJ5 1 0
XYZAP27NDMF99 1 0
XYZAP27NGGDYE 0 1
XYZAP27NKWKY2 1 0
XYZAP27NRG4SQ 5 0
XYZAP27PF3SSZ 0 1
XYZAP27PFBSLF 0 1
XYZAP27PU5LLG 0 1
XYZAP27QEJKLE 3 0
XYZAP27RCTGAG 1 0
XYZAP27RE78YU 1 0
XYZAP27RKWDGC 0 1
XYZAP27RMZZER 1 0
XYZAP27T27DYV 1 0
XYZAP27T8WPVP 0 1
XYZAP27TA29K8 0 1
XYZAP27TJJN5K 0 1
XYZAP27UE3FCG 0 1
XYZAP27UG7Q5G 1 0
XYZAP27V3KFD3 1 0
XYZAP27VDUCTL 0 2
XYZAP27VKX8KK 1 0
XYZAP27WCCBWS 1 0
XYZAP27WHXVSB 1 0
XYZAP27WPD8AL 1 0
XYZAP27X2G72J 0 1
XYZAP27X4NE3A 1 0
XYZAP27X5CEBX 1 0
XYZAP27X6ZKDF 0 2
XYZAP27XCXN2N 1 0
XYZAP27XULWJW 1 0
XYZAP27Y562A5 0 1
XYZAP27YE28A4 0 1
XYZAP27Z5RU9B 0 1
XYZAP27Z6SR4R 1 0
XYZAP27ZM2YN8 0 1
XYZAP27ZQXCSL 0 1
XYZAP302TY64K 1 0
XYZAP302XPVRH 0 2
XYZAP3034A3QP 0 1
XYZAP3039R5YU 1 0
XYZAP303B7W4Q 1 0
XYZAP303E9MDS 0 1
XYZAP303M5RMD 1 0
XYZAP303MQBN6 0 2
XYZAP303SKDBM 0 1
XYZAP303TZHAZ 0 7
XYZAP3049KN3C 1 0
XYZAP3049RVDW 1 0
XYZAP304E93VT 1 0
XYZAP304HQ64K 1 0
XYZAP304MN8GN 0 3
XYZAP304TDG2P 1 0
XYZAP304ZQA7N 0 1
XYZAP305JMHWY 0 1
XYZAP306752QA 0 1
XYZAP306BVTB8 1 0
XYZAP306H5BNF 0 1
XYZAP306MD3MJ 1 0
XYZAP3078FQ4X 1 0
XYZAP307AGB7N 0 1
XYZAP307AR9D7 1 0
XYZAP307B2KJU 1 0
XYZAP307LXL6R 2 0
XYZAP307XFXE8 1 0
XYZAP3087AQ98 1 0
XYZAP308CA2ES 1 0
XYZAP308NXRGD 0 1
XYZAP308QK7T4 1 0
XYZAP308SGE7Z 1 0
XYZAP3095HLXC 0 1
XYZAP3097DZM8 0 1
XYZAP309HX6XV 1 0
XYZAP309PJC8N 0 1
XYZAP30A2XZ3U 0 2
XYZAP30AW3GSC 0 1
XYZAP30AXQTS3 2 0
XYZAP30B8YT3V 1 0
XYZAP30BJPDX3 2 0
XYZAP30BL5BC8 0 1
XYZAP30BRZ3HL 1 0
XYZAP30BTPHW6 0 1
XYZAP30BTQQU5 0 4
XYZAP30CSEUED 0 1
XYZAP30D6733B 0 1
XYZAP30DFF288 0 1
XYZAP30DFSSBG 0 1
XYZAP30DFXR66 0 1
XYZAP30DN2B5N 0 3
XYZAP30DUXFQ4 0 1
XYZAP30DVL74Q 1 0
XYZAP30DYVP8K 3 0
XYZAP30DZMR34 0 1
XYZAP30E4JE9E 1 0
XYZAP30EHBGG6 0 1
XYZAP30EWNTAY 0 1
XYZAP30FETSC9 1 0
XYZAP30FL24DD 0 2
XYZAP30GB6XG3 1 0
XYZAP30GB8SK5 1 0
XYZAP30GB9WFA 1 0
XYZAP30GYDDPV 0 1
XYZAP30H4NMBA 1 0
XYZAP30HTZ533 0 2
XYZAP30J98ZD6 1 0
XYZAP30JAB22B76Q 1 0
XYZAP30JAB269NVA 2 0
XYZAP30JAB2AEKXA 0 1
XYZAP30JAB2KJ4HP 0 1
XYZAP30JAB2QRKXM 0 1
XYZAP30JAB2U82W2 0 3
XYZAP30JAB2ZQFRZ 0 1
XYZAP30JAB34J7KW 1 0
XYZAP30JAB39G7BX 1 0
XYZAP30JAB3BRQER 0 1
XYZAP30JAB3HLTNJ 1 0
XYZAP30JAB42JM97 0 2
XYZAP30JAB4CUUPK 1 0
XYZAP30JAB4EHF8E 1 0
XYZAP30JAB4QXAWW 0 1
XYZAP30JAB54L9EF 0 1
XYZAP30JAB5BVRWM 2 0
XYZAP30JAB5SWQZU 1 0
XYZAP30JAB5TMHSN 0 1
XYZAP30JAB5V8TBL 1 0
XYZAP30JAB6BKJ6L 0 3
XYZAP30JAB6CD2AW 1 0
XYZAP30JAB6X2PNG 1 0
XYZAP30JAB843NLP 1 0
XYZAP30JAB8V6X4Z 0 1
XYZAP30JAB979GHY 0 2
XYZAP30JAB99SWLJ 1 0
XYZAP30JAB9HQZ8C 1 0
XYZAP30JAB9S7KDS 1 0
XYZAP30JABAWCZX4 0 2
XYZAP30JABB36QK8 0 2
XYZAP30JABB8LETR 0 2
XYZAP30JABB9M328 0 1
XYZAP30JABC33VHE 1 0
XYZAP30JABCCK8PJ 1 0
XYZAP30JABCCLLUN 1 0
XYZAP30JABCGESC5 1 0
XYZAP30JABCSH9ET 1 0
XYZAP30JABCTAJSH 1 0
XYZAP30JABCTAMDU 1 0
XYZAP30JABDAL3HN 1 0
XYZAP30JABDTSUJ4 0 1
XYZAP30JABDULPBT 0 1
XYZAP30JABE3TTSZ 0 1
XYZAP30JABE4Y6CC 1 0
XYZAP30JABE5UYQ3 0 1
XYZAP30JABEBU583 0 1
XYZAP30JABECUA9X 0 1
XYZAP30JABEQ8WBB 4 0
XYZAP30JABEUE288 1 0
XYZAP30JABEWBZKF 1 0
XYZAP30JABEZYUGA 2 0
XYZAP30JABF4TURE 1 0
XYZAP30JABF5H25C 0 1
XYZAP30JABF65963 0 1
XYZAP30JABF6Z7ZT 0 1
XYZAP30JABFLWE7F 0 1
XYZAP30JABFMG53S 1 0
XYZAP30JABFR2HHG 0 1
XYZAP30JABFRQX5Z 2 0
XYZAP30JABG5NEW9 0 1
XYZAP30JABG658TF 1 0
XYZAP30JABGAPAX2 0 2
XYZAP30JABGLFGW5 1 0
XYZAP30JABGN4KMV 0 2
XYZAP30JABGPL5AX 1 0
XYZAP30JABGTDR78 1 0
XYZAP30JABGVJGPN 1 0
XYZAP30JABH7CN3L 0 1
XYZAP30JABH7QPTQ 1 0
XYZAP30JABH8BSG8 0 1
XYZAP30JABHFFP9V 0 1
XYZAP30JABHNYB9W 1 0
XYZAP30JABHQ9RHK 0 1
XYZAP30JABHUK5DF 1 0
XYZAP30JABHY6DXV 0 1
XYZAP30JABJ8KUZY 0 2
XYZAP30JABJE4SQA 0 1
XYZAP30JABJEV7YK 1 0
XYZAP30JABJFZVYE 1 0
XYZAP30JABJGVDY4 2 0
XYZAP30JABJR7H23 0 1
XYZAP30JABJSJRE7 0 1
XYZAP30JABJV2UHG 1 0
XYZAP30JABJXYCWQ 0 1
XYZAP30JABK3HM3X 0 1
XYZAP30JABK45V37 1 0
XYZAP30JABK4DVH6 1 0
XYZAP30JABK86SH6 0 3
XYZAP30JABK9KZVS 0 1
XYZAP30JABL5SEYB 0 1
XYZAP30JABL8WJPV 1 0
XYZAP30JABLAQFAG 0 1
XYZAP30JABLEPEK7 0 1
XYZAP30JABLN7WQV 0 1
XYZAP30JABM4NUN6 0 1
XYZAP30JABM9V8C6 1 0
XYZAP30JABMDRQF4 1 0
XYZAP30JABMX745W 0 1
XYZAP30JABMYRGRE 1 0
XYZAP30JABN4L8TQ 0 1
XYZAP30JABN4NATP 1 0
XYZAP30JABN7SMRD 0 1
XYZAP30JABNH22CH 0 1
XYZAP30JABNPAUQK 0 1
XYZAP30JABNZH3GG 1 0
XYZAP30JABP4TEFQ 0 1
XYZAP30JABP6FXN9 0 1
XYZAP30JABP78GT7 0 1
XYZAP30JABP8GTZ4 0 3
XYZAP30JABP8UEF3 1 0
XYZAP30JABPB8LDC 2 0
XYZAP30JABPCUDX2 0 1
XYZAP30JABPFUE7S 0 1
XYZAP30JABPG9PCJ 0 3
XYZAP30JABPHWJTK 1 0
XYZAP30JABPJ7A4B 0 1
XYZAP30JABPK3Y69 0 2
XYZAP30JABPQ6CTT 0 1
XYZAP30JABPX4A48 1 0
XYZAP30JABQ9QEF4 1 0
XYZAP30JABQBDZYQ 0 2
XYZAP30JABQMPQLV 1 0
XYZAP30JABQP3H82 0 1
XYZAP30JABQRL4KM 0 1
XYZAP30JABQX3D9L 1 0
XYZAP30JABR4HQV6 0 2
XYZAP30JABR4RVZ3 0 1
XYZAP30JABRTWWD9 0 1
XYZAP30JABS4KHR7 1 0
XYZAP30JABS8Q4J8 0 1
XYZAP30JABSB53CT 0 1
XYZAP30JABSENHPJ 0 1
XYZAP30JABSR5N9X 0 1
XYZAP30JABTJADA6 1 0
XYZAP30JABTLS3C3 1 0
XYZAP30JABU6977P 0 1
XYZAP30JABU8MKS5 1 0
XYZAP30JABUMFWF5 1 0
XYZAP30JABUU9GY6 0 1
XYZAP30JABUWKRY2 0 1
XYZAP30JABV2E8VN 1 0
XYZAP30JABVG8CNK 0 1
XYZAP30JABVLBK9A 0 1
XYZAP30JABVPE94T 1 0
XYZAP30JABVRXJBR 0 1
XYZAP30JABVXVTJQ 0 1
XYZAP30JABW6QX3B 1 0
XYZAP30JABWGKVJG 0 1
XYZAP30JABWS4YFF 1 0
XYZAP30JABWYRVC2 0 1
XYZAP30JABXJX32T 0 1
XYZAP30JABXQCURU 1 0
XYZAP30JABXU6RSU 1 0
XYZAP30JABY2VZHP 2 0
XYZAP30JABY2YN5X 0 3
XYZAP30JABY5YYMY 1 0
XYZAP30JABYLENG6 0 1
XYZAP30JABYQEWLU 0 1
XYZAP30JABYR7SN4 0 1
XYZAP30JABYSWBD7 0 1
XYZAP30JABYWA8ZC 1 0
XYZAP30JABZ2DESK 0 1
XYZAP30JABZ9J4YY 2 0
XYZAP30JABZDV4NV 1 0
XYZAP30JABZT6LN2 0 1
XYZAP30JABZZ7G8N 0 1
XYZAP30K3F8NV 1 0
XYZAP30KKUWZ2 1 0
XYZAP30KMX7R8 1 0
XYZAP30KN5UGG 1 0
XYZAP30MCDQD4 2 0
XYZAP30MF6R5F 0 1
XYZAP30MFZAGZ 0 1
XYZAP30MG5KBK 1 0
XYZAP30MXU7KF 1 0
XYZAP30NBD58E 1 0
XYZAP30NHYXRJ 2 0
XYZAP30PFDZHM 1 0
XYZAP30PRAJR6 0 1
XYZAP30PTCRJS 0 1
XYZAP30PZ5Y8G 0 1
XYZAP30QMPUPZ 1 0
XYZAP30REPNC5 1 0
XYZAP30RKHY9R 0 1
XYZAP30RQU4MV 0 2
XYZAP30RSMGN8 2 0
XYZAP30RZE8GL 0 2
XYZAP30S462SP 2 0
XYZAP30S5EG3L 0 1
XYZAP30SDWKK8 1 0
XYZAP30SHKXCY 0 1
XYZAP30SQHM4E 1 0
XYZAP30SRQR8N 1 0
XYZAP30TXCYLV 0 1
XYZAP30TYNPL2 2 0
XYZAP30U4XFEP 0 1
XYZAP30U7B99L 0 1
XYZAP30UFN6XJ 1 0
XYZAP30UQ62MX 0 1
XYZAP30UQX6F3 2 0
XYZAP30V2SC48 0 1
XYZAP30VCHM99 1 0
XYZAP30VELM9F 1 0
XYZAP30VG6FWU 0 1
XYZAP30VG7WSS 1 0
XYZAP30VKEUDA 0 1
XYZAP30VPJ5GM 2 0
XYZAP30VVYD4R 0 1
XYZAP30VZC6WH 0 1
XYZAP30W525P4 1 0
XYZAP30WCL52K 0 1
XYZAP30WEPPRP 2 0
XYZAP30WMP7YN 1 0
XYZAP30WRWRYZ 2 0
XYZAP30XF85CY 0 1
XYZAP30XPQZ3C 2 0
XYZAP30XPRLUF 2 0
XYZAP30Y4QMGN 0 2
XYZAP30Y4RA76 0 4
XYZAP30Y75RN2 0 3
XYZAP30YHJFJQ 1 0
XYZAP30YJZQRZ 1 0
XYZAP30YR4APH 0 1
XYZAP30YVAT97 0 1
XYZAP30Z3Q4DV 0 1
XYZAP30Z7YUSE 1 0
XYZAP30ZGEAPL 1 0
XYZAP30ZLYTDR 0 1
XYZAP30ZVPLGL 0 1
ZINGCLUB15 2 0
Does the Brand affect consumer's choice of payment method?
mytable6 <- xtabs(~ Brand+COD, data=ecom)
mytable6
COD
Brand 0 1
ATHENA 1329 2811
FABALLEY 2876 4023
GRITSTONES 2581 4320
HARPA 3123 4148
MEIRA 2161 3261
MISS CHASE 537 1141
MONTEIL & MUNERO 2356 4183
MR BUTTON 314 534
THE VANCA 1920 2884
TSHIRT COMPANY 557 839
chisq.test(mytable6)
Pearson's Chi-squared test
data: mytable6
X-squared = 221.81, df = 9, p-value < 2.2e-16
```
barplot(mytable2,
main="Highest Selling Brands for Non-COD",
xlab="Brands", ylab="Frequency", breaks= 200)
Are premium priced goods less discounted? (analysing impact of MRP on discounts)
premi_mod1 <- lm(VendorDiscount ~ MRP, data= ecom)
summary(premi_mod1)
Call:
lm(formula = VendorDiscount ~ MRP, data = ecom)
Residuals:
Min 1Q Median 3Q Max
-2698.28 -158.51 -50.11 188.57 1420.18
Coefficients:
Estimate Std. Error t value Pr(>|t|)
(Intercept) -88.96252 2.55629 -34.8 <2e-16 ***
MRP 0.30973 0.00229 135.3 <2e-16 ***
---
Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
Residual standard error: 228 on 45896 degrees of freedom
Multiple R-squared: 0.285, Adjusted R-squared: 0.285
F-statistic: 1.83e+04 on 1 and 45896 DF, p-value: < 2.2e-16
premi_mod2 <- lm(WebsiteDiscount ~ MRP, data= ecom)
summary(premi_mod2)
Call:
lm(formula = WebsiteDiscount ~ MRP, data = ecom)
Residuals:
Min 1Q Median 3Q Max
-1284.36 -81.88 -45.33 -9.73 2766.50
Coefficients:
Estimate Std. Error t value Pr(>|t|)
(Intercept) -38.244021 1.770001 -21.61 <2e-16 ***
MRP 0.120248 0.001585 75.84 <2e-16 ***
---
Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
Residual standard error: 157.9 on 45896 degrees of freedom
Multiple R-squared: 0.1114, Adjusted R-squared: 0.1114
F-statistic: 5752 on 1 and 45896 DF, p-value: < 2.2e-16
Which website discounts were most popular with customers?
library(vcd)
HasVendorDiscount <- factor(ecom$HasVendorDiscount, levels = c(0,1), labels = c("No","Yes"))
HasWebsiteDiscount <- factor(ecom$HasWebsiteDiscount, levels = c(0,1), labels = c("No", "Yes"))
discountcount <- table(HasWebsiteDiscount, HasVendorDiscount)
discountcount
HasVendorDiscount
HasWebsiteDiscount No Yes
No 12536 17335
Yes 10146 5881
Correlation
x <- ecom[,c("FinalTotalPrice")]
y <- ecom[,c("HasVendorDiscount","HasWebsiteDiscount")]
matrix <- cor(x,y)
round(matrix,2)
HasVendorDiscount HasWebsiteDiscount
[1,] -0.15 0.03
How does discounts affect price?
fit <- lm(FinalTotalPrice~HasVendorDiscount+HasWebsiteDiscount+HasVendorDiscount*HasWebsiteDiscount, data=ecom)
summary(fit)
Call:
lm(formula = FinalTotalPrice ~ HasVendorDiscount + HasWebsiteDiscount +
HasVendorDiscount * HasWebsiteDiscount, data = ecom)
Residuals:
Min 1Q Median 3Q Max
-832.9 -212.2 -98.7 147.1 6260.2
Coefficients:
Estimate Std. Error t value Pr(>|t|)
(Intercept) 788.615 3.025 260.733 <2e-16
HasVendorDiscount -70.835 3.970 -17.841 <2e-16
HasWebsiteDiscount 44.305 4.522 9.797 <2e-16
HasVendorDiscount:HasWebsiteDiscount -105.064 6.824 -15.396 <2e-16
(Intercept) ***
HasVendorDiscount ***
HasWebsiteDiscount ***
HasVendorDiscount:HasWebsiteDiscount ***
---
Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
Residual standard error: 338.6 on 45894 degrees of freedom
Multiple R-squared: 0.02883, Adjusted R-squared: 0.02877
F-statistic: 454.1 on 3 and 45894 DF, p-value: < 2.2e-16
Segment customers based on Recency, Frequency & Monetary value.
avg_amount %COD_transact
1 754.7938 0.6131858
month counter avg_amount sum_amount
1 4 40765 741.3831 30222482
2 5 5133 861.2985 4421045
Computing recency, frequency, and average purchase amount
customers = sqldf("SELECT CustomerID,
MIN(days_since) AS 'recency',
MAX(days_since) AS 'first_purchase',
COUNT(*) AS 'frequency',
SUM(COD) AS 'cod_frequency',
AVG(FinalTotalPrice) AS 'amount'
FROM ecom GROUP BY 1")
View(customers)
#Estimating prefernce for COD as what percent of all transactions were COD
customers$cod_preference <-round((customers$cod_frequency/customers$frequency),2)
customers$primary_PM <- ifelse(customers$cod_preference>0.5,"COD","Electronic Payment")
head(customers)
CustomerID recency first_purchase frequency cod_frequency amount
1 197 38.77083 38.77083 1 1 420.000
2 306 41.77083 41.77083 1 0 628.950
3 366 49.77083 49.77083 1 1 941.850
4 475 48.77083 51.77083 3 1 224.700
5 702 30.77083 30.77083 2 0 1065.015
6 789 44.77083 44.77083 1 0 1048.950
cod_preference primary_PM
1 1.00 COD
2 0.00 Electronic Payment
3 1.00 COD
4 0.33 Electronic Payment
5 0.00 Electronic Payment
6 0.00 Electronic Payment
Computing recency, frequency, and average purchase amount
summary(customers)
CustomerID recency first_purchase frequency
Min. : 197 Min. :26.77 Min. :26.77 Min. : 1.00
1st Qu.: 4561269 1st Qu.:34.77 1st Qu.:35.77 1st Qu.: 1.00
Median : 9107940 Median :42.77 Median :43.77 Median : 1.00
Mean : 9169946 Mean :42.28 Mean :42.74 Mean : 1.44
3rd Qu.:15114432 3rd Qu.:50.77 3rd Qu.:50.77 3rd Qu.: 2.00
Max. :16007333 Max. :58.77 Max. :58.77 Max. :99.00
cod_frequency amount cod_preference primary_PM
Min. : 0.0000 Min. : 0.0 Min. :0.0000 Length:31869
1st Qu.: 0.0000 1st Qu.: 550.2 1st Qu.:0.0000 Class :character
Median : 1.0000 Median : 692.0 Median :1.0000 Mode :character
Mean : 0.8831 Mean : 774.0 Mean :0.6114
3rd Qu.: 1.0000 3rd Qu.: 927.9 3rd Qu.:1.0000
Max. :23.0000 Max. :6663.3 Max. :1.0000
hist(customers$recency,200)
hist(customers$frequency,breaks= 200)
hist(customers$amount, breaks = 200)
hist(customers$cod_preference)
CODING A MANAGERIAL SEGMENTATION
we use the following segementation based on RFM for customers:
Average Purchase Amount > Average amount = 754.7938 then HIGH VALUE customer else LOW VALUE customer
If customer made purchase in April but not in May = INACTIVE If customer made purchase in April and also in May = ACTIVE If customer made first purchase in May = NEW
customers$seg1 <- ifelse(customers$amount> database$avg_amount, "High Value", "Low Value")
customers$seg2 <- ifelse(customers$first_purchase<31, "New Customer", ifelse(customers$recency<31, "Active Customer","Inactive Customer"))
customers$segment <- paste(customers$seg1,customers$seg2)
# Profile of each customer segemnt
table(customers$segment)
High Value Active Customer High Value Inactive Customer
208 11439
High Value New Customer Low Value Active Customer
1899 174
Low Value Inactive Customer Low Value New Customer
16412 1737
aggregate(x = customers[,6:7], by = list(customers$segment), mean)
Group.1 amount cod_preference
1 High Value Active Customer 1057.3840 0.7519231
2 High Value Inactive Customer 1053.9257 0.6488985
3 High Value New Customer 1163.8163 0.6593365
4 Low Value Active Customer 563.9218 0.6946552
5 Low Value Inactive Customer 553.8064 0.5786096
6 Low Value New Customer 572.0102 0.5970524
aggregate(x = customers[,6], by = list(customers$primary_PM), mean)
Group.1 x
1 COD 797.0899
2 Electronic Payment 738.1125