Predict next visit

[lionginass]

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

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

 

[Keebellah]

Hi, first thing, which version of Excel (just for those who don't have the same version)
I would suggest one table with the actual visits and another table with the predictions

 

[lionginass]

Hi,

I have excel 2010

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Day	1	2	3	4	5	6	7	8	9	10	11	12	13
2	Customer1		1		1		1		1		1
3	Customer2	1			1			1			1

<tbody>
</tbody>

Once again, i need a formula to return 1 in Cell M2 and Cell N3

1 means that customer has visited the shop

 

[Keebellah]

Since you cannot have a formula AND a value in the same cell. have you given the idea I opted a thought?

 

[Keebellah]

It will probably have to be done using a macro to calculate the intervals between each visit and the number of visits the customer makes.
I don't think a ready-made formula exists for these type of calculations, but maybe someone with statistics knowledge can shed a light for you.
I guess it will be writing down the options and then write the code for this.