Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I use the probability feature in Xcel?
I heard that you can use Microsoft Xcel to compute probability. I've written
down about 30 different games of rock, paper, scissors in an attempt to find patterns of what people do. I'd like to enter this information into the computer and then just have the computer tell me what is most likely to come next during a game. ie. If I told Xcel that someone did rock, rock, scissors, could Xcel then tell me what is most likely to come next from the information it's already been given about previous games? Thanks very much. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I use the probability feature in Xcel?
It would be complicated I would assume and likely be easiest to involve
macros. I am not sure. However, it sounds like you'd like to cheat someone. And they may not even know that they have a pattern. Who is to say there is a strong enough one that your computer's processor could figure it out where you haven't. Good luck. MNKeeper wrote: I heard that you can use Microsoft Xcel to compute probability. I've written down about 30 different games of rock, paper, scissors in an attempt to find patterns of what people do. I'd like to enter this information into the computer and then just have the computer tell me what is most likely to come next during a game. ie. If I told Xcel that someone did rock, rock, scissors, could Xcel then tell me what is most likely to come next from the information it's already been given about previous games? Thanks very much. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I use the probability feature in Xcel?
The probability that X happens is the number of times that X happens divided
by the number of times anything happens. P(rock) = N(rock)/(N(rock)+N(paper)+N(scissors)) Looking for patterns is much more complicated. The probability that a rock follows a rock is: P(rock follows rock) = N(rock follows rock)/(N(rock follows rock)+N(paper follows rock)+N(scissors follows rock)) so now you can only consider the trials after the previous trial was a rock. And it gets more complex from here. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "MNKeeper" wrote in message ... I heard that you can use Microsoft Xcel to compute probability. I've written down about 30 different games of rock, paper, scissors in an attempt to find patterns of what people do. I'd like to enter this information into the computer and then just have the computer tell me what is most likely to come next during a game. ie. If I told Xcel that someone did rock, rock, scissors, could Xcel then tell me what is most likely to come next from the information it's already been given about previous games? Thanks very much. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I use the probability feature in Xcel?
I realize that it gets very complex. That's why I was hoping a computer
program could help me. And to Jason- I'm confused as to how you think it would be considered cheating. "Jon Peltier" wrote: The probability that X happens is the number of times that X happens divided by the number of times anything happens. P(rock) = N(rock)/(N(rock)+N(paper)+N(scissors)) Looking for patterns is much more complicated. The probability that a rock follows a rock is: P(rock follows rock) = N(rock follows rock)/(N(rock follows rock)+N(paper follows rock)+N(scissors follows rock)) so now you can only consider the trials after the previous trial was a rock. And it gets more complex from here. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "MNKeeper" wrote in message ... I heard that you can use Microsoft Xcel to compute probability. I've written down about 30 different games of rock, paper, scissors in an attempt to find patterns of what people do. I'd like to enter this information into the computer and then just have the computer tell me what is most likely to come next during a game. ie. If I told Xcel that someone did rock, rock, scissors, could Xcel then tell me what is most likely to come next from the information it's already been given about previous games? Thanks very much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Probability Question | Excel Discussion (Misc queries) | |||
List feature in XL 2003 | Excel Discussion (Misc queries) | |||
synchronizing timestamp feature with time on video software. | Excel Discussion (Misc queries) | |||
Autosave feature in Excel 2003 | Excel Discussion (Misc queries) | |||
Installing: Microsoft Excel Feature | Excel Discussion (Misc queries) |