lionginass
New Member
- Joined
- Jul 29, 2016
- Messages
- 24
Hello,
Lets say that i am trying to predict when will a customer come back to my shop.
1 means that customer has visited my shop, meanwhile blank cell means that customer did not visit
I recorded data of 10 days and i need to predict next visit.
It is obvious that customer1 visits every 2 days ant customer2 every 3 days, so Customer1 will visit on 12th day and Customer2 on 13th day.
problem is that i have much more customers and less obvious patterns
So i need a formula which return "blanks" for both customers on 11th day, return "1" for customer1 on 12th day and return "1" for customer2 on 13th day
<tbody>
</tbody>
Hope that everything is clear and solutions is easy
Lets say that i am trying to predict when will a customer come back to my shop.
1 means that customer has visited my shop, meanwhile blank cell means that customer did not visit
I recorded data of 10 days and i need to predict next visit.
It is obvious that customer1 visits every 2 days ant customer2 every 3 days, so Customer1 will visit on 12th day and Customer2 on 13th day.
problem is that i have much more customers and less obvious patterns
So i need a formula which return "blanks" for both customers on 11th day, return "1" for customer1 on 12th day and return "1" for customer2 on 13th day
Day | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 |
Customer1 | 1 | 1 | 1 | 1 | 1 | ||||||||
Customer2 | 1 | 1 | 1 | 1 |
<tbody>
</tbody>
Hope that everything is clear and solutions is easy