Are there more services pushed if advisor generated maintenance menu (clicked button MENU - not at the end of the process)?
Data conditions
- period: 120 days, approximately from 2017/01/10 to 2017/05/10
- analyzed sample has size 5000 and obtained randomly from uniform distribution
- data source: Application Insigts, PROD2, ad.dealer-fx.com
Analysis dependency MENU and total count of DRS+FRS submited





ANOVA
av = aov(drs_plus_frs ~ menu, dataset)
summary(av)
Df Sum Sq Mean Sq F value Pr(>F)
menu 1 717 717.2 5.617 0.0178 *
Residuals 4998 638170 127.7
---
Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1
Analysis dependency MENU and total sum of DRS+FRS submited



ANOVA
av = aov(drs_plus_frs_sum ~ menu, dataset)
summary(av)
Df Sum Sq Mean Sq F value Pr(>F)
menu 1 527238 527238 48.17 4.4e-12 ***
Residuals 4998 54699150 10944
---
Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1
Conclusion
- Generating MENU affects the number of DRS+FRS submited
- The average number of pushed services increases ~ two times if MENU genereted
- In 2% of cases MENU is generating
- The average total price of FRS+FRS if MENU generated is about $128
- The average total price of FRS+FRS if MENU not generated is about $46
- There are many outliers of total sums if menu was not generated.
LS0tCnRpdGxlOiAiQUQuIFRlc3QgaHlwb3RoZXNpcyIKb3V0cHV0OiBodG1sX25vdGVib29rCi0tLQoKIyMjIEFyZSB0aGVyZSBtb3JlIHNlcnZpY2VzIHB1c2hlZCBpZiBhZHZpc29yIGdlbmVyYXRlZCBtYWludGVuYW5jZSBtZW51IChjbGlja2VkIGJ1dHRvbiBNRU5VIC0gbm90IGF0IHRoZSBlbmQgb2YgdGhlIHByb2Nlc3MpPwoKCiMjIyMgRGF0YSBjb25kaXRpb25zCgoqIHBlcmlvZDogMTIwIGRheXMsIGFwcHJveGltYXRlbHkgZnJvbSAyMDE3LzAxLzEwIHRvIDIwMTcvMDUvMTAKKiBhbmFseXplZCBzYW1wbGUgaGFzIHNpemUgNTAwMCBhbmQgb2J0YWluZWQgcmFuZG9tbHkgZnJvbSB1bmlmb3JtIGRpc3RyaWJ1dGlvbgoqIGRhdGEgc291cmNlOiBBcHBsaWNhdGlvbiBJbnNpZ3RzLCBQUk9EMiwgYWQuZGVhbGVyLWZ4LmNvbQoKYGBge3IgZWNobz1GQUxTRX0KbGlicmFyeShnZ3Bsb3QyKQpkYXRhc2V0IDwtcmVhZC5jc3YoJ34vcHJvamVjdHMvZGZ4L2FpLWFuYWx5dGljcy9nZW4tbWVudS1zZXJ2aWNlcy00LmNzdicsIGhlYWRlciA9IFRSVUUsIHNlcCA9ICIsIikKYGBgCgoKIyMgQW5hbHlzaXMgZGVwZW5kZW5jeSBNRU5VIGFuZCB0b3RhbCBjb3VudCBvZiBEUlMrRlJTIHN1Ym1pdGVkCgpgYGB7ciBlY2hvPUZBTFNFfQpnZ3Bsb3QoZGF0YXNldCwgYWVzKHggPSBtZW51LCB5ID0gZHJzX3BsdXNfZnJzKSkgKwogIGdlb21fYm94cGxvdChmaWxsID0gImdyZXk4MCIsIGNvbG91ciA9ICJibHVlIikgKwogIHNjYWxlX3hfZGlzY3JldGUoKSArIHhsYWIoIldhcyBNRU5VIGdlbmVyYXRlZD8iKSArCiAgeWxhYigiUHVzaGVkIHNlcnZpY2VzIGNvdW50IikKCmdncGxvdChkYXRhc2V0LCBhZXMoeD1kcnNfcGx1c19mcnMpKSArIGdlb21fZGVuc2l0eSgpICsgeGxhYigiVG90YWwgbnVtYmVyIERSUytGUlMgc3VibWl0ZWQiKSArIGdndGl0bGUoIkRlbnNpdHkgb2Ygc2VsZWN0ZWQgRlJTK0RSUyBzZXJ2aWNlcyByZWdhcmRsZXNzIE1FTlUgd2FzIGdlbmVyYXRlZCBvciBub3QiKQoKZ2dwbG90KGRhdGFzZXRbZGF0YXNldCRtZW51ID09ICd0cnVlJyxdLCBhZXMoeD1kcnNfcGx1c19mcnMpKSArIGdlb21fZGVuc2l0eSgpICsgeGxhYigiVG90YWwgbnVtYmVyIERSUytGUlMgc3VibWl0ZWQiKSArIGdndGl0bGUoIlVzZXIgZ2VuZXJhdGVkIE1FTlUgYmVmb3JlIHN1Ym1pdCBSTyIpCgpnZ3Bsb3QoZGF0YXNldFtkYXRhc2V0JG1lbnUgPT0gJ2ZhbHNlJyxdLCBhZXMoeD1kcnNfcGx1c19mcnMpKSArIGdlb21fZGVuc2l0eSgpICsgeGxhYigiVG90YWwgbnVtYmVyIERSUytGUlMgc3VibWl0ZWQiKSArIGdndGl0bGUoIlVzZXIgZGlkIG5vdCBnZW5lcmF0ZSBNRU5VIGJlZm9yZSBzdWJtaXQgUk8iKQoKCmRmID0gZGF0YS5mcmFtZSh4PWMoJ21lbnUgZ2VuZXJhdGVkJywgJ25vdCBnZW5lcmF0ZWQnKSwgeT1jKDEwMCpucm93KGRhdGFzZXRbZGF0YXNldCRtZW51ID09ICd0cnVlJyxdKS9ucm93KGRhdGFzZXQpLCAxMDAqbnJvdyhkYXRhc2V0W2RhdGFzZXQkbWVudSA9PSAnZmFsc2UnLF0pL25yb3coZGF0YXNldCkpKQpnZ3Bsb3QoZGYsIGFlcyhtZW51KSkgKyBnZW9tX2NvbChhZXMoeCx5KSwgcG9zaXRpb24gPSAiZG9kZ2UiLCBmaWxsID0gInJlZCIpICsgY29vcmRfZmxpcCgpICsgZ2d0aXRsZSgiUGVyY2VudCBvZiBjYXNlcyB3aGVuIG1lbnUgZ2VuZXJhdGVkIGFuZCB3aGVuIG5vdCIpCgpgYGAKIyMjIEFOT1ZBIApgYGB7cn0KYXYgPSBhb3YoZHJzX3BsdXNfZnJzIH4gbWVudSwgZGF0YXNldCkKc3VtbWFyeShhdikKYGBgCgojIyBBbmFseXNpcyBkZXBlbmRlbmN5IE1FTlUgYW5kIHRvdGFsIHN1bSBvZiBEUlMrRlJTIHN1Ym1pdGVkCgoKYGBge3IgZWNobz1GQUxTRX0KZ2dwbG90KGRhdGFzZXQsIGFlcyh4ID0gbWVudSwgeSA9IGRyc19wbHVzX2Zyc19zdW0pKSArCiAgZ2VvbV9ib3hwbG90KGZpbGwgPSAiZ3JleTgwIiwgY29sb3VyID0gImJsdWUiKSArCiAgc2NhbGVfeF9kaXNjcmV0ZSgpICsgeGxhYigiV2FzIE1FTlUgZ2VuZXJhdGVkPyIpICsKICB5bGFiKCJQdXNoZWQgRlJTK0RSUyB0b3RhbCBzdW0iKQoKZ2dwbG90KGRhdGFzZXRbZGF0YXNldCRtZW51ID09ICd0cnVlJyxdLCBhZXMoeD1kcnNfcGx1c19mcnNfc3VtKSkgKyBnZW9tX2RlbnNpdHkoKSArIHhsYWIoIlRvdGFsIHN1bSBvZiBEUlMrRlJTIHN1Ym1pdGVkIikgKyBnZ3RpdGxlKCJVc2VyIGdlbmVyYXRlZCBNRU5VIGJlZm9yZSBzdWJtaXQgUk8iKQoKZ2dwbG90KGRhdGFzZXRbZGF0YXNldCRtZW51ID09ICdmYWxzZScsXSwgYWVzKHg9ZHJzX3BsdXNfZnJzX3N1bSkpICsgZ2VvbV9kZW5zaXR5KCkgKyB4bGFiKCJUb3RhbCBzdW0gb2YgRFJTK0ZSUyBzdWJtaXRlZCIpICsgZ2d0aXRsZSgiVXNlciBkaWQgbm90IGdlbmVyYXRlIE1FTlUgYmVmb3JlIHN1Ym1pdCBSTyIpCgoKYGBgCgojIyMgQU5PVkEgCmBgYHtyfQphdiA9IGFvdihkcnNfcGx1c19mcnNfc3VtIH4gbWVudSwgZGF0YXNldCkKc3VtbWFyeShhdikKYGBgCgoKIyMgQ29uY2x1c2lvbgoqIEdlbmVyYXRpbmcgTUVOVSBhZmZlY3RzIHRoZSBudW1iZXIgb2YgRFJTK0ZSUyBzdWJtaXRlZAoqIFRoZSBhdmVyYWdlIG51bWJlciBvZiBwdXNoZWQgc2VydmljZXMgaW5jcmVhc2VzIH4gdHdvIHRpbWVzIGlmIE1FTlUgZ2VuZXJldGVkCiogSW4gMiUgb2YgY2FzZXMgTUVOVSBpcyBnZW5lcmF0aW5nCiogVGhlIGF2ZXJhZ2UgdG90YWwgcHJpY2Ugb2YgRlJTK0ZSUyBpZiBNRU5VIGdlbmVyYXRlZCBpcyBhYm91dCAkMTI4CiogVGhlIGF2ZXJhZ2UgdG90YWwgcHJpY2Ugb2YgRlJTK0ZSUyBpZiBNRU5VIG5vdCBnZW5lcmF0ZWQgaXMgYWJvdXQgJDQ2CiogVGhlcmUgYXJlIG1hbnkgb3V0bGllcnMgb2YgdG90YWwgc3VtcyBpZiBtZW51IHdhcyBub3QgZ2VuZXJhdGVkLiAKCg==