Calculating Order Frequency by Customer

Hi Anonymous

Could you show the summary table with the quintiles already calculated for me to refer to?

As for some details, please confirm:

1.Calculate time between each order placed by a customer 

eg.

customer1     order   date

1                     1         2018/1/1

1                     2         2018/1/7

for customer1, time between each order =2018/1/7-2018/1/1=6 days, right?

2.Calculate the avg time between orders per customer

for customer1, avg time between orders=6days/2 orders=3, right?

3.Break the data into quintiles

???

Best Regards

Maggie