Prediction Help Needed

[PAB]

Hi martor54,

I would like you to tell me whether there is an error somewhere: I replaced all the data under Y1-Y15, in turn, with only one alpha character, A, B or C each time. Every line looked like this: "A A A A A A A A A A A A A A A" instead of, say, "B C A B A B B C A C B C C B C" (or any such alpha combination). Even the dots were replaced by that string of A's. So, I had A's all over. Predicted string was "B". I did the same thing with B's --> predicted string "A". I did that with C's --> predicted string "A" (A again?). The question is: "Where is C?" (C was never predicted though it, probably, should have been). Could you, please, explain why?

I have just tested the uploaded file with the criteria you have stated to try and replicate the errors, but unfortunately couldn't, it all works perfectly.

You know that you can only change the data in cells B322 don't you?

The SpreadSheet was purely to test the prediction of the next alpha string.
If you are happy with it and intend to use it by adding data under the current matrix, you will need to adjust the formulas to account for the fact that there will be cells that are BLANK until alpha data in inserted. Then you can copy the formulas down without them getting corrupted.

May I suggest that you download the file again and try that, it may just be a case that the file you are using could have got corrupted on the download for some reason.

Please let me know how you get on!

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
Mathematics is the language of nature.
Everything around us can be represented and understood through numbers.
If you graph the numbers of any system, patterns emerge. Therefore, there are patterns everywhere in nature.

 

[martor54]

Hi PAB,
I've done it again. B322 (all A's) --> B's; B322 (all B's) --> A's; B322 (all C's) --> A's. I wonder why the system never predicts a row of C's when B322 is all A's or B's. I did not extend the B322 field or fill in values into other blank cells. It's ok, though, if it works for combinations like the actual values we started with.

I'm sorry for the trouble I gave you. Thank you again. Excellent effort.
Best regards,
martor854

 

[PAB]

Hi martor54,

I've done it again. B322 (all A's) --> B's; B322 (all B's) --> A's; B322 (all C's) --> A's. I wonder why the system never predicts a row of C's when B322 is all A's or B's. I did not extend the B322 field or fill in values into other blank cells.

I mis-interpreted what you had actually done to get the errors.
I have re-tested the file with your criteria and it does indeed produce the results you stated.
The SpreadSheet was setup as a quick and easy way to try and predict the next string of alphas, which is exactly what it does.
Is there REALLY a chance that ALL cells will ONLY have one alpha???

The reason you get the results you do are as follows:

(1) Inputting all A's the program assumes that the next draw it will be something other than A, and you will notice that the B & C fields are both showing 19, and B being before C in the scheme of things selects B over C.

(2) Inputting all B's the program assumes that the next draw it will be something other than B, and you will notice that the A & C fields are both showing 19, and A being before C in the scheme of things selects A over C.

(3) Inputting all C's the program assumes that the next draw it will be something other than C, and you will notice that the A & B fields are both showing 19, and A being before C in the scheme of things selects A over C.

As I said, is there REALLY a chance that ALL cells will ONLY have one alpha???, if so, then this whole exercise is a waste of time, isn't it?

I have asked you twice now about how you are collating this data, which you have not replied to.
The reason I ask is:

Perhaps if you could explain in a bit more detail what you are ACTUALLY trying to do, there may be a much simpler approach and solution to your request. Knowing how you arrive at the data you do could possibly be a big help.

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
Mathematics is the language of nature.
Everything around us can be represented and understood through numbers.
If you graph the numbers of any system, patterns emerge. Therefore, there are patterns everywhere in nature.

 

[martor54]

Hi PAB,
Thank you. I got it now. You are perfectly right: there is no chance that all cells may assume the same value, whatever this may be. The exercise was just for me to see how the thing works and understand the conditions set. It was for my personal understanding, not for annoying you. If this was the result, please accept my apologies. I'm absolutely grateful for your help. I'll pass these results, as well as your explanations, on to my friend and he'll take it from there. Again, thanks for the best and unique help I had on this forum.

Best regards,
martor54

 

[PAB]

Hi martor54,

It was for my personal understanding, not for annoying you. If this was the result, please accept my apologies.

NOT at all martor54.

Knowing exactly what somebody is after makes giving them help and advice so much easier.
I hope your friend finds the information useful.
If he wants further information then just come back and ask.
Good luck!

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
Mathematics is the language of nature.
Everything around us can be represented and understood through numbers.
If you graph the numbers of any system, patterns emerge. Therefore, there are patterns everywhere in nature.